0 Replies Latest reply on Jul 2, 2007 5:05 PM by james leddy

    Default hsqldb database not working

    james leddy Newbie

      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.