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/>
