KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > mchange > v1 > db > sql > ConnectionUtils


1 /*
2  * Distributed as part of c3p0 v.0.9.1
3  *
4  * Copyright (C) 2005 Machinery For Change, Inc.
5  *
6  * Author: Steve Waldman <swaldman@mchange.com>
7  *
8  * This library is free software; you can redistribute it and/or modify
9  * it under the terms of the GNU Lesser General Public License version 2.1, as
10  * published by the Free Software Foundation.
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
15  * GNU Lesser General Public License for more details.
16  *
17  * You should have received a copy of the GNU Lesser General Public License
18  * along with this software; see the file LICENSE. If not, write to the
19  * Free Software Foundation, Inc., 59 Temple Place, Suite 330,
20  * Boston, MA 02111-1307, USA.
21  */
22
23
24 package com.mchange.v1.db.sql;
25
26 import java.sql.*;
27 import com.mchange.v2.log.*;
28
29 public final class ConnectionUtils
30 {
31     private final static MLogger logger = MLog.getLogger( ConnectionUtils.class );
32
33     /**
34      * @return false iff and Exception occurred while
35      * trying to close this object.
36      */
37     public static boolean attemptClose(Connection con)
38     {
39     try
40         {
41         if (con != null) con.close();
42         //System.err.println("Connection [ " + con + " ] closed.");
43 return true;
44         }
45         catch (SQLException e)
46         {
47         //e.printStackTrace();
48 //System.err.println("Connection close FAILED.");
49
50         if ( logger.isLoggable( MLevel.WARNING ) )
51             logger.log( MLevel.WARNING, "Connection close FAILED.", e );
52         return false;
53         }
54     }
55
56     public static boolean attemptRollback(Connection con)
57     {
58         try
59         {
60         if (con != null) con.rollback();
61         return true;
62         }
63         catch (SQLException e)
64             {
65         //e.printStackTrace();
66
67         if ( logger.isLoggable( MLevel.WARNING ) )
68             logger.log( MLevel.WARNING, "Rollback FAILED.", e );
69         return false;
70         }
71     }
72
73     private ConnectionUtils()
74     {}
75 }
76
Popular Tags