> Good point! I did it and I got another error, which is perfectly explained > by an unanswered question to this mailing-list > > > http://hippo15.castaserver.com/pipermail/hippocms-dev/2009-March/005960.html > > Any clue? Maybe Daniel managed to figure it out? > > TIA > mau > > I did some further investigation, and managed to get a meaningful stacktrace: Root cause: com.microsoft.sqlserver.jdbc.SQLServerException: 'nextVal' is not a recognized built-in function name. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source) at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.sendExecute(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteQuery(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(Unknown Source) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) at com.opensymphony.workflow.spi.jdbc.JDBCWorkflowStore.getNextEntrySequence(JDBCWorkflowStore.java:597) at com.opensymphony.workflow.spi.jdbc.JDBCWorkflowStore.createEntry(JDBCWorkflowStore.java:159) at com.opensymphony.workflow.AbstractWorkflow.initialize(AbstractWorkflow.java:582)
So, sqlserver throws an error on the nextVal function. This function is in the osworkflow code as the default value for entry.sequence and step.sequence properties. We're using the example_project_sqlserver_J2EE template, and in the WorkflowStore.xml entry.sequence is not defined causing osworkflow to fall back on the default value, which causes the error. 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? Thanks, Rogier ******************************************** 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
