Serge - Thanks, that was the problem.
The htmlDoc supplied with the driver touches on this, the use of SelectMethod. The syntax is as you mentioned, namely <dburl>jdbc:microsoft:sqlserver://gci-00:1433;SelectMethod=cursor</dburl> If you are putting together a guide to using JDBC with James, I would like to mention that the ODBC bridge does not work - a shame but understandable. In fact, let me put together a list if questions I had when trying to setup the JDBC vs. the File based system... Alan -----Original Message----- From: Serge Sozonoff [mailto:serge@;globalbeach.com] Sent: Tuesday, October 29, 2002 4:44 PM To: James Users List Subject: Re: MSSQL JDBC errors prevent it's usage ... Hi Noel, Sure, I will just wait confirmation from Alan that this did solve his problem. Serge ----- Original Message ----- From: "Noel J. Bergman" <[EMAIL PROTECTED]> To: "James Users List" <[EMAIL PROTECTED]> Sent: Tuesday, October 29, 2002 10:41 PM Subject: RE: MSSQL JDBC errors prevent it's usage ... > Serge, > > Could you write this up as a little FAQ item for James JDBC support? > > --- Noel > > -----Original Message----- > From: Serge Sozonoff [mailto:serge@;globalbeach.com] > Sent: Tuesday, October 29, 2002 3:54 > To: James Users List; [EMAIL PROTECTED] > Subject: Re: MSSQL JDBC errors prevent it's usage ... > > > 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> > > > -- > 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> -- To unsubscribe, e-mail: <mailto:james-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:james-user-help@;jakarta.apache.org>
