Apache Derby supports natively script delimiters?
- by Steel Plume
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