-
Bug
-
Resolution: Done
-
Major
-
None
-
None
-
None
-
False
-
False
-
NEW
-
NEW
-
Undefined
-
Workaround Exists
-
-
-
Using our provided ddl scripts sql server tables are created with identities:
create table SessionInfo (
id numeric(19,0) identity not null,
lastModificationDate datetime,
rulesByteArray image,
startDate datetime,
OPTLOCK int,
primary key (id)
);
but sqlserver2012dialect is expecting sequences
WARN SqlExceptionHelper | |: SQL Error: 208, SQLState: S0002
SqlExceptionHelper | |: Invalid object name 'SESSIONINFO_ID_SEQ'.
WARN PersistableRunner | |: Could not commit session
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
Looks like jbpm project distinguish from sqlserver2008 and sqlserver above 2008 but use of identities is the same:
- sql server 2008 script: https://github.com/kiegroup/jbpm/blob/master/jbpm-db-scripts/src/main/resources/db/ddl-scripts/sqlserver2008/sqlserver2008-jbpm-schema.sql#L354
- sql server above 2008 script: https://github.com/kiegroup/jbpm/blob/master/jbpm-db-scripts/src/main/resources/db/ddl-scripts/sqlserver/sqlserver-jbpm-schema.sql#L354
- clones
-
-
- Closed
-
