4:12 p.m.
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 my 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)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:58 a.m.
New subject: [JBoss JIRA] Updated: (JBPM-2624) ERROR org.hibernate.hql.PARSER in InitializePropertiesCmd.java
[
https://jira.jboss.org/jira/browse/JBPM-2624?page=com.atlassian.jira.plug...
]
Michael Wohlfart updated JBPM-2624:
-----------------------------------
Description:
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)
was:
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 my 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)
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)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:01 a.m.
New subject: [JBoss JIRA] Commented: (JBPM-2624) ERROR org.hibernate.hql.PARSER in InitializePropertiesCmd.java
[
https://jira.jboss.org/jira/browse/JBPM-2624?page=com.atlassian.jira.plug...
]
Tom Baeyens commented on JBPM-2624:
-----------------------------------
can you give the full stack trace ?
are you using the hibernate libs that are are specified in our dependencies and that ship
in our distro ?
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)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:07 a.m.
New subject: [JBoss JIRA] Commented: (JBPM-2624) ERROR org.hibernate.hql.PARSER in InitializePropertiesCmd.java
[
https://jira.jboss.org/jira/browse/JBPM-2624?page=com.atlassian.jira.plug...
]
Michael Wohlfart commented on JBPM-2624:
----------------------------------------
I am using hibernate 3.3.2.GA instead of 3.3.1.GA from the pom, give me some time for the
stacktrace.
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)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:39 p.m.
New subject: [JBoss JIRA] Commented: (JBPM-2624) ERROR org.hibernate.hql.PARSER in InitializePropertiesCmd.java
[
https://jira.jboss.org/jira/browse/JBPM-2624?page=com.atlassian.jira.plug...
]
Michael Wohlfart commented on JBPM-2624:
----------------------------------------
I had to add a e.printStackTrace(); in line 158 to get the stacktrace,
but actually it seems like this is caused by a incomplete database setup
on my side and not a jbpm4 problem at all, sorry for the noise.
the exception :
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: object near line 1, column
12 [select max(object.dbid) from org.jbpm.pvm.internal.type.Variable as object]
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82)
at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:284)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:182)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1651)
at
org.jbpm.pvm.internal.id.InitializePropertiesCmd.getMaxDbid(InitializePropertiesCmd.java:147)
at
org.jbpm.pvm.internal.id.InitializePropertiesCmd.initializeNextId(InitializePropertiesCmd.java:107)
at
org.jbpm.pvm.internal.id.InitializePropertiesCmd.execute(InitializePropertiesCmd.java:69)
at
org.jbpm.pvm.internal.id.InitializePropertiesCmd.execute(InitializePropertiesCmd.java:54)
at
org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)
at
org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:54)
at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)
at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)
at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:55)
at
org.jbpm.pvm.internal.id.DatabaseDbidGenerator.initialize(DatabaseDbidGenerator.java:109)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.jbpm.pvm.internal.util.ReflectUtil.invoke(ReflectUtil.java:160)
at org.jbpm.pvm.internal.wire.operation.InvokeOperation.apply(InvokeOperation.java:39)
at
org.jbpm.pvm.internal.wire.descriptor.ObjectDescriptor.initialize(ObjectDescriptor.java:234)
at org.jbpm.pvm.internal.wire.WireContext.performInitialization(WireContext.java:533)
at org.jbpm.pvm.internal.wire.WireContext.initialize(WireContext.java:495)
at org.jbpm.pvm.internal.wire.WireContext.create(WireContext.java:449)
at org.jbpm.pvm.internal.wire.WireContext.create(WireContext.java:437)
at org.jbpm.pvm.internal.wire.WireContext.get(WireContext.java:417)
at org.jbpm.pvm.internal.wire.WireContext.get(WireContext.java:327)
at org.jbpm.pvm.internal.wire.WireContext.get(WireContext.java:688)
at org.jbpm.pvm.internal.env.BasicEnvironment.get(BasicEnvironment.java:139)
at org.jbpm.pvm.internal.env.BasicEnvironment.get(BasicEnvironment.java:130)
at org.jbpm.pvm.internal.env.EnvironmentImpl.getFromCurrent(EnvironmentImpl.java:201)
at org.jbpm.pvm.internal.id.DbidGenerator.getDbidGenerator(DbidGenerator.java:35)
at
org.jbpm.pvm.internal.repository.RepositorySessionImpl.deploy(RepositorySessionImpl.java:56)
at org.jbpm.pvm.internal.cmd.DeployCmd.execute(DeployCmd.java:47)
at org.jbpm.pvm.internal.cmd.DeployCmd.execute(DeployCmd.java:33)
at
org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)
at
org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:54)
at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)
at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)
at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:55)
at org.jbpm.pvm.internal.svc.SkipInterceptor.execute(SkipInterceptor.java:43)
at org.jbpm.pvm.internal.repository.DeploymentImpl.deploy(DeploymentImpl.java:91)
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)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:51 a.m.
New subject: [JBoss JIRA] Closed: (JBPM-2624) ERROR org.hibernate.hql.PARSER in InitializePropertiesCmd.java
[
https://jira.jboss.org/jira/browse/JBPM-2624?page=com.atlassian.jira.plug...
]
Joram Barrez closed JBPM-2624.
------------------------------
Resolution: Cannot Reproduce Bug
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)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5475
days inactive
5531
days old
5 comments
3 participants
participants (3)
-
Joram Barrez (JIRA) -
Michael Wohlfart (JIRA)
-
Tom Baeyens (JIRA)