You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-user@james.apache.org by Serge Sozonoff <se...@globalbeach.com> on 2002/11/01 09:35:10 UTC
Re: MSSQL JDBC errors prevent it's usage ...
Hi Noel,
OK, I will do this.
Serge
----- Original Message -----
From: "Noel J. Bergman" <no...@devtech.com>
To: "James Users List" <ja...@jakarta.apache.org>
Sent: Thursday, October 31, 2002 10:59 PM
Subject: RE: MSSQL JDBC errors prevent it's usage ...
> Serge,
>
> Looks good to me. :-) Thank you very much. The only thing more that you
> could have done would have been to take the actual HTML page, updated it,
> and submit a patch as described in the how to contribute part of the James
> site.
>
> --- Noel
>
> -----Original Message-----
> From: Serge Sozonoff [mailto:serge@globalbeach.com]
> Sent: Thursday, October 31, 2002 16:37
> To: James Users List
> Subject: Re: MSSQL JDBC errors prevent it's usage ...
>
>
> Hi Noel,
>
> Is this what you had in mind ?
>
> Q. I am using a Microsoft SQL Server as my database server along with
> Microsoft's Type 4 JDBC Driver, why do I get the following exception?
> java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
> JDBC]Can't start
> manual transaction mode because there are cloned connections.
>
> A. This seems to be a problem with the Microsoft Type 4 JDBC Driver and
> concurrent
> statements/transactions/resultsets on the same database conntection. To
> solve this you need to
> add ;SelectMethod=cursor to the end of your dburl string. Your dburl
> string
> would then look something like this
>
>
<dburl>jdbc:microsoft:sqlserver://dvserver.host.name:1433;SelectMethod=curso
> r</dburl>
> NOTE. some people have complained about performance when using the
> option, the alternative
> is a 3rd party JDBC driver but these are often not free.
>
> Serge
>
> ----- Original Message -----
> From: "Noel J. Bergman" <no...@devtech.com>
> To: "James Users List" <ja...@jakarta.apache.org>
> 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; alan.gerhard@GerCom.Com
> > 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" <al...@GerCom.Com>
> > To: "'James Users List'" <ja...@jakarta.apache.org>
> > 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:
> > <ma...@jakarta.apache.org>
> > > For additional commands, e-mail:
> > <ma...@jakarta.apache.org>
> > >
> > >
> >
> >
> > --
> > To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> <ma...@jakarta.apache.org>
> >
> >
> > --
> > To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> <ma...@jakarta.apache.org>
> >
> >
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>