Uploaded image for project: 'JBoss Enterprise Application Platform 4 and 5'
  1. JBoss Enterprise Application Platform 4 and 5
  2. JBPAPP-3901

JBoss Messaging does not work with MS SQL Server 2005/2008 with MS JDBC driver 2.0 in default JDBC configuration

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • TBD
    • EAP 5.0.1.CR1
    • Messaging
    • None
    • Workaround Exists
    • Hide

      Use parameter responseBuffering to the JDBC connection URL. Default mode is "full" for the JDBC Driver version 1.2 and "adaptive" for version 2.0.

      JDBC connection URL:
      <url>jdbc:sqlserver://[host];database=[database];responseBuffering=full;</url>

      Show
      Use parameter responseBuffering to the JDBC connection URL. Default mode is "full" for the JDBC Driver version 1.2 and "adaptive" for version 2.0. JDBC connection URL: <url>jdbc:sqlserver:// [host] ;database= [database] ;responseBuffering=full;</url>

      Combination Microsoft SQL server 2005/2008 with Microsoft JDBC drivers 2.0 causes unstable builds in JBM testsuite.

      Description:
      Problem is caused by JDBC's Adaptive buffering which is default buffering mode in the MS JDBC version 2.0 (in previous version of JDBC was ,,full buffering mode").
      Column can be accessed by the getXXXStream only once in the Adaptive buffering mode. The second attempt causes exception.
      Please see http://msdn.microsoft.com/en-us/library/bb879937.aspx

      This problem has been already fixed by Howard (see JBMESSAGING-1767) and fix will be available in JBM 1.4.7.GA, JBM 1.4.6.GA.SP1. EAP 5.0.1 CR1 contains JBM 1.4.6.GA.

              pslavice@redhat.com Pavel Slavicek
              pslavice@redhat.com Pavel Slavicek
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: