Skip to Content
0
Former Member
Aug 13, 2008 at 04:14 PM

multiple sql statements from java

981 Views

I am executing sql statements in MaxDB 7.6.04.12 from java using jdbc.

I want to execute multiple statements at a time, but it seems that however I separate the statements, I get

com.sap.dbtech.jdbc.exceptions.DatabaseException: [-3014] (at 433): Invalid end of SQL statement

I have tried separating the statements with just a semi-colon, with a semi-colon and new line, with newline-//-newline (as works with SQL Studio), but whatever I try I get this error or some other.

Is it possible to do this? and if so how?

Thanks

Chris