[ 
https://issues.apache.org/jira/browse/JUDDI-1012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17155826#comment-17155826
 ] 

Alex O'Ree commented on JUDDI-1012:
-----------------------------------

confirmed, the newer version of hibernate has a bunch of more dialects for 
different versions of sql server. I've added automated generation for the other 
versions and the output is exactly as you described.

> 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
>            Priority: Major
>
> 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)

Reply via email to