Boris,
go to http://prdownloads.sourceforge.net/hsqldb/hsql_143.zip
and download the zip file with hypersonic.
unzip it, go to the demo folder and launch the
org.hsql.util.DatabaseManager (look at the memorydbmanager.html source)
and connect to the in memory db that is running when jBoss is running.
(settings can be found in jboss.jcml)
Werner
Boris Garbuzov wrote:
> I can not rid of Column not found error. Some column JBoss does not want to accept
>as a primary key
> in spite of renaming and retyping it (I tried to avoid forbidden types and reserved
>names). I would
> like to observe tables in Hypersonic created and also kill old repository. Can you
>please tell me
> 1. where Hypersonic keeps its data file and
> 2. how to get a client console tool to easily see database contents (execute
>queries)?
> -----------------
> [JAWS] java.sql.SQLException: Column not found: HUETA in statement [INSERT INTO
>OrderEntity
> (customerName,hueta,cartBean,isDelivered,sessionId) VALUES
>
>('myCustomerName',NULL,'aced0005737200196a6176612e726d692e4d61727368616c6c65644f626a6563747cbd1e97ed63fc3e020003490004686173685b00086c6f6342797465737400025b425b00086f626a427974657371007e00017870ae19ac31757200025b42acf317f8060854e00200007870000000c4aced000574004f66696c653a2f443a2f4a426f73732d322e322e325f546f6d6361742d332e322e322f6a626f73732f746d702f6465706c6f792f44656661756c742f636172742e6561722f656a62313031302e6a6172740014687474703a2f2f554b5241494e453a383038332f71007e000174004f66696c653a2f443a2f4a426f73732d322e322e325f546f6d6361742d332e322e322f6a626f73732f746d702f6465706c6f792f44656661756c742f636172742e6561722f656a62313031302e6a61727571007e00030000014caced000573720008436172744265616e9c1b719cb3d97aba0200014c000e70726f6475637442756e636865737400124c6a6176612f7574696c2f566563746f723b7870737200106a6176612e7574696c2e566563746f72d9977d5b803baf010200034900116361706163697479496e6372656d656e7449000c656c656d656e74436f756e745b000b656c656d656e74446174617400135b4c6a6176612f6c616e672f4f626a6563743b78700000000000000001757200135b4c6a6176612e6c616e672e4f626a6563743b90ce589f1073296c02000078700000000a7372001050726f6475637442756e63684265616ee3e752afd8ca334902000346000570726963654900087175616e746974794c000b70726f647563744e616d657400124c6a6176612f6c616e672f537472696e673b78704094cccd00000007740006666f6f642031707070707070707070',FALSE,'mySessionId')]
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user
--
-----------------------------------------------------------------------
crypto : One who covertly supports a certain doctrine, group, or party.
<mailto: [EMAIL PROTECTED]> <http://www.shiftat.com>
-----------------------------------------------------------------------
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
