Sql Server 2005 Configuration

[Pieter van der Merwe <pv...@theenablergroup.com>]

Does anyone have an example using Microsoft Sql Server for persistence?

 

I have the following configuration:

 

    <persistenceAdapter>

            <journaledJDBC journalLogFiles="5"
dataDirectory="../activemq-data" dataSource="#mssql-ds"
useJournal="false">

                  <statements>

                        <statements binaryDataType="varbinary(max)"/>

                  </statements>

            </journaledJDBC>

    </persistenceAdapter>

 

And

 

<!-- Microsoft Sql Server DataSource -->

  <bean id="mssql-ds"
class="com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource">

      <property name="URL" value="jdbc:sqlserver://localhost:1433"/>

        <property name="databaseName" value="BUZMessaging"/>

    <property name="integratedSecurity" value="true"/>

  </bean>

 

When ActiveMQ starts the following warning appears:

 

WARN  JDBCPersistenceAdapter         - Database driver NOT recognized:
[microsof

t_sql_server_2005_jdbc_driver].  Will use default JDBC implementation.

 

Does this mean that the Sql Server 2005 JDBC Driver is even being used?

 

If not how do I configure the mssql-ds bean?

 

Thanks in Advance