We are in the process of upgrading out IS from WM 6.1 to 6.5. We are also upgrading the OS from Windows to AIX 5.3. We decided to upgrade the JDBC Adapter from 603 to 6.5. When I try enabling any of our Adapter Notifications I get the following error:
[ART.116.3038] Adapter Runtime (Notification): Error in Notification Callback:enableCallback notification Z_Stran.POC:testSTNotification.
[ADA.1.316] Cannot execute the SQL statement “Unable to get metadata.”. "
(17008) Closed Connection"
We are hitting an Oracle 9i database.
I even tried creating an adapter notification from scratch and still get the same error.