Time for a new JDBC driver for IBM Business Process Manager?
VictorPauloAlvesdeAlmeida 120000JJSK Comment (1) Visits (6569)
IBM Business Process Manager comes with Java database connectivity (JDBC) drivers for DB2, Oracle, and Microsoft SQL Server databases. The version of the database JDBC drivers represents the level of the database product at the moment that the IBM Business Process Manager (BPM) product was released. A good practice is to update these drivers to fit the latest version of your database vendor.
Is there any way to know the version of my driver?
Yes, you can find the information using the BPM_
Note: The output of the command above is: IBM Data Server Driver for JDBC and SQLJ 4.11.69
For Oracle jdbc driver:
Note: The output of the command above is: Oracle 220.127.116.11.0 JDBC 4.0 compiled with JDK6
You can check the version of DB2 JDBC drivers by database level in the DB2
For example, if you are using a IBM Business Process Manager Version 8.0.1, you probably have JDBC driver version 4.11.69 because it comes as the default driver version with the product binaries. However, let us suppose that you have DB2 database Version 9.7.0 Fix Pack 5 (18.104.22.168) and you are using it as back-end database for the IBM Business Process Manager databases. In this example, your JDBC driver is out-of-date because this DB2 version comes with JDBC driver Version 4.13.80 if you are using JDBC type 4. To update your JDBC driver, complete the following steps:
[3/17/14 11:57:26:122 BRT] 00000000 InternalGener I DSRA8203I: Database product name : DB2/AIX64
[3/17/14 11:57:26:123 BRT] 00000000 InternalGener I DSRA8204I: Database product version : SQL09075
[3/17/14 11:57:26:124 BRT] 00000000 InternalGener I DSRA8205I: JDBC driver name : IBM Data Server Driver for JDBC and SQLJ
[3/17/14 11:57:26:124 BRT] 00000000 InternalGener I DSRA8206I: JDBC driver version : 4.13.80
[3/17/14 11:57:26:124 BRT] 00000000 InternalGener I DSRA8218I: JDBC driver specification level : 4.0
You have now updated your JDBC driver. The advice is always to be up-to-date with your JDBC drivers so that you can avoid unexpected errors due some failures coming from the driver.
What about you? Do you have any thoughts about this topic?