[jbpm-issues] [JBoss JIRA] Closed: (JBPM-2624) ERROR org.hibernate.hql.PARSER in InitializePropertiesCmd.java

ERROR org.hibernate.hql.PARSER in InitializePropertiesCmd.java --------------------------------------------------------------- Key: JBPM-2624 URL: https://jira.jboss.org/jira/browse/JBPM-2624 Project: jBPM Issue Type: Bug Security Level: Public(Everyone can see) Affects Versions: jBPM 4.3 Environment: Ubuntu 9.04 Oracle JDBC Driver version - "11.1.0.6.0-Production+" Java(TM) SE Runtime Environment (build 1.6.0_14-b08) Oracle Database 10g Express Edition Release 10.2.0.1.0 jBPM 4.3-SNAPSHOT Reporter: Michael Wohlfart Priority: Trivial the query for maxDbid in InitializePropertiesCmd.java gives me a ERROR org.hibernate.hql.PARSER - line 1:12: unexpected token: object I think this is caused by the "as" keyword not supported in oracle. the following change in InitializePropertiesCmd.java fixed this for me: for (String persistedType: persistedTypes) { try { Long maxDbid = (Long) session.createQuery( - "select max(object.dbid) " + - "from "+persistedType+" as object" + "select max(dbid) " + + "from "+persistedType ).uniqueResult(); if ( (maxDbid!=null)