HSQLDB: COMMIT within stored procedure

Question

Within HSQLDB, I'm trying to create a stored procedure that executes a commit after having updated the database.

Something like: CREATE PROCEDURE MY_PROC(IN p_id INTEGER) MODIFIES SQL DATA BEGIN ATOMIC ... UPDATE ... ... COMMIT; END

Creating this procedure, by means of a call to the JDBC Statement.execute() method, I get an error: SQLSyntaxErrorException: unexpected token: COMMIT required: END

Without the COMMIT statement, the procedure is compiled correctly.

Any idea what I'm doing wrong?

fredt · Accepted Answer · 2014-03-05 12:54:40Z

0

You cannot commit the transaction inside a procedure.

You can commit after calling the procedure.

answered Mar 5, 2014 at 12:54

fredt

24.5k3 gold badges43 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Robert Kock Over a year ago

That's what I was afraid of. Thanks anyway

Collectives™ on Stack Overflow

HSQLDB: COMMIT within stored procedure

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related