JDBC comm.channel issue with MS SQL select statement

[Former Member]

Hello,

We are using JDBC adapter to connect to an MS SQL database.

This is the comm.channel config.

com.microsoft.sqlserver.jdbc.SQLServerDriver

jdbc:sqlserver://<DNSname>:1433;databaseName=PSMI

Activation of channel is successful.

But when starting a select on a table of the database we will get this error for any table there in comm.channel monitoring.

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'TABLENAME' (structure 'STATEMENT'): com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'SAP_Header'.

Error processing request in sax parser: Error when executing statement for table/stored proc. 'TABLENAME' (structure 'STATEMENT'): com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'SAP_Header'.

Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'TABLENAME' (structure 'STATEMENT'): com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'SAP_Header'.

The table is existing because we can access it from excel database connect.

The connect address is the same in Excel as in comm.channel.

Installed driver is for JDBC for 2000/2005 (1.2/4). for JDK 1.4

Your help is really appreciated!

Best regards

Dirk

[Former Member]

Make sure the created datatypes are in correct DB format.

http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards

Ramg

[former_member193386]

I think you have a problem with your structure to receive the messege for your database, you need build a structure like this:

st1   +(0..unbounded)+
    dbTableName +(1..1)+
        action	+(required) (xsd:string)+
        table +	+(0..1) (xsd:string)+ <here You need to put the name of yor table in the column value>
        access 	+(1..1)+
                <your collumns from table >
        key     +(1..1)+
                <You need put your key columns if You need do a Update/Delete>

Look this example on SAP ( http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm )

[Former Member]

Hi Dirk,

 This is the comm.channel config.
com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc:sqlserver://<DNSname>:1433;databaseName=PSMI

I hope the DNSname you using is your Server name of the SQL Server (IP/ServerName) you trying to connect to.

Please ensure that if you are using Hostname the entry is made in the host file at server level against the IP.

Try using the Connection string as :

jdbc:microsoft:sqlserver://IP(hostname)\ServerName;DatabaseName

Cheers

Dhwani

Edited by: dhwani kamdar on Jun 11, 2010 5:31 PM