The problem is Iam using Oracle database to store emails. When iam using outlook
express to receive mails, James is opening an connection with Oracle and it is not
closing. So each and every time when it opens a connections the no. of opened
connection with oracle increases and at one stage, it reaching its limit, ie iam
getting the following message in mailstore lgo
1038125899342 [INFO ] (mailstore): added repository: db://maildb/inbox/xx
/MAIL->org.apache.james.mailrepository.JDBCMailRepository
1038129521019 [ERROR ] (mailstore): Error retrieving pending messages
java.sql.SQLException: ORA-01000: maximum open cursors exceeded
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oopen.receive(Oopen.java:118)
at oracle.jdbc.ttc7.TTC7Protocol.open(TTC7Protocol.java:472)
at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:492
at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:511
at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedSt
ment.java:209)
1038129521229 [ERROR ] (mailstore): Error retrieving pending messages
java.sql.SQLException: ORA-01000: maximum open cursors exceeded
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedSt
ment.java:209)
java.sql.SQLException: ORA-01000: maximum open cursors exceeded
java.sql.SQLException: ORA-01000: maximum open
cursors exceeded
at
oracle.jdbc.driver.OraclePreparedStatement.<init>(O79,2-9reparedSt
ment.java:209)
I need to solve this problem?
Thanks
"Noel J. Bergman" <[EMAIL PROTECTED]> wrote: Christie,
> I have downloaded the latest version and get the same problem.
Which problem? Running out of cursors with Oracle? How quickly? What do
you seem happening? If you want to build James, you need to download from
the CVS. JDBC goes through org.apache.james.util.mordred.JdbcDataSource.
The last time I saw that reported was sometime last summer, and I was pretty
sure that it was fixed and reported by the user as fixed, so I'm wondering
about the details of what you are encountering.
--- Noel
--
To unsubscribe, e-mail:
For additional commands, e-mail:
---------------------------------
With Yahoo! Mail you can get a bigger mailbox -- choose a size that fits your needs
