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 mod._jdbc;
25cdf0e10cSrcweir 
26cdf0e10cSrcweir import java.io.PrintWriter;
27cdf0e10cSrcweir 
28cdf0e10cSrcweir import lib.Status;
29cdf0e10cSrcweir import lib.StatusException;
30cdf0e10cSrcweir import lib.TestCase;
31cdf0e10cSrcweir import lib.TestEnvironment;
32cdf0e10cSrcweir import lib.TestParameters;
33cdf0e10cSrcweir import util.DBTools;
34cdf0e10cSrcweir 
35cdf0e10cSrcweir import com.sun.star.beans.PropertyValue;
36cdf0e10cSrcweir import com.sun.star.lang.XMultiServiceFactory;
37cdf0e10cSrcweir import com.sun.star.uno.XInterface;
38cdf0e10cSrcweir 
39cdf0e10cSrcweir 
40cdf0e10cSrcweir /**
41cdf0e10cSrcweir * Here <code>com.sun.star.sdbc.Driver</code> service is tested.<p>
42cdf0e10cSrcweir * Test allows to run object tests in several threads concurently.
43cdf0e10cSrcweir * @see com.sun.star.sdbc.Driver
44cdf0e10cSrcweir * @see com.sun.star.sdbc.XDriver
45cdf0e10cSrcweir * @see ifc.sdbc._XDriver
46cdf0e10cSrcweir */
47cdf0e10cSrcweir public class JDBCDriver extends TestCase {
48cdf0e10cSrcweir     /**
49cdf0e10cSrcweir      * Creates an instance of the service
50cdf0e10cSrcweir      * <code>com.sun.star.sdbc.Driver</code>. <p>
51cdf0e10cSrcweir      * Object relations created :
52cdf0e10cSrcweir      * <ul>
53cdf0e10cSrcweir      *  <li> <code>'XDriver.URL'</code> for {@link ifc.sdbc._XDriver}:
54cdf0e10cSrcweir      *      is the URL of the database to which to connect.
55cdf0e10cSrcweir      *      The URL is obtained from the parameter <code>jdbc.url</code></li>
56cdf0e10cSrcweir      *  <li> <code>'XDriver.UNSUITABLE_URL'</code> for {@link ifc.sdbc._XDriver}:
57cdf0e10cSrcweir      *      the wrong kind of URL to connect using given driver.
58cdf0e10cSrcweir      *      The URL is obtained from the parameter <code>flat.url</code></li>
59cdf0e10cSrcweir      *  <li> <code>'XDriver.INFO'</code> for {@link ifc.sdbc._XDriver}:
60cdf0e10cSrcweir      *      a list of arbitrary string tag/value pairs as connection arguments.
61cdf0e10cSrcweir      *      The values for list are obtained from the parameter
62cdf0e10cSrcweir      *      <code>jdbc.user</code> and <code>jdbc.password</code>.</li>
63cdf0e10cSrcweir      * </ul>
64cdf0e10cSrcweir      */
createTestEnvironment(TestParameters Param, PrintWriter log)65cdf0e10cSrcweir     protected synchronized TestEnvironment createTestEnvironment(TestParameters Param, PrintWriter log) {
66cdf0e10cSrcweir 
67cdf0e10cSrcweir         XInterface oObj = null;
68cdf0e10cSrcweir 
69cdf0e10cSrcweir         try {
70cdf0e10cSrcweir             oObj = (XInterface)((XMultiServiceFactory)Param.getMSF()).createInstance(
71cdf0e10cSrcweir                 "com.sun.star.comp.sdbc.JDBCDriver");
72cdf0e10cSrcweir         } catch (com.sun.star.uno.Exception e) {
73cdf0e10cSrcweir             e.printStackTrace(log);
74cdf0e10cSrcweir             throw new StatusException(Status.failed("Couldn't create object"));
75cdf0e10cSrcweir         }
76cdf0e10cSrcweir 
77cdf0e10cSrcweir         log.println("creating a new environment for JDBCDriver object");
78cdf0e10cSrcweir         TestEnvironment tEnv = new TestEnvironment(oObj);
79cdf0e10cSrcweir 
80cdf0e10cSrcweir         //adding relation for sdbc.XDriver
81cdf0e10cSrcweir         String jdbcURL = (String) Param.get("jdbc.url");
82cdf0e10cSrcweir         if (jdbcURL == null) {
83cdf0e10cSrcweir             throw new StatusException(Status.failed(
84cdf0e10cSrcweir                 "Couldn't get 'jdbc.url' from ini-file"));
85cdf0e10cSrcweir         }
86cdf0e10cSrcweir         tEnv.addObjRelation("XDriver.URL", "jdbc:" + jdbcURL);
87cdf0e10cSrcweir 
88cdf0e10cSrcweir         String user = (String) Param.get("jdbc.user");
89cdf0e10cSrcweir         String password = (String) Param.get("jdbc.password");
90cdf0e10cSrcweir         if (user == null || password == null) {
91cdf0e10cSrcweir             throw new StatusException(Status.failed(
92cdf0e10cSrcweir                 "Couldn't get 'jdbc.user' or 'jdbc.password' from ini-file"));
93cdf0e10cSrcweir         }
94cdf0e10cSrcweir         PropertyValue[] info = new PropertyValue[4];
95cdf0e10cSrcweir         info[0] = new PropertyValue();
96cdf0e10cSrcweir         info[0].Name = "JavaDriverClass";
97cdf0e10cSrcweir         info[0].Value = DBTools.TST_JDBC_DRIVER;
98cdf0e10cSrcweir         info[1] = new PropertyValue();
99cdf0e10cSrcweir         info[1].Name = "user";
100cdf0e10cSrcweir         info[1].Value = user;
101cdf0e10cSrcweir         info[2] = new PropertyValue();
102cdf0e10cSrcweir         info[2].Name = "password";
103cdf0e10cSrcweir         info[2].Value = password;
104cdf0e10cSrcweir         info[3] = new PropertyValue();
105cdf0e10cSrcweir         info[3].Name = "isPasswordRequired";
106cdf0e10cSrcweir         info[3].Value = new Boolean(true);
107cdf0e10cSrcweir 
108cdf0e10cSrcweir         tEnv.addObjRelation("XDriver.INFO", info);
109cdf0e10cSrcweir 
110cdf0e10cSrcweir         String flatUrl = (String) Param.get("flat.url");
111cdf0e10cSrcweir         if (flatUrl == null) {
112cdf0e10cSrcweir             throw new StatusException(Status.failed(
113cdf0e10cSrcweir                 "Couldn't get 'flat.url' from ini-file"));
114cdf0e10cSrcweir         }
115cdf0e10cSrcweir         tEnv.addObjRelation("XDriver.UNSUITABLE_URL", "sdbc:flat:" + flatUrl);
116cdf0e10cSrcweir 
117cdf0e10cSrcweir         return tEnv;
118cdf0e10cSrcweir     }
119cdf0e10cSrcweir }
120