Problem generating Seam entity from a table with a composite primary key.

Issue

• Problem generating Seam entity from a table with a composite primary key.

  Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
   at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
   at org.hibernate.loader.Loader.doList(Loader.java:2458)
   at org.hibernate.loader.Loader.doList(Loader.java:2440)
   at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2316)
   at org.hibernate.loader.Loader.list(Loader.java:2311)
   at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:414)
   at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:364)
   at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
   at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1192)
   at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
   at org.hibernate.ejb.QueryImpl.getSingleResult(QueryImpl.java:116)
   ... 94 more
  Caused by: java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis
  
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
   at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
   at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
   at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
   at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
   at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
   at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
   at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
   at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
   at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
   at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
   at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
   at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342)
   at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
   at org.hibernate.loader.Loader.getResultSet(Loader.java:1997)
   at org.hibernate.loader.Loader.doQuery(Loader.java:840)
   at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:298)
   at org.hibernate.loader.Loader.doList(Loader.java:2455)
   ... 103 more
  10:40:59,101 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: null
  10:40:59,101 ERROR [JDBCExceptionReporter] Transaction is not active: tx=TransactionImple < ac, BasicAction: -7ffe2ff2:f88:4f1d651a:1bc status: ActionStatus.ABORT_ONLY >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -7ffe2ff2:f88:4f1d651a:1bc status: ActionStatus.ABORT_ONLY >)