installing db-driver as a deployment

[nimo22]

Hello,

I use Jboss 7 and have installed a DB2-datasource as as module, which works fine.

However, when installing this jdbc driver as a deployment instead of a moduel, it does not work:

I have placed these jars into my standolne/deployment-directory:

-db2jcc4.jar (db2jcc4.jar has already build in META-INF/services/java.sql.Driver)

-db2jcc_license_cu.jar

with my test.war file.

I defined the ds in standalone.xml:

<datasource jndi-name="dsTest" use-java-context="true" pool-name="dsTest">

            <connection-url>jdbc:db2://...</connection-url>

            <driver>db2jcc4</driver>

                <pool></pool>

            <security>

                <user-name>..</user-name>

                  <password>..</password>

            </security>

            <validation></validation>

</datasource>

<drivers>

    <driver name="db2jcc4" module="com.ibm.db2">

      <driver-class>com.ibm.db2.jcc.DB2Driver</driver-class>

    </driver>

</drivers>

When doing a "dodeploy",  i get this log-msg:

New missing/unsatisfied dependencies:

      service jboss.jdbc-driver.db2jcc4 (missing)

..

15:19:19,953 INFO  [org.jboss.as.server.controller] (DeploymentScanner-threads - 2) Deployment of "db2jcc_license_cu.jar" was rolled back with no failure message

15:19:19,953 INFO  [org.jboss.as.server.controller] (DeploymentScanner-threads - 2) Deployment of "db2jcc4.jar" was rolled back with no failure message

15:19:19,984 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-4) Stopped deployment test.war in 47ms

15:19:19,984 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-4) Stopped deployment db2jcc_license_cu.jar in 30ms

15:19:19,984 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-4) Stopped deployment db2jcc4.jar in 30ms

..

According to documentation, I have understood putting db-driver into the deployment-directory is enough the get the dependency. Am I wrong?

[gonne]

I think it does not work to deploy the DB2 JDBC driver as deployment, because the db2jcc.jar depends on the license jar db2jcc_license_cu.jar and these are 2 isolated deployments. Besides that I suppose your driver name in the datasource definition must match with the name of your JDBC jar.

Have a look at "Define the datasource" in https://docs.jboss.org/author/display/AS7/How+do+I+migrate+my+application+from+AS5+or+AS6+to+AS7

Kind regards,

Gonne

[nimo22]

Yes, you are right.

If a db-driver consists of more than one jar, than only module deployment will be allowed.

thank you!

[antonio_bruno]

So if I use external libraries, and these interact with each other, I'm forced to use modules of jboss? I can not use another mechanism to link these external libraries?

Thanks in advance.

Antonio