Search:   Namespaces Discussions .NET v1.1 Feedback

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...     Ad MBR BootFX Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT

Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd. Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com