cancel
Showing results for 
Search instead for 
Did you mean: 

multiple sql statements from java

Former Member
0 Kudos
1,097

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

View Entire Topic
Former Member
0 Kudos

Hi Lars,

As I understand it - and I'm open to correction - the issue is the visibility of the temporary tables, and that is not about executing the statements in a single transaction, but executing them all from the same connection.

I think maybe our posts crossed - as I said above, I've found a workaround.

Thanks again for your help.

Chris

lbreddemann
Active Contributor
0 Kudos

HI Chris,

yep - temporary tables are just visible from within a single transaction. And one transaction is always bound to one session.

As I wrote: perhaps you don't need db-temporary tables. Perhaps you need something else, like data that you store in regular tables and access it later on and delete it again eventually.

As a matter of fact, temporary tables are most often misused for cases where views would have done the same thing.

Best regards,

Lars

p.s.

you are allowed to give points