Error in DB2 connection Pooling

[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>   

then i write J2EE code as

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

then
i got an error in eclipse as

  
12:04:16,744 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: Failed to register driver for: COM.ibm.db2.jdbc.app.DB2Driver; - nested throwable: (java.lang.ClassNotFoundException: COM.ibm.db2.jdbc.app.DB2Driver))
	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:18)
	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: Failed to register driver for: COM.ibm.db2.jdbc.app.DB2Driver; - nested throwable: (java.lang.ClassNotFoundException: COM.ibm.db2.jdbc.app.DB2Driver)
	at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getDriver(LocalManagedConnectionFactory.java:489)
	at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:206)
	... 33 more
Caused by: java.lang.ClassNotFoundException: COM.ibm.db2.jdbc.app.DB2Driver
	at java.net.URLClassLoader$1.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.net.URLClassLoader.findClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at java.lang.ClassLoader.loadClassInternal(Unknown Source)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Unknown Source)
	at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getDriver(LocalManagedConnectionFactory.java:474)
	... 34 more
12:04:16,753 INFO  [STDOUT] Error in DBConnection Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Failed to register driver for: COM.ibm.db2.jdbc.app.DB2Driver; - nested throwable: (java.lang.ClassNotFoundException: COM.ibm.db2.jdbc.app.DB2Driver)); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Failed to register driver for: COM.ibm.db2.jdbc.app.DB2Driver; - nested throwable: (java.lang.ClassNotFoundException: COM.ibm.db2.jdbc.app.DB2Driver)))
12:04:16,753 INFO  [STDOUT] Error:- [Ljava.lang.StackTraceElement;@36ee92

I have to do any more changes?Why this error??Somebody please help......

thanks in advance....

[Jaikiran Pai]

Caused by: java.lang.ClassNotFoundException: COM.ibm.db2.jdbc.app.DB2Driver

This says it all. Have you placed the DB2 JDBC driver jar file in JBOSS_HOME/server/<servername>/lib folder?

[damodaran puliyassery]

Sir i am not copied that file.
Where that file is located??

[Jaikiran Pai]

Damodaran,

Please do not create more than one topic for the same question. I'm closing this one. Please continue the discussion in your other thread here http://www.coderanch.com/t/476484/JBoss/java-lang-ClassNotFoundException-COM-ibm