Re: Monitoring DB cursor leaks

2006-10-10 Thread Bruno CROS
Hi, Here is my connector, Oracle9i yet... May be i have to set the jdbc-level at 3.0 ? Referring to this article, it seems that it is a hard to resolve trouble. http://www.orafaq.com/node/758 Except looking into code, how to check real cursors leak (if they are)? Regards

Re: Monitoring DB cursor leaks

2006-10-10 Thread Bruno CROS
http://oracleandy.blogspot.com/2006/03/vopencursor-find-cursors-that-are.html Perhaps i found something to detect bad code, but i don't known how to set the session parameter in OJB connections. The equivalent of : alter session set _close_cached_open_cursors = TRUE Did someone already do ?

RE: Monitoring DB cursor leaks

2006-10-10 Thread Charles Anthony
Hi, You could write your own ConnectionFactory http://db.apache.org/ojb/docu/guides/connection.html And execute the appropriate statement in the lookup method. E.g. public class MyConnectionManager extends ConnectionFactoryDBCPImpl { public Connection

Cassio Dos Santos is out of the office

2006-10-10 Thread Cassio Dos Santos
I will be out of the office starting 10/10/2006 and will not return until 10/23/2006. Please contact Kevin Shank or Amy Wong for any emergency. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail:

Re: Specific sequence implementation for a table

2006-10-10 Thread Armin Waibel
Hi Ozkan, zkn wrote: Hi, I use the SequenceManagerMySQLImpl for my application. But for only one table/object I want to use the SequenceManagerInMemoryImpl. Is that possible? Currently this is not supported by default. You have to implement your own SequenceManager to handle this (e.g. a

Re: Problems generating sql with the SqlGenerator

2006-10-10 Thread Armin Waibel
Hi Josef, could you clarify your problem: The generated sql is only invalid when you add your extension or is the generated sql invalid in general? regards, Armin Josef Wagner wrote: Hi List, i have written my one SqlGenerator, because i have to extend each query width the criteria, that

Re: Problems generating sql with the SqlGenerator

2006-10-10 Thread Josef Wagner
Hi Armin, yes, I have the problem only when adding my extension. Generally, all works fine. We have tried a other solution like this: - public String getPreparedSelectStatement(Query query, ClassDescriptor cld) { try { if