Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (athena.apache.org: domain of francois.rappaz@unifr.ch
 designates 134.21.14.71 as permitted sender)
From: RAPPAZ Francois <francois.rappaz@unifr.ch>
To: 'Derby Discussion' <derby-user@db.apache.org>
Date: Fri, 30 Oct 2009 14:37:44 +0100
Subject: RE: data lost with ij
Thread-Topic: data lost with ij
Thread-Index: AcpZZTcF2IK7gtEuSsqemZmIiL3+KwAALDow
Message-ID: <FEFE4227FE41814EAAC5D1AADE3DA3BC0C9E1D3A@EXCHANGE2.unifr.ch>
References: <FEFE4227FE41814EAAC5D1AADE3DA3BC0C9E1D37@EXCHANGE2.unifr.ch>
 <4AEAE5A2.8030007@sun.com>
 <FEFE4227FE41814EAAC5D1AADE3DA3BC0C9E1D38@EXCHANGE2.unifr.ch>
 <4AEAEA60.5000806@sun.com>
In-Reply-To: <4AEAEA60.5000806@sun.com>
Accept-Language: fr-FR, fr-CH
Content-Language: en-US
acceptlanguage: fr-FR, fr-CH
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

That was it: putting autocommit on; at the end of my first script correct t=
he problem
I copy the script from one of the example...

My mistake, sorry.
Fran=E7ois

> -----Original Message-----
> From: Richard.Hillegas@Sun.COM [mailto:Richard.Hillegas@Sun.COM]
> Sent: vendredi, 30. octobre 2009 14:30
> To: Derby Discussion
> Subject: Re: data lost with ij
>=20
> Hi Fran=E7ois,
>=20
> Your data will disappear on exit if you don't commit after the insert
> in
> the second ij script.
>=20
> Hope this helps,
> -Rick
>=20
> RAPPAZ Francois wrote:
> > I use to file called with the run command in ij
> > 1 file says:
> > AUTOCOMMIT OFF;
> >
> > CREATE TABLE authors (
> > 	name1 varchar(20) NOT NULL,
> > 	name2 varchar(20) NOT NULL,
> > 	data varchar(50),
> > 	auhtor_id INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START
> WITH 1, INCREMENT BY 1)
> > );
> >
> > CREATE INDEX name ON AUTHORS (name1, name2);
> >
> > ALTER TABLE authors
> >    ADD CONSTRAINT authors_pk Primary Key (
> >       author_id);
> >
> > COMMIT;
> >
> > 2 file contains the insert statement and nothing else.
> > Is this the problem ?
> >
> > Fran=E7ois
> >
> >
> >
> >> -----Original Message-----
> >> From: Richard.Hillegas@Sun.COM [mailto:Richard.Hillegas@Sun.COM]
> >> Sent: vendredi, 30. octobre 2009 14:10
> >> To: Derby Discussion
> >> Subject: Re: data lost with ij
> >>
> >> RAPPAZ Francois wrote:
> >>
> >>> Using ij, I create a database, then I build a table and populate it
> >>>
> >> with a serie of insert statement. Without doing anything else I
> >> disconnect (that take a long time) and I exit.
> >>
> >>> When I reconnect and run a select * from table; I got nothing in
> the
> >>>
> >> table...
> >>
> >>> If run that select statement after the inserts, the bug does not
> >>>
> >> appear.
> >>
> >>> Is this a known problem ?
> >>>
> >>> Fran=E7ois
> >>>
> >>>
> >> Hi Fran=E7ois,
> >>
> >> It sounds as though you are not committing your transaction before
> >> exiting. As part of an orderly exit, make sure that you do the
> >> following:
> >>
> >> 1) Commit your transaction
> >>
> >> 2) Shutdown the database
> >>
> >> 3) Then exit
> >>
> >> Hope this helps,
> >> -Rick
> >>