Re: What SQLException when MySQL box crashes or is shutdown?
Mark Matthews <[email protected]>
| Newsgroups | gmane.comp.db.mysql.java |
|---|---|
| Message-ID | <[email protected]> |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Kevin Burton said the following on 5/3/2006 8:39 PM: > Hey. > > I'm writing a load balancing JDBC driver which is MySQL and replication > aware... I'll post more info when its complete. > > What SQLException and errorCode are thrown if an existing Connection object > has a SELECT called when the MySQL db is no longer running? This can > happen > if its manually shutdown or it crashes. > > I believe I've seen EOFException but I'm not 100% sure. > > Thoughts? Kevin, You won't get EOFException, you'll get a SQLException with the SQLState of "08S01". Any reason you're re-inventing the wheel? Maybe you could look at contributing to features that make com.mysql.jdbc.ReplicationDriver do what you need? -Mark -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2.2 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFEWey0tvXNTca6JD8RAk3SAJ0cz0fd6bzki+g45uHJgQYiMiHiXwCgqRhi eQ860quBMgO2p+Pp1Sx+yq0= =c8cd -----END PGP SIGNATURE----- -- MySQL Java Mailing List For list archives: http://lists.mysql.com/java To unsubscribe: http://lists.mysql.com/[email protected]