db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dan Scott <deni...@gmail.com>
Subject Re: Executing multiple SQL statements withing a single Statement
Date Mon, 21 Mar 2005 15:13:31 GMT
J2SE documentation says that Statement.execute():

"Executes the given SQL statement"

It sounds like you're relying on non-standard behavior in your other
JDBC driver.

You might want to look into the executeBatch() method for a
standardized (but optionally implemented) means of achieving the same


On Mon, 21 Mar 2005 06:13:40 -0800 (PST), Arunanthisivam Vimalathithen
<vimalathithen@yahoo.com> wrote:
> Hi, 
> Derby does not seem to be supporting multiple SQL statetments that can be
> passed as a single string to one Statement as in other databases (eg :-
> Statement.execute(CREATE table A(test VARCHAR(64));CREATE table B(test
> VARCHAR(64));)). (Derby seems to error out in the semicolon after the first
> CREATE statement) Is there a way around this, or must we invoke the ij tool
> within the program to run the script to invoke an sql script file? 
> Thanks in advance, 
> V.
>  ________________________________
> Do you Yahoo!?
>  Yahoo! Small Business - Try our new resources site! 

View raw message