1 /***
2 * Redistribution and use of this software and associated documentation
3 * ("Software"), with or without modification, are permitted provided
4 * that the following conditions are met:
5 *
6 * 1. Redistributions of source code must retain copyright
7 * statements and notices. Redistributions must also contain a
8 * copy of this document.
9 *
10 * 2. Redistributions in binary form must reproduce the
11 * above copyright notice, this list of conditions and the
12 * following disclaimer in the documentation and/or other
13 * materials provided with the distribution.
14 *
15 * 3. The name "Exolab" must not be used to endorse or promote
16 * products derived from this Software without prior written
17 * permission of Exoffice Technologies. For written permission,
18 * please contact info@exolab.org.
19 *
20 * 4. Products derived from this Software may not be called "Exolab"
21 * nor may "Exolab" appear in their names without prior written
22 * permission of Exoffice Technologies. Exolab is a registered
23 * trademark of Exoffice Technologies.
24 *
25 * 5. Due credit should be given to the Exolab Project
26 * (http://www.exolab.org/).
27 *
28 * THIS SOFTWARE IS PROVIDED BY EXOFFICE TECHNOLOGIES AND CONTRIBUTORS
29 * ``AS IS'' AND ANY EXPRESSED OR IMPLIED WARRANTIES, INCLUDING, BUT
30 * NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND
31 * FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL
32 * EXOFFICE TECHNOLOGIES OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT,
33 * INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
34 * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR
35 * SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION)
36 * HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT,
37 * STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
38 * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED
39 * OF THE POSSIBILITY OF SUCH DAMAGE.
40 *
41 * Copyright 2000-2005 (C) Exoffice Technologies Inc. All Rights Reserved.
42 */
43 package org.exolab.jms.persistence;
44
45 import java.io.IOException;
46 import java.io.InputStream;
47 import java.io.OutputStream;
48 import java.sql.Connection;
49 import java.sql.ResultSet;
50 import java.sql.SQLException;
51 import java.sql.Statement;
52
53
54 /***
55 * SQL helper routines.
56 *
57 * @version $Revision: 1.2 $ $Date: 2005/06/09 14:39:52 $
58 * @author <a href="mailto:tima@intalio.com">Tim Anderson</a>
59 */
60 public class SQLHelper {
61
62 public static boolean rollback(Connection connection) {
63 boolean rolledback = false;
64 if (connection != null) {
65 try {
66 connection.rollback();
67 rolledback = true;
68 } catch (SQLException ignore) {
69 }
70 }
71 return rolledback;
72 }
73
74 public static boolean close(Connection connection) {
75 boolean closed = false;
76 if (connection != null) {
77 try {
78 connection.close();
79 closed = true;
80 } catch (SQLException ignore) {
81 }
82 }
83 return closed;
84 }
85
86 public static boolean close(Statement statement) {
87 boolean closed = false;
88 if (statement != null) {
89 try {
90 statement.close();
91 closed = true;
92 } catch (SQLException ignore) {
93 }
94 }
95 return closed;
96 }
97
98 public static boolean close(ResultSet set) {
99 boolean closed = false;
100 if (set != null) {
101 try {
102 set.close();
103 closed = true;
104 } catch (SQLException ignore) {
105 }
106 }
107 return closed;
108 }
109
110 public static boolean close(InputStream is) {
111 boolean closed = false;
112 if (is != null) {
113 try {
114 is.close();
115 closed = true;
116 } catch (IOException ignore) {}
117 }
118 return closed;
119 }
120
121 public static boolean close(OutputStream os) {
122 boolean closed = false;
123 if (os != null) {
124 try {
125 os.close();
126 closed = true;
127 } catch (IOException ignore) {}
128 }
129 return closed;
130 }
131
132 }