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 Alan Gerhard <al...@GerCom.Com> on 2002/10/29 05:37:53 UTC
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.invoke(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(ExecutableRun
nable.java:47)
at
org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread.java:86)
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.invoke(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(ExecutableRun
nable.java:47)
at
org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread.java:86)
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>
Re: MSSQL JDBC errors prevent it's usage ...
Posted by Serge Sozonoff <se...@globalbeach.com>.
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" <al...@GerCom.Com>
To: "'James Users List'" <ja...@jakarta.apache.org>
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" <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>
RE: MSSQL JDBC errors prevent it's usage ...
Posted by Alan Gerhard <al...@GerCom.Com>.
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" <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>
Re: MSSQL JDBC errors prevent it's usage ...
Posted by Serge Sozonoff <se...@globalbeach.com>.
Hi Noel,
Sure, I will just wait confirmation from Alan that this did solve his
problem.
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>
Re: MSSQL JDBC errors prevent it's usage ...
Posted by Serge Sozonoff <se...@globalbeach.com>.
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>
RE: [PATCH] Added MSSQL JDBC driver FAQ item
Posted by "Noel J. Bergman" <no...@devtech.com>.
Serge,
Thanks. :-) Actually I gave you a false direction. The file that we
actually update is src/xdocs/FAQ.xml, from which we generate the HTML page.
But I've done the merge. Thanks!
--- Noel
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
[PATCH] Added MSSQL JDBC driver FAQ item
Posted by Serge Sozonoff <se...@globalbeach.com>.
Solves this exception when using an MS SQL db server and the MS Type 4 JDBC
driver
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't
start
manual transaction mode because there are cloned connections.
Serge
RE: MSSQL JDBC errors prevent it's usage ...
Posted by "Noel J. Bergman" <no...@devtech.com>.
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>
Re: MSSQL JDBC errors prevent it's usage ...
Posted by Serge Sozonoff <se...@globalbeach.com>.
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>
RE: MSSQL JDBC errors prevent it's usage ...
Posted by "Noel J. Bergman" <no...@devtech.com>.
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>
Re: MSSQL JDBC errors prevent it's usage ...
Posted by Serge Sozonoff <se...@globalbeach.com>.
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>