activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Strachan" <james.strac...@gmail.com>
Subject Re: Sql Server 2005 Configuration
Date Fri, 14 Jul 2006 13:30:21 GMT
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/

Mime
View raw message