aspose 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
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
Changing job roles, from team leader to DBA, what to think about ?
Connection Pooling help needed
iplanet app server
Connection Pooling help needed
Temporary tables (Oracle) and web based apps