1*ef39d40dSAndrew Rist /**************************************************************
2cdf0e10cSrcweir  *
3*ef39d40dSAndrew Rist  * Licensed to the Apache Software Foundation (ASF) under one
4*ef39d40dSAndrew Rist  * or more contributor license agreements.  See the NOTICE file
5*ef39d40dSAndrew Rist  * distributed with this work for additional information
6*ef39d40dSAndrew Rist  * regarding copyright ownership.  The ASF licenses this file
7*ef39d40dSAndrew Rist  * to you under the Apache License, Version 2.0 (the
8*ef39d40dSAndrew Rist  * "License"); you may not use this file except in compliance
9*ef39d40dSAndrew Rist  * with the License.  You may obtain a copy of the License at
10*ef39d40dSAndrew Rist  *
11*ef39d40dSAndrew Rist  *   http://www.apache.org/licenses/LICENSE-2.0
12*ef39d40dSAndrew Rist  *
13*ef39d40dSAndrew Rist  * Unless required by applicable law or agreed to in writing,
14*ef39d40dSAndrew Rist  * software distributed under the License is distributed on an
15*ef39d40dSAndrew Rist  * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16*ef39d40dSAndrew Rist  * KIND, either express or implied.  See the License for the
17*ef39d40dSAndrew Rist  * specific language governing permissions and limitations
18*ef39d40dSAndrew Rist  * under the License.
19*ef39d40dSAndrew Rist  *
20*ef39d40dSAndrew Rist  *************************************************************/
21*ef39d40dSAndrew Rist 
22*ef39d40dSAndrew Rist 
23cdf0e10cSrcweir 
24cdf0e10cSrcweir package ifc.sdbc;
25cdf0e10cSrcweir 
26cdf0e10cSrcweir import lib.MultiMethodTest;
27cdf0e10cSrcweir import lib.StatusException;
28cdf0e10cSrcweir 
29cdf0e10cSrcweir import com.sun.star.sdbc.XConnection;
30cdf0e10cSrcweir import com.sun.star.sdbc.XIsolatedConnection;
31cdf0e10cSrcweir import com.sun.star.task.XInteractionHandler;
32cdf0e10cSrcweir 
33cdf0e10cSrcweir /**
34cdf0e10cSrcweir  * Testing <code>com.sun.star.sdb.XCompletedConnection</code>
35cdf0e10cSrcweir  * interface methods :
36cdf0e10cSrcweir  * <ul>
37cdf0e10cSrcweir  *  <li><code> getIsolatedConnectionWithCompletion()</code></li>
38cdf0e10cSrcweir  *  <li><code> getIsolatedConnection()</code></li>
39cdf0e10cSrcweir  * </ul> <p>
40cdf0e10cSrcweir *    The following object relations required :
41cdf0e10cSrcweir * <ul>
42cdf0e10cSrcweir * <li> <code>'XCompletedConnection.Handler'</code> : passed as parameter
43cdf0e10cSrcweir * to <code>connectWithCompletion</code> method. </li>
44cdf0e10cSrcweir * </ul>
45cdf0e10cSrcweir * @see com.sun.star.sdb.XIsolatedConnection
46cdf0e10cSrcweir * @see com.sun.star.task.XInteractionHandler
47cdf0e10cSrcweir * @see com.sun.star.sdbc.XConnection
48cdf0e10cSrcweir */
49cdf0e10cSrcweir public class _XIsolatedConnection extends MultiMethodTest {
50cdf0e10cSrcweir 
51cdf0e10cSrcweir     // oObj filled by MultiMethodTest
52cdf0e10cSrcweir     public XIsolatedConnection oObj = null ;
53cdf0e10cSrcweir 
54cdf0e10cSrcweir     /**
55cdf0e10cSrcweir     * Test call the method with handler passed as object relation.
56cdf0e10cSrcweir     * Then value returned is checked.<p>
57cdf0e10cSrcweir     * Has OK status if not null value returned. <&nbsp>
58cdf0e10cSrcweir     * FAILED if exception occured, null value returned or object
59cdf0e10cSrcweir     * relation was not found.
60cdf0e10cSrcweir     */
61cdf0e10cSrcweir     public void _getIsolatedConnectionWithCompletion() throws StatusException {
62cdf0e10cSrcweir         XInteractionHandler handler = (XInteractionHandler)
63cdf0e10cSrcweir             tEnv.getObjRelation("XCompletedConnection.Handler") ;
64cdf0e10cSrcweir 
65cdf0e10cSrcweir         if (handler == null) {
66cdf0e10cSrcweir             log.println("Required object relation not found !") ;
67cdf0e10cSrcweir             tRes.tested("getIsolatedConnectionWithCompletion()", false) ;
68cdf0e10cSrcweir             return ;
69cdf0e10cSrcweir         }
70cdf0e10cSrcweir 
71cdf0e10cSrcweir         XConnection con = null ;
72cdf0e10cSrcweir         try {
73cdf0e10cSrcweir             con = oObj.getIsolatedConnectionWithCompletion(handler) ;
74cdf0e10cSrcweir         } catch (com.sun.star.sdbc.SQLException e) {
75cdf0e10cSrcweir             throw new StatusException("Exception while method calling", e) ;
76cdf0e10cSrcweir         }
77cdf0e10cSrcweir 
78cdf0e10cSrcweir         tRes.tested("getIsolatedConnectionWithCompletion()", con != null) ;
79cdf0e10cSrcweir     }
80cdf0e10cSrcweir 
81cdf0e10cSrcweir     /**
82cdf0e10cSrcweir     * Test call the method with handler passed as object relation.
83cdf0e10cSrcweir     * Then value returned is checked.<p>
84cdf0e10cSrcweir     * Has OK status if not null value returned. <&nbsp>
85cdf0e10cSrcweir     * FAILED if exception occured, null value returned or object
86cdf0e10cSrcweir     * relation was not found.
87cdf0e10cSrcweir     */
88cdf0e10cSrcweir     public void _getIsolatedConnection() throws StatusException {
89cdf0e10cSrcweir         String[] userSettings = (String[])
90cdf0e10cSrcweir                         tEnv.getObjRelation("UserAndPassword") ;
91cdf0e10cSrcweir 
92cdf0e10cSrcweir         String user = null;
93cdf0e10cSrcweir         String pwd = null;
94cdf0e10cSrcweir         if (userSettings == null) {
95cdf0e10cSrcweir             log.println("Required object relation not found !") ;
96cdf0e10cSrcweir         }
97cdf0e10cSrcweir 
98cdf0e10cSrcweir         if (userSettings[0] != null)
99cdf0e10cSrcweir             user = userSettings[0].equals("")?"<empty>":userSettings[0];
100cdf0e10cSrcweir         else
101cdf0e10cSrcweir             user = "<null>";
102cdf0e10cSrcweir         if (userSettings[1] != null)
103cdf0e10cSrcweir             pwd = userSettings[1].equals("")?"<empty>":userSettings[1];
104cdf0e10cSrcweir         else
105cdf0e10cSrcweir             pwd = "<null>";
106cdf0e10cSrcweir 
107cdf0e10cSrcweir         log.println("Testing \"getIsolatedConnection('user', 'password')\"\n" +
108cdf0e10cSrcweir                     "with user = '" + user + "'; password = '" + pwd + "'");
109cdf0e10cSrcweir         XConnection con = null ;
110cdf0e10cSrcweir         try {
111cdf0e10cSrcweir             con = oObj.getIsolatedConnection(user, pwd) ;
112cdf0e10cSrcweir         } catch (com.sun.star.sdbc.SQLException e) {
113cdf0e10cSrcweir             throw new StatusException("Exception while method calling", e) ;
114cdf0e10cSrcweir         }
115cdf0e10cSrcweir 
116cdf0e10cSrcweir         tRes.tested("getIsolatedConnection()", con != null) ;
117cdf0e10cSrcweir     }
118cdf0e10cSrcweir }  // finish class _XIsolatedConnection
119cdf0e10cSrcweir 
120