You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@juddi.apache.org by "Alex O'Ree (Jira)" <ju...@ws.apache.org> on 2020/07/11 02:02:00 UTC
[jira] [Resolved] (JUDDI-1012) MS SQL Server Sequence table change
[ https://issues.apache.org/jira/browse/JUDDI-1012?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Alex O'Ree resolved JUDDI-1012.
-------------------------------
Fix Version/s: 3.3.8
Assignee: Alex O'Ree
Resolution: Fixed
> MS SQL Server Sequence table change
> -----------------------------------
>
> Key: JUDDI-1012
> URL: https://issues.apache.org/jira/browse/JUDDI-1012
> Project: jUDDI
> Issue Type: Improvement
> Components: core
> Affects Versions: 3.3.7
> Reporter: Steve Luisser
> Assignee: Alex O'Ree
> Priority: Major
> Fix For: 3.3.8
>
>
> SQL Server 2012 is the oldest version that is supported by Microsoft. This and newer versions support sequences.
>
> File mssql2000.ddl:
>
> create table hibernate_sequence (next_val numeric(19,0));
> Multiple instances of insert into hibernate_sequence values ( 1 );
>
> Suggestion to change this to:
> create sequence hibernate_sequence start with 1 increment by 1;
>
> To remove the sequence use: DROP sequence hibernate_sequence;
--
This message was sent by Atlassian Jira
(v8.3.4#803005)