[JBoss-user] Column not found, hypersonic details

[Boris G. <bor...@bo...>]

I sitll fail to run my first entity bean. This time primary key column is=
 not found. May be it tries to use old table schema? It would be handy to=
 observe HSQL's tables, and kill and re-create the
repository, but I neither know where the data file is nor how to show all=
 tables. I saw, Orion has Hypersonic's client graphics console. Does JBos=
s have one? Where to get such information?
-------------------------

[JAWS] java.sql.SQLException: Column not found: CREATIONTIME in statement=
 [INSERT INTO OrderEntity (customerName,creationTime,cartBean,isDelivered=
,sessionId) VALUES
('myCustomerName',993326836652,'aced0005737200196a6176612e726d692e4d61727=
368616c6c65644f626a6563747cbd1e97ed63fc3e020003490004686173685b00086c6f63=
42797465737400025b425b00086f626a427974657371007e00017870ae19ac31757200025=
b42acf317f8060854e00200007870000000ccaced000574005366696c653a2f443a2f4a42=
6f73732d322e322e325f546f6d6361742d332e322e322f6a626f73732f746d702f6465706=
c6f792f44656661756c742f636172744a3265652e6561722f656a62313031302e6a617274=
0014687474703a2f2f554b5241494e453a383038332f71007e000174005366696c653a2f4=
43a2f4a426f73732d322e322e325f546f6d6361742d332e322e322f6a626f73732f746d70=
2f6465706c6f792f44656661756c742f636172744a3265652e6561722f656a62313031302=
e6a61727571007e00030000014caced000573720008436172744265616e9c1b719cb3d97a=
ba0200014c000e70726f6475637442756e636865737400124c6a6176612f7574696c2f566=
563746f723b7870737200106a6176612e7574696c2e566563746f72d9977d5b803baf0102=
00034900116361706163697479496e6372656d656e7449000c656c656d656e74436f756e7=
45b000b656c656d656e74446174617400135b4c6a6176612f6c616e672f4f626a6563743b=
78700000000000000001757200135b4c6a6176612e6c616e672e4f626a6563743b90ce589=
f1073296c02000078700000000a7372001050726f6475637442756e63684265616ee3e752=
afd8ca334902000346000570726963654900087175616e746974794c000b70726f6475637=
44e616d657400124c6a6176612f6c616e672f537472696e673b78704094cccd0000000774=
0006666f6f642031707070707070707070',FALSE,'mySessionId')]

[JAWS]  at org.hsql.Trace.getError(Trace.java:124)
[JAWS]  at org.hsql.Result.<init>(Result.java:70)
[JAWS]  at org.hsql.jdbcConnection.executeHSQL(jdbcConnection.java:644)
[JAWS]  at org.hsql.jdbcConnection.execute(jdbcConnection.java:540)
[JAWS]  at org.hsql.jdbcStatement.fetchResult(jdbcStatement.java:499)
[JAWS]  at org.hsql.jdbcStatement.executeUpdate(jdbcStatement.java:52)
[JAWS]  at org.hsql.jdbcPreparedStatement.executeUpdate(jdbcPreparedState=
ment.java:114)
[JAWS]  at org.opentools.minerva.jdbc.PreparedStatementInPool.executeUpda=
te(PreparedStatementInPool.java:82)
[JAWS]  at org.jboss.ejb.plugins.jaws.jdbc.JDBCUpdateCommand.executeState=
mentAndHandleResult(JDBCUpdateCommand.java:49)