[jboss-user] [Datasource Configuration] - Wrong driver class [class comm.ibm.db2.jcc.db2Driver]

[Joseph Fouts]

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]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20120213/65ee3c5f/attachment-0001.html