RE: Active connection

2006-10-25 Thread Anthony
That ping query, specifically the "DUAL" part, is strictly for Oracle only Use an SQL92 standard query. This will work on Oracle, MS-SQL, and newer versions of MySQL as well. Of course if you have hundreds of tables, this query will lose performance. In that case you may need to derive a more effi

Re: Active connection

2006-10-25 Thread Larry Meadors
You'll need to use a ping query to make sure that the connection is valid. Something like this: http://www.mail-archive.com/ibatis-user-java@incubator.apache.org/msg02651.html Larry On 10/25/06, Dorin Manoli <[EMAIL PROTECTED]> wrote: Hi ALL! I'm wondering if is there any way to see if a

RE : Re: distributed cahing/iBATIS.Net

2006-10-25 Thread Tite Etoundi
Hi all,   about caching in iBATIS, I've downloaded memcacheddonet library and I've find how someone can write an ICacheController as Ron's last post hereafter. But, my question is how can I, after writing MemcachedCacheController as Ron did, make iBATIS uses this controller instead of the default

Active connection

2006-10-25 Thread Dorin Manoli
Hi ALL! I’m wondering if is there any way to see if a connection is active or not (didn’t found in docs), because I got exceptions when I loose DB connection and have to reconnect. Need a nice way to do that, not catching exceptions.