Hi, (So the info is in this thread too):
I've updated the wiki at: http://activemq.org/site/sqlserver.html to include information about the SQL Server 2005 Drivers. cheers, j. On 7/14/06, James Strachan <[EMAIL PROTECTED]> wrote:
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/
