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

Ferenc

InstantDB periodically tries to truncate the journal file back to zero
length. It sounds like something is going wrong in the process. AFAIK,
there's no way to do an explicit truncation of a RandomAccessFile in Java
(anyone out there care to educate me though?), so InstantDB does a file
delete followed by a create to truncate the log.

There are several possibilities.

First, can we rule out any possibility of you running two programs on the
same database at once (just asking to make sure)?

Once that's ruled out, could you let me know if your application has
multiple threads accessing the database at the same time?

As a work around you could always set transaction logging off during the
import (transLevel=0 in the .prp file). However I would like to get as much
detail on this as possible. In particular, which OS and JVM (with versions)
that are being used.

Regards

Peter Hearty
Lutris Technologies UK Ltd.
-----Original Message-----
From: Ferenc Csizmadia <fcsiz@chemaxon.com>
To: instantDB@enhydra.org <instantDB@enhydra.org>
Date: 10 July 2000 11:09
Subject: InstantDB: FileNotFoundException: idb.jrl


>Hi,
>
>I would like to import rows into an InstantDB database through JDBC
>using INSERT.
>After INSERT-ing a couple of hundreds or thousands (this seems random)
>of records the system removes the idb.jrl file and I get
>FileNotFoundException.
>
>I tried using the InstantDB driver both directly and through RmiJdbc,
>but there is no difference (it seems the exception comes sooner when
>RmiJdbc is applied).
>
>Transaction handlings is not applied explicitly.
>
>When I try to debug by recording trace information, the problem
>disappeares (but the system slows down).
>
>The same program code works when other database engines (MySQL,
>Oracle, MS SQL Server ....) are used.
>
>This is the exception:
>java.sql.SQLException: Problem opening/creating journal file: idb.jrl
>java.io.FileNotFoundException: C:\htdocs\jchem\idb\system\idb.jrl
>(Access is denied)
>        at
>sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemote
Call.java:245)
>
>        at
>sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:220)
>
>        at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:354)
>        at
>RmiJdbc.RJPreparedStatementServer_Stub.executeUpdate(RJPreparedStatementSer
ver_Stub.java:272)


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