update statement problem for jdbc adapter

24 Views

Hi all

In the jdbc sender adapter, I configured as follows:

Query statement

select * from pickdiff where tid is null

Update statement

delete from pickdiff where tid is null

I got following error message:

Database-level error reported by JDBC driver while executing statement 'delete from pickdiff where tid is null'. The JDBC driver returned the following error message: 'java.sql.SQLException: [SQLServer 2000 Driver for JDBC][SQLServer]Die Unterabfrage gab mehr als einen Wert zurück. Das ist ungültig, wenn die Unterabfrage auf =, !=, <, <= , >, >= folgt oder als Ausdruck verwendet wird.'. For details, contact your database server vendor.

If I change the Update statement to

update pickdiff set tid = 'sapxi' where tid is null

Then everything is ok.

Doese any one have some idea about this problem?

Regards

Hui