Kurt Penrose wrote:
Hi,
I'm using Derby as installed with Netbeans 5.5. I'm using the scripts
that came with netbeans to start and stop the database. When I stop
it and start it back up, all of the tables I created are gone. The
database itself is there, but not the tables.
Is there something I'm doing wrong?
Thanks,
Kurt
------------------------------------------------------------------------
Cheap Talk? Check out
<http://us.rd.yahoo.com/mail_us/taglines/postman8/*http://us.rd.yahoo.com/evt=39663/*http://voice.yahoo.com>
Yahoo! Messenger's low PC-to-Phone call rates.
Hi Kurt -
Two configuration problems that could cause this:
This symptom can also be caused when different default schemas are set
for the two database sessions. Check to see if the tables are listed in
SYS.SYSTABLES but in different schemas. The default schema will be the
username specified when logging onto the database. If no username is
specified then the default schema is APP.
This can also be caused when the connect URL specifies ';create=true'
and the derby.system.home differs between the two executions. This
caused the DB to be silently created if it does not already exist but
the location on disk will differ. You can search your disk drive to see
if there are multiple directories with the Database name containing
Derby database files.
HTH
