help me pls!!!!!!!! i cant able to start Event sub system

SharpVenkat

i m using TS 6.5 win 2000 serer and i configured jmsconfignew.xml and included jdbc drivers in HKEY/JVM option 0.i get the following errors while start the eent subsystem...help me ASAP



OpenJMS 0.7.6.1
The OpenJMS Group. (C) 1999-2004. All rights reserved.
http://openjms.sourceforge.net
org.exolab.jms.server.ServerException: org.exolab.jms.persistence.PersistenceException: org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement from pool failed, cause:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.setupImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.prepareStatement(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.prepareStatement(Unknown Source)
at org.apache.commons.dbcp.PoolingConnection.makeObject(PoolingConnection.java:223)
at org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:792)
at org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:130)
at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:216)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:323)
at org.exolab.jms.persistence.RDBMSAdapter.initSchemaVersion(Unknown Source)
at org.exolab.jms.persistence.RDBMSAdapter.(Unknown Source)
at org.exolab.jms.persistence.DatabaseService.createRdbmsAdapter(Unknown Source)
at org.exolab.jms.persistence.DatabaseService.(Unknown Source)
at org.exolab.jms.persistence.DatabaseService.instance(Unknown Source)
at org.exolab.jms.server.JmsServer.registerServices(Unknown Source)
at org.exolab.jms.server.JmsServer.init(Unknown Source)
at org.exolab.jms.server.JmsServer.main(Unknown Source)

Migrateduser

Check the url property value for the RdbmsDatabaseConfiguration property in openJMSCOnfignew.xml.
url="jdbc:microsoft:sqlserver://localhost:1433;databaseName=DefaultDDL;selectMethod=cursor"

SelectMethod value of the cursor enables multiple active statements within a transaction determined by whether database cursors are used for Select statements.. The default is direct.