[jira] [Commented] (JUDDI-1012) MS SQL Server Sequence table change
[ https://issues.apache.org/jira/browse/JUDDI-1012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17159603#comment-17159603 ] ASF subversion and git services commented on JUDDI-1012: Commit bad3192dddc3f4b168e6923da9f051616554c2ed in juddi's branch refs/heads/bug/JUDDI-1015 from Alex O'Ree [ https://gitbox.apache.org/repos/asf?p=juddi.git;h=bad3192 ] JUDDI-1012 newer version of hibernate (jre8 min), also adds some additional DDLs for mssql and oracle > 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)
[jira] [Commented] (JUDDI-1012) MS SQL Server Sequence table change
[ https://issues.apache.org/jira/browse/JUDDI-1012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17155828#comment-17155828 ] ASF subversion and git services commented on JUDDI-1012: Commit bad3192dddc3f4b168e6923da9f051616554c2ed in juddi's branch refs/heads/master from Alex O'Ree [ https://gitbox.apache.org/repos/asf?p=juddi.git;h=bad3192 ] JUDDI-1012 newer version of hibernate (jre8 min), also adds some additional DDLs for mssql and oracle > 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)
[jira] [Commented] (JUDDI-1012) MS SQL Server Sequence table change
[ 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)
[jira] [Commented] (JUDDI-1012) MS SQL Server Sequence table change
[ https://issues.apache.org/jira/browse/JUDDI-1012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17155814#comment-17155814 ] Alex O'Ree commented on JUDDI-1012: --- so our DDL files are actually generated from the source code using some tooling. I'll check to see if there's a newer version we can jump too that may produce a newer/better result > 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)