RE: Sql Server 2005 Configuration

[Ning Li]

I am using MS SQL2000, this is what I did.

<persistenceAdapter>
      <journaledJDBC journalLogFiles="5"
dataDirectory="../activemq-data" dataSource="#mssql-ds">
       <adapter><imageBasedJDBCAdaptor/></adapter>
      </journaledJDBC>
</persistenceAdapter>


  <bean id="mssql-ds" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
    <property name="driverClassName"
value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
    <property name="url" value="jdbc:microsoft:sqlserver://HOSTNAME
\\INSTANCE;DataBaseName=DBNAME"/>
    <property name="username" value="sa"/>
    <property name="password" value="password"/>
  </bean>

And it works.


-----Original Message-----
From: Pieter van der Merwe [mailto:[EMAIL PROTECTED] 
Sent: Thursday, July 13, 2006 12:57 PM
To: activemq-users@geronimo.apache.org
Subject: Sql Server 2005 Configuration

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