Rogier Peters wrote:
So, how would I determine if this is right or wrong? Anything in the
database I can look at?
According to the api docs[0], it's defined as:
'SQL query that returns the next ID for a workflow entry.'
So you should check if new workflow entries indeed get an ID, one
higher than the previous one.
There might very well be a better way to do this in MSSQL, but this
should work AFAICT without actually having tested it.
[0]http://www.opensymphony.com/osworkflow/api/com/opensymphony/workflow/spi/jdbc/JDBCWorkflowStore.html
On Fri, Nov 13, 2009 at 1:41 PM, Bartosz Oudekerk
<[email protected]>wrote:
Rogier Peters wrote:
I assume putting a correct value for entry.sequence in the
WorkflowStore.xml
would solve this, but I have no idea what the value should be. Could you
please help me with this?
If anyone is feeling adventurous, they could try to define
entry.sequence as:
<entry key="entry.sequence">
<value>select count(*) + 1 from OS_WFENTRY</value>
</entry>
Note that this is *untested* !!
Regards,
--
Bartosz Oudekerk
.---------------------------------.-----------------------------------.
| Hippo B.V. | Hippo USA Inc. |
| Oosteinde 11 | 101 H Street, suite Q Petaluma CA |
| 1017 WT Amsterdam | 94952-5100 San Francisco |
| The Netherlands | United States |
| Tel +31 (0)20 5224466 | +1 (707) 773-4646 |
+---------------------------------+-----------------------------------+
| [email protected] | http://www.onehippo.com |
`---------------------------------^-----------------------------------'
********************************************
Hippocms-dev: Hippo CMS development public mailinglist
Searchable archives can be found at:
MarkMail: http://hippocms-dev.markmail.org
Nabble: http://www.nabble.com/Hippo-CMS-f26633.html
--
Bartosz Oudekerk
.---------------------------------.-----------------------------------.
| Hippo B.V. | Hippo USA Inc. |
| Oosteinde 11 | 101 H Street, suite Q Petaluma CA |
| 1017 WT Amsterdam | 94952-5100 San Francisco |
| The Netherlands | United States |
| Tel +31 (0)20 5224466 | +1 (707) 773-4646 |
+---------------------------------+-----------------------------------+
| [email protected] | http://www.onehippo.com |
`---------------------------------^-----------------------------------'
********************************************
Hippocms-dev: Hippo CMS development public mailinglist
Searchable archives can be found at:
MarkMail: http://hippocms-dev.markmail.org
Nabble: http://www.nabble.com/Hippo-CMS-f26633.html
