activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jamie McCrindle" <jamiemccrin...@gmail.com>
Subject Re: Sql Server 2005 Configuration
Date Fri, 14 Jul 2006 13:18:08 GMT
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/
>

Mime
View raw message