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>
