Print Thread
Client crashes after connection-loos
#8528 07/27/06 01:31 PM
Joined: Aug 2003
Posts: 7
A
Andi Offline OP
Member
OP Offline
Member
A
Joined: Aug 2003
Posts: 7
Hi,

my application crashes after the connection to the oracle-server was lost. It can also reproduced by renaming the tnsnames.ora during load. The application tries to reconnect the session. After some time the application crashes. An Accessviolation (on address 00000) is handled in SysUtils.ExceptHandler. Maybe a bug in oci.dll??

Application:
- MultiThreaded
- Each Thread has a own TOracleSession
- TOracleSession.ThreadSafe=True
- has a TServerSocket with connected Clients that requests data from the database.

Enviroment:
- Delphi 5
- Windows XP SP2
- DOA 4.0.7.1
- Oracle 9i Server
- Oracle 10.1.0.5 Instant Client

Thanks!

Andi

Re: Client crashes after connection-loos
#8529 07/27/06 05:09 PM
Joined: Aug 1999
Posts: 22,232
Member
Offline
Member
Joined: Aug 1999
Posts: 22,232
What is the exact Oracle Server version?


Marco Kalter
Allround Automations
Re: Client crashes after connection-loos
#8530 07/28/06 01:24 PM
Joined: Nov 2003
Posts: 18
D
Member
Offline
Member
D
Joined: Nov 2003
Posts: 18
Try to use Oracle 10.2.0.1.0 Instant Client. We had a similar problem (Access violation at address 00000000. Read of address 00000000) and a new version of instant client solves it.

--
Best regards,
Daniel

Re: Client crashes after connection-loos
#8531 07/28/06 04:23 PM
Joined: Aug 2003
Posts: 7
A
Andi Offline OP
Member
OP Offline
Member
A
Joined: Aug 2003
Posts: 7
Hi,

thanks for you replies. I've found the reason - no DOA problem. I had some problems with my WindowsSockets.

Thanks!

Andi


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.037s Queries: 13 (0.008s) Memory: 2.5081 MB (Peak: 3.0429 MB) Data Comp: Off Server Time: 2024-06-17 04:36:07 UTC
Valid HTML 5 and Valid CSS