Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Connection Pooling & Refreshed Data

843854Jan 22 2002 — edited Jan 23 2002

Hi All

I am totally confused with connection pooling.

Here is my problem

I have a oracle database which gets updated every 15min by SQL Loader. I am using connection pooling in my web application. Since the connection pool is created at the begining of the application/servletcontext.

Will my connection be able to see the changes in the database. ??? I wrote a simple application to test this but the connection eventhough its closed and reopened its not able to see the refreshed data in database.

Also any suggestions if the user shouldnt see any database changes throughout his session ???

Thanks for ur time

-s

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 20 2002

Added on Jan 22 2002

#java-database-connectivity-jdbc

3 comments

461 views