I think I found the answer to the problem. The problem is the 'drop all objects delete file' sql statement.
What I did was to comment off the clean() and to replace the cleaning function of the database , I added 'drop all objects' in the sql script before it did all the other create tables and it ran well. On Sep 5, 12:28 am, Thotheolh <[email protected]> wrote: > The problem seems to lie in that when it's checking for created > tables, the only table left out is the 'ACL' table presumably not > created I guess? > > I noticed that if the AutoSetup did do any create tables, the tables > were somehow not found when I use the H2 console to manually login and > browse for the tables. It is as though the runscript did run but > nothing was really created in my opinion. > > On Sep 4, 11:13 pm, Thotheolh <[email protected]> wrote: > > > I have created a java class to do automatic setup of database using > > 'RUNSCRIPT' from a setup sql file. > > > Please go to 'http://www.thotheolh.pastebin.com/m739dcbc9'toget my > > codes for the java class. > > > As for the setup sql script, go to 'http://www.thotheolh.pastebin.com/ > > m19be7a70'. > > > To use this class, a sample code as below... > > > new AutoSetup(new Connection(<make your new sql > > connection>)).init(new File(<setup sql file>)); > > > I am not sure if this is some code logic problem or is this H2 > > database problem so I need some help here. > > > I am using the 1.1.117 build. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
