JDBC sender adapter ERROR!

[former_member745782]

hello everybody!

i have a error with my jdbc sender adapter (I'm working with SAP PI 7.1).

i use connection with DB2 using this string connection.

JDBC driver: com.ibm.as400.access.AS400JDBCDriver

connection: jdbc:as400://192.168.xx.xx/SAPTEST

this is the SQL statement

*select * from STECT00F where TTSTAT = '0' ORDER BY TTCTBN FETCH FIRST 1 ROWS ONLY*

It work fine if i use <TEST> as Update SQL statement.

but when i use Update SQL statement i have back an error in adapter monitor:

Database-level error reported by JDBC driver while executing statement 'update STECT00F set TTSTAT = '9' where TTCTBN = (select TTCTBN from STECT00F where TTSTAT = '0' ORDER BY TTCTBN FETCH FIRST 1 ROWS ONLY)'. The JDBC driver returned the following error message: 'java.sql.SQLException: [SQL7008] STECT00F in SAPTEST non valido per l'operazione.'. For details, contact your database server vendor.

the Update SQL statement is the following:

update STECT00F set TTSTAT = '9' where TTCTBN = (select TTCTBN from STECT00F where TTSTAT = '0' ORDER BY TTCTBN FETCH FIRST 1 ROWS ONLY)

any suggestion? :(((

PS: i'm using transaction isolation level as default

Edited by: apederiva on Dec 6, 2010 6:22 PM

[stefan_grube · Accepted solution]

> where TTCTBN = (select

I think it should be in instead of =

where TTCTBN in (select

[former_member745782 · Accepted solution]

hi Stefan!

thanks.

I tryed but i have same error

Database-level error reported by JDBC driver while executing statement 'update STECT00F set TTSTAT='9' where TTCTBN in (select TTCTBN from STECT00F where TTSTAT='0' ORDER BY TTCTBN FETCH FIRST 1 ROWS ONLY)'. The JDBC driver returned the following error message: 'java.sql.SQLException: [SQL7008] STECT00F in SAPTEST non valido per l'operazione.'. For details, contact your database server vendor.

[stefan_grube · Accepted solution]

Did you google for this error message?

I think you should address IBM forum.

[former_member745782 · Accepted solution]

i found a IBM forum where they suggest to set Transaction Isolation Level to NONE.

i tried but i have a error on BPM

[stefan_grube · Accepted solution]

When you have an error in BPM, that means that your JDBC adapter is working now?

[former_member745782 · Accepted solution]

yes stefan!

actually now the problem is on BPM so i can close the question.

I think to solve the BPM problem myself.

So i solved changing isolation level

Thanks a lot