Hi RMR, Well I'd like to help you out but I really don't know much about HSQL other than it's a free java-based DB. From turbine's docs, it should work with HSQL (I just didn't spend the time to get it working). As for open source DBs I am sure others on this list are using them with success. Have you read the Howto guides on the Turbine website? They are guides for using Postgres and other DBs. Good luck! dan On Mon, 27 Aug 2001, rmr wrote: > Dan, > Could please clarify on Hypersonic Sql (HSQL) > Does turbine work with it or is there some flaw in HSQL that prevents it > from successful implementation. > Is there a workaround ??? Is there a robust SQL DB open source that does > work... > > My organization/Budget does not have the option luxuary of oracle.... > Many thanks > RMR > > ----- Original Message ----- > From: "Dan Kha" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Thursday, August 23, 2001 11:43 AM > Subject: Re: turbine setup, installation, getting started, help please? > > > > Hi Hubert, > > Yes I've resolved it by doing a few things: > > 1. I switched to Oracle. In my post on this topic, I was initially using > hypersonic sql as the db, which I gave up on since it wasn't worth my > effort to get it going. > > 2. Then I created a new Oracle schema (ie. username/password). > > 3. Setup the db connection info in build.properties. > (ie. databaseUrl, databaseDriver, databaseUser, databasePassword, > databaseHost) > > 4. And lastly, you have two options: > a. Modify build.properties (I think) so that manual db creation is > used. And then run the generated .sql files to setup the db. > Basically, add a line: database.manual.creation = true > b. Or, what I did was (copied from my other post): > > "What I did was that I created a fake > <TDK_root>/webapps/newapp/WEB-INF/build/bin/torque/templates/sql/db-init/ora > cle/ > windows.vm > file with nothing in it and allowed the "ant init" to continue with its > stuff (which generated the database tables and etc.; I've > pre-created the db and set the user/password/info accordingly in the > build.properties file.)" > > Hope this helps, > > -- > Dan Kha > Development Team > Computing & Network Services > York University, Toronto, Canada > > On Thu, 23 Aug 2001 [EMAIL PROTECTED] wrote: > > > Hi Dan, > > > > I got the same problem, > > do you meanwhile have a solution ??? > > > > >>create-database: > > >> [echo] create-database.bat > > >>E:\Java\software\tdk\webapps\newapp\WEB-INF\src\sql\create-database.bat > > > > >>BUILD FAILED > > > > >>E:\Java\software\tdk\webapps\newapp\WEB-INF\build\build.xml:115: > > Exception > > >>throw > > >>n by 'generator.parse'. For more information consult the velocity log. > > >>--- Nested Exception --- > > >>org.apache.velocity.exception.ResourceNotFoundException: Unable to find > > >>resource > > >> 'sql/db-init/hypersonic/windows.vm' > > >> at > > >>org.apache.velocity.runtime.resource.ResourceManager.getResource(Reso > > >>urceManager.java, Compiled Code) > > > > TIA > > > > Mit freundlichen Gr�ssen / with best regards > > > > Hubert Vey > > Manager Research & Development > > IntraWare AG > > Brueckenmuehle 93 | D-36100 Petersberg-Marbach > > fon +49 (0) 661 - 9642 -450 | fax +49 (0) 661 - 9642 - 99 450 > > email: [EMAIL PROTECTED] > > www.intraware.de > > > > > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
