Perfect - many thanks!
On 7/14/06, Jamie McCrindle <[EMAIL PROTECTED]> wrote:
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/
>
--
James
-------
http://radio.weblogs.com/0112098/
