InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

SV: InstantDB: Cols error ??


You're right a newer version should be installed, and I will check to see I
have time in the near future (a small thing to it, is that this user is
localed in Japan). Lucky it turned out that the user had a old backup of the
database and I just copied the old system tables into the right place and
the database worked.

Thanks for you time Peter.


Regrads
Martin


-----Oprindelig meddelelse-----
Fra: owner-instantDB@enhydra.org [mailto:owner-instantDB@enhydra.org]På
vegne af Peter Hearty
Sendt: 25. april 2001 18:57
Til: instantDB@enhydra.org
Emne: Re: InstantDB: Cols error ??


Martin

I vaguely remember adding a fix for something like this. If I remember
rightly, IDB used
to do some consistency checks on string during recovery, but if it found a
problem it just
stopped - as you described.

I think the latest version logs the problem and continues. So it might be
worth trying a
more up to date IDB version to see if it can get around the problem.

Pete
----- Original Message -----
From: "Martin Husted Hartvig" <mh@ctek.dk>
To: <InstantDB@enhydra.org>
Sent: Wednesday, April 25, 2001 8:59 AM
Subject: InstantDB: Cols error ??


> Hey,
>
> Hmmm....  I hope someone (Peter) have can help with this one:
> Some time a go I was making a java product with idb as an embedded
database,
> there for the idb version may be a little out of date (we are taking
v.3.14)
> the point is that the user have a lot of data and would be very sorry to
> lose it. Ok, the problem has with it this exception:
>
>
>
> java.sql.SQLException: IO problem: java.io.IOException: Internal error -
max
> string size of 1024 is too big for column usrid table
> BasicMachineDataInternal error - max string size of 1024 is too big for
> column usrid table BasicMachineData
>         at
> org.enhydra.instantdb.jdbc.idbConnection.<init>(idbConnection.java:87)
>         at org.enhydra.instantdb.jdbc.idbDriver.connect(idbDriver.java:40)
>         at java.sql.DriverManager.getConnection(DriverManager.java:517)
>         at java.sql.DriverManager.getConnection(DriverManager.java:199)
>   .
>   .
>   .
>   .
>
> ..... sounds strange as the column "usrid" is a column in a other table. I
> guess its idb's system tables either xxx$db$Cols or xxx$db$Tables, but I
> can't make a connect to the database. Is there a way to fix this without
> losing data ??
>
>
> Regrads
> Martin
>
> --------------------------------------------------------------------------
---
> 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.
>


----------------------------------------------------------------------------
-
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.

-----------------------------------------------------------------------------
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.