db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From yarono <yar...@il.ibm.com>
Subject Re: How do I Open / Close a db using odbc interface?
Date Mon, 04 Jun 2007 18:07:02 GMT

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.


Mime
View raw message