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]
