Hi Gerhard, As I recall you need to append ";SelectMethod=cursor" to the end of your dburl to get this working.
so your dburl would look something like this: <dburl>jdbc:microsoft:sqlserver://gci-00:1433;SelectMethod=cursor</dburl> This problem is directly related to the MSSQL Type 4 JDBC driver and is a known issue. If you want some clarification as to why you need this please have a look through the MS SQL server news group. I hope it works. Serge ----- Original Message ----- From: "Alan Gerhard" <[EMAIL PROTECTED]> To: "'James Users List'" <[EMAIL PROTECTED]> Sent: Tuesday, October 29, 2002 5:37 AM Subject: MSSQL JDBC errors prevent it's usage ... > am having a problem with the MSSQL driver; can manage the repository okay > (remote admin) > though some idiosyncrasies in deleting users; > cannot send mail to the repository, we are throwing an error - could very well > be a driver setting i am missing. > > from config.xml > <data-source name="maildb" > class="org.apache.james.util.mordred.JdbcDataSource"> > <driver>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver> > <dburl>jdbc:microsoft:sqlserver://gci-00:1433</dburl> > <user>James</user> > <password>James</password> > <max>5</max> > </data-source> > > > (from console) > Phoenix 4.0a4 > > Application file:/D:/Java/James20A3/apps/james.sar uses a deprecated packaging > format. > James 2.0a3 > Started POP3 Server plain:110/gci-00.gercom.com/66.181.193.108 > Started SMTP Server plain:25/gci-00.gercom.com/66.181.193.108 > java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start > manual transaction mode because there are cloned connections. > at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown > Source) > at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) > at com.microsoft.jdbc.base.BaseConnection.setAutoCommit(Unknown Source) > at > org.apache.james.util.mordred.PoolConnEntry.setAutoCommit(PoolConnEntry.java :232 > ) > at > org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepository. java > :293) > at org.apache.james.James.storeMail(James.java:452) > at java.lang.reflect.Method.invoke(Native Method) > at > org.apache.avalon.phoenix.components.application.BlockInvocationHandler.invo ke(B > lockInvocationHandler.java:91) > at $Proxy9.storeMail(Unknown Source) > at > org.apache.james.transport.mailets.LocalDelivery.service(LocalDelivery.java: 34) > at > org.apache.james.transport.LinearProcessor.service(LinearProcessor.java:183) > at > org.apache.james.transport.JamesSpoolManager.process(JamesSpoolManager.java: 241) > at > org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.java:208) > at > org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Executabl eRun > nable.java:47) > at > org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread.java:8 6) > java.lang.RuntimeException: Exception caught while storing mail Container: > java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start > manual transaction mode because there are cloned connections. > at > org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepository. java > :422) > at org.apache.james.James.storeMail(James.java:452) > at java.lang.reflect.Method.invoke(Native Method) > at > org.apache.avalon.phoenix.components.application.BlockInvocationHandler.invo ke(B > lockInvocationHandler.java:91) > at $Proxy9.storeMail(Unknown Source) > at > org.apache.james.transport.mailets.LocalDelivery.service(LocalDelivery.java: 34) > at > org.apache.james.transport.LinearProcessor.service(LinearProcessor.java:183) > at > org.apache.james.transport.JamesSpoolManager.process(JamesSpoolManager.java: 241) > at > org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.java:208) > at > org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Executabl eRun > nable.java:47) > at > org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread.java:8 6) > > > system and what's being used ... > > James 20a3 > W2K > MSSQL2K > Dell PowerEdge 1300 1Gig RAM, 2 700mhz processors > > > -- > To unsubscribe, e-mail: <mailto:james-user-unsubscribe@;jakarta.apache.org> > For additional commands, e-mail: <mailto:james-user-help@;jakarta.apache.org> > > -- To unsubscribe, e-mail: <mailto:james-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:james-user-help@;jakarta.apache.org>
