From 95845d747c487e435f2bc44dc37f29cfeb69cb64 Mon Sep 17 00:00:00 2001
From: Matthew Newhook <matthew@zeroc.com>
Date: Wed, 27 Aug 2008 15:31:51 -0230
Subject: probe connection before returning it.

---
 java/demo/Database/library/ConnectionPool.java | 7 +++++++
 1 file changed, 7 insertions(+)

(limited to 'java/demo/Database/library/ConnectionPool.java')

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)
         {
-- 
cgit v1.2.3