Connection Pooling in JBoss v5.0 with IBM DB2

[damodaran puliyassery]

I modify the db2-ds.xml file and put it in server/default/deploy folder.The file is

  
<?xml version="1.0" encoding="UTF-8"?>

<!-- ===================================================================== -->
<!-- -->
<!-- JBoss Server Configuration -->
<!-- -->
<!-- ===================================================================== -->

<!-- $Id: db2-ds.xml 43824 2006-04-16 21:48:44Z wprice $ -->


<datasources>
<local-tx-datasource>
<jndi-name>test</jndi-name>
<connection-url>jdbc:db2://localhost:50000/dbinventory</connection-url>

<!-- DB2 Universal Driver Note connection URL is in form of
jdbc:db2://host:port:dbname

Default port for Type 4 driver is 50000

Note, host and port must be specified if using Type 4 driver. And be forewarned, no native
XA support is provided with Type 4; you must set a DB property calling for Type 2 to get XA

<driver-class>com.ibm.db2.jcc.DB2Driver</driver-class>
<connection-url>jdbc:db2://[hostname]:[port]/databasename"</connection-url>

Please see http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0512kokkat/
or the DB2 JDBC application developers manual.
-->

<driver-class>COM.ibm.db2.jdbc.app.DB2Driver</driver-class>
<user-name>admin</user-name>
<password>admin</password>
<min-pool-size>0</min-pool-size>
<max-pool-size>50</max-pool-size>

<!-- New org.jboss.resource.adapter.jdbc.vendor.DB2ExceptionSorter

<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.DB2ExceptionSorter</exception-sorter-class-name>

-->

<!-- sql to call when connection is created
<new-connection-sql>some arbitrary sql</new-connection-sql>
-->

<!-- sql to call on an existing pooled connection when it is obtained from pool
<check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
-->

<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->


<metadata>
<type-mapping>DB2</type-mapping>
</metadata>
</local-tx-datasource>

</datasources> 

And in J2EE i write this code

    
try
{
ic=new javax.naming.InitialContext();
ds=(javax.sql.DataSource)ic.lookup("test");
conn=ds.getConnection();
}
catch(Exception e)
{
System.out.println("Error in DBConnection "+e.getMessage());
} 

But i got this error Message:- Error in DBConnection test not bound
I have to do any more changes?Why this error??Somebody please help......

thanks in advance....

[Jaikiran Pai]

By default the datasource will bind to java: namespace. So use java:test as the jndi name during the lookup. And remember that the java: namespace is visible only to clients running in the same JVM as the server where the datasource is deployed.

[damodaran puliyassery]

I use java:test in lookup.i copied the file db2java.jar to jboss<HOME>/server/default/lib folder.But i got this error while try to create connection.
I used the driver name as COM.ibm.db2.jdbc.app.DB2Driver.
Please help me...

   23:05:13,905 WARN  [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Wrong driver class for this connection URL)
	at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:225)
	at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:195)
	at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:611)
	at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:257)
	at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:607)
	at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)
	at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:381)
	at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
	at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
	at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
	at general.DBConnection.<init>(DBConnection.java:19)
	at Login.doPost(Login.java:28)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
	at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
	at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:601)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
	at java.lang.Thread.run(Unknown Source)
Caused by: org.jboss.resource.JBossResourceException: Wrong driver class for this connection URL
	at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:209)
	... 33 more
23:05:13,925 INFO  [STDOUT] Error in DBConnection Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Wrong driver class for this connection URL); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Wrong driver class for this connection URL)) 

[Mark E Hansen]

The error says you're using the wrong driver class for the url. What that means is the driver class, COM.ibm.db2.jdbc.app.DB2Driver (as you say in your message) doesn't work with the connection url you have specified in the datasource descriptor, jdbc:db2://localhost:50000/dbinventory.

It's been a long time since I worked with DB2, so unless someone can give you better help here, you'll need to look up the JDBC driver help provided by IBM and see what they say. They should include examples of how to configure the datasource properly.

In looking at the xml file you provided, I did notice two things. First, the driver class specified in the file is different from the one specified in the commented instructions in the file - one uses com while the other uses COM. Are you sure you have that correct.
Secondly, it seems the URL format is different for the different types of drivers. Again, read through the documentation and make sure you're using all the correct configuration information for the drive you wish to use.

I hope this helps,