Yeah.. thats where my thoughts were heading... splitting each CREATE TABLE into its own file, and reading/executing each one at a time...
I was just hoping for another possible way.
> To: firstname.lastname@example.org > From: email@example.com > Subject: Re: Reading DDL SQL from JAR > Date: Tue, 11 Mar 2008 20:13:10 +0100 > > 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 >
Climb to the top of the charts! Play the word scramble challenge with star power. Play now!