activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pieter van der Merwe" <pvand...@theenablergroup.com>
Subject Sql Server 2005 Configuration
Date Thu, 13 Jul 2006 19:57:05 GMT
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

 

 

 

 

 

 

 

 

 


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