Win a copy of Get Programming with Java (MEAP only) this week in the Beginning Java forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Bear Bibeault
  • Knute Snortum
  • Liutauras Vilda
Sheriffs:
  • Tim Cooke
  • Devaka Cooray
  • Paul Clapham
Saloon Keepers:
  • Tim Moores
  • Frits Walraven
  • Ron McLeod
  • Ganesh Patekar
  • salvin francis
Bartenders:
  • Tim Holloway
  • Carey Brown
  • Stephan van Hulst

Using connection pool on Oracle 8i temporary tables  RSS feed

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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??
 
permaculture is largely about replacing oil with people. And one tiny ad:
Programmatically Create PDF Using Free Spire.PDF with Java
https://coderanch.com/wiki/703735/Programmatically-Create-PDF-Free-Spire
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!