What's New in Apama > 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 database with ODBC.
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:
New path:
apama_install_dir\lib\pgsqlserver.jar
apama_install_dir\lib\eysqlserver.jar
Old URL:
New URL:
jdbc:progress:sqlserver://HOSTNAME::PORT;databaseName=DATABASENAME
jdbc:sag:sqlserver://HOSTNAME::PORT;databaseName=DATABASENAME
Old class name:
New class name:
com.prgs.jdbc.sqlserver.SQLServerDriver
com.apama.jdbc.sqlserver.SQLServerDriver
Oracle
Old path:
New path:
apama_install_dir\lib\pgoracle.jar
apama_install_dir\lib\eyoracle.jar
Old URL:
New URL:
jdbc:progress:oracle://HOSTNAME::PORT;databaseName=DATABASENAME
jdbc:sag:oracle://HOSTNAME::PORT;databaseName=DATABASENAME
Old class name:
New class name:
com.prgs.jdbc.oracle.OracleDriver
com.apama.jdbc.oracle.OracleDriver
DB2
Old path:
New path:
apama_install_dir\lib\pgdb2.jar
apama_install_dir\lib\eydb2.jar
Old URL:
New URL:
jdbc:progress:db2://HOSTNAME::PORT;databaseName=DATABASENAME
jdbc:sag:db2://HOSTNAME::PORT;databaseName=DATABASENAME
Old class name:
New class name:
com.prgs.jdbc.db2.DB2Driver
com.apama.jdbc.db2.DB2Driver
Copyright © Software AG, Darmstadt, Germany and/or Software AG USA Inc., Reston, VA, USA, and/or its Subsidiaries and or/its Affiliates and/or their licensors.
Use, reproduction, transfer, publication or disclosure is prohibited except as specifically provided for in your License Agreement with Software AG.