Joseph Fouts [https://community.jboss.org/people/foutjo] created the discussion
"Wrong driver class [class comm.ibm.db2.jcc.db2Driver]" To view the discussion, visit: https://community.jboss.org/message/716299#716299 -------------------------------------------------------------- Trying to get db2 univeral type 4 driver to work with jboss 7.1 and keep getting : Caused by: javax.resource.ResourceException: Wrong driver class [class com.ibm.db2.jcc.DB2Driver] for this connection URL [jdbc:db2//10.90.10.125/apdev70:60009] at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:251) --------------------------------------------------------------------------- DB2 Version 8.1 Used jar files from IBM/SQLLIB/java -------------------------------------------------------------------------- Setup db2 driver as module: modules/com/ibm/db2/main/db2jcc.jar /db2jcc_license_cu Created module.xml file: <?xml version="1.0" encoding="UTF-8"?> <!-- ~ This file will define the DB2 database driver and any ~ dependencies. --> <module xmlns="urn:jboss:module:1.1" name="com.ibm.db2"> <resources> <resource-root path="db2jcc.jar"/> <resource-root path="db2jcc_license_cu.jar"/> </resources> <dependencies> <module name="javax.api"/> <module name="javax.transaction.api"/> <module name="sun.jdk"/> </dependencies> </module> ----------------------------------------------------------------------------------- Verifed database IP/Port/Name 10.90.10.125 60009 apdev70 ------------------------------------------------------------------------------------ Added db2 datasource to standalone.xml | | <datasources> | | | <datasource jndi-name="java:/admindatasource" pool-name="admindatasource" enabled="true" jta="true" use-java-context="true" use-ccm="true"> | | | <connection-url> | | | jdbc:db2//10.90.10.125/apdev70:60009 | | | </connection-url> | | | <driver> | | | db2jcc | | | </driver> | | | <timeout> | | | <idle-timeout-minutes> | | | 0 | | | </idle-timeout-minutes> | | | <query-timeout> | | | 600 | | | </query-timeout> | | | </timeout> | | | </datasource> | | | <drivers> | | | <driver name="db2jcc" module="com.ibm.db2"> | | | <driver-class> | | | com.ibm.db2.jcc.DB2Driver | | | </driver-class> | | | </driver> | | | </drivers> | | | </datasources> | -------------------------------------------------------------------------------------------------------- Java code connection: InitialContext ic = new InitialContext(); DataSource ds = (DataSource)ic.lookup("java:/admindatasource"); Connection con = ds.getConnection(); _____________________________________________________________ When starting standalone server get the following log messages: (See that the db2 driver is deployed and that the "admindatsource" is Bound 13:00:15,404 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 26) JBAS010403: Deploying JDBC-compliant driver class com.ibm.db2.jcc.DB2Driver (version 2.11) 13:00:15,430 INFO [org.jboss.as.remoting] (MSC service thread 1-5) Listening on /10.100.100.12:4447 13:00:15,932 INFO [org.jboss.as.remoting] (MSC service thread 1-6) Listening on /10.100.100.12:9999 13:00:15,969 INFO [org.jboss.as.server.deployment.scanner] (MSC service thread 1-1) JBAS015012: Started FileSystemDeploymentService for directory C:\apps\jboss-as-7.1.0.CR1b\standalone\deployments 13:00:16,388 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-2) JBAS010400: Bound data source [java:/admindatasource] ------------------------------------------------------------------------------------------------------ So any ideas on why I am getting the following error when trying to make a connection? Any help is greatly appreciated. Thanks. -------------------------------------------------------------- Reply to this message by going to Community [https://community.jboss.org/message/716299#716299] Start a new discussion in Datasource Configuration at Community [https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]
_______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
