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):


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.

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.