TomcatExpert

Retrieving Inner Oracle Connections

posted by SpringSource on May 21, 2010 01:11 PM

Using DBCP or the connection pooling built into the Oracle JDBC driver implementation.

You should just be able to cast to the DBCP specific Connection class and from there retrieve the inner Oracle connection:

import org.apache.commons.dbcp.DelegatingConnection;
 
DelegatingConnection dc = (DelegatingConnection)conn;
OracleConnection oc = (OracleConnection)pc.getInnermostDelegate();

Note: If you are using Tomcat's built-in copy of DBCP then the import you will need is:

import org.apache.tomcat.dbcp.dbcp.DelegatingConnection;

Or you can use the connection pooling built into the Oracle JDBC driver implementation. This returns an Oracle connection. A simple setup would be:

<Resource auth="Container"
          connectionCacheName="CXCACHE"
          connectionCacheProperties="{MaxStatementsLimit=5,MinLimit=1, MaxLimit=1, ValidateConnection=true}"
          connectionCachingEnabled="true"
          description="Oracle Datasource"
          factory="oracle.jdbc.pool.OracleDataSourceFactory"
          name="jdbc/TestDB"
          user="default_user" 
          password="password"
          type="oracle.jdbc.pool.OracleDataSource"
          url="jdbc:oracle:thin:@//localhost:1521/orcl"
          />

For more than 10 years, SpringSource employees have been supporting Apache technologies, with unparalleled experience and commitment to the Apache Software Foundation. More than 400 of the Fortune 500 count on SpringSource to support their mission-critical business applications. Leaders of the Apache Software Foundation, including Board Members, work at SpringSource and dedicate a significant amount of time further developing the Apache Tomcat open source project. Over the last 2 years, 95% of the issues fixed in the Apache Tomcat project were fixed by SpringSource engineers. For more information on how SpringSource can help your enterprise, see the SpringSource website, or call 800/444-1935.

Comments

RE:

Post very nicely written, and it contains useful facts. I am happy to find your distinguished way of writing the post.

Best essay writing service

I like to recommend

I like to recommend exclusively fine plus efficient information and facts, hence notice it: หารายได้เสริม

I really enjoy simply reading

I really enjoy simply reading all of your weblogs. Simply wanted to inform you that you have people like me who appreciate your work. Definitely a great post. Hats off to you! The information that you have provided is very helpful. www.onlinecheats4u.com

For many people this is the

For many people this is the best solution here see how to do it. Folding Solar Panels

This is very appealing,

This is very appealing, however , it is very important that will mouse click on the connection: situs poker online

good posts

Be sure to keep going the terrific job together with That i will enjoy even more to your impressive articles..!
Self Assessment Tax Return

good posts

Be sure to keep going the terrific job together with That i will enjoy even more to your impressive articles.
Accountants East Grinstead

instagram online

I’m impressed with the special and informative contents that you just offer in such short timing instagram online

great news

Wow! This could be one particular of the most helpful blogs We’ve ever arrive across on this subject. Basically Excellent. I’m also an expert in this topic therefore I can understand your effort.
voyance en direct

I really wanted to send a

I really wanted to send a small word to say thanks to you for the fantastic points you are writing on this site. Plumbing repair

I wanted to thank you for

I wanted to thank you for this great read!! I definitely enjoying every little bit of it I have you bookmarked to check out new stuff you post. pressure washing pasco

This is an excellent post I

This is an excellent post I seen thanks to share it. It is really what I wanted to see hope in future you will continue for sharing such a excellent post. air condition company

Thanks for the post. I

Thanks for the post. I appreciate the info on blog comments and will surely start looking out for people who are using automated programmes for making blog comment posts.

lanai screen

I am very happy to read this.

I am very happy to read this. This blog was really an awesome site which I had never found it anywhere, keep post.Family Law

You will find a lot of

You will find a lot of approaches after visiting your post. I was exactly searching for. Thanks for such post and please keep it up. Great work.Deep Tissue Massage

Thanks a lot completely with

Thanks a lot completely with regard to creating such an intriguing article about this theme. This has truly made me personally believe in addition to Lets hope to see much more.. Digital marketing group

Excellent article. Very

Excellent article. Very interesting to read. I really love to read such a nice article. Thanks! keep rocking. Offer In Compromise Lawyer

Great post! I am actually

Great post! I am actually getting ready to across this information, is very helpful my friend. Also great blog here with all of the valuable information you have. Keep up the good work you are doing here. Home Builders Tampa

Thanks for the tips guys.

Thanks for the tips guys. They were all great. I have been having issues with being fat both mentally and physically. Thanks to you guys i have been showing improvements. Do post more. Chiropractor Tampa

I was surfing net and

I was surfing net and fortunately came across this site and found very interesting stuff here. Its really fun to read. Custom Motorcycle Insurance

I just stumbled upon your

I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts.
kleider kaufen topmediamarkt

instagram online

Here at this site really the fastidious material collection so that everybody can enjoy a lot instagram online

This is a wonderful article,

This is a wonderful article, Given so much info in it, These type of articles keeps the users interest in the website, and keep on sharing more ..wordpress designer india

Thanks for your post! it is

Thanks for your post! it is helpful to those who are always looking for new ones like us! home air conditioner repair

youtube-mp3.org

A very awing web log post. We have a tendency to be very grateful for your web log post. you’ll notice plenty of approaches when visiting your post youtube-mp3.org

wow what a great post is

wow what a great post is this... thanks for sharing boss, keep share these valuable content. home inspection

Injustice 2 Free Gold

Yes, great US Military force. Also, in his post you have given a chance to listen about US Military. I really appreciate your work. Thanks for sharing it. Injustice 2 Free Gold

eliza

We are really grateful for your blog post. You will find a lot of approaches after visiting your post. Great work Instagram uploader

Sometime the user of iTunes

Sometime the user of iTunes try to get some iTunes gift card code to avoid incovenience that they may be having when listening to their saved playlist at itunes.

It was a decent post in

It was a decent post in reality. I altogether delighted in understanding it in my lunch time. Will without a doubt come and visit this blog all the more frequently. A debt of gratitude is in order for sharing. garcinia cambogia does it work

xfdtsrh

Thanks for showing this awesome post APP download and click and click and click and click and click

Really i appreciate the

Really i appreciate the effort you made to share the knowledge. This is really a great stuff for sharing. Keep it up . Thanks for sharing. voyance par telephone

http://supplementsaid.com/kou-tea-review

I'm grateful I found this website, I could not find any information on this issue prior to.Also function a website and if you are ever fascinated in doing some guest composing for me if possible you can let me know, im always look for people to check out my website. http://supplementsaid.com/kou-tea-review

Retrieving Inner Oracle Connections

We are retrieving inner oracle connections with great tips for tom cat experts. So we can easily understood the urgent custom essays articles from the website. That's really amazing to everyone of this blog, and thank you.

Jual Laptop Notebook PC HP Lenovo Printer Tinta Toner Epson Mura

Which will feature short-term, still it’s not just a effective long-term alternative designed for men of all ages who wish to result in being this particular 1 completely unique lover these consumers can’t finish entertaining the idea of. jual HP Spectre

David

Swiftly this web site can unquestionably become popular between almost all blogging and site-building folks, due to its meticulous posts or perhaps critiques. http://sgseo.co/financial-advisor-seo/

David

buy twitter accounts I just genuinely gain knowledge of yuor web blog for the purpose of working assessments in addition to I just genuinely at present get to look that is why invited. I just genuinely were to choose from a job to try a for a wonderful craft creating business enterprise in addition to Images staying away from these products. It could be at present, with mind-set you probably talented families, Let me test it. get more plays on soundcloud

You have shared a very

You have shared a very informative blog about retrieving the oracle inner connections. It is really very helpful for me. This site always shares very important topics like this. I also understood about Oracle JDBC driver implementation. Keep updating blogs. zip line brake

jhon

Great tips and very easy to understand. This will definitely be very useful for me when I get a chance to start my blog. Divorce law tax attorney

DSASDASD

jimmy choozxx1A
the north face outlet
red valentino
michael kors
louis vuitton sacs
cheap jordan shoes
rolex replica watches
michael kors handbags outlet
ed hardy
jordan shoes
cheap jordans
nike blazer
ralph lauren pas cher
adidas nmd
gucci borse
fitflops shoes
nike outlet store
michael kors handbags online
nike free 5
nike roshe
converse trainers
true religion jeans sale
adidas nmd
omega watches for sale
michael kors handbags wholesale
michael kors handbags
cheap basketball shoes
longchamps
michael kors outlet
michael kors handbags wholesale
cheap nfl jerseys wholesale
instyler max 2
nike huarache trainers
ed hardy outlet
pandora charms
michael kors handbags sale
tiffany and co outlet
lebron shoes
longchamp le pliage
skechers outlet
lebron james shoes
abercrombie and fitch
michael kors handbags
michael kors handbags
michael kors handbags
nike store uk
asics shoes
pandora jewelry
michael kors handbags
nike huarache
cheap mlb jerseys
cheap ray ban sunglasses
cheap nhl jerseys
jimmy choo shoes
nike store
michael kors outlet store
nike tn
michael kors outlet
michael kors outlet
toms shoes
cheap nike shoes
michael kors handbags
michael kors outlet
yeezy boost 350 black
michael kors handbags
michael kors handbags
polo ralph lauren
toms outlet
sac longchamp
fitflops sale clearance
michael kors uk
mlb jerseys
kobe 9
michael kors uk
nike air max 90
christian louboutin outlet
cheap michael kors handbags
nike blazer pas cher
cheap michael kors handbags
saics running shoes
ecco shoes outlet
ralph lauren outlet online
michael kors handbags
nike outlet
nike trainers uk
ghd hair straighteners
new balance outlet
hugo boss outlet
supra shoes
nba jerseys
nike air huarache
ralph lauren outlet
polo ralph lauren outlet
nike blazer low
michael kors outlet store
nike trainers uk
hugo boss sale
armani exchange
fitflops
air jordan uk
cheap jordans
michael kors handbags
tiffany and co
supra shoes sale
michael kors handbags
dolce and gabbana
cheap nike shoes sale
new balance shoes
nike air force 1
michael kors handbags wholesale
omega watches
nike trainers
gucci sito ufficiale
michael kors outlet online
salomon boots
armani exchange outlet
michael kors handbags
yeezy boost 350
christian louboutin shoes
nike huarache
instyler max
nike tn pas cher
valentino shoes
nike trainers
ed hardy clothing
under armour outlet
michael kors handbags
fitflops sale clearance
nike free
michael kors handbags
michael kors handbags
cheap oakley sunglasses
oakley sunglasses
salomon shoes
cheap oakley sunglasses
oakley sunglasses
ghd flat iron
michael kors handbags
the north face
chaussure louboutin
cheap oakley sunglasses
michael kors handbags
pandora outlet
michael kors handbags
salvatore ferragamo
moncler outlet
converse shoes
nike blazer pas cher
true religion jeans
adidas nmd r1
louis vuitton pas cher
ray ban sunglasses
jordan shoes
mont blanc pens
michael kors handbags wholesale
replica watches
ecco shoes
ralph lauren
ray ban sunglasses
michael kors handbags outlet
abercrombie and fitch kids
michael kors handbags clearance
cheap ray bans
longchamp bags
oakley sunglasses
versace
ed hardy uk
pandora jewelry
mont blanc pens outlet
cheap nfl jerseys
michael kors outlet
dolce and gabbana shoes
basketball shoes
nike huarache
michael kors outlet
nike air huarache
michael kors outlet
versace shoes
air force 1 shoes
cheap michael kors handbags
michael kors handbags outlet
michael kors outlet
cheap nba jerseys
under armour shoes
ferragamo shoes
adidas nmd runner
michael kors handbags
nike blazer
reebok shoes
michael kors handbags wholesale
skechers shoes
chaussure louboutin pas cher
dolce and gabbana outlet
michael kors handbags
michael kors outlet online
cheap michael kors handbags
birkenstock sandals
air max 90
michael kors outlet clearance
birkenstocks
nike roshe run
yeezy boost 350 white
reebok outlet
moncler jackets
michael kors handbags sale
kobe 9 elite
nhl jerseys
michael kors handbags
michael kors outlet

work

Great post however , I was wanting to know if you could write a litte more on this subject? I’d be very thankful if you could elaborate a little bit further. Bless you!
Real Musically Followers, like and fans for free

cleaning services in dubai

To start with there is another thing you must learn when you happen to be cleaning concrete that is certainly that tangible cannot be restored for you to its virgin mobile state after many experts have stained. You could always find stains brighter or bleached nevertheless completely removing it is rather difficult. So when actually talking to a buyer explain this for many years otherwise they shall be asking for the job that cannot be accomplished unless your entire concrete piece is attractive up along with re-poured. cleaning services in dubai

XENDER FOR PC

great post
Very good for file and picture share To PC To any Phone
NICE ARTICLE THANKS FOR SHARING
xender for pc

XENDER FOR PC

Great post
Very good for file and picture share To PC To any Phone
NICE ARTICLE THANKS FOR SHARING
xender for pc

Moving into an apartment may

Moving into an apartment may look like a deal from which you get something small at the cost of something substantial. Nevertheless, this small gain has some amazing benefits.best insulation contractors edmonton

Great post full of useful

Great post full of useful tips! My site is fairly new and I am also having a hard time getting my readers to leave comments. bluetooth hoverboard

We are really grateful for

We are really grateful for your blog post. You will find a lot of approaches after visiting your post. Great work. best router for wifi

This content is written very

This content is written very well. Your use of formatting when making your points makes your observations very clear and easy to understand.
pendulum friction test

Truly, this article is really

Truly, this article is really one of the very best in the history of articles. I am a antique ’Article’ collector and I sometimes read some new articles if I find them interesting. And I found this one pretty fascinating and it should go into my collection. Very good work! تركيبات

Thank you for your post, I

Thank you for your post, I look for such article along time, today i find it finally. this post give me lots of advise it is very useful for me. งานคีย์ข้อมูล

Post new comment

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.