The UX Platform for the Frontline Workforce

DB2 Driver Licenses

When trying to connect to some DB2 versions from the AE, you might encounter an error like the following:

Could not connect to database […] the version of the IBM Universal
JDBC driver in use is not licensed for connectivity to QDB2 databases.
To connect to this server, please obtain a licensed copy of the IBM DB2
Universal Driver for JDBC and SQLJ.  An appropriate license file
db2jcc_license_*.jar for this target platform must be installed to the
application class path.  Connectivity to QDB2 databases is enabled by
[…] the following license file: db2jcc_license_cisuz.jar

The specific file named (which may vary depending on the version) needs to be obtained from the customer's DB admin. (It can typically be found in C:\Program Files\IBM\SQLLIB\java.) It should be placed on the appliance in the following location (which is where the existing JDBC drivers are):

/home/mdw/appserver/jboss-4.0.5.GA/server/default/deploy/webalo.ear/lib [R21]

- or -

/home/mdw/appserver/jboss-6.0.0.Final/server/jbossweb-standalone/deploy/webalo.ear/lib [R22]

You should probably set the permissions and ownership/group to the same as the other .jar files in this folder (755, mdw/mdw). Next, the application.xml file in:

/home/mdw/appserver/jboss-4.0.5.GA/server/default/deploy/webalo.ear/META-INF [R21]

- or -

/home/mdw/appserver/jboss-6.0.0.Final/server/jbossweb-standalone/deploy/webalo.ear/META-INF [R22]

needs to be modified to add a reference to the file. You can copy and modify an existing entry, to look like the following (for the specific file above):

    <module>
        <java>lib/db2jcc_license_cisuz.jar</java>
    </module>

Finally, the appliance can be rebooted, or you can simply restart the MDW service with the following command:

service webalo-md restart

You should then be able to get a successful test connection to the DB2 server. Make sure the port specified is actually the one they use -- our default is not always correct.

Presumably, installing a JDBC driver for some database that is not supported by default (e.g. MySQL) would involve similar steps, but I haven't been through that yet.

W
Webalo is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.