tags:

views:

9

answers:

0

Hello, I know that I could separate all statements by pre-cutting before their execution, but I have a case in which I would like to insert a series of statements in one execution, currently I receive the following error:

Caused by: java.sql.SQLException: Syntax Error: Encountered ";" at line 2, column 33.
    at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
    ... 17 more
Caused by: ERROR 42X01: Syntax Error: Encountered ";" at line 2, column 33.

Also do you know also if Derby supports conditional statements like that in pgsql case when else?

Thanks