[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Default hsqldb database not working

[jleddy]

I'm having this problem with the default hsqldb database, which looks like this in hsqldb-ds.xml:

<connection-url>jdbc:hsqldb:${jboss.server.data.dir}${/}hypersonic${/}localDB</connection-url>

Whenever I try the helloworld from the seccond chapter of http://www.infoq.com/news/2006/12/seam-intro, I get this printed in the console:

15:17:20,861 INFO  [MyfacesConfig] No context init parameter 'org.apache.myfaces
.PRETTY_HTML' found, using default value true
15:17:20,861 INFO  [MyfacesConfig] No context init parameter 'org.apache.myfaces
.ALLOW_JAVASCRIPT' found, using default value true
15:17:20,862 INFO  [MyfacesConfig] Tomahawk jar not available. Autoscrolling, De
tectJavascript, AddResourceClass and CheckExtensionsFilter are disabled now.
15:17:29,127 INFO  [STDOUT] REPORTID 0
15:17:30,864 INFO  [STDOUT] REPORTID 1
15:17:32,279 INFO  [STDOUT] REPORTID 2
15:17:33,385 INFO  [STDOUT] REPORTID 3
15:17:34,491 INFO  [STDOUT] REPORTID 4
15:18:13,515 INFO  [STDOUT] Hibernate: insert into Person (id, name) values (nul
l, ?)
15:18:13,516 WARN  [JDBCExceptionReporter] SQL Error: -28, SQLState: S0022
15:18:13,516 ERROR [JDBCExceptionReporter] Column not found: NAME in statement [
insert into Person (id, name) values (null, ?)]
15:18:13,517 ERROR [[Faces Servlet]] Servlet.service() for servlet Faces Servlet
 threw exception
javax.faces.FacesException: Error calling action method of component with id _id
Jsp1:_idJsp4

What's more is that I get:

SET AUTOCOMMIT FALSE
SET AUTOCOMMIT TRUE

in my data/hypersonic/localDB.log every time I try to use the helloworld app as well.  This happens whenever I try to enter a name into the input box.




View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4059740#4059740

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4059740