Hi Alan, One other thing to note is that you will get a slight performance hit by using server based cursors, but for the moment this is the only way to get things to work with the MS JDBC driver. Other drivers like the one from http://www.inetsoftware.de/English/produkte/JDBC_Overview/default.htm do not have this problem and can support multiple statements per connection... unfortunately they are not free :-(
Glad that worked. Thanks for the input, Serge ----- Original Message ----- From: "Alan Gerhard" <[EMAIL PROTECTED]> To: "'James Users List'" <[EMAIL PROTECTED]> Sent: Wednesday, October 30, 2002 1:22 AM Subject: RE: MSSQL JDBC errors prevent it's usage ... > 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> > > -- To unsubscribe, e-mail: <mailto:james-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:james-user-help@;jakarta.apache.org>
