JDBC java SQL Exception error

[Former Member]

Hi all,

I am getting the following SQL error for the JDBC adapter.

<u><i>TransformException error in xml processor class: Error processing request in sax parser: Error when executing statement for table/stored proc. 'CUSTOMER' (structure 'statementname'): java.sql.SQLException: [SQL7008] TEST1 in QGPL not valid for operation.</i></u>

Need help to solve the problem.

Will be rewarded points for sure.

Thanks,

Andy

[bhavesh_kantilal · Accepted solution]

Andy,

Can you post the message being sent from XI to the Adapter / the response payload.

Regards,

Bhavesh

[Former Member · Accepted solution]

Hi Bhavesh,

The following is the XML message payload

<?xml version="1.0" encoding="utf-8" ?>

- <ns1:TESTCUSTOMER xmlns:ns1="http://test.com/xi/JDBC">

- <statementname>

- <CUSTOMER action="insert">

- <access>

<TEST1>100</TEST1>

</access>

</CUSTOMER>

</statementname>

</ns1:TESTCUSTOMER>

Thank you and appreciate your help.

[bhavesh_kantilal · Accepted solution]

Andy,

Can you confirm the follwoing,

1, CUSTOMER is the name of the TABLE.

2. TEST1 is a column exisiting in your table.

Also, if you have an DB client, try this insert query and see if it works,

insert into CUSTOMER(TEST1) values('100)

Is the insertion succcesful.?

Finally, try chaning TEST1 to test1 and /or CUSTOMER to customer .

Regards,

Bhavesh

[moorthy · Accepted solution]

HI,

This is not as per the document format expected by JDBC ..

Check this part of help-

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

Regards,

Moorthy

[Former Member · Accepted solution]

Hi Bhavesh,

My table is CUSTOMER and Column is TEST1.

We wrote a JAVA programme to insert the data into the Table using the same JDBC driver and worked fine.

I tried by changing the name of the Table and Column to test and customer.

Then I got a SQL fault error.

Thank you.

[bhavesh_kantilal · Accepted solution]

Andy,

Use this settingto see the SQL coming out of your adapter,refer note : 801367

<i>JDBC Receiver Adapter Parameters

1. Parameter name: "logSQLStatement"

Parameter type: boolean

Parameter value: true for any string value, false only for empty string

Parameter value default: false (empty String)

Available with: SP9

Category: 2

Description:

When implementing a scenario with the JDBC receiver adapter, it may be helpful to see which SQL statement is generated by the JDBC adapter from the XI message content for error analysis. Before SP9, this can only be found in the trace of the JDBC adapter if trace level DEBUG is activated. With SP9, the generated SQL statement will be shown in the details page (audit protocol) of the message monitor for each message directly.

This should be used only during the test phase and not in productive scenarios.</i>

Regards,

Bhavesh

[Former Member · Accepted solution]

Hi Bhavesh,

I am sorry for the late reply.

The problem is solved.The error was due to the commit in the database.

I didn't use any Parametrs in the Advance Mode.

I Thank you and appreciate for the great help.

Andy Wick.