0 Replies Latest reply on Jul 2, 2006 4:05 PM by mtedone1

    TableGenerator doesn't work with MySQL

    mtedone1

      Hi, I tried the @GeneratedValue(strategy=GenerationType.AUTO) annotation on an entity mapped to a table with auto pk on and it worked fine. Then I tried to use the @TableGenerator as follows:

      @javax.persistence.Id()
       @javax.persistence.Column(name = "ID")
       @TableGenerator(name="Employee_Sequence",
       table="ID_GEN",
       pkColumnName="GEN_NAME",
       pkColumnValue="GEN_VAL")
       @GeneratedValue(generator="Employee_Sequence")
       public int getId() {
       return id;
       }
      


      after creating a ID_GEN table, and have removed the auto increment option from the Employee table id. But when I ran the application I got the following exception:

      Exception in thread "main" javax.ejb.EJBException: javax.persistence.PersistenceException: org.hibernate.HibernateException: The database returned no natively generated identity value
      at org.jboss.ejb3.tx.Ejb3TxPolicy.handleExceptionInOurTx(Ejb3TxPolicy.java:69)
      at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:83)
      at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:197)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:78)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:47)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:225)
      at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:106)
      at org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invoke(AOPRemotingInvocationHandler.java:82)
      at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:828)
      at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:681)
      at org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:358)
      at org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:398)
      at org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:239)


      I take that the table mode of auto-creating primary keys doesn't work with my db. I'm using MySQL 4.1.7-NT