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]

Re: InstantDB: InstantDB table access from CMP EJB


Peter --

The tables are there. I get the following messages from the server:

2000.08.25 07:31:34: kernel,STATUS: Could not get Connection on
jdbc:idb:/users/
ctipper/enhydra/output/db/NE.prp for /
2000.08.25 07:31:34: kernel,STATUS: Failed to create bean in database
2000.08.25 07:31:34: kernel,STATUS: System exc. => Rollback the
transaction.
2000.08.25 07:31:34: kernel,STATUS: System Exception in create or finder
method:
org.enhydra.multiServer.manager.ManagerError: Not allowed to access the
Kernel's
 Log Writer, yet.

The database URL is correct; I've tried both relative and full path
names -- same result.
FWIW -- this is the same message I get when the db 'recoveryPolicy'
property is set to 0 and the server is killed (Cntl-C), i.e., I can't
read the files on server restarts when the server doesn't exit cleanly.

Enabling an InstantDB trace level of 3 (TR_EVENT + TR_SQL) I get the
following in both cases:

RMI TCP Connection(6)-192.168.0.155 Opening database
/users/ctipper/enhydra/output/db/NE.prp opens=0

In the case of server restart, where things 'work', the next output from
the db indicates the tables are being recovered (as expected).

-- Cindy

Peter Hearty wrote:
> 
> Cindy
> 
> When you say that you can't access tables, do you mean that you get a file
> permissions error of some sort, or simply that the tables aren't there?
> 
> Regards
> 
> Peter Hearty
> Lutris Technologies (UK)
> ----- Original Message -----
> From: "Cindy Tipper" <ctipper@laurelnetworks.com>
> To: <instantdb@enhydra.org>; <EnhydraEnterprise@enhydra.org>
> Sent: Thursday, August 24, 2000 10:36 PM
> Subject: InstantDB: InstantDB table access from CMP EJB
> 
> > Not sure which list this belongs on...
> >
> > I have a simple Java client that creates CMP EJBs (using latest versions
> > of EnhydraEnterprise and InstantDB). I've found that if I use
> > org.enhydra.instantdb.ScriptTool to create the table, using a file with
> > the following code:
> >
> > ---------------------------------------------------
> > ; First load the JDBC driver and open a database.
> > d org.enhydra.instantdb.jdbc.idbDriver;
> > o jdbc:idb=<full_path_to_file>/NE.prp;
> >
> > e drop table ne_sample;
> > e create table ne_sample (
> >   name        varchar(30) unique primary key
> > );
> > e insert into ne_sample values("foo");
> > e insert into ne_sample values("bar");
> >
> > c close;
> > ----------------------------------------------------
> >
> > that I can't access the tables from my bean. However, if I use a servlet
> > (using JDBC/Datasource; specifically a modified version of InitServlet,
> > found in EETest) to do the same table creation steps, the beans then
> > have access to the table, even with server restarts. In both cases, I
> > can use DBBrowser to view the table contents.
> >
> > Any thoughts? I'm new to Enhydra/InstantDB so I'm not sure if there are
> > file permission issues (I'm grasping here!) that I might be missing, or
> > something....
> >
> > Thanks --
> > Cindy
> > --------------------------------------------------------------------------
> ---
> > 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.