Howdy,
Yes, the MySQL Query Browser will also time out, but if it does, it notices this when it tries to
execute a query and will ask you if you want to reconnect and then parse the query. If you click on
"Yes" or "OK" (can't remember the exact message now), it will do all of this
transparently.
Lets call this - The right way to do error handling for end users, shall we.
As Keith has mentioned with OOo you have to close the error message, which for some
dumb reason often exceeds the size of my desktop window (because you get a load of
Java error message handling drivel about nested exceptions) and is a pain to get rid
of, then you have to shut down your Base file (or form) and reconnect. <snip>
Ok then - let's look at what is laying around to test this on - I would
like a general error handling function for connections so how about not
sticking with just JDBC.
The Test Network then:
-- Server --
Ubuntu 9.04 AMD 3300+ (64bit) / MySQL 5.1.31-1ubuntu2 / VirtualBox 2.2.4
-- Virtual (hosted) Clients --
Client 1 - MS Win 7 / OO.o 3.2m_50 (spcl FilePicker build) / JRE
1.6_0_13 / Connector-J 5.1.6
Clinet 2 - MS Win 7 / OO.o 3.1.1m_16 / (beta 1) MySQL Native Connector /
JRE 1.6_0_13
--Physical Clients--
Client 3 - Kubuntu 9.04 / OO.o 3.1 / OpenJDK 6 / Connector-j 5.1.6 (hard
wired - Linksys router)
Client 4 - HP mini 110 Mi (hp variant ubuntu Linux) / Go - OO 2.4.1 /
JRE 1.6_0_14 / Connector-J 5.1.6 (WiFi/G - Belkin G+ router) [NOTE will
most likely swap out to OO.o 3.1.1 as we go]
Base line test 1 - Client 1
Created a new Base file that connects to the MySQL server with the JDBC
connector.
Logon to the server via the Base file, go to the tables section.
(Meanwhile my evil twin fires up MySQL Aministrator on the host and
kills the user connection)
Double click on a table...looks like what Alex described -
http://baseanswers.com/downloads/ConnError/ConnLostError.PNG
let's call that - Not the right way to do error handling for end users.
Great, so where do we start....
[Thinking I need to start a new pot of coffee for this]
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
