[JIRA-OS] Created: (WF-201) Provide better sequence support for ibm db2

Message:

  A new issue has been created in JIRA.

---------------------------------------------------------------------
View the issue:

  http://jira.opensymphony.com/secure/ViewIssue.jspa?key=WF-201


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: WF-201
    Summary: Provide better sequence support for ibm db2
       Type: Task

     Status: Assigned
   Priority: Critical

    Project: OSWorkflow
 Components: 
             Core
   Versions:
             2.5

   Assignee: Patrick Lightbody
   Reporter: Howard

    Created: Tue, 26 Aug 2003 9:41 AM
    Updated: Tue, 26 Aug 2003 9:41 AM
Environment: Microsoft Windows 2000
Service Pack 2
IBM WebShphere Studio Application Developer v5.0
IBM DB2 Java Driver
Data Source Helper Class Name -> com.ibm.websphere.rsadapter.DB2DataStoreHelper
IBM DB2 Personal v8.0


Description:
Db2 with osworkflow 2.5 , my problem is in the workflow.xml i am using the
line of code  as seen below......

<osworkflow>
      <persistence
class="com.opensymphony.workflow.spi.jdbc.JDBCWorkflowStore">
        <property key="datasource" value="jdbc/DefaultDS"/>

<!-- Here is the problem -->
        <property key="step.sequence" value="SELECT NEXTVAL FOR
WORKFLOW.seq_currentsteps FROM WORKFLOW.DUAL WHERE 1=1"/>
        <property key="entry.sequence" value="SELECT NEXTVAL FOR
WORKFLOW.seq_workflow_entry FROM WORKFLOW.DUAL WHERE 1=1"/>

As you can see I have modified the osworkflow.xml to reflect how to access
sequence objects for db2, but this is a hack, I have created a table DUAL
with has one(1) column. The sequence is generated/incremented based on the
value in the column.

What is the proper way to do this.

---
The problem is that the JDBC provider assumes that sequences are never
identity sequences, which isn't the case for DBs like MS SQL Server and
mySQL.



---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://jira.opensymphony.com/secure/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira



-------------------------------------------------------
This SF.net email is sponsored by: VM Ware
With VMware you can run multiple operating systems on a single machine.
WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual machines
at the same time. Free trial click here:http://www.vmware.com/wl/offer/358/0