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.sql.SQLDataException;
26 import java.sql.SQLException;
27 import java.sql.SQLNonTransientException;
28 import static org.testng.Assert.*;
29 import org.testng.annotations.Test;
30 import util.BaseTest;
31 
32 public class SQLDataExceptionTests extends BaseTest {
33 
34     /**
35      * Create SQLDataException and setting all objects to null
36      */
SQLClientInfoExceptionTests()37     @Test
38     public void test() {
39         SQLDataException e = new SQLDataException(null, null, errorCode, null);
40         assertTrue(e.getMessage() == null && e.getSQLState() == null
41                 && e.getCause() == null && e.getErrorCode() == errorCode);
42     }
43 
44     /**
45      * Create SQLDataException with no-arg constructor
test()46      */
47     @Test
48     public void test1() {
49         SQLDataException ex = new SQLDataException();
50         assertTrue(ex.getMessage() == null
51                 && ex.getSQLState() == null
52                 && ex.getCause() == null
53                 && ex.getErrorCode() == 0);
54     }
55 
56     /**
test1()57      * Create SQLDataException with message
58      */
59     @Test
60     public void test2() {
61         SQLDataException ex = new SQLDataException(reason);
62         assertTrue(ex.getMessage().equals(reason)
63                 && ex.getSQLState() == null
64                 && ex.getCause() == null
65                 && ex.getErrorCode() == 0);
66     }
67 
68     /**
69      * Create SQLDataException with message, and SQLState
test2()70      */
71     @Test
72     public void test3() {
73         SQLDataException ex = new SQLDataException(reason, state);
74         assertTrue(ex.getMessage().equals(reason)
75                 && ex.getSQLState().equals(state)
76                 && ex.getCause() == null
77                 && ex.getErrorCode() == 0);
78     }
79 
80     /**
81      * Create SQLDataException with message, SQLState, and error code
82      */
83     @Test
test3()84     public void test4() {
85         SQLDataException ex = new SQLDataException(reason, state, errorCode);
86         assertTrue(ex.getMessage().equals(reason)
87                 && ex.getSQLState().equals(state)
88                 && ex.getCause() == null
89                 && ex.getErrorCode() == errorCode);
90     }
91 
92     /**
93      * Create SQLDataException with message, SQLState, errorCode, and Throwable
94      */
95     @Test
96     public void test5() {
test4()97         SQLDataException ex = new SQLDataException(reason, state, errorCode, t);
98         assertTrue(ex.getMessage().equals(reason)
99                 && ex.getSQLState().equals(state)
100                 && cause.equals(ex.getCause().toString())
101                 && ex.getErrorCode() == errorCode);
102     }
103 
104     /**
105      * Create SQLDataException with message, SQLState, and Throwable
106      */
107     @Test
108     public void test6() {
109         SQLDataException ex = new SQLDataException(reason, state, t);
test5()110         assertTrue(ex.getMessage().equals(reason)
111                 && ex.getSQLState().equals(state)
112                 && cause.equals(ex.getCause().toString())
113                 && ex.getErrorCode() == 0);
114     }
115 
116     /**
117      * Create SQLDataException with message, and Throwable
118      */
119     @Test
120     public void test7() {
121         SQLDataException ex = new SQLDataException(reason, t);
122         assertTrue(ex.getMessage().equals(reason)
123                 && ex.getSQLState() == null
124                 && cause.equals(ex.getCause().toString())
test6()125                 && ex.getErrorCode() == 0);
126     }
127 
128     /**
129      * Create SQLDataException with null Throwable
130      */
131     @Test
132     public void test8() {
133         SQLDataException ex = new SQLDataException((Throwable)null);
134         assertTrue(ex.getMessage() == null
135                 && ex.getSQLState() == null
136                 && ex.getCause() == null
137                 && ex.getErrorCode() == 0);
138     }
139 
test7()140     /**
141      * Create SQLDataException with Throwable
142      */
143     @Test
144     public void test9() {
145         SQLDataException ex = new SQLDataException(t);
146         assertTrue(ex.getMessage().equals(cause)
147                 && ex.getSQLState() == null
148                 && cause.equals(ex.getCause().toString())
149                 && ex.getErrorCode() == 0);
150     }
151 
152     /**
153      * Serialize a SQLDataException and make sure you can read it back properly
test8()154      */
155     @Test
156     public void test10() throws Exception {
157         SQLDataException e = new SQLDataException(reason, state, errorCode, t);
158         SQLDataException ex1 = createSerializedException(e);
159         assertTrue(reason.equals(ex1.getMessage())
160                 && ex1.getSQLState().equals(state)
161                 && cause.equals(ex1.getCause().toString())
162                 && ex1.getErrorCode() == errorCode);
163     }
164 
165     /**
166      * Validate that the ordering of the returned Exceptions is correct
167      * using for-each loop
168      */
test10()169     @Test
170     public void test11() {
171         SQLDataException ex = new SQLDataException("Exception 1", t1);
172         SQLDataException ex1 = new SQLDataException("Exception 2");
173         SQLDataException ex2 = new SQLDataException("Exception 3", t2);
174         ex.setNextException(ex1);
175         ex.setNextException(ex2);
176         int num = 0;
177         for (Throwable e : ex) {
178             assertTrue(msgs[num++].equals(e.getMessage()));
179         }
180     }
181 
182     /**
183      * Validate that the ordering of the returned Exceptions is correct
184      * using traditional while loop
185      */
test11()186     @Test
187     public void test12() {
188         SQLDataException ex = new SQLDataException("Exception 1", t1);
189         SQLDataException ex1 = new SQLDataException("Exception 2");
190         SQLDataException ex2 = new SQLDataException("Exception 3", t2);
191         ex.setNextException(ex1);
192         ex.setNextException(ex2);
193         int num = 0;
194         SQLException sqe = ex;
195         while (sqe != null) {
196             assertTrue(msgs[num++].equals(sqe.getMessage()));
197             Throwable c = sqe.getCause();
198             while (c != null) {
199                 assertTrue(msgs[num++].equals(c.getMessage()));
200                 c = c.getCause();
201             }
202             sqe = sqe.getNextException();
203         }
204     }
205 
test12()206     /**
207      * Create SQLDataException and validate it is an instance of
208      * SQLNonTransientException
209      */
210     @Test
211     public void test13() {
212         Exception ex = new SQLDataException();
213         assertTrue(ex instanceof SQLNonTransientException);
214     }
215 }
216