Re: jdbc icc connection cache

On May 22, 8:34 pm, "news.verizon.net" <kenned...@xxxxxxxxxxx> wrote:
<kuassi.men...@xxxxxxxxx> wrote in message

news:eb45f9a5-352a-447c-b48e-91a394027397@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

On May 21, 2:20 pm, "jim. dot scuba dot kennedy at gee male dot com"
<jim.scuba.kenn...@xxxxxxxxx> wrote:
Does anyone have any experience using Oracle's JDBC ICC (implicit
connections cache) with RAC? We are on 10G. What I am looking for is
if anyone is using this and their overall experience. Good bad, etc.
Thanks,
Jim Kennedy

Hi,

I am the Oracle JDBC product manager, not a customer.
I don't have permission to give names but there are happy customers
using ICC with RAC as well as Fast Connection Failover and Runtime
Connection Load Balancing.
Fwiw, my blog entry
http://db360.blogspot.com/2007/01/is-your-java-application-failoverpr...,
gives a summary of how it works and how to enable it.

Kuassi
- bloghttp://db360.blogspot.com
- bookhttp://www.amazon.com/exec/obidos/ASIN/1555583296
-http://www.savedarfur.org/content

Thanks. If you know of any customers that would be willing to provide
feedback to me directly - I would not diseminate the information elsewhere -
please have them contact me. jimk at snapnames dot com. We have been
struggling with a non-rac related isse with the thin jdbc driver for a
couple of years on a known issue. (create a type in schema A, grant execute
on type to schema B. Create a synonym in schema B for the type defined in
schema A. The JDBC thin driver does not handle this case. It turns out the
11g jdbc driver finally does, but Oracle recommends not using it because of
a sever memory leak. Subsequently, we have had to write a lot of code to
get around this issue and the QA manager is gun shy with some Oracle
products. Which has lead me to my assignment to get some feedback from
other customers. (not to be made public, to be kept in confidence) The QA
manager wants to know if anyone actually uses this in production and wants
to get feed back from them.

I know I have rambled a bit. I have booked marked your site and am keeping
a copy of your reply for reference.
Thanks,
Jim Kennedy

Jim,

Will do.

There is no known memory leak with 11g JDBC-Thin; The recommendation
is to use full/complete schema name instead of synonym becoz it takes
a couple of round trips to get the complete information from the
server.

Kuassi
.

Relevant Pages

  • Re: jdbc icc connection cache
    ... I don't have permission to give names but there are happy customers ... using ICC with RAC as well as Fast Connection Failover and Runtime ... (create a type in schema A, ... 11g jdbc driver finally does, but Oracle recommends not using it because of ...
    (comp.databases.oracle.server)
  • Re: jdbc icc connection cache
    ... using ICC with RAC as well as Fast Connection Failover and Runtime ... (create a type in schema A, ... get around this issue and the QA manager is gun shy with some Oracle ... researching using the 11G jdbc thin driver he came across the doc. ...
    (comp.databases.oracle.server)
  • Re: jdbc icc connection cache
    ... using ICC with RAC as well as Fast Connection Failover and Runtime ... (create a type in schema A, ... get around this issue and the QA manager is gun shy with some Oracle ... researching using the 11G jdbc thin driver he came across the doc. ...
    (comp.databases.oracle.server)
  • RAC, the Listener and Weblogic
    ... We have a two node Oracle RAC cluster (10.2g on Linux), ... (SERVER = DEDICATED) ... Uneven distrabution of the connection arcoss the two rac nodes. ...
    (comp.databases.oracle.server)
  • EJB Gurus - switching between DB schemas
    ... connection, and lets the user form SQL queries that may involve multiple ... If this application were re-engineered as an stateful session bean, ... Provide a number of schema-specific DB connection descriptors, ... Provide one communal connection descriptor (without the schema), ...
    (comp.lang.java.help)