You have the choice with hsqldb as to whether to run in-memory only or disk based. If you run disk based then you can pre-populate the database using the standard AppFuse build. If you choose to run in-memory only then you will need to provide the mechanism to populate the database on startup - by default AppFuse does not contain any support to do this. Note that if you run in memory only you will loose all data written to the database whenever the application shuts down.
Mike. On 8/1/07, jimmy6 <[EMAIL PROTECTED]> wrote: > > > If i am using hsql, it is impossible for me to do that right? because hsql > will just in the momery. when application close the DB also will be remove > right? > > > Michael Horwitz wrote: > > > > No. The creation and populating of the database is un-connected to > > starting > > or stopping of the web application. There is a single ant > > target(setup-dp) which creates and populates the database if you want > to > > do > > it all in one go. > > > > Mike. > > > > On 8/1/07, jimmy6 <[EMAIL PROTECTED]> wrote: > >> > >> > >> So it depends on ant to start the web application right? > >> > >> > >> Michael Horwitz wrote: > >> > > >> > DBUnit is used to load the initial dataset into the database. Both > >> AppFuse > >> > 1.9.4 and 2.0.x do this. In 1.9.4 the Ant task db-load will load your > >> > database with the dataset defined in sample-data.xml. > >> > > >> > Mike. > >> > > >> > On 8/1/07, jimmy6 <[EMAIL PROTECTED]> wrote: > >> >> > >> >> > >> >> I am using 1.9.4 appfuse. Thus, how to create a predefined data to > db > >> on > >> >> startup after hibernate create the table? > >> >> > >> >> > >> >> Michael Horwitz wrote: > >> >> > > >> >> > I'm not sure I understand the question? What is it you are trying > to > >> >> do? > >> >> > It > >> >> > would also help to know which version of AppFuse you are using, > and > >> >> which > >> >> > versions you are referring to in your email below. > >> >> > > >> >> > Mike > >> >> > > >> >> > On 8/1/07, jimmy6 <[EMAIL PROTECTED]> wrote: > >> >> >> > >> >> >> > >> >> >> Actually i want to how to create run the sql script in startup. > It > >> is > >> >> >> because > >> >> >> i am using hsql. i remember last time appfuse was run in this way > >> but > >> >> the > >> >> >> latest one is not right? > >> >> >> > >> >> >> > >> >> >> Michael Horwitz wrote: > >> >> >> > > >> >> >> > This is the property that tells Hibernate which database > flavour > >> you > >> >> >> are > >> >> >> > using. It is replaced by Ant during the build process with the > >> value > >> >> in > >> >> >> > your > >> >> >> > build.properties file. A list of the valid settings for this > >> >> property > >> >> >> can > >> >> >> > be > >> >> >> > found here: http://tinyurl.com/dpkau > >> >> >> > > >> >> >> > Mike > >> >> >> > > >> >> >> > On 8/1/07, jimmy6 <[EMAIL PROTECTED]> wrote: > >> >> >> >> > >> >> >> >> > >> >> >> >> What is the @HIBERNATE-DIALECT@ mean? > >> >> >> >> -- > >> >> >> >> View this message in context: > >> >> >> >> > >> >> >> > >> >> > >> > http://www.nabble.com/%3Cprop-key%3D%22hibernate.dialect%22%3E%40HIBERNATE-DIALECT%40%3C-prop%3E---tf4198684s2369.html#a11941559 > >> >> >> >> Sent from the AppFuse - User mailing list archive at > Nabble.com. > >> >> >> >> > >> >> >> >> > >> >> > --------------------------------------------------------------------- > >> >> >> >> To unsubscribe, e-mail: [EMAIL PROTECTED] > >> >> >> >> For additional commands, e-mail: > [EMAIL PROTECTED] > >> >> >> >> > >> >> >> >> > >> >> >> > > >> >> >> > > >> >> >> > >> >> >> -- > >> >> >> View this message in context: > >> >> >> > >> >> > >> > http://www.nabble.com/%3Cprop-key%3D%22hibernate.dialect%22%3E%40HIBERNATE-DIALECT%40%3C-prop%3E---tf4198684s2369.html#a11942209 > >> >> >> Sent from the AppFuse - User mailing list archive at Nabble.com. > >> >> >> > >> >> >> > >> --------------------------------------------------------------------- > >> >> >> To unsubscribe, e-mail: [EMAIL PROTECTED] > >> >> >> For additional commands, e-mail: [EMAIL PROTECTED] > >> >> >> > >> >> >> > >> >> > > >> >> > > >> >> > >> >> -- > >> >> View this message in context: > >> >> > >> > http://www.nabble.com/%3Cprop-key%3D%22hibernate.dialect%22%3E%40HIBERNATE-DIALECT%40%3C-prop%3E---tf4198684s2369.html#a11942665 > >> >> Sent from the AppFuse - User mailing list archive at Nabble.com. > >> >> > >> >> > --------------------------------------------------------------------- > >> >> To unsubscribe, e-mail: [EMAIL PROTECTED] > >> >> For additional commands, e-mail: [EMAIL PROTECTED] > >> >> > >> >> > >> > > >> > > >> > >> -- > >> View this message in context: > >> > http://www.nabble.com/%3Cprop-key%3D%22hibernate.dialect%22%3E%40HIBERNATE-DIALECT%40%3C-prop%3E---tf4198684s2369.html#a11942955 > >> Sent from the AppFuse - User mailing list archive at Nabble.com. > >> > >> --------------------------------------------------------------------- > >> To unsubscribe, e-mail: [EMAIL PROTECTED] > >> For additional commands, e-mail: [EMAIL PROTECTED] > >> > >> > > > > > > -- > View this message in context: > http://www.nabble.com/%3Cprop-key%3D%22hibernate.dialect%22%3E%40HIBERNATE-DIALECT%40%3C-prop%3E---tf4198684s2369.html#a11943158 > Sent from the AppFuse - User mailing list archive at Nabble.com. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >