Hi,
I just ran the query with mysql-connector-java-5.1.6 -- and it seems to
work OK.

1641 test TRACE [main] openjpa.jdbc.SQL - <t 23776721, conn 22927632>
executing prepstmnt 21830977 UPDATE JBT_Order_Product SET product_id=? WHERE
EXISTS (SELECT o.id FROM JBT_Order o WHERE o.scenario=0 AND o.id = order_id)
[params=(int) 100]


--
Sent from the OpenJPA Users mailing list archive at Nabble.com.