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,
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!