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
Integration server: 6.1
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.
The problem was fixed… there was discrepancy in JDBC drivers.