Uploaded image for project: 'ActiveMQ Classic'
  1. ActiveMQ Classic
  2. AMQ-6904

custom sql statements for SqlServer

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 5.15.3
    • 5.15.11, 5.16.0
    • JDBC
    • None

    Description

      ms sql syntax is different, so we need custom statements

       

              <persistenceAdapter>
                  <jdbcPersistenceAdapter dataSource="#mssql-ds" createTablesOnStartup="true"   >
                    <statements>
                       <statements binaryDataType ="VARBINARY(MAX)" lockCreateStatement= "SELECT * FROM ACTIVEMQ_LOCK WITH (UPDLOCK, ROWLOCK) WHERE ID=1"/>
                    </statements>
                  </jdbcPersistenceAdapter>
              </persistenceAdapter>

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            jbonofre Jean-Baptiste Onofré
            chipitsine Ilya Shipitsin
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 10m
                10m

                Slack

                  Issue deployment