"Peter Hearty" <peter.hearty@lutris.com> on 26/09/2000 03:17:35
Please respond to instantDB@enhydra.org
To: instantDB@enhydra.org
cc:
Subject: Re: InstantDB: Strange error when adding a column to a table
Peter,
It happens on both NT (dev) and Linux (prod) - haven't tried on Solaris.
SURVEYS.tbl exists in both environments.
The database and application work fine (selecting, inserting and updating),
that is, until I try to alter the table def, and chaos ensues.
Seems to render entire database unusable (not just that table).
I will try to abstract a small servlet which shows the problem and send it
to you.
I appreciate the advice on export - I need to do that for backup in any
case.
thanks
David
______________________________________________________________________________________________
"The surest sign that intelligent life exists elsewhere in the universe is
that it has never tried to contact us."
______________________________________________________________________________________________
David
I don't know for certain why you're being prevented from deleting the
surveys.tbl file. Are you on a Unix or Windows system? Maybe InstantDB is
having a filename case problem. could you check to see whether SURVEYS.tbl
actually exists? (As opposed to, say, "surveys.tbl").
Another possibility is that another JVM has the file open. Do you run any
database exploration tools that could have he database open at the same
time?
As a work around, to save you loosing data on the ALTER TABLE, you could
export, do a drop/create and then re-import. Something like this:
drop table tmp;
create table tmp (id int, data1 char(10));
insert into tmp values (1, "111");
insert into tmp values (2, "222");
set export "tmp.cvs" csvdelimited;
select tmp.*,"333" from tmp;
set export "null";
drop table tmp;
create table tmp (id int, data1 char(10), data2 char(10));
import "tmp" from "tmp.cvs";
Regards
Pete
--
Peter Hearty peter.hearty@lutris.com
Lutris Technologies (UK) http://www.lutris.com
-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.
|