Thanks - the shutdown is what I was looking for. Now I have a couple of questions: 1. How do I use it from the odbc interface? do I just perform an SQL statement with the shutdown command? 2. How do I turn the DB back on?
Thanks, Yaron m96 wrote: > > hi, > > checkout [3]. since i had a crashing and freezing problem with odbc > connections from MS Query and Brio i couldn't test it if it also works > from ODBC. just check your derby log to see if the db is booted and > shutdown. > > cheers... > > [3] http://db.apache.org/derby/manuals/reference/sqlj251.html > > > On Sun, 2007-06-03 at 04:44 -0700, yarono wrote: >> by open / close I mean that after I started the connection and created a >> db >> and inserted values to a table, I want to close the db (save it to file) >> and >> the later on be able to open the file and get the db as it was at the >> point >> of closure. >> >> >> m96 wrote: >> > >> > hi, >> > >> > what do you mean with open/close? >> > >> > just start your network server as described in the tutorial [1] and >> > configure your odbc connection with IBM DB2 connect [2] and connect to >> > your db like any other db. >> > >> > cheers... >> > >> > [1] http://db.apache.org/derby/papers/DerbyTut/ns_intro.html >> > [2] http://www-306.ibm.com/software/data/db2/db2connect/ >> > >> > >> > >> > On Sun, 2007-06-03 at 01:29 -0700, yarono wrote: >> >> I looked through the manuals and api guides, but was unable to find >> how >> >> do I >> >> close / open a db in odbc interface. >> >> Could someone please reply with a refernce to the answer? or just >> reply >> >> with >> >> the answer? >> >> >> >> thanks in advance, >> >> Yaron >> > >> > >> > >> > > > -- View this message in context: http://www.nabble.com/How-do-I-Open---Close-a-db-using-odbc-interface--tf3859752.html#a10954828 Sent from the Apache Derby Users mailing list archive at Nabble.com.
