Error in sender JDBC Adapater

[Former Member]

I have a select query as

SELECT * FROM ULIDTA2.F5631505 where QSINTF ='Y'

update query is

Update ULIDTA2.F5631505 set QSINTF='Y' where QSINTF ='N'

i get the following error in my Adapater .

Sender Adapter v2108 for Party '', Service 'BS_Database_to_RFC_BPM':

Configured at 2006-03-10 12:31:18 GMT+08:00

History:

- 2006-03-10 12:33:06 GMT+08:00: Retry interval started. Length: 60.000 s

- 2006-03-10 12:33:05 GMT+08:00: Error: SQLException during update 'Update ULIDTA2.F5631505 set QSINTF='Y' where QSINTF ='N'': SQLException: [SQL7008] F5631505 in ULIDTA2 not valid for operation.

- 2006-03-10 12:33:00 GMT+08:00: Processing started

- 2006-03-10 12:32:05 GMT+08:00: Error: SQLException during update 'Update ULIDTA2.F5631505 set QSINTF='Y' where QSINTF ='N'': SQLException: [SQL7008] F5631505 in ULIDTA2 not valid for operation.

- 2006-03-10 12:32:00 GMT+08:00: Processing started

[Former Member]

Hi Amit,

I think ULIDTA2.F5631505 is ur table name and it is causing some problem.Its taking the ULIDTA2 as a variable, if i am right.

Try with some other table having a simpler name.

Regards,

Sudharshan

[Former Member]

in that case select also should have also given a problem

on as 400 u execute the query as

select * from libraryname.tablename ;

select is fine only update is giving a issue

[bhavesh_kantilal]

Hi Amit,

Can you try to use this same Update Query in your Client Databse and check if it is exectuing fine or if it is showing up some error.

Regards,

Bhavesh

[Former Member]

yes the same update query is working at the client database . thats the problem it is working directly on As400 but not through XI

[bhavesh_kantilal]

Hi Amit,

I know this might sound stupid, but can you ckeck the Update query of your Sender Adapter. the error log you have pasted shows a double quote after n.

<i>- 2006-03-10 12:32:05 GMT+08:00: Error: SQLException during update 'Update ULIDTA2.F5631505 set QSINTF='Y' where QSINTF ='N'': SQLException: [SQL7008] F5631505 in ULIDTA2 not valid for operation.</i>

Can you check in the sender adapter, if your Update query has the corerect synatx and activate the adapter again.

Regards,

Bhavesh

[Former Member]

Hi,

Plz go through the following link and i think this will help u to solve the above error.

http://www.websina.com/bugzero/faq/exception-as400.html

Regards,

Sudheer.

[Former Member]

even i looked at this link . but dont understand if there is still something that has to be done at mu end to resolve it .

[Former Member]

check for the "journaling" status of your database. I guess this is the problem with transactions.

Regards,

Amol

[Former Member]

Hi Amit,

A JDBC sender adapter has 2 essential fields,

1. SQL Statement

2. Update Statement

Your SQL statement will contain your SELECT statement and once your SQL statement is executed, UPDATE statement is executed. This is done so that records that have been selected by the SQL statement should not be selected again as the JDBC sender adapter will poll over the database for every poll interval.

If you want to SELECT something from your Database, then you will have to go for a JDBC sender adapter.

But, if you want to insert/update your Database, then you can go for a JDBC receiver adapter.

Multiple insertions are possible for a JDBC receiver, but multiple Selection queries (different select queries) are not possible for a single JDBC sender adapter.

Just check these links to understand how JDBC adapters work,

If you wanna do update/insert you will have to follow the

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm">Document Formats for the Receiver JDBC Adapter</a>

For Configuring the Receiver JDBC Adapter refer:

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm">Configuring the Receiver JDBC Adapter</a>

For Configuring the Sender JDBC Adapter refer:

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm">Configuring the Sender JDBC Adapter</a>

Regards,

Abhy