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 08:07:44 GMT
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