Great thanks - I've added this example to the wiki...
http://activemq.org/site/sqlserver.html
On 7/13/06, Ning Li <[EMAIL PROTECTED]> wrote:
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: [email protected]
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
--
James
-------
http://radio.weblogs.com/0112098/
