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çois
> -----Original Message-----
> From: [email protected] [mailto:[email protected]]
> 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çois
> >
> Hi François,
>
> 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
