Re: [Hsqldb-user] db file ?

[Blaine S. <bla...@ad...>]

You may also want to commit your changes.

fredt wrote:

>Well, in normal usage you should also execute the SQL command "SHUTDWON" 
>when you want to close the database. In that case, the .script file will 
>contain the data you have entered. Please read the Guide on different table 
>types and various parameters you can set for your specific usage.
>
>Fred
>
>----- Original Message ----- 
>From: <flo...@ho...>
>To: <hsq...@li...>
>Sent: 22 February 2005 22:05
>Subject: Re: [Hsqldb-user] db file ?
>
>
>I don't understand - please consider the Testdb file which comes in sample 
>with
>the distribution
>..
>//get connection
>conn = DriverManager.getConnection("jdbc:hsqldb:file:/tmp/x/testdb" 
>,"sa","");
>//do something
>st = conn.createStatement();    // statements
>int i = st.executeUpdate(expression);    // run the query
>//close
>conn.close();
>..
>What I would have expected is that file "/tmp/x/testdb" to exist and 
>persist. In
>this case, in /tmp/x,  are generated 2 files: a property file and a log file 
>but no
>db file.
>
>Thank you,
>--Tino
>
>
>»If you connect with a file URL, then all valid data is automatically
>»persisted to the database files and next time you start the database it 
>will
>»be restored automatically.
>»
>»Fred
>»
>»----- Original Message ----- 
>»From: <flo...@ho...>
>»To: <hsq...@li...>
>»Sent: 20 February 2005 18:33
>»Subject: [Hsqldb-user] db file ?
>»
>»
>»
>»I want  use hsqldb "in-process" to store some data for 24 hours but can't
>»figure out
>»from documentation following - in case of an exception haw do you save the
>»db to file
>»and eventually restore db later ?
>»
>»Thank you
>»
>»
>»
>»-------------------------------------------------------
>»SF email is sponsored by - The IT Product Guide
>»Read honest & candid reviews on hundreds of IT Products from real users.
>»Discover which products truly live up to the hype. Start reading now.
>»http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
>»_______________________________________________
>»Hsqldb-user mailing list
>»Hsq...@li...
>»https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>»
>»
>»
>»-------------------------------------------------------
>»SF email is sponsored by - The IT Product Guide
>»Read honest & candid reviews on hundreds of IT Products from real users.
>»Discover which products truly live up to the hype. Start reading now.
>»http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
>»_______________________________________________
>»Hsqldb-user mailing list
>»Hsq...@li...
>»https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>»
>
>  
>


-- 
ICF:  703-934-3692       Cell:  703-944-9317