KrisSimonis
Programmer
Hi,
I'm having trouble with the JdbcDriver class for the Oracle 9i database.
When I tryin to send multiple operations to my database in
the 'execute(String SQL)' method that are separated with the ';' command seperator, I get errors about the syntax being invalid. Using the addBatch(String SQL) and executeBatch methods everything works just fine. However,
with the structure of my objects in my code, differentiating between when to use one or the other is rather difficult since the SQL operation(s) are return from a different class and without extra code that re-examines the statement and breaks it up in batches the only way I can do the operation(s) is with the execute method. With a Microsoft SQL database, I didn't have any problems doing exactly this, does anyone know if there is a workaround or other solution to this problem?
I'm having trouble with the JdbcDriver class for the Oracle 9i database.
When I tryin to send multiple operations to my database in
the 'execute(String SQL)' method that are separated with the ';' command seperator, I get errors about the syntax being invalid. Using the addBatch(String SQL) and executeBatch methods everything works just fine. However,
with the structure of my objects in my code, differentiating between when to use one or the other is rather difficult since the SQL operation(s) are return from a different class and without extra code that re-examines the statement and breaks it up in batches the only way I can do the operation(s) is with the execute method. With a Microsoft SQL database, I didn't have any problems doing exactly this, does anyone know if there is a workaround or other solution to this problem?