1 /*
2 * Copyright (c) 2014, Oracle and/or its affiliates. All rights reserved.
3 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
4 *
5 * This code is free software; you can redistribute it and/or modify it
6 * under the terms of the GNU General Public License version 2 only, as
7 * published by the Free Software Foundation.
8 *
9 * This code is distributed in the hope that it will be useful, but WITHOUT
10 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
11 * FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License
12 * version 2 for more details (a copy is included in the LICENSE file that
13 * accompanied this code).
14 *
15 * You should have received a copy of the GNU General Public License version
16 * 2 along with this work; if not, write to the Free Software Foundation,
17 * Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA.
18 *
19 * Please contact Oracle, 500 Oracle Parkway, Redwood Shores, CA 94065 USA
20 * or visit www.oracle.com if you need additional information or have any
21 * questions.
22 */
23 package test.sql;
24
25 import java.io.FileInputStream;
26 import java.io.FileOutputStream;
27 import java.io.ObjectInputStream;
28 import java.io.ObjectOutputStream;
29 import java.sql.SQLException;
30 import java.sql.SQLTimeoutException;
31 import java.sql.SQLTransientException;
32 import static org.testng.Assert.*;
33 import org.testng.annotations.AfterClass;
34 import org.testng.annotations.AfterMethod;
35 import org.testng.annotations.BeforeClass;
36 import org.testng.annotations.BeforeMethod;
37 import org.testng.annotations.Test;
38
39 public class SQLTimeoutExceptionTests {
40
41 private final String reason = "reason";
42 private final String state = "SQLState";
43 private final String cause = "java.lang.Throwable: cause";
44 private final Throwable t = new Throwable("cause");
45 private final Throwable t1 = new Throwable("cause 1");
46 private final Throwable t2 = new Throwable("cause 2");
47 private final int errorCode = 21;
48 private final String[] msgs = {"Exception 1", "cause 1", "Exception 2",
49 "Exception 3", "cause 2"};
50
51 public SQLTimeoutExceptionTests() {
52 }
53
54 @BeforeClass
55 public static void setUpClass() throws Exception {
56 }
57
58 @AfterClass
59 public static void tearDownClass() throws Exception {
60 }
61
62 @BeforeMethod
63 public void setUpMethod() throws Exception {
64 }
65
66 @AfterMethod
67 public void tearDownMethod() throws Exception {
68 }
69
70 /**
71 * Create SQLTimeoutException and setting all objects to null
72 */
73 @Test
74 public void test() {
75 SQLTimeoutException e = new SQLTimeoutException(null,
76 null, errorCode, null);
77 assertTrue(e.getMessage() == null && e.getSQLState() == null
78 && e.getCause() == null && e.getErrorCode() == errorCode);
79 }
80
81 /**
82 * Create SQLTimeoutException with no-arg constructor
83 */
84 @Test
85 public void test1() {
86 SQLTimeoutException ex = new SQLTimeoutException();
87 assertTrue(ex.getMessage() == null
88 && ex.getSQLState() == null
89 && ex.getCause() == null
90 && ex.getErrorCode() == 0);
91 }
92
93 /**
94 * Create SQLTimeoutException with message
95 */
96 @Test
97 public void test2() {
98 SQLTimeoutException ex = new SQLTimeoutException(reason);
99 assertTrue(ex.getMessage().equals(reason)
100 && ex.getSQLState() == null
101 && ex.getCause() == null
102 && ex.getErrorCode() == 0);
103 }
104
105 /**
106 * Create SQLTimeoutException with message, and SQLState
107 */
108 @Test
109 public void test3() {
110 SQLTimeoutException ex = new SQLTimeoutException(reason, state);
111 assertTrue(ex.getMessage().equals(reason)
112 && ex.getSQLState().equals(state)
113 && ex.getCause() == null
114 && ex.getErrorCode() == 0);
115 }
116
117 /**
118 * Create SQLTimeoutException with message, SQLState, and error code
119 */
120 @Test
121 public void test4() {
122 SQLTimeoutException ex = new SQLTimeoutException(reason, state, errorCode);
123 assertTrue(ex.getMessage().equals(reason)
124 && ex.getSQLState().equals(state)
125 && ex.getCause() == null
126 && ex.getErrorCode() == errorCode);
127 }
128
129 /**
130 * Create SQLTimeoutException with message, SQLState, errorCode, and Throwable
131 */
132 @Test
133 public void test5() {
134 SQLTimeoutException ex = new SQLTimeoutException(reason, state, errorCode, t);
135 assertTrue(ex.getMessage().equals(reason)
136 && ex.getSQLState().equals(state)
137 && cause.equals(ex.getCause().toString())
138 && ex.getErrorCode() == errorCode);
139 }
140
141 /**
142 * Create SQLTimeoutException with message, SQLState, and Throwable
143 */
144 @Test
145 public void test6() {
146 SQLTimeoutException ex = new SQLTimeoutException(reason, state, t);
147 assertTrue(ex.getMessage().equals(reason)
148 && ex.getSQLState().equals(state)
149 && cause.equals(ex.getCause().toString())
150 && ex.getErrorCode() == 0);
151 }
152
153 /**
154 * Create SQLTimeoutException with message, and Throwable
155 */
156 @Test
157 public void test7() {
158 SQLTimeoutException ex = new SQLTimeoutException(reason, t);
159 assertTrue(ex.getMessage().equals(reason)
160 && ex.getSQLState() == null
161 && cause.equals(ex.getCause().toString())
162 && ex.getErrorCode() == 0);
163 }
164
165 /**
166 * Create SQLTimeoutException with null Throwable
167 */
168 @Test
169 public void test8() {
170 SQLTimeoutException ex = new SQLTimeoutException((Throwable)null);
171 assertTrue(ex.getMessage() == null
172 && ex.getSQLState() == null
173 && ex.getCause() == null
174 && ex.getErrorCode() == 0);
175 }
176
177 /**
178 * Create SQLTimeoutException with Throwable
179 */
180 @Test
181 public void test9() {
182 SQLTimeoutException ex = new SQLTimeoutException(t);
183 assertTrue(ex.getMessage().equals(cause)
184 && ex.getSQLState() == null
185 && cause.equals(ex.getCause().toString())
186 && ex.getErrorCode() == 0);
187 }
188
189 /**
190 * Serialize a SQLTimeoutException and make sure you can read it back properly
191 */
192 @Test
193 public void test10() throws Exception {
194 SQLTimeoutException e =
195 new SQLTimeoutException(reason, state, errorCode, t);
196 ObjectOutputStream out
197 = new ObjectOutputStream(
198 new FileOutputStream("SQLTimeoutException.ser"));
199 out.writeObject(e);
200 ObjectInputStream is = new ObjectInputStream(
201 new FileInputStream("SQLTimeoutException.ser"));
202 SQLTimeoutException ex1 = (SQLTimeoutException) is.readObject();
203 assertTrue(reason.equals(ex1.getMessage())
204 && ex1.getSQLState().equals(state)
205 && cause.equals(ex1.getCause().toString())
206 && ex1.getErrorCode() == errorCode);
207 }
208
209 /**
210 * Validate that the ordering of the returned Exceptions is correct
211 * using for-each loop
212 */
213 @Test
214 public void test11() {
215 SQLTimeoutException ex = new SQLTimeoutException("Exception 1", t1);
216 SQLTimeoutException ex1 = new SQLTimeoutException("Exception 2");
217 SQLTimeoutException ex2 = new SQLTimeoutException("Exception 3", t2);
218 ex.setNextException(ex1);
219 ex.setNextException(ex2);
220 int num = 0;
221 for (Throwable e : ex) {
222 assertTrue(msgs[num++].equals(e.getMessage()));
223 }
224 }
225
226 /**
227 * Validate that the ordering of the returned Exceptions is correct
228 * using traditional while loop
229 */
230 @Test
231 public void test12() {
232 SQLTimeoutException ex = new SQLTimeoutException("Exception 1", t1);
233 SQLTimeoutException ex1 = new SQLTimeoutException("Exception 2");
234 SQLTimeoutException ex2 = new SQLTimeoutException("Exception 3", t2);
235 ex.setNextException(ex1);
236 ex.setNextException(ex2);
237 int num = 0;
238 SQLException sqe = ex;
239 while (sqe != null) {
240 assertTrue(msgs[num++].equals(sqe.getMessage()));
241 Throwable c = sqe.getCause();
242 while (c != null) {
243 assertTrue(msgs[num++].equals(c.getMessage()));
244 c = c.getCause();
245 }
246 sqe = sqe.getNextException();
247 }
248 }
249
250 /**
251 * Create SQLTimeoutException and validate it is an instance of
252 * SQLNonTransientException
253 */
254 @Test
255 public void test13() {
256 Exception ex = new SQLTimeoutException();
257 assertTrue(ex instanceof SQLTransientException);
258 }
259 }