Magnus Prime wrote on 11.03.2008 19:05:
Thanks for the quick reply. I read through that, and I could use the
runScript method of IJ, but is there nothing inside through standard JDBC
that allows me to do that? Anything like starting a transactions, running
them all, then commiting the transaction? Or trying to commit after each
create table?
The reason I ask, is that as of now, I am using Derby, but I dont want to be
tied into any DB way of doing things... thats why I was hoping for some
generic method using standard JDBC only.
The generic way is to split your script into the individual statements (removing
; at the end), and then run each statement using executeUpdate() or execute().
That will work for all DBMS, the CREATE TABLE statements might not work for all
DBMS (because each one has different data types)
Thomas
