Multiple SQL execution
Posted by: Emjay Khan
Date: August 13, 2005 04:33AM

Hi.

I'm trying to have a PreparedStatement execute with multiple SQL statements.
For example,

UPDATE MY_DOC SET READ_CNT = READ_CNT + 1
WHERE DOC_ID = 'doc_001';

SELECT * FROM MY_DOC
WHERE DOC_ID = 'doc_001';

SELECT * FROM DOC_COMMENT
WHERE DOC_ID = 'doc_001';

Although I appended 'allowMultiQueries=true' to the url property,
it still complains something about syntax error.
Is there any way I can pull this off?

Thanks in advance.

(I'm using MySQL 5.x and the driver is 3.2.0 alpha on WinXP.)

Options: ReplyQuote


Subject
Written By
Posted
Multiple SQL execution
August 13, 2005 04:33AM
August 13, 2005 09:11AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.