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