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 Kenny Smith <ke...@journalscape.com> on 2002/10/28 17:45:26 UTC
Multiple Recipient Aliases
Hi all,
I'm taking my next step toward full James functionality :)
I'm trying to setup multiple receipient aliases, like
support@journalscape.com -> kenny@journalscape.com
-> jenn@journalscape.com
So that an email to support will go to both kenny and jenn.
Does JDBCVirtualUserTable support that? Am I supposed to use a listserv?
Using a listserv seems overkill, I want anyone to be able to send a message
to the address.
Any help is appreciated,
Kenny Smith
JournalScape.com
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: Multiple Recipient Aliases
Posted by "Noel J. Bergman" <no...@devtech.com>.
> Is it ok (or even preferred) if I use an existing
> James Mailet as a skeleton?
Always a good idea. If you need it now, go for it. As I said, I'll be
adding more features later.
--- Noel
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: Multiple Recipient Aliases
Posted by Kenny Smith <ke...@journalscape.com>.
Hi Danny,
> I'm currently running a mailet which does this, IMO its a
> nice way to do this, aliases, mailing lists, forwarding
> are all controlled from a single web interface maintaining
> three tables, people, lists and list-people.
> do try to roll your own, its worth it.
>
> (and if its nice, submit it to James or www.mailet.org)
Not a bad idea, I'll give that a try. Is it ok (or even preferred) if I use
an existing James Mailet as a skeleton? Noel's JDBCVirtualUserTable is
probably already very close to what I need.
Kenny Smith
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: Multiple Recipient Aliases
Posted by Danny Angus <da...@apache.org>.
> Some of my users and have hundreds or thousands of email
> addresses in their
> lists. We are currently using the :include:/path/to/file functionality of
> sendmail. I'd love to create another table that has a one-to-many
> relationship with with virt user table, so we can associate an arbitrary
> number of emails with a list.
I'm currently running a mailet which does this, IMO its a nice way to do this, aliases, mailing lists, forwarding are all controlled from a single web interface maintaining three tables, people, lists and list-people.
Its a pretty ropey hack, so don't expect to see it in James, but do try to roll your own, its worth it.
(and if its nice, submit it to James or www.mailet.org)
d.
--
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>
MSSQL JDBC errors prevent it's usage ...
Posted by Alan Gerhard <al...@GerCom.Com>.
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: Multiple Recipient Aliases
Posted by "Noel J. Bergman" <no...@devtech.com>.
-----Original Message-----
From: Kenny Smith [mailto:kenny@journalscape.com]
Sent: Monday, October 28, 2002 14:22
To: James Users List
Subject: RE: Multiple Recipient Aliases
Hi Noel,
Thanks, I'll use your suggestion until the VirtualUserTable is upgraded.
> JDBCVirtualUserTable does not have that functionality at
> this time. I think it is mentioned in the comments as a
> future TODO, along with some other features from
> sendMail's virtual user table.
If I could, I don't know what you have planned, but a feature that I'd like
to have...
Some of my users and have hundreds or thousands of email addresses in their
lists. We are currently using the :include:/path/to/file functionality of
sendmail. I'd love to create another table that has a one-to-many
relationship with with virt user table, so we can associate an arbitrary
number of emails with a list.
Also, if there is anything I can do to help or facilitate the new code in
any way, just let me know. I'm fairly adept with Java, but super newbie when
it comes to James/Phoenix/Avalon.
Kenny Smith
JournalScape.com
--
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: Multiple Recipient Aliases
Posted by Kenny Smith <ke...@journalscape.com>.
Hi Noel,
Thanks, I'll use your suggestion until the VirtualUserTable is upgraded.
> JDBCVirtualUserTable does not have that functionality at
> this time. I think it is mentioned in the comments as a
> future TODO, along with some other features from
> sendMail's virtual user table.
If I could, I don't know what you have planned, but a feature that I'd like
to have...
Some of my users and have hundreds or thousands of email addresses in their
lists. We are currently using the :include:/path/to/file functionality of
sendmail. I'd love to create another table that has a one-to-many
relationship with with virt user table, so we can associate an arbitrary
number of emails with a list.
Also, if there is anything I can do to help or facilitate the new code in
any way, just let me know. I'm fairly adept with Java, but super newbie when
it comes to James/Phoenix/Avalon.
Kenny Smith
JournalScape.com
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: Multiple Recipient Aliases
Posted by "Noel J. Bergman" <no...@devtech.com>.
Kenny,
JDBCVirtualUserTable does not have that functionality at this time. I think
it is mentioned in the comments as a future TODO, along with some other
features from sendMail's virtual user table.
Try:
<mailet match="RecipientIs=support@journalscape.com" class="Redirect">
<recipients>kenny@journalscape.com,jenn@journalscape.com</recipients>
<prefix xml:space="preserve">[SUPPORT] </prefix>
<inline>unaltered</inline>
<static>true</static>
</mailet>
And see how that floats your boat.
Informationally, my current plan for JDBCVirtualUserTable is to subclass the
Redirect mailet, and pick up all of its cool features/options. It will
entail a table change (and some further enhancement/optimization to
Redirect), but it will be worth it. I will most likely make those changes
sometime between Thanksgiving and New Year's.
--- Noel
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>