KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > jboss > resource > adapter > jdbc > vendor > PostgreSQLValidConnectionChecker


1 /*
2  * JBoss, Home of Professional Open Source
3  * Copyright 2005, JBoss Inc., and individual contributors as indicated
4  * by the @authors tag. See the copyright.txt in the distribution for a
5  * full listing of individual contributors.
6  *
7  * This is free software; you can redistribute it and/or modify it
8  * under the terms of the GNU Lesser General Public License as
9  * published by the Free Software Foundation; either version 2.1 of
10  * the License, or (at your option) any later version.
11  *
12  * This software is distributed in the hope that it will be useful,
13  * but WITHOUT ANY WARRANTY; without even the implied warranty of
14  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
15  * Lesser General Public License for more details.
16  *
17  * You should have received a copy of the GNU Lesser General Public
18  * License along with this software; if not, write to the Free
19  * Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA
20  * 02110-1301 USA, or see the FSF site: http://www.fsf.org.
21  */
22
23 package org.jboss.resource.adapter.jdbc.vendor;
24
25 import java.io.Serializable JavaDoc;
26 import java.sql.Connection JavaDoc;
27 import java.sql.SQLException JavaDoc;
28 import java.sql.Statement JavaDoc;
29
30 import org.jboss.resource.adapter.jdbc.ValidConnectionChecker;
31
32 /**
33  * A PostgreSQLValidConnectionChecker.
34  *
35  * @author <a HREF="weston.price@jboss.com">Weston Price</a>
36  * @version $Revision: 44573 $
37  */
38 public class PostgreSQLValidConnectionChecker implements ValidConnectionChecker, Serializable JavaDoc
39 {
40
41    /** The serialVersionUID */
42    private static final long serialVersionUID = 4867167301823753925L;
43
44    public SQLException JavaDoc isValidConnection(Connection JavaDoc c)
45    {
46
47       Statement JavaDoc stmt = null;
48       SQLException JavaDoc sqe = null;
49       
50       try
51       {
52          stmt = c.createStatement();
53          stmt.execute("");
54
55       }
56
57       catch (Exception JavaDoc e)
58       {
59          if (e instanceof SQLException JavaDoc)
60          {
61             sqe = (SQLException JavaDoc)e;
62             
63          }
64
65       }
66       finally
67       {
68          if (stmt != null)
69          {
70
71             try
72             {
73                stmt.close();
74             }
75             catch (SQLException JavaDoc e)
76             {
77             }
78
79          }
80       }
81
82       return sqe;
83    }
84
85 }
86
Popular Tags