Apama 10.15.0 | Release Notes | What's New in Apama 5.2 | Upgrading to Apama-supplied JDBC and ODBC database drivers in 5.2
 
Upgrading to Apama-supplied JDBC and ODBC database drivers in 5.2
As in past releases, Apama 5.2 provides JDBC and ODBC database drivers. For Apama 5.2, these drivers have been upgraded and configured slightly differently than in past releases.
The drivers provided in previous releases are incompatible with Apama 5.2. The drivers provided in Apama 5.2 are incompatible with previous Apama releases. If you have pre-Apama 5.2 projects that use the previously-supplied drivers and you want to run those projects with Apama 5.2 then you must manually convert those projects to use the Apama 5.2 drivers.
To upgrade your project to use Apama 5.2 ODBC drivers, change your application so that it uses an ODBC driver supplied with Apama 5.2. See Registering your ODBC database DSN on Windows.
To upgrade your project to use Apama 5.2 JDBC drivers, change your application to use the new JDBC URLs and class names.
MSSQL
Old path:
apama_install_dir\lib\pgsqlserver.jar
New path:
apama_install_dir\lib\eysqlserver.jar
Old URL:
jdbc:progress:sqlserver://HOSTNAME::PORT;databaseName=DATABASENAME
New URL:
jdbc:sag:sqlserver://HOSTNAME::PORT;databaseName=DATABASENAME
Old class name:
com.prgs.jdbc.sqlserver.SQLServerDriver
New class name:
com.apama.jdbc.sqlserver.SQLServerDriver
Oracle
Old path:
apama_install_dir\lib\pgoracle.jar
New path:
apama_install_dir\lib\eyoracle.jar
Old URL:
jdbc:progress:oracle://HOSTNAME::PORT;databaseName=DATABASENAME
New URL:
jdbc:sag:oracle://HOSTNAME::PORT;databaseName=DATABASENAME
Old class name:
com.prgs.jdbc.oracle.OracleDriver
New class name:
com.apama.jdbc.oracle.OracleDriver
DB2
Old path:
apama_install_dir\lib\pgdb2.jar
New path:
apama_install_dir\lib\eydb2.jar
Old URL:
jdbc:progress:db2://HOSTNAME::PORT;databaseName=DATABASENAME
New URL:
jdbc:sag:db2://HOSTNAME::PORT;databaseName=DATABASENAME
Old class name:
com.prgs.jdbc.db2.DB2Driver
New class name:
com.apama.jdbc.db2.DB2Driver