Perfect - many thanks!
On 7/14/06, Jamie McCrindle <jamiemccrindle@gmail.com> 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 <james.strachan@gmail.com> wrote:
> > Great thanks - I've added this example to the wiki...
> >
> > http://activemq.org/site/sqlserver.html
> >
> > On 7/13/06, Ning Li <Ning.Li@businessobjects.com> 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:pvanderm@theenablergroup.com]
> > > 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
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
> > --
> >
> > James
> > -------
> > http://radio.weblogs.com/0112098/
> >
>
--
James
-------
http://radio.weblogs.com/0112098/
|