There's a database manager sort of thing shipped with hypersonic, just
downloaded it yesterday, don't know how well it works. You can get it at
http://hsql.oron.ch/
----- Original Message -----
From: "Tim Drury" <[EMAIL PROTECTED]>
To: "'jBoss'" <[EMAIL PROTECTED]>
Sent: Thursday, August 10, 2000 3:25 PM
Subject: RE: [jBoss-User] column not found? (MORE INFO)
>
> After reading the latest emails about a big bug, I checked
> out and built the latest jboss from CVS. I don't get the
> "column not found" error anymore.
>
> QUESTION: is there any way to see what is in the Hypersonic
> tables? I just want to see my data to be sure it went in
> correctly. Not that I don't trust you guys.... :)
>
> -tim
>
> > -----Original Message-----
> > From: Tim Drury [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, August 09, 2000 6:58 PM
> > To: Jboss Users (E-mail)
> > Subject: [jBoss-User] column not found?
> >
> >
> >
> > Hello all,
> >
> > When I deploy my CMP bean, JBoss (seemingly correctly) gives me the
> > following message:
> >
> > [Container factory] Deploying SampleDocumentBean
> > [JAWS] Initializing JAWS plugin for SampleDocumentBean
> > [JAWS] Remove:DELETE FROM SampleDocumentBean WHERE id=?
> > [JAWS] Drop:DROP TABLE SampleDocumentBean
> > [JAWS] Create table:CREATE TABLE SampleDocumentBean (sampleInt
> > INTEGER,sampleDou
> > ble DOUBLE,id VARCHAR(256),sampleString VARCHAR(256))
> > [JAWS] Insert:INSERT INTO SampleDocumentBean
> > (sampleInt,sampleDouble,id,sampleSt
> > ring) VALUES (?,?,?,?)
> > [JAWS] Select:SELECT sampleInt,sampleDouble,id,sampleString FROM
> > SampleDocumentB
> > ean WHERE id=?
> > [JAWS] Exists:SELECT COUNT(*) AS Total FROM
> > SampleDocumentBean WHERE id=?
> > [Container factory] Bound SampleDocumentBean to
> > document/SampleDocument
> > [JAWS] Table SampleDocumentBean exists
> > [Container factory] Deployed application:
> > file:/D:/java/jBoss2.0_pr3/deploy/nvdo
> > cejb.jar
> >
> > Note the CREATE TABLE line with column "sampleInt". When I
> > create a bean
> > and fill it will data, it gets persisted but JBoss throws an
> > exception:
> >
> > < most of the exception deleted >
> > [Default] javax.ejb.CreateException: Could not create
> > entity:java.sql.SQLExcepti
> > on: Column not found: SAMPLEINT in statement [INSERT INTO
> > SampleDocumentBean
> > (sa
> > mpleInt,sampleDouble,id,sampleString) VALUES
> > (NULL,NULL,'7ee6fc:e0e1c44b91:-7ffb
> > ',NULL)]
> >
> > Apparently it cannot find the column "sampleInt" now. Any
> > idea what I did
> > wrong? If I remove both the Integer and Double from my bean
> > (leaving two
> > Strings: id and sampleString) everything works fine.
> >
> > Also: is there any way to see the Hypersonic db and administer it?
> >
> > Thanks for any help,
> >
> > -tim drury
> >
> >
> > --
> > --------------------------------------------------------------
> > To subscribe: [EMAIL PROTECTED]
> > To unsubscribe: [EMAIL PROTECTED]
> > Problems?: [EMAIL PROTECTED]
> >
>
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
>
>
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
