osworkflow-2.8.0的例子跑不通

[hrob1]

研究了几天osworkflow，把osworkflow-2.8.0-example按照官方的开发指南的配置了一下（数据库是用的Oracle），初始化用test用户登录后，New Workflow 的时候页面报错（如下）：

javax.servlet.ServletException: Unable to create current step for workflow instance #60: root cause: ORA-02289: 序列（号）不存在

org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.newworkflow_jsp._jspService(newworkflow_jsp.java:81)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


root cause

com.opensymphony.workflow.StoreException: Unable to create current step for workflow instance #60: root cause: ORA-02289: 序列（号）不存在

com.opensymphony.workflow.spi.jdbc.JDBCWorkflowStore.createCurrentStep(JDBCWorkflowStore.java:166)
com.opensymphony.workflow.AbstractWorkflow.createNewCurrentStep(AbstractWorkflow.java:1509)
com.opensymphony.workflow.AbstractWorkflow.transitionWorkflow(AbstractWorkflow.java:1256)
com.opensymphony.workflow.AbstractWorkflow.initialize(AbstractWorkflow.java:618)
org.apache.jsp.newworkflow_jsp._jspService(newworkflow_jsp.java:53)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


root cause

java.sql.SQLException: ORA-02289: 序列（号）不存在

oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:810)
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:850)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134)
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3384)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
com.opensymphony.workflow.spi.jdbc.JDBCWorkflowStore.getNextStepSequence(JDBCWorkflowStore.java:753)
com.opensymphony.workflow.spi.jdbc.JDBCWorkflowStore.createCurrentStep(JDBCWorkflowStore.java:819)
com.opensymphony.workflow.spi.jdbc.JDBCWorkflowStore.createCurrentStep(JDBCWorkflowStore.java:161)
com.opensymphony.workflow.AbstractWorkflow.createNewCurrentStep(AbstractWorkflow.java:1509)
com.opensymphony.workflow.AbstractWorkflow.transitionWorkflow(AbstractWorkflow.java:1256)
com.opensymphony.workflow.AbstractWorkflow.initialize(AbstractWorkflow.java:618)
org.apache.jsp.newworkflow_jsp._jspService(newworkflow_jsp.java:53)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

意思应该是创建当前步骤的时候出现异常，说明工作流的实例已经有了，os_wfentry表里也的确有数据，但是为什么不能创建当前步骤呢，搞不懂
ps：数据源配置肯定没有问题，用测试页面测试过的，可以得到conn

[jjtking]

To use oracle as the backend database, execute the file tables_oracle.sql
against the database and make sure the following is defined in the
osworkflow.xml:

<!- Oracle sequence access ->
<property key="entry.sequence"
value="SELECT seq_os_wfentry.nextval FROM dual"/>
<property key="step.sequence"
value="SELECT seq_os_currentsteps.nextval FROM dual"/> 这两个序号一定要建好先，查看下你编译后目标文件osworkflow.xml里面这两句有没有改掉。

[jjtking]

楼主不知道你现在学得怎么样了，我最近在研究这个东西，比较郁闷。不知道选osworkflow好还是jbpm,这两个都是开源的，相关的资料都不怎么全面，都是相互贴来贴去的。