From: fredt <fr...@us...> - 2005-02-22 22:35:48
|
Thanks Blaine, True, we should update the sample file to reflect a real case. Fred ----- Original Message ----- From: "Blaine Simpson" <bla...@ad...> To: <hsq...@li...> Sent: 22 February 2005 22:23 Subject: Re: [Hsqldb-user] db file ? 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 ------------------------------------------------------- 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 |