JDBC Adapter connection problem - catalog separator @

, , ,
1

Hello,

I have problem with JDBC Adapter connection.
Configuration:
Transaction type: LOCAL_TRANSACTION
DataSource Class: com.wm.dd.jdbcx.oracle.OracleDataSource
Other Properties: driverType=thin

[b]Environment:[/b]
IS: 9.6.0.0
IS Updates: IS_9.6_Core_Fix5
JDBC Adapter: Version 6.5, fix: WmJDBCAdapter_6.5_Fix28, JDBC_6.5_Fix42, JDBC_6.5_Fix50, JDBC_9.0_fix1

When I called stored procedure (Oracle: 11.2.0.2) then get error:

[ADA.1.316] Cannot execute the SQL statement "call SCHEMA_NAME@PACKAGE_NAME.PROCEDURE_NAME (?, ?, ?, ?) ". "
(HY000/6550) [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 7:
PLS-00352: Unable to access another database ‘PACKAGE_NAME.PROCEDURE_NAME’
ORA-06550: line 1, column 7:
PLS-00201: identifier ‘SCHEMA_NAME@PACKAGE_NAME.PROCEDURE_NAME’ must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

JDBC driver uses invalid catalog separator ‘@’.
Do you have any idea to change parameter value ‘catalog separator’ from ‘@’ to ‘.’ ?
This stored procedure works fine on IS 8.2.

Thanks.

2

In your JDBC connection what is the value given in the “Other Properties”. I assume you have the latest JDBC fix installed.

3

Other properties: driverType=thin

Yes I have latest JDBC fix (JDBC_9.0_fix1).

4

Hi Jaroslaw,

what is the reason you have applied JDBC_9.0_Fix1 to the JDBC-Adapter 6.5?

Latest Fix for JDBC-Adapter 6.5 I am aware of is Fix51.

JDBC_9.0_Fix1 should only be applied to JDBC-Adapter 9.0 which is available for all wM 9.x Versions.

The mismatch in the versions might be the cause for your issue.

Regards,
Holger

5

Since your adapter version of JDBC is 6.5 roll back the fix (JDBC_9.0_fix1)

6

I install JDBC Adapter Version: 9.0.0.0 and fix: JDBC_9.0_Fix1.
Problem still exist… any idea?

7

In this case you will have to open an incident at SAG Support.

Another option might be to revert the Adapter to 6.5 and try again.

Can you try with an ojdbc.jar from Oracle TechNet?

Can you share a screeshot of your adapter service?

Regards,
Holger