diff options
| author | Matthew Newhook <matthew@zeroc.com> | 2008-08-27 15:31:51 -0230 |
|---|---|---|
| committer | Matthew Newhook <matthew@zeroc.com> | 2008-08-27 15:31:51 -0230 |
| commit | 95845d747c487e435f2bc44dc37f29cfeb69cb64 (patch) | |
| tree | 7aa0938833dd0a9d442de4ac04ef0fed6fa12d6d /java/demo/Database/library | |
| parent | use /2 timeout. (diff) | |
| download | ice-95845d747c487e435f2bc44dc37f29cfeb69cb64.tar.bz2 ice-95845d747c487e435f2bc44dc37f29cfeb69cb64.tar.xz ice-95845d747c487e435f2bc44dc37f29cfeb69cb64.zip | |
probe connection before returning it.
Diffstat (limited to 'java/demo/Database/library')
| -rw-r--r-- | java/demo/Database/library/ConnectionPool.java | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/java/demo/Database/library/ConnectionPool.java b/java/demo/Database/library/ConnectionPool.java index 30bf5205fff..c65d7944f05 100644 --- a/java/demo/Database/library/ConnectionPool.java +++ b/java/demo/Database/library/ConnectionPool.java @@ -64,6 +64,13 @@ class ConnectionPool _logger.warning("ConnectionPool: lost connection to database"); conn = null; } + else + { + // Probe the connection with the database. + java.sql.PreparedStatement stmt = conn.prepareStatement("SELECT 1"); + java.sql.ResultSet rs = stmt.executeQuery(); + stmt.close(); + } } catch(java.sql.SQLException e) { |