It appears that you are trying to use Tomcat's jndi and connection pooling.
What happens it you try to use jboss' jndi connection pooling by setting
up an XADataSourceLoader or JDBCDataSourceLoader (if I remember correctly)
in jboss.jcml? (with XADataSourceLoader you need to explicitly control tx
with UserTransaction, with JDBCDataSourceLoader all connections are
autocommit)
david jencks
On 2002.03.01 05:35:20 -0500 Dirk Storck wrote:
> Hi,
>
> I have a problem to connect to ma Datasource. In the server.xml I have
> defined
>
> <Resource name="jdbc/MySqlPool"
> auth="CONTAINER"
> type="javax.sql.DataSource"/>
> <ResourceParams name="jdbc/MySqlPool">
>
><parameter><name>root</name><value>sa</value></parameter>
>
><parameter><name>dmmsx</name><value></value></parameter>
> <parameter><name>driverClassName</name>
>
><value>org.gjt.mm.mysql.Driver</value></parameter>
> <parameter><name>driverName</name>
>
> <value>jdbc:mysql://localhost:3306/EJBPool</value></parameter>
> </ResourceParams>
>
> in my Context-tag.
>
> In web.xml I have defined
> <resource-ref>
> <res-ref-name>jdbc/MySqlPool</res-ref-name>
> <res-type>javax.sql.DataSource</res-type>
> <res-auth>Container</res-auth>
> </resource-ref>
>
> In my helperclass wich I access within a Struts-action I use the
> following
> code
>
> ConnectionPoolDataSource ds = null;
>
> try {
> InitialContext iniCtx = new InitialContext();
> InitialContext envCtx =
>(InitialContext)iniCtx.lookup("java:/comp/env/");
> Object obj = envCtx.lookup("jdbc/MySqlPool");
> ds = (ConnectionPoolDataSource)obj;
> } catch(NamingException ne) {
> ne.printStackTrace();
> log.error("Naming exception: "+ne);
> } //end of try
>
>
> and I get the following exception. Can someone please tell me why ?
>
> java.lang.ClassCastException: org.apache.naming.NamingContext
> at com.tecmath.cms.mt.biz.ImportHelper.process(ImportHelper.java:149)
> at
> com.tecmath.cms.mt.struts.CreateNewArticleAction.perform(CreateNewArticleAct
> ion.java:91)
> at
> org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.ja
> va:1720)
> at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1519)
> at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:505)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
> FilterChain.java:247)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
> ain.java:193)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
> va:243)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> 66)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
> va:201)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> 66)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2344)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164
> )
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> 66)
> at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
> java:170)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> 64)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170
> )
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> 64)
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:462)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> 64)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
> :163)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> 66)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
> org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:
> 1011)
> at
> org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1106
> )
> at java.lang.Thread.run(Thread.java:484)
>
>
> MANY Thanks! and any suggestions are welcome !
>
>
> _______________________________________________________________________
> ************************************************************************
> Bitte beachten Sie unsere neue Adresse
> ************************************************************************
> Dirk Storck, Dipl.-Ing. (FH) t e c m a t h A G
> Content Management Systems Division
> Telefon 0631 303-5290 Europaallee 10, 67657 Kaiserslautern
> Telefax 0631 303-5209 http://www.tecmath.com
> ________________________________________________________________________
>
>
>
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
>
>
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
