01: /*
02: * Distributed as part of c3p0 v.0.9.1.2
03: *
04: * Copyright (C) 2005 Machinery For Change, Inc.
05: *
06: * Author: Steve Waldman <swaldman@mchange.com>
07: *
08: * This library is free software; you can redistribute it and/or modify
09: * 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: package com.mchange.v1.db.sql;
24:
25: import java.sql.*;
26: import com.mchange.v2.log.*;
27:
28: public final class ConnectionUtils {
29: private final static MLogger logger = MLog
30: .getLogger(ConnectionUtils.class);
31:
32: /**
33: * @return false iff and Exception occurred while
34: * trying to close this object.
35: */
36: public static boolean attemptClose(Connection con) {
37: try {
38: if (con != null)
39: con.close();
40: //System.err.println("Connection [ " + con + " ] closed.");
41: return true;
42: } catch (SQLException e) {
43: //e.printStackTrace();
44: //System.err.println("Connection close FAILED.");
45:
46: if (logger.isLoggable(MLevel.WARNING))
47: logger.log(MLevel.WARNING, "Connection close FAILED.",
48: e);
49: return false;
50: }
51: }
52:
53: public static boolean attemptRollback(Connection con) {
54: try {
55: if (con != null)
56: con.rollback();
57: return true;
58: } catch (SQLException e) {
59: //e.printStackTrace();
60:
61: if (logger.isLoggable(MLevel.WARNING))
62: logger.log(MLevel.WARNING, "Rollback FAILED.", e);
63: return false;
64: }
65: }
66:
67: private ConnectionUtils() {
68: }
69: }
|