jdbc receiver: SQL Exception

[Former Member]

Hi all,

We got the below system error in jdbc receiver scenario:

Unable to execute statement for table or stored procedure. 'xxx_001' (Structure 'Statement') due to java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'systm.MasterTracking'

What can be the possible reason and solution?

Thanks,

Durga

[Former Member]

Hi,

Do you have a msg sample for us to have a look at ? Without much details, it is hard to investigate ... Btw, are you using XMLSQL or native mode in the receiver channel ?

Rgds

Chris

[Former Member]

Hi,

Make sure that you are passing the Correct Table name according to the Database Table name. This is case sensitive.And also abt the Field names

Every thing we have to take care abt case sensitice in JDBC adapter.

Regards

Seshagiri

[Former Member]

But we got this error only for few interfaces and the remaining interfaces which r using the same communication channel are successful.

[Former Member]

Hi,

Iam agree with that.

But Here the problem is not with the CC configuration and all, the problem may be with the Table name and the field names mentioned in the JDBC Receiver structure.

Regards

Seshagiri