J2SE documentation says that Statement.execute(): "Executes the given SQL statement" (http://java.sun.com/j2se/1.5.0/docs/api/java/sql/Statement.html)
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 goals. Dan On Mon, 21 Mar 2005 06:13:40 -0800 (PST), Arunanthisivam Vimalathithen <[EMAIL PROTECTED]> 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! > >
