I have not (yet) done this myself, but I had thought about this before. This is what I was going to try whenever I had a chance:
I believe HypersonicSQL runs in-memory. As I recall from the website (its hosted on SourceForge.net) Hypersonic is designed to run as an applet (or using the filesystem). Again, from my recollection - it is in the SQL's that a table is added to disk So if your SQL looks like: CREATE TABLE CACHED ... the "CACHED" is what tells hypersonic to save to disk. If you remove the "CACHED" keyword, hypersonic runs only in memory. Perhaps you could modify the src/sql's to remove the "CACHED" keyword, then run a little script which runs the script as your application starts. Like I say, I have not implemented this myself, so I would be interested if this works for you, or if you find another solution. My boss has asked me about a demo-cd possibility, but has not - yet - assigned me the task. Steve B. ----- Original Message ----- From: "David Cruwys" <[EMAIL PROTECTED]> To: "Turbine Users List" <[EMAIL PROTECTED]> Sent: Friday, July 12, 2002 7:20 AM Subject: Run demonstration turbine from CD with in memory database. > I would like to setup a self contained turbine application where the > database that I read/write to is a self contained in memory. > > Why? So I can run the application from a CD for demonstration purposes. > > I would like the api to be like any SQL database so that I can remove it > and put a standard database inplace for a production system. > > 1. I'm wondering if anyone knows of any open source products like this. > Hopefully deployable as simple jars so that there is no installation > worrys (The smaller the better). > > 2. How you would link it to turbine. > > Cheers Dave > > > > CONFIDENTIALITY NOTICE > This email is private and confidential and may contain legally privileged information. If you are not named above as an addressee it may be unlawful for you to read, copy, distribute, disclose or otherwise use the information in this email. If you are not the intended recipient of this email please destroy it and contact the sender via the switchboard on +353 (0) 1 457 3299 or via e-mail return. > > Any views or opinions presented are solely those of the author and do not necessarily represent those of the company or its associated companies unless otherwise specifically stated. > > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
