OsWorkFlow学习(数据库设置)

OsWorkFlow官方网站:http://www.opensymphony.com/osworkflow/
从网上找到OsWorkFlow的一些介绍性文摘,例如:http://my.so-net.net.tw/idealist/OSWorkflow/。开始自己第一个OsWorkFlow程序。
环境:jboss 4.0.1 sp1,Ms sql server 2000 sp4
一、数据库设置(注意红色字体):
    1、 deploy/mssql-ds.xml配置:
datasources
  local-tx-datasource
    jndi-nameMSSQLDS/jndi-name
    connection-urljdbc:microsoft:sqlserver://localhost:1433;DatabaseName=OSWorkflow/connection-url
    driver-classcom.microsoft.jdbc.sqlserver.SQLServerDriver/driver-class
    user-namesa/user-name
    password11/password
  /local-tx-datasource
/datasources 
    2、classes/osworkflow.xml配置:
osworkflow
!--
persistence class="com.opensymphony.workflow.spi.memory.MemoryWorkflowStore"/
--
persistence class="com.opensymphony.workflow.spi.jdbc.JDBCWorkflowStore"

 property key="datasource" value="java:MSSQLDS"/
 property key="entry.sequence"
                      value="select count(*) + 1 from os_wfentry"/
 property key="entry.table" value="OS_WFENTRY"/
 property key="entry.id" value="ID"/
 property key="entry.name" value="NAME"/
 property key="entry.state" value="STATE"/
 property key="step.sequence"
value="select sum(c1) + 1 from (select 1 as tb, count(*) as c1
       from os_currentstep union
       select 2 as tb, count(*) as c1 from os_historystep) as TabelaFinal"/
 property key="history.table" value="OS_HISTORYSTEP"/
 property key="current.table" value="OS_CURRENTSTEP"/
 property key="historyPrev.table" value="OS_HISTORYSTEP_PREV"/
 property key="currentPrev.table" value="OS_CURRENTSTEP_PREV"/
 property key="step.id" value="ID"/
 property key="step.entryId" value="ENTRY_ID"/
 property key="step.stepId" value="STEP_ID"/
 property key="step.actionId" value="ACTION_ID"/
 property key="step.owner" value="OWNER"/
 property key="step.caller" value="CALLER"/
 property key="step.startDate" value="START_DATE"/
 property key="step.finishDate" value="FINISH_DATE"/
 property key="step.dueDate" value="DUE_DATE"/
 property key="step.status" value="STATUS"/
 property key="step.previousId" value="PREVIOUS_ID"/
/persistence
    factory class="com.opensymphony.workflow.loader.XMLWorkflowFactory"
        property key="resource" value="workflows.xml" /
    /factory
/osworkflow    
   3、classes/propertyset.xml配置
propertysets
 propertyset name="jdbc" class="com.opensymphony.module.propertyset.database.JDBCPropertySet"
  arg name="table.name" value="os_propertyentry"/
  arg name="col.globalKey" value="GLOBAL_KEY"/
  arg name="col.itemKey" value="ITEM_KEY"/
  arg name="col.itemType" value="ITEM_TYPE"/
  arg name="col.string" value="STRING_VALUE"/
  arg name="col.date" value="DATE_VALUE"/
  arg name="col.data" value="DATA_VALUE"/
  arg name="col.float" value="FLOAT_VALUE"/
  arg name="col.number" value="NUMBER_VALUE"/
  arg name="datasource" value="java:MSSQLDS"/
  arg name="" value=""/
 /propertyset
/propertysets
在未增加/propertyset.xml文件时,浏览文件执行流程会抛出以下的异常:
23:18:19,380 FATAL [JDBCPropertySet] Error looking up DataSource atjdbc/DefaultDS
javax.naming.NameNotFoundException: jdbc not bound
        at org.jnp.server.NamingServer.getBinding(NamingServer.java:491)
        at org.jnp.server.NamingServer.getBinding(NamingServer.java:499)
        at org.jnp.server.NamingServer.getObject(NamingServer.java:505)
        at org.jnp.server.NamingServer.lookup(NamingServer.java:249)
        at org.jnp.server.NamingServer.lookup(NamingServer.java:252)
        at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:544)
        at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:658)
        at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:520)
        at javax.naming.InitialContext.lookup(InitialContext.java:347)
        at com.opensymphony.module.propertyset.database.JDBCPropertySet.lookup(J
DBCPropertySet.java:536)
系统根本就没有设置过jdbc/DefaultDS的数据源,OsWorlFlow把jdbc/DefaultDS作为默认的数据源了。

转载于:https://www.cnblogs.com/swingboat/archive/2005/07/26/200721.html

最新回复(0)
/jishuggf4ZzGZDedIWWmJ8bmxj43Np4XFQ6jBr3h9DZAbLJI_3D4719441
8 简首页