File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Using connection pool on Oracle 8i temporary tables Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Using connection pool on Oracle 8i temporary tables" Watch "Using connection pool on Oracle 8i temporary tables" New topic
Author

Using connection pool on Oracle 8i temporary tables

David Manoj
Greenhorn

Joined: Nov 27, 2001
Posts: 1
Hi all,
In ORACLE 8i, for temporary tables and cursors, after creation if we are incrementally trying to
query the temporary table or cursor (in profile reports), there is no guarantee that we will get
the same connection as the one we got for the first time because we are using pooled connections
from the middle tier. This could lead to data integrity issues. To solve this problem, we have to
go for permanent tables OR file system which are costly operations. We would like to know whether
there is any alternative solution to overcome this problem. Probably, we can check whether
anybody else has faced a similar problem in the past and what was done to solve the same. Can
materialised views in ORACLE 8i be used for this purpose ?
Can anybody help??
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Using connection pool on Oracle 8i temporary tables
 
Similar Threads
Temporary tables (Oracle) and web based apps
Connection Pooling help needed
iplanet app server
Changing job roles, from team leader to DBA, what to think about ?
Connection Pooling help needed