activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ning Li" <>
Subject RE: Sql Server 2005 Configuration
Date Thu, 13 Jul 2006 22:34:29 GMT
I am using MS SQL2000, this is what I did.

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

  <bean id="mssql-ds" class="org.apache.commons.dbcp.BasicDataSource"
    <property name="driverClassName"
    <property name="url" value="jdbc:microsoft:sqlserver://HOSTNAME
    <property name="username" value="sa"/>
    <property name="password" value="password"/>

And it works.

-----Original Message-----
From: Pieter van der Merwe [] 
Sent: Thursday, July 13, 2006 12:57 PM
Subject: Sql Server 2005 Configuration

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


I have the following configuration:



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


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







<!-- Microsoft Sql Server DataSource -->

  <bean id="mssql-ds"

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

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

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



When ActiveMQ starts the following warning appears:


WARN  JDBCPersistenceAdapter         - Database driver NOT recognized:

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










View raw message