Qt-interest Archive, January 2007
SQl/Oracle isOpen report true when it's not connected
Message 1 in thread
I have an Oracle app. I open the database and it runs fine.
However, at 11pm on Saturdays, the database is shutdown for a cold
backup. At that time I appear to get no indication that the database has
closed and isOpen() still reports true. I do get an error message that
the query failed because the database is not open.
Does isOpen() only report that open() has been called or is it supposed
to track the status of the connection too?
What is the accepted method of handling this situation?
Thanks,
William R Volz, Staff Research Scientist
Emerging Technology, Strategy & Consulting Team
Technical Computing Technology Department
Chevron Corporation
Energy Technology Company
#19094A
1500 Louisiana
Houston, TX, 77002
Tel 832 854 6738 Fax 832 854 6721
> <mailto:bill.volz@xxxxxxxxxxx>
> This message may contain confidential information that is proprietary
> to ChevronTexaco and is intended only for the use of the parties to
> whom it is addressed. If you are not an intended recipient, you are
> hereby notified that any disclosure, copying, distribution or use of
> any information in this message is strictly prohibited. If you have
> received this message in error, please notify me immediately at the
> telephone number noted above
>
Message 2 in thread
Hi,
> Does isOpen() only report that open() has been called or is it supposed
> to track the status of the connection too?
As far as I know it does not track the status of the connection. I think
some databases don't support that - Qt would have to simulate that by
sending a dummy query every few seconds/minutes.
--
[ signature omitted ]
