You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Kumar <sr...@thbs.com> on 2002/06/24 17:00:38 UTC
javax.naming.NamingException: Cannot create resource instance
Hi,
Can anyone help me how to configure JDBC DataSource using IBM DB2 as the
database.I had gone through the solution "Generic DataSource Resource
Factory Available. JDBC Data Sources." posted by Mr.Anthony Dodd.But there
the solution was explained using Oracle database.Has anyone tried
configuring a DataSource using DB2?
I'm using IBM DB2 7.1 (Driver - COM.ibm.db2.jdbc.app.DB2Driver)
Tomcat 4.0.2
Here are the snippets for server.xml,web.xml and the JVM stack trace:
server.xml:
<Context path="/test" docBase="test" debug="0" reloadable="true">
<Resource name="jdbc/myDS" type="COM.ibm.db2.jdbc.DB2DataSource"
reloadable="true" auth="Container"/>
<ResourceParams name="jdbc/myDS">
<parameter>
<name>factory</name>
<value>org.apache.naming.factory.DataSourceFactory</value>
</parameter>
<Parameter>
<name>user</name>
<value>db2admin</value>
</Parameter>
<Parameter>
<name>password</name>
<value>db2admin</value>
</Parameter>
<Parameter>
<name>driverClassName</name>
<value>COM.ibm.db2.jdbc.app.DB2Driver</value>
</Parameter>
<Parameter>
<name>driverName</name>
<value>jdbc:db2:sample</value>
</Parameter>
</ResourceParams>
<Realm className="org.apache.catalina.realm.JDBCRealm"
connectionName="db2admin"
connectionPassword="db2admin"
connectionURL="jdbc:db2:sample"
digest="SHA"
driverName="COM.ibm.db2.jdbc.app.DB2Driver"
roleNameCol="role_name"
userCredCol="password"
userNameCol="user_name"
userRoleTable="user_roles"
userTable="users" />
</Context>
web.xml:
<resource-ref>
<description>DS resource factory</description>
<res-ref-name>jdbc/myDS</res-ref-name>
<res-type>COM.ibm.db2.jdbc.DB2DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
I get the following error when i try to lookup the datasource in my JSP:
ctx (java:comp/env) = org.apache.naming.NamingContext@42a80d
obj = myDS: org.apache.naming.ResourceRef
Error processing the request (doGet) : Cannot create resource instance
javax.naming.NamingException: Cannot create resource instance
at org.apache.naming.NamingContext.lookup(NamingContext.java:837)
at org.apache.naming.NamingContext.lookup(NamingContext.java:181)
at org.apache.naming.NamingContext.lookup(NamingContext.java:822)
at org.apache.naming.NamingContext.lookup(NamingContext.java:194)
at CheckDBServlet.doGet(CheckDBServlet.java:40)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:1125)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:1264)
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:215)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase
.java:472)
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.StandardContext.invoke(StandardContext.java:2366)
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.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:
1005)
at
org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1098
)
at java.lang.Thread.run(Thread.java:484)
Thanks,
Srinivas Kumar
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: javax.naming.NamingException: Cannot create resource instance
Posted by Jacob Kjome <ho...@visi.com>.
Hello Kumar,
Try using the "username" parameter.
Also, the solution that has worked flawlessly for me is here:
http://marc.theaimsgroup.com/?l=tomcat-user&m=102225547106556&w=2
Note that this is with the new 4.1.x versions of Tomcat. If you are
using 4.0.x versions, your mileage may vary.
Jake
Monday, June 24, 2002, 10:00:38 AM, you wrote:
K> Hi,
K> Can anyone help me how to configure JDBC DataSource using IBM DB2 as the
K> database.I had gone through the solution "Generic DataSource Resource
K> Factory Available. JDBC Data Sources." posted by Mr.Anthony Dodd.But there
K> the solution was explained using Oracle database.Has anyone tried
K> configuring a DataSource using DB2?
K> I'm using IBM DB2 7.1 (Driver - COM.ibm.db2.jdbc.app.DB2Driver)
K> Tomcat 4.0.2
K> Here are the snippets for server.xml,web.xml and the JVM stack trace:
K> server.xml:
K> <Context path="/test" docBase="test" debug="0" reloadable="true">
K> <Resource name="jdbc/myDS" type="COM.ibm.db2.jdbc.DB2DataSource"
K> reloadable="true" auth="Container"/>
K> <ResourceParams name="jdbc/myDS">
K> <parameter>
K> <name>factory</name>
K> <value>org.apache.naming.factory.DataSourceFactory</value>
K> </parameter>
K> <Parameter>
K> <name>user</name>
K> <value>db2admin</value>
K> </Parameter>
K> <Parameter>
K> <name>password</name>
K> <value>db2admin</value>
K> </Parameter>
K> <Parameter>
K> <name>driverClassName</name>
K> <value>COM.ibm.db2.jdbc.app.DB2Driver</value>
K> </Parameter>
K> <Parameter>
K> <name>driverName</name>
K> <value>jdbc:db2:sample</value>
K> </Parameter>
K> </ResourceParams>
K> <Realm className="org.apache.catalina.realm.JDBCRealm"
K> connectionName="db2admin"
K> connectionPassword="db2admin"
K> connectionURL="jdbc:db2:sample"
K> digest="SHA"
K> driverName="COM.ibm.db2.jdbc.app.DB2Driver"
K> roleNameCol="role_name"
K> userCredCol="password"
K> userNameCol="user_name"
K> userRoleTable="user_roles"
K> userTable="users" />
K> </Context>
K> web.xml:
K> <resource-ref>
K> <description>DS resource factory</description>
K> <res-ref-name>jdbc/myDS</res-ref-name>
K> <res-type>COM.ibm.db2.jdbc.DB2DataSource</res-type>
K> <res-auth>Container</res-auth>
K> </resource-ref>
K> I get the following error when i try to lookup the datasource in my JSP:
K> ctx (java:comp/env) = org.apache.naming.NamingContext@42a80d
K> obj = myDS: org.apache.naming.ResourceRef
K> Error processing the request (doGet) : Cannot create resource instance
K> javax.naming.NamingException: Cannot create resource instance
K> at org.apache.naming.NamingContext.lookup(NamingContext.java:837)
K> at org.apache.naming.NamingContext.lookup(NamingContext.java:181)
K> at org.apache.naming.NamingContext.lookup(NamingContext.java:822)
K> at org.apache.naming.NamingContext.lookup(NamingContext.java:194)
K> at CheckDBServlet.doGet(CheckDBServlet.java:40)
K> at javax.servlet.http.HttpServlet.service(HttpServlet.java:1125)
K> at javax.servlet.http.HttpServlet.service(HttpServlet.java:1264)
K> at
K> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
K> FilterChain.java:247)
K> at
K> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
K> ain.java:193)
K> at
K> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
K> va:243)
K> at
K> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
K> 66)
K> at
K> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
K> at
K> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
K> at
K> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
K> va:215)
K> at
K> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
K> 66)
K> at
K> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase
K> .java:472)
K> at
K> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
K> 64)
K> at
K> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
K> at
K> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
K> at
K> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2366)
K> at
K> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164
K> )
K> at
K> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
K> 66)
K> at
K> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:462)
K> at
K> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
K> 64)
K> at
K> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
K> at
K> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
K> at
K> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
K> :163)
K> at
K> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
K> 66)
K> at
K> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
K> at
K> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
K> at
K> org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:
K> 1005)
K> at
K> org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1098
K> )
K> at java.lang.Thread.run(Thread.java:484)
K> Thanks,
K> Srinivas Kumar
K> --
K> To unsubscribe, e-mail: <ma...@jakarta.apache.org>
K> For additional commands, e-mail: <ma...@jakarta.apache.org>
--
Best regards,
Jacob mailto:hoju@visi.com
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>