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


Cindy

Phew - glad that one's solved! Although InstantDB should have reported the
different versions and offered a more helpful error message.

I'll have a look at why it didn't.

Pete
----- Original Message -----
From: "Cindy Tipper" <ctipper@laurelnetworks.com>
To: <instantDB@enhydra.org>
Sent: Friday, August 25, 2000 2:56 PM
Subject: Re: InstantDB: InstantDB table access from CMP EJB


> Problem solved.
>
> The version of InstantDB (idb.jar, specifically) shipped with the latest
> EnhydraEnterprise is version 3.13. I'm assuming the incompatible changes
> in v3.14 (and, therefore, 3.20 which I'm using) were biting me. I've
> moved Enhydra up to 3.20 and everyone is happy.
>
> Sorry for the flood of mail.
>
> -- Cindy
>
> Cindy Tipper wrote:
> >
> > Peter --
> >
> > Further follow-up....
> > If I create and populate the table using ScriptTool, and then try to use
> > the servlet to do the same (the servlet first attempts to drop the
> > table), I get the following stack trace:
> >
> > Cannot get connection: java.sql.SQLException: IO problem:
> > java.sql.SQLException: Internal error header recLength=3
> > Computed record length should be 419
> > Table: NE$db$Cols
> >         at jdbc.idbConnection.<init>(idbConnection.java:87)
> >         at jdbc.idbDriver.connect(idbDriver.java:40)
> >         at java.sql.DriverManager.getConnection(DriverManager.java:457)
> >         at java.sql.DriverManager.getConnection(DriverManager.java:159)
> >         at
> >
org.objectweb.jonas.jdbc_xa.XADataSourceImpl.getXAConnection(XADataSourceImp
l.java:155)
> >         at
> >
org.objectweb.jonas.dbm.ConnectionManager.getConnection(ConnectionManager.ja
va:294)
> >         at
> >
org.objectweb.jonas.dbm.ConnectionManager.getConnection(ConnectionManager.ja
va:257)
> >         at InitServlet.doGet(InitServlet.java:49)
> >         at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
> >         at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)
> >         at
> >
org.apache.tomcat.core.ServiceInvocationHandler.method(ServletWrapper.java:6
32)
> >         at
> >
org.apache.tomcat.core.ServletWrapper.handleInvocation(ServletWrapper.java,
> > Compiled Code)
> >         at
> >
org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:383)
> >         at
> > org.apache.tomcat.core.InvokerServlet.service(InvokerServlet.java:239)
> >         at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)
> >         at
> >
org.apache.tomcat.core.ServiceInvocationHandler.method(ServletWrapper.java:6
32)
> >         at
> >
org.apache.tomcat.core.ServletWrapper.handleInvocation(ServletWrapper.java,
> > Compiled Code)
> >         at
> >
org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:383)
> >         at
> > org.apache.tomcat.core.Context.handleRequest(Context.java:735)
> >         at
> >
org.enhydra.servlet.servletManager.ServletManager.service(ServletManager.jav
a:1347)
> >         at
> >
org.enhydra.servlet.servletManager.ServletManager.service(ServletManager.jav
a:1256)
> >         at
> >
org.enhydra.servlet.connectionMethods.http.HttpHandler.doARequest(HttpHandle
r.java,
> > Compiled Code)
> >         at
> >
org.enhydra.servlet.connectionMethods.http.HttpHandler.processRequests(HttpH
andler.java,
> > Compiled Code)
> >         at
> >
org.enhydra.servlet.connectionMethods.http.HttpHandler.run(HttpHandler.java,
> > Compiled Code)
> >         at java.lang.Thread.run(Thread.java:479)
> >
> > 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.
> --------------------------------------------------------------------------
---
> 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.