osworkflow / docs / JDBCWorkflowFactory.html

<html><head><title>JDBCWorkflowFactory</title></head><body>
<b class="bold">com.opensymphony.workflow.loader.JDBCWorkflowFactory</b> is an alternative factory, that allows you to store your workflow definitions in a JDBC database instead of putting them into the xml files.
<h3 class="heading-1">These features are planned for JDBCWorkflowFactory, but not yet implemented:
</h3>
<ol>
<li> versioning support</li>
<li> find alternative to storing xml directly</li>
<li> delete function</li>
</ol><p class="paragraph"></p>It requires some configuration to get it running:
<h3 class="heading-1-1"><a name="osworkflow.xml"></a><a href="JDBCWorkflowFactory#osworkflow_xml.html" title="Permalink to osworkflow.xml"></img></a> osworkflow.xml:
</h3>
<div class="wikicode"><pre>&#60;osworkflow&#62;
  &#60;persistence class=<span class="java&#45;quote">"com.opensymphony.workflow.spi.jdbc.JDBCWorkflowStore"</span>&#62;
    &#60;arg name=<span class="java&#45;quote">"foo"</span> value=<span class="java&#45;quote">"bar"</span>/&#62;
    ...
  &#60;/persistence&#62;
  &#60;factory class=<span class="java&#45;quote">"com.opensymphony.workflow.loader.JDBCWorkflowFactory"</span>&#62;
  &#60;/factory&#62;
&#60;/osworkflow&#62;</pre></div>
<h3 class="heading-1-1"><a name="JDBCDatabase"></a><a href="JDBCWorkflowFactory#JDBCDatabase.html" title="Permalink to JDBCDatabase"></img></a> JDBC Database:
</h3><p class="paragraph"></p>Example create table script for HSQLDB:
<div class="wikicode"><pre>CREATE CACHED TABLE OS_WORKFLOWDEFS (WF_DEFINITION BINARY,WF_NAME VARCHAR(256) NOT NULL PRIMARY KEY)</pre></div></body></html>
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.