5 Replies Latest reply on Sep 30, 2003 4:26 AM by adrian.brock

    JBoss 3.2.1 + SQL Server 2K + JMS

    mattygiedt

      I have SQL Server running on JBoss using the jdbc2 PersistenceManager. The important points are:

      use BLOB_TYPE=BINARYSTREAM_BLOB
      use MESSAGEBLOB IMAGE, for the CREATE_MESSAGE_TABLE property
      do not use an XA data source for the ConnectionManager

      I have posted a working copy of my jbossmq-service.xml

      Note that this does not start any InvocationLayers other than the JVM, and does not enable Tracing or Security.

      -Matt