ActiveMQ + SQL Server

["Gogineni, Venu (Home Office)" <go...@lls.org>]

Hi All,
 
I am having problems configuring the jdbcPersistence to use sql server
database. 
I am getting the following error when i tried to start the broker. 
 
ActiveMQ Message Broker (http://activemq.org/ <http://activemq.org/> )
 
Loading Message Broker from file: activemq.xml
14:22:48 INFO  JDK 1.4+ collections available
Caught: org.springframework.beans.factory.BeanCreationException: Error
creating
bean with name 'jdbcPersistence' defined in file
[C:\activemq\bin\activemq.xml]:
Can't resolve reference to bean 'mssqlserver-ds' while setting property
'dataSource';
nested exception is
org.springframework.beans.factory.NoSuchBeanDefinitionException: 
No bean named 'mssqlserver-ds' is defined:
org.activemq.spring.ActiveMQBeanFactory 
defining beans [memoryManager,broker]; root of BeanFactory hierarchy
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name
'jdbcPersistence' defined.
 
Here is the snippet of configuration i am using. Any idea what i am doing
wrong...
 
<persistence>        
        <jdbcPersistence dataSourceRef="mssqlserver-ds" />
</persistence>
 
 <bean id="mssqlserver-ds"
          class="org.apache.commons.dbcp.BasicDataSource" 
          destroy-method="close">
      <property name="driverClassName">
          <value>net.sourceforge.jtds.jdbc.Driver</value>
      </property>
      <property name="url">
          <value>url name....</value>
      </property>
      <property name="username">
          <value>user name....</value>
      </property>
      <property name="password">
          <value>password.....</value>
      </property>        
  </bean>
 
Thanks,
Venu.
NOTICE: This message, including all attachments transmitted with it, is for
the use of the addressee only. It may contain proprietary, confidential
and/or legally privileged information. No confidentiality or privilege is
waived or lost by any mistransmission. If you are not the intended
recipient, you must not, directly or indirectly, use, disclose, distribute,
print or copy any part of this message. If you believe you have received
this message in error, please delete it and all copies of it from your
system and notify the sender immediately by reply e-mail. Thank you.
REF#38293.51942 


______________________________________________________________________
This e-mail has been scanned by The Leukemia & Lymphoma Society Managed Email Content Service, provided by MCI and Message Labs.