KickJava   Java API By Example, From Geeks To Geeks.

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


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 DB2ValidConnectionChecker.
34  *
35  * @author <a HREF="weston.price@jboss.com">Weston Price</a>
36  * @version $Revision: 54951 $
37  */
38 public class DB2ValidConnectionChecker implements ValidConnectionChecker, Serializable JavaDoc
39 {
40    /** The serialVersionUID */
41    private static final long serialVersionUID = -1256537245822198702L;
42
43    /** The VALID_QUERY */
44    private static final String JavaDoc VALID_QUERY = "SELECT CURRENT TIMESTAMP FROM SYSIBM.SYSDUMMY1";
45
46    public SQLException JavaDoc isValidConnection(final Connection JavaDoc c)
47    {
48       SQLException JavaDoc theResult = null;
49       Statement JavaDoc s = null;
50
51       try
52       {
53
54          s = c.createStatement();
55          s.execute(VALID_QUERY);
56
57       }
58       catch (SQLException JavaDoc e)
59       {
60
61          theResult = e;
62
63       }
64       finally
65       {
66
67          try
68          {
69
70             if (s != null)
71                s.close();
72          }
73          catch (SQLException JavaDoc e)
74          {
75          }
76
77       }
78
79       return theResult;
80    }
81
82 }
83
Popular Tags