db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Shreyas Kaushik <Shreyas.Kaus...@Sun.COM>
Subject Re: Executing multiple SQL statements withing a single Statement
Date Mon, 21 Mar 2005 15:22:39 GMT
Why don't you consider using addBatch() and executeBatch(). I don't 
think what you are using is a standard feature.

~ Shreyas

Arunanthisivam Vimalathithen 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! 
> <http://us.rd.yahoo.com/evt=31637/*http://smallbusiness.yahoo.com/resources/> 

View raw message