2 Replies Latest reply on Oct 21, 2005 5:30 AM by Lauro Canonica

    database problem

    helen wang Newbie

      Hi, I downloaded EJB3 trailblazer and put in my server folder as instructed. The server gave an error later about database table insertion problem. Don't know why. Suppose a downloaded sample should be running w/o problems.

      The error is:
      10:11:24,978 INFO [STDOUT] The isFirst variable is true
      10:11:24,978 INFO [STDOUT] Populate the database tables
      10:11:25,119 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
      10:11:25,119 ERROR [JDBCExceptionReporter] Table not found in statement [insert into investor (name, end, start, id) val
      ues (?, ?, ?, null)]
      10:11:25,119 ERROR [[jsp]] Servlet.service() for servlet jsp threw exception
      javax.ejb.EJBException: null; CausedByException is:
      could not insert: [trail.entity.beans.Investor]
      at org.jboss.ejb3.tx.Ejb3TxPolicy.handleExceptionInOurTx(Ejb3TxPolicy.java:46)
      at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:70)
      at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:134)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
      at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:61)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)

      Could anyone help?