This content has been marked as final. Show 10 replies
I'm not a Java person so I could be (way) off base here.
Anyway, I found this sample:
which looks to be using database resident connection pooling and jdbc.
As noted in the above link, that technique is an extension of Arup's article here:
Perhaps something in there will be helpful.
Hi Mark, thanks for the help. I actually wound up opening a TAR and just got word Tuesday that the proper OCI hooks aren't exposed through the JDBC driver to take advantage of DRCP. The example you showed was one that I had looked at as well. It is true, as this example shows, that you can connect, but it effectively works like a regular connection with out connection pooling since the network connection to the server to closed each time you close the database connection.
I was afraid of something like that. Well, anyway, at least you have a more definitive answer as to the current situation.
I am trying the same usecase - DRCP and OCI JDBC driver. From the V$CPOOL_STATS view I could see even after DRCP in enabled it behaves as a dedicated server. The value in NUM_MISSES column is the same as the number of connection requests made.
The OCI JDBC driver version I am using is 18.104.22.168.0. I could not find any oracle documentation link which would mention that the JDBC OCI driver does not support this (even if OCI supports. I was looking for a link just be sure that I am not missing anything in the configuration).
Thanks in advance.
The JDBC driver has not yet fully exposed the DRCP functionality.
Hi, please see the 11g New Features guide, which mentions the addition of DRCP feature and the Oracle drivers which can be used to leverage this feature. (OCI & OCCI)
Open source drivers like PHP, Perl, Python also have exposed this feature. Oracle JDBC driver is yet to expose this fully. Using a JDBC client, and the connect string with (SERVER=POOLED), you can connect to a DRCP pooled server, but you do not have interfaces to share and reuse the pooled servers across multiple clients.
Ok. Do you mean that since DRCP is a new feature introduced in 11g, Oracle JDBC Driver would take sometime to add a support for this functionality and hence there is no bug or issue logged to track this? I was just looking for some link that officially stated that currently Oracle JDBC Driver does not support this or some link which atleast stated that it would be supported in future version of the driver.
Edited by: table1 on Apr 5, 2011 7:34 PM
That's right. It will be documented when JDBC exposes it.
Sorry for the late addition to this thread, which answered my question.
I checked on MOS for an official statement and I came up with this.
Thanks for the answer.