.NETGURU
  Search:  
NamespacesDiscussions.NET v1.1Dot Net Guru's BlogIT Certification
Oracle data caching problem
Messages   Related Types
This message was discovered on ASPFriends.com 'ngfx-oracle' list.


Feduke Cntr Charles R
-- Moved from [aspngfreeforall] to [ngfx-oracle] by Sheik Yerbouti <Click here to reveal e-mail address> --

I am experiencing a very weird problem with Oracle 9i and ASP.NET
(maybe the MS ODBC driver for Oracle that I am using). Basically any data
that is updated, inserted, deleted, etc via my ASP.NET application appears
to instantly fall through to the database, no problems. When I use a
program like SQL*Plus or SQL Navigator to INSERT, UPDATE, or DELETE rows in
the same exact database on the _server_, the effects are not seen in the
ASP.NET application - thus I can delete everything in a table using
SQL*Plus, but the ASP.NET application running against the same datasource
still retrieves those rows as if they are cached locally. This only happens
when a table has been first accessed by the ASP.NET application before
operating on it with another program such as SQL*Plus. The weirdest thing
about all of this is IIS, the ASP.NET application, and Oracle all run on a
server (IIS and Oracle separate) and my workstation runs no IIS or Oracle,
but the problem appears to correct itself only when I reboot my workstation
(*not* the server!) as if its caching data in my workstation's memory.

    I am using Oracle 9i, IIS 5.1, .NET Framework with SP2, Windows 2000
Server SP2 on the server with the Microsoft Oracle ODBC driver (version
unknown).

    I am using Visual Studio .NET with .NET Framework SP2 on Windows
2000 Professional SP3 on my workstation.

    This problem has been going on for several weeks and is very
annoying. What can I do to fix it?

- Chuck
Reply to this message...
 
    
Michael Gerholdt
Are you remembering to 'commit' when in sql*plus and other environments? The
query will appear commited only in the environment it was run until you
explicitly commit or unless autocommit is default or autocommit upon logoff
....

Regards,
Michael Gerholdt
SUNY College at Fredonia

[Original message clipped]
Reply to this message...
 
    
Feduke Cntr Charles R
Michael,

    No, I was omitting the "COMMIT" command. My wife told me about that
Friday night too. Thanks!

- Chuck

-----Original Message-----
From: Michael Gerholdt [mailto:Click here to reveal e-mail address]
Sent: Friday, August 16, 2002 11:03 PM
To: ngfx-oracle
Subject: [ngfx-oracle] Re: Oracle data caching problem

Are you remembering to 'commit' when in sql*plus and other environments? The
query will appear commited only in the environment it was run until you
explicitly commit or unless autocommit is default or autocommit upon logoff
....

Regards,
Michael Gerholdt
SUNY College at Fredonia

[Original message clipped]

| [ngfx-oracle] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/ngfx-oracle.asp = JOIN/QUIT
Reply to this message...
 
 




ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
Ad


Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews
.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT
Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project
FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.
Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials
 
ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
 Copyright © ExamGuru, Inc. 2001-2006
Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification