Hi All,
I’m calling stored procedure using JDBC adapter service (stored proc with signature). The strange thing is when I deploy the package containing the adapter service to another server. The name of the stored proc is appended by ;1(E.g. stored proc name on Server A=abc, after deploying on server B the stored proc name becomes abc;1) and in some cases the name changes all together pointing so some other stored procedure in the database.I would appreciate any inputs to fix this problem
Environment
Integration server: 6.1
Updates:
IS_6-1_SP2
TNS_6-1_SP1
JDBC adapter version: 6.0.3
Database I’m connecting to MS SQL 2005
Note: There is firewall between our organization and the client(SQL2005).The adapter connection is enable without any errors.
Thank you,
Salvo.
The problem was fixed… there was discrepancy in JDBC drivers.