[JBoss-user] DataSource connection problem with JBoss 2.4.4 and Tomcat 4.0.2

[Dirk Storck]

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