Source

osworkflow / docs / JDBCWorkflowFactory.html

<html>
    <head>
        <title>JDBCWorkflowFactory</title>
	    <link rel="stylesheet" href="styles/site.css" type="text/css" />
    </head>

    <body>
	    <table class="pagecontent" border="0" cellpadding="0" cellspacing="0" width="100%" bgcolor="#ffffff">
		    <tr>
			    <td valign="top" class="pagebody">

				    <p class="paragraph"><b class="strong">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.
<h2 class="heading2"> These features are planned for JDBCWorkflowFactory, but not yet implemented:</h2><ol>
<li> versioning support</li>
<li> find alternative to storing xml directly</li>
<li> delete function</li>
</ol><br/>
It requires some configuration to get it running:
<h3 class="heading3"> <a name="JDBCWorkflowFactory-osworkflow.xml" ></a> osworkflow.xml:</h3>
<div class="code"><pre>&lt;osworkflow&gt;&#10;  &lt;persistence class=&quot;com.opensymphony.workflow.spi.jdbc.JDBCWorkflowStore&quot;&gt;&#10;    &lt;arg name=&quot;foo&quot; value=&quot;bar&quot;/&gt;&#10;    ...&#10;  &lt;/persistence&gt;&#10;  &lt;factory class=&quot;com.opensymphony.workflow.loader.JDBCWorkflowFactory&quot;&gt;&#10;  &lt;/factory&gt;&#10;&lt;/osworkflow&gt;</pre></div>
<h3 class="heading3"> <a name="JDBCWorkflowFactory-JDBCDatabase" ></a> JDBC Database:</h3></p>Example create table script for HSQLDB:
<div class="code"><pre>CREATE CACHED TABLE OS&#95;WORKFLOWDEFS (WF&#95;DEFINITION BINARY,WF&#95;NAME VARCHAR(256) NOT NULL PRIMARY KEY)</pre></div>

				    
			    </td>
		    </tr>
	    </table>
    </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.