1*cdf0e10cSrcweir /*************************************************************************
2*cdf0e10cSrcweir  *
3*cdf0e10cSrcweir  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
4*cdf0e10cSrcweir  *
5*cdf0e10cSrcweir  * Copyright 2000, 2010 Oracle and/or its affiliates.
6*cdf0e10cSrcweir  *
7*cdf0e10cSrcweir  * OpenOffice.org - a multi-platform office productivity suite
8*cdf0e10cSrcweir  *
9*cdf0e10cSrcweir  * This file is part of OpenOffice.org.
10*cdf0e10cSrcweir  *
11*cdf0e10cSrcweir  * OpenOffice.org is free software: you can redistribute it and/or modify
12*cdf0e10cSrcweir  * it under the terms of the GNU Lesser General Public License version 3
13*cdf0e10cSrcweir  * only, as published by the Free Software Foundation.
14*cdf0e10cSrcweir  *
15*cdf0e10cSrcweir  * OpenOffice.org is distributed in the hope that it will be useful,
16*cdf0e10cSrcweir  * but WITHOUT ANY WARRANTY; without even the implied warranty of
17*cdf0e10cSrcweir  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
18*cdf0e10cSrcweir  * GNU Lesser General Public License version 3 for more details
19*cdf0e10cSrcweir  * (a copy is included in the LICENSE file that accompanied this code).
20*cdf0e10cSrcweir  *
21*cdf0e10cSrcweir  * You should have received a copy of the GNU Lesser General Public License
22*cdf0e10cSrcweir  * version 3 along with OpenOffice.org.  If not, see
23*cdf0e10cSrcweir  * <http://www.openoffice.org/license.html>
24*cdf0e10cSrcweir  * for a copy of the LGPLv3 License.
25*cdf0e10cSrcweir  *
26*cdf0e10cSrcweir  ************************************************************************/
27*cdf0e10cSrcweir 
28*cdf0e10cSrcweir package ifc.sdbc;
29*cdf0e10cSrcweir 
30*cdf0e10cSrcweir import lib.MultiMethodTest;
31*cdf0e10cSrcweir import lib.StatusException;
32*cdf0e10cSrcweir 
33*cdf0e10cSrcweir import com.sun.star.sdbc.XConnection;
34*cdf0e10cSrcweir import com.sun.star.sdbc.XIsolatedConnection;
35*cdf0e10cSrcweir import com.sun.star.task.XInteractionHandler;
36*cdf0e10cSrcweir 
37*cdf0e10cSrcweir /**
38*cdf0e10cSrcweir  * Testing <code>com.sun.star.sdb.XCompletedConnection</code>
39*cdf0e10cSrcweir  * interface methods :
40*cdf0e10cSrcweir  * <ul>
41*cdf0e10cSrcweir  *  <li><code> getIsolatedConnectionWithCompletion()</code></li>
42*cdf0e10cSrcweir  *  <li><code> getIsolatedConnection()</code></li>
43*cdf0e10cSrcweir  * </ul> <p>
44*cdf0e10cSrcweir *    The following object relations required :
45*cdf0e10cSrcweir * <ul>
46*cdf0e10cSrcweir * <li> <code>'XCompletedConnection.Handler'</code> : passed as parameter
47*cdf0e10cSrcweir * to <code>connectWithCompletion</code> method. </li>
48*cdf0e10cSrcweir * </ul>
49*cdf0e10cSrcweir * @see com.sun.star.sdb.XIsolatedConnection
50*cdf0e10cSrcweir * @see com.sun.star.task.XInteractionHandler
51*cdf0e10cSrcweir * @see com.sun.star.sdbc.XConnection
52*cdf0e10cSrcweir */
53*cdf0e10cSrcweir public class _XIsolatedConnection extends MultiMethodTest {
54*cdf0e10cSrcweir 
55*cdf0e10cSrcweir     // oObj filled by MultiMethodTest
56*cdf0e10cSrcweir     public XIsolatedConnection oObj = null ;
57*cdf0e10cSrcweir 
58*cdf0e10cSrcweir     /**
59*cdf0e10cSrcweir     * Test call the method with handler passed as object relation.
60*cdf0e10cSrcweir     * Then value returned is checked.<p>
61*cdf0e10cSrcweir     * Has OK status if not null value returned. <&nbsp>
62*cdf0e10cSrcweir     * FAILED if exception occured, null value returned or object
63*cdf0e10cSrcweir     * relation was not found.
64*cdf0e10cSrcweir     */
65*cdf0e10cSrcweir     public void _getIsolatedConnectionWithCompletion() throws StatusException {
66*cdf0e10cSrcweir         XInteractionHandler handler = (XInteractionHandler)
67*cdf0e10cSrcweir             tEnv.getObjRelation("XCompletedConnection.Handler") ;
68*cdf0e10cSrcweir 
69*cdf0e10cSrcweir         if (handler == null) {
70*cdf0e10cSrcweir             log.println("Required object relation not found !") ;
71*cdf0e10cSrcweir             tRes.tested("getIsolatedConnectionWithCompletion()", false) ;
72*cdf0e10cSrcweir             return ;
73*cdf0e10cSrcweir         }
74*cdf0e10cSrcweir 
75*cdf0e10cSrcweir         XConnection con = null ;
76*cdf0e10cSrcweir         try {
77*cdf0e10cSrcweir             con = oObj.getIsolatedConnectionWithCompletion(handler) ;
78*cdf0e10cSrcweir         } catch (com.sun.star.sdbc.SQLException e) {
79*cdf0e10cSrcweir             throw new StatusException("Exception while method calling", e) ;
80*cdf0e10cSrcweir         }
81*cdf0e10cSrcweir 
82*cdf0e10cSrcweir         tRes.tested("getIsolatedConnectionWithCompletion()", con != null) ;
83*cdf0e10cSrcweir     }
84*cdf0e10cSrcweir 
85*cdf0e10cSrcweir     /**
86*cdf0e10cSrcweir     * Test call the method with handler passed as object relation.
87*cdf0e10cSrcweir     * Then value returned is checked.<p>
88*cdf0e10cSrcweir     * Has OK status if not null value returned. <&nbsp>
89*cdf0e10cSrcweir     * FAILED if exception occured, null value returned or object
90*cdf0e10cSrcweir     * relation was not found.
91*cdf0e10cSrcweir     */
92*cdf0e10cSrcweir     public void _getIsolatedConnection() throws StatusException {
93*cdf0e10cSrcweir         String[] userSettings = (String[])
94*cdf0e10cSrcweir                         tEnv.getObjRelation("UserAndPassword") ;
95*cdf0e10cSrcweir 
96*cdf0e10cSrcweir         String user = null;
97*cdf0e10cSrcweir         String pwd = null;
98*cdf0e10cSrcweir         if (userSettings == null) {
99*cdf0e10cSrcweir             log.println("Required object relation not found !") ;
100*cdf0e10cSrcweir         }
101*cdf0e10cSrcweir 
102*cdf0e10cSrcweir         if (userSettings[0] != null)
103*cdf0e10cSrcweir             user = userSettings[0].equals("")?"<empty>":userSettings[0];
104*cdf0e10cSrcweir         else
105*cdf0e10cSrcweir             user = "<null>";
106*cdf0e10cSrcweir         if (userSettings[1] != null)
107*cdf0e10cSrcweir             pwd = userSettings[1].equals("")?"<empty>":userSettings[1];
108*cdf0e10cSrcweir         else
109*cdf0e10cSrcweir             pwd = "<null>";
110*cdf0e10cSrcweir 
111*cdf0e10cSrcweir         log.println("Testing \"getIsolatedConnection('user', 'password')\"\n" +
112*cdf0e10cSrcweir                     "with user = '" + user + "'; password = '" + pwd + "'");
113*cdf0e10cSrcweir         XConnection con = null ;
114*cdf0e10cSrcweir         try {
115*cdf0e10cSrcweir             con = oObj.getIsolatedConnection(user, pwd) ;
116*cdf0e10cSrcweir         } catch (com.sun.star.sdbc.SQLException e) {
117*cdf0e10cSrcweir             throw new StatusException("Exception while method calling", e) ;
118*cdf0e10cSrcweir         }
119*cdf0e10cSrcweir 
120*cdf0e10cSrcweir         tRes.tested("getIsolatedConnection()", con != null) ;
121*cdf0e10cSrcweir     }
122*cdf0e10cSrcweir }  // finish class _XIsolatedConnection
123*cdf0e10cSrcweir 
124