activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gary Tully <gary.tu...@gmail.com>
Subject Re: weird sql jdbc statements
Date Fri, 02 Mar 2018 14:00:07 GMT
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 Илья Шипицин <chipitsine@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
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message