that 'sequence' is for migration, when the PK exists and needs to be modified.
you should simplify if you are going to specify statements via configuration. On Sun, 25 Feb 2018 at 17:09 Илья Шипицин <chipits...@gmail.com> wrote: > hello, > > I'm struggling with mssql, the following lines are strange > > > https://github.com/apache/activemq/blob/master/activemq-jdbc-store/src/main/java/org/apache/activemq/store/jdbc/Statements.java#L115-L116 > > > i.e. primary key is created > > https://github.com/apache/activemq/blob/master/activemq-jdbc-store/src/main/java/org/apache/activemq/store/jdbc/Statements.java#L109 > and dropped and recreated from scratch. > > within single statement. any particular reason for that ? > > ms sql is not happy with "DROP PRIMARY KEY" > proper statement is > > ALTER TABLE Table > DROP CONSTRAINT PK_Name > > i.e. name of primary key is needed. > > should we just simplify statements ? > > to single create (without drop/recreate) > > Cheers, > > Ilya Shipitsin >
