 | Mailing List | | Home | | Forum Home | | JBoss - Java Application Server | | Tomcat - JSP/Servlet container | | Struts - A MVC web framework | | iText - An open source PDF Java Library | | JDOM - JDOM XML Parser | | J2EE - A mailing list for Java(tm) 2 Platform, Enterprise Edition | | JSP - A mailing list about Java Server Pages specification and reference | | J2EE Pattern - An interest list for Sun Java Center J2EE Pattern Catalog | | Servlet - A mailing list for discussion about Sun Microsystem's Java Servlet API Technology | |
Struts & Hibernate
|
|
|
| | | - ProcessDefinition disapear from the database | - ProcessDefinition disapear from the database 2007-07-16 - By mailinator
Back
Hi,
i have encountred some issue while testing jbpm.
Here what i have done :
Deploying my processdefinition with the deployer of the jbpm Designer eclipse
plugin.
Checking in the database for that processdefinition : it appeared.
In my Struts action :
JbpmConfiguration jbpmConfiguration=JbpmConfiguration.getInstance();
JbpmContext jbpmContext=jbpmConfiguration.createJbpmContext();
jbpmConfiguration.createSchema();
ProcessDefinition processDefinition=ProcessDefinition.parseXmlResource(
"demandeAccesVerifUserAlerteRH/processdefinition.xml");
This throws an exception :
17:06:21,822 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
17:06:21,822 ERROR [JDBCExceptionReporter] ORA-00942 (See http://ORA-00942.ora-code.com): Table ou vue inexistante
17:06:21,822 ERROR [JobSession] org.hibernate.exception.SQLGrammarException  : cou
ld not execute query
17:06:21,838 ERROR [JobExecutorThread] exception in job executor thread. waiting
5000 milliseconds
org.jbpm.JbpmException: couldn't get acquirable jobs
at org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:44)
at org.jbpm.job.executor.JobExecutorThread.acquireJobs(JobExecutorThread
.java:111)
at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:56
)
Caused by: org.hibernate.exception.SQLGrammarException : could not execute query
at org.hibernate.exception.SQLStateConverter (SQLStateConverter.j
ava:67)
at org.hibernate.exception.JDBCExceptionHelper (JDBCExceptionHelp
er.java:43)
at org.hibernate.loader.Loader (Loader.java:2223)
at org.hibernate.loader.Loader (Loader.java:2104)
at org.hibernate.loader.Loader (Loader.java:2099)
at org.hibernate.loader.hql.QueryLoader (QueryLoader.java:378)
at org.hibernate.hql.ast.QueryTranslatorImpl (QueryTranslatorImpl.ja
va:338)
at org.hibernate.engine.query.HQLQueryPlan (HQLQueryPlan.java
:172)
at org.hibernate.impl.SessionImpl (SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl (QueryImpl.java:79)
at org.hibernate.impl.AbstractQueryImpl (AbstractQueryImpl.j
ava:811)
at org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:40)
... 2 more
Caused by: java.sql.SQLException : ORA-00942 (See http://ORA-00942.ora-code.com): Table ou vue inexistante
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:
830)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.jav
a:2391)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:2672)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
edStatement.java:589)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePrepare
dStatement.java:527)
at org.hibernate.jdbc.AbstractBatcher (AbstractBatcher.java:
186)
at org.hibernate.loader.Loader (Loader.java:1787)
at org.hibernate.loader.Loader (Loader.java:674)
at org.hibernate.loader.Loader (Lo
ader.java:236)
at org.hibernate.loader.Loader (Loader.java:2220)
... 11 more
17:06:26,931 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
17:06:26,931 ERROR [JDBCExceptionReporter] ORA-00942 (See http://ORA-00942.ora-code.com): Table ou vue inexistante
17:06:26,931 ERROR [JobSession] org.hibernate.exception.SQLGrammarException : cou
ld not execute query
17:06:26,931 ERROR [JobExecutorThread] exception in job executor thread. waiting
10000 milliseconds
org.jbpm.JbpmException: couldn't get acquirable jobs
at org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:44)
at org.jbpm.job.executor.JobExecutorThread.acquireJobs(JobExecutorThread
.java:111)
at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:56
)
Caused by: org.hibernate.exception.SQLGrammarException : could not execute query
at org.hibernate.exception.SQLStateConverter (SQLStateConverter.j
ava:67)
at org.hibernate.exception.JDBCExceptionHelper (JDBCExceptionHelp
er.java:43)
at org.hibernate.loader.Loader (Loader.java:2223)
at org.hibernate.loader.Loader (Loader.java:2104)
at org.hibernate.loader.Loader (Loader.java:2099)
at org.hibernate.loader.hql.QueryLoader (QueryLoader.java:378)
at org.hibernate.hql.ast.QueryTranslatorImpl (QueryTranslatorImpl.ja
va:338)
at org.hibernate.engine.query.HQLQueryPlan (HQLQueryPlan.java
:172)
at org.hibernate.impl.SessionImpl (SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl (QueryImpl.java:79)
at org.hibernate.impl.AbstractQueryImpl (AbstractQueryImpl.j
ava:811)
at org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:40)
... 2 more
Caused by: java.sql.SQLException : ORA-00942 (See http://ORA-00942.ora-code.com): Table ou vue inexistante
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:
830)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.jav
a:2391)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:2672)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
edStatement.java:589)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePrepare
dStatement.java:527)
at org.hibernate.jdbc.AbstractBatcher (AbstractBatcher.java:
186)
at org.hibernate.loader.Loader (Loader.java:1787)
at org.hibernate.loader.Loader (Loader.java:674)
at org.hibernate.loader.Loader (Lo
ader.java:236)
at org.hibernate.loader.Loader (Loader.java:2220)
... 11 more
If someone know about this or has already encountred that issue, please keep me
posted.
Best regards,
O.M.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic
&p=4064597#4064597
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode
=reply&p=4064597
__ ____ ____ ____ ____ ____ ____ ____ ____ ____
jboss-user mailing list
jboss-user@(protected)
https://lists.jboss.org/mailman/listinfo/jboss-user
|
|
|