We are aware of the max open cursors problem. That will be fixed
before the final release. We cache PreparedStatements, and we need to
have some configurable maximum size to avoid keeping so many open that we
see errors like this.
Are you aware that you can use Minerva outside jBoss? It is not
dependent on jBoss in any way, and that may make your task easier. If you
still want to manage connection rollback/commit manually, you should use
the JDBCDataSourceLoader instead of the XADataSourceLoader, and that will
leave out all the transaction and two-phase-commit stuff that you should
not interact with. In fact, the XADataSourceLoader will probably change
between now and the final release to throw an exception if you call commit
or rollback manually.
If you need help configuring this, let me know. It is quite
similar to XADataSourceLoader, but not identical.
Finally, I'm not sure what could be causing the memory leak you
report (if it is more significant than the size of the extra
PreparedStatement objects). We will need to investigate that.
Aaron
On Wed, 4 Oct 2000, Tilmann Ludwig wrote:
> I'm having a problem with Connections managed on connection basis and the
> Minerva ConnectionPool.
> I'm using the Minerva Connevtion Pool with a Oracle DB using the Oracle Thin
> Driver and the latest
> JBoss 2.0 binary.
> I want to use my classes, which are doing the DB'calls, also outside JBOSS
> with a Connection Pool manager
> written by our own so i'm doing the transaction mangement on a Connection
> basis with con.commit() and con.close()
> although the Connection itself is managed by the Minerva Connection Pool.
> In this scenario, the memory consumption of JBOSS is getting higher and
> higher doing our stress test and after a while i'm getting an exception from
> the Oracle Database (maximum open cursor exceeded). The same beans in a
> weblogic 5.1 are working
> perfectly and the memory consumption is almost constant so i think my source
> is o.k.
> Is it possible, that JBOSS 2.0 is having a problem with this Scenario,
> propably not releasing some resources?
>
> Any help is appreciated
>
>
> Tilmann Ludwig
> [EMAIL PROTECTED]
>
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
>
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
