1*b1cdbd2cSJim Jagielski /************************************************************** 2*b1cdbd2cSJim Jagielski * 3*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one 4*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file 5*b1cdbd2cSJim Jagielski * distributed with this work for additional information 6*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file 7*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the 8*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance 9*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at 10*b1cdbd2cSJim Jagielski * 11*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0 12*b1cdbd2cSJim Jagielski * 13*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing, 14*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an 15*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the 17*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations 18*b1cdbd2cSJim Jagielski * under the License. 19*b1cdbd2cSJim Jagielski * 20*b1cdbd2cSJim Jagielski *************************************************************/ 21*b1cdbd2cSJim Jagielski 22*b1cdbd2cSJim Jagielski 23*b1cdbd2cSJim Jagielski 24*b1cdbd2cSJim Jagielski package mod._dbaccess; 25*b1cdbd2cSJim Jagielski 26*b1cdbd2cSJim Jagielski import com.sun.star.beans.PropertyValue; 27*b1cdbd2cSJim Jagielski import com.sun.star.beans.PropertyVetoException; 28*b1cdbd2cSJim Jagielski import com.sun.star.beans.UnknownPropertyException; 29*b1cdbd2cSJim Jagielski import com.sun.star.beans.XPropertySet; 30*b1cdbd2cSJim Jagielski import com.sun.star.frame.XStorable; 31*b1cdbd2cSJim Jagielski 32*b1cdbd2cSJim Jagielski 33*b1cdbd2cSJim Jagielski import com.sun.star.uno.Exception; 34*b1cdbd2cSJim Jagielski import com.sun.star.uno.UnoRuntime; 35*b1cdbd2cSJim Jagielski import com.sun.star.uno.XInterface; 36*b1cdbd2cSJim Jagielski import com.sun.star.uno.XNamingService; 37*b1cdbd2cSJim Jagielski import java.io.PrintWriter; 38*b1cdbd2cSJim Jagielski import lib.StatusException; 39*b1cdbd2cSJim Jagielski import lib.TestCase; 40*b1cdbd2cSJim Jagielski import lib.TestEnvironment; 41*b1cdbd2cSJim Jagielski import lib.TestParameters; 42*b1cdbd2cSJim Jagielski import util.DesktopTools; 43*b1cdbd2cSJim Jagielski import util.utils; 44*b1cdbd2cSJim Jagielski 45*b1cdbd2cSJim Jagielski import com.sun.star.io.IOException; 46*b1cdbd2cSJim Jagielski import com.sun.star.lang.IllegalArgumentException; 47*b1cdbd2cSJim Jagielski import com.sun.star.lang.WrappedTargetException; 48*b1cdbd2cSJim Jagielski import com.sun.star.lang.XMultiServiceFactory; 49*b1cdbd2cSJim Jagielski import com.sun.star.sdb.XOfficeDatabaseDocument; 50*b1cdbd2cSJim Jagielski import com.sun.star.task.XInteractionHandler; 51*b1cdbd2cSJim Jagielski 52*b1cdbd2cSJim Jagielski /** 53*b1cdbd2cSJim Jagielski * Test for object which is represented by service 54*b1cdbd2cSJim Jagielski * <code>com.sun.star.sdb.DataSource</code>. <p> 55*b1cdbd2cSJim Jagielski * 56*b1cdbd2cSJim Jagielski * Object implements the following interfaces : 57*b1cdbd2cSJim Jagielski * <ul> 58*b1cdbd2cSJim Jagielski * <li> <code>com::sun::star::sdb::XQueryDefinitionsSupplier</code></li> 59*b1cdbd2cSJim Jagielski * <li> <code>com::sun::star::sdb::DataSource</code></li> 60*b1cdbd2cSJim Jagielski * <li> <code>com::sun::star::sdb::XCompletedConnection</code></li> 61*b1cdbd2cSJim Jagielski * <li> <code>com::sun::star::util::XFlushable</code></li> 62*b1cdbd2cSJim Jagielski * <li> <code>com::sun::star::sdb::XBookmarksSupplier</code></li> 63*b1cdbd2cSJim Jagielski * <li> <code>com::sun::star::beans::XPropertySet</code></li> 64*b1cdbd2cSJim Jagielski * </ul> 65*b1cdbd2cSJim Jagielski * 66*b1cdbd2cSJim Jagielski * @see com.sun.star.sdb.XQueryDefinitionsSupplier 67*b1cdbd2cSJim Jagielski * @see com.sun.star.sdb.XFormDocumentsSupplier 68*b1cdbd2cSJim Jagielski * @see com.sun.star.beans.XPropertySet 69*b1cdbd2cSJim Jagielski * @see com.sun.star.sdb.DataSource 70*b1cdbd2cSJim Jagielski * @see com.sun.star.sdb.XCompletedConnection 71*b1cdbd2cSJim Jagielski * @see com.sun.star.util.XFlushable 72*b1cdbd2cSJim Jagielski * @see com.sun.star.sdb.XReportDocumentsSupplier 73*b1cdbd2cSJim Jagielski * @see ifc.sdb._XQueryDefinitionsSupplier 74*b1cdbd2cSJim Jagielski * @see ifc.sdb._XFormDocumentsSupplier 75*b1cdbd2cSJim Jagielski * @see ifc.beans._XPropertySet 76*b1cdbd2cSJim Jagielski * @see ifc.sdb._DataSource 77*b1cdbd2cSJim Jagielski * @see ifc.sdb._XCompletedConnection 78*b1cdbd2cSJim Jagielski * @see ifc.util._XFlushable 79*b1cdbd2cSJim Jagielski * @see ifc.sdb._XReportDocumentsSupplier 80*b1cdbd2cSJim Jagielski */ 81*b1cdbd2cSJim Jagielski public class ODatabaseSource extends TestCase { 82*b1cdbd2cSJim Jagielski 83*b1cdbd2cSJim Jagielski private static int uniqueSuffixStat = 0 ; 84*b1cdbd2cSJim Jagielski 85*b1cdbd2cSJim Jagielski private int uniqueSuffix = 0 ; 86*b1cdbd2cSJim Jagielski private XNamingService xDBContextNameServ = null ; 87*b1cdbd2cSJim Jagielski private String databaseName = null ; 88*b1cdbd2cSJim Jagielski private XOfficeDatabaseDocument xDBDoc = null; 89*b1cdbd2cSJim Jagielski 90*b1cdbd2cSJim Jagielski /** 91*b1cdbd2cSJim Jagielski * Assigns database's name unique suffix for this object depending 92*b1cdbd2cSJim Jagielski * on static field. For names differs in different object threads. 93*b1cdbd2cSJim Jagielski */ initialize( TestParameters Param, PrintWriter log)94*b1cdbd2cSJim Jagielski protected void initialize ( TestParameters Param, PrintWriter log) { 95*b1cdbd2cSJim Jagielski uniqueSuffix = uniqueSuffixStat++ ; 96*b1cdbd2cSJim Jagielski } 97*b1cdbd2cSJim Jagielski cleanup(TestParameters tParam, PrintWriter log)98*b1cdbd2cSJim Jagielski protected void cleanup(TestParameters tParam, PrintWriter log) { 99*b1cdbd2cSJim Jagielski log.println(" disposing not longer needed docs... "); 100*b1cdbd2cSJim Jagielski DesktopTools.closeDoc(xDBDoc); 101*b1cdbd2cSJim Jagielski } 102*b1cdbd2cSJim Jagielski 103*b1cdbd2cSJim Jagielski 104*b1cdbd2cSJim Jagielski 105*b1cdbd2cSJim Jagielski /** 106*b1cdbd2cSJim Jagielski * Creating a Testenvironment for the interfaces to be tested. 107*b1cdbd2cSJim Jagielski * 108*b1cdbd2cSJim Jagielski * Creates new <code>DataSource</code> which represents DBase database 109*b1cdbd2cSJim Jagielski * located in temporary directory, and then registers it in service 110*b1cdbd2cSJim Jagielski * <code>com.sun.star.sdb.DatabaseContext</code>. 111*b1cdbd2cSJim Jagielski * 112*b1cdbd2cSJim Jagielski * Created object relations : 113*b1cdbd2cSJim Jagielski * <ul> 114*b1cdbd2cSJim Jagielski * <li> <code>'XCompletedConnection.Handler'</code> for interface test 115*b1cdbd2cSJim Jagielski * <code>XCompletedConnection</code> </li> 116*b1cdbd2cSJim Jagielski * </ul> 117*b1cdbd2cSJim Jagielski * <li> <code>'UserAndPassword'</code> for interface test 118*b1cdbd2cSJim Jagielski * <code>XIsolatedConnection</code> </li> 119*b1cdbd2cSJim Jagielski * </ul> 120*b1cdbd2cSJim Jagielski * @see com.sun.star.sdb.DatabaseContext 121*b1cdbd2cSJim Jagielski * @see com.sun.star.sdb.DataSource 122*b1cdbd2cSJim Jagielski */ createTestEnvironment(TestParameters Param, PrintWriter log)123*b1cdbd2cSJim Jagielski protected TestEnvironment createTestEnvironment(TestParameters Param, PrintWriter log) { 124*b1cdbd2cSJim Jagielski XInterface oObj = null; 125*b1cdbd2cSJim Jagielski Object oInterface = null; 126*b1cdbd2cSJim Jagielski XMultiServiceFactory xMSF = null ; 127*b1cdbd2cSJim Jagielski 128*b1cdbd2cSJim Jagielski xMSF = (XMultiServiceFactory)Param.getMSF(); 129*b1cdbd2cSJim Jagielski try{ 130*b1cdbd2cSJim Jagielski oInterface = xMSF.createInstance( "com.sun.star.sdb.DatabaseContext" ); 131*b1cdbd2cSJim Jagielski 132*b1cdbd2cSJim Jagielski if (oInterface == null) 133*b1cdbd2cSJim Jagielski throw new StatusException("Could not get service 'com.sun.star.sdb.DatabaseContext'", new Exception()); 134*b1cdbd2cSJim Jagielski 135*b1cdbd2cSJim Jagielski }catch( Exception e ) { 136*b1cdbd2cSJim Jagielski log.println("Could not get service 'com.sun.star.sdb.DatabaseContext'" ); 137*b1cdbd2cSJim Jagielski e.printStackTrace (); 138*b1cdbd2cSJim Jagielski throw new StatusException("Service not available", e) ; 139*b1cdbd2cSJim Jagielski } 140*b1cdbd2cSJim Jagielski 141*b1cdbd2cSJim Jagielski xDBContextNameServ = (XNamingService) 142*b1cdbd2cSJim Jagielski UnoRuntime.queryInterface(XNamingService.class, oInterface) ; 143*b1cdbd2cSJim Jagielski 144*b1cdbd2cSJim Jagielski // retrieving temp directory for database 145*b1cdbd2cSJim Jagielski String tmpDatabaseUrl = utils.getOfficeTempDir((XMultiServiceFactory)Param.getMSF()); 146*b1cdbd2cSJim Jagielski 147*b1cdbd2cSJim Jagielski tmpDatabaseUrl = "sdbc:dbase:file:///" + tmpDatabaseUrl ; 148*b1cdbd2cSJim Jagielski 149*b1cdbd2cSJim Jagielski try{ 150*b1cdbd2cSJim Jagielski XInterface oDatabaseDoc = (XInterface) xMSF.createInstance 151*b1cdbd2cSJim Jagielski ("com.sun.star.sdb.OfficeDatabaseDocument") ; 152*b1cdbd2cSJim Jagielski 153*b1cdbd2cSJim Jagielski if (oDatabaseDoc == null) 154*b1cdbd2cSJim Jagielski throw new StatusException("Could not get service 'com.sun.star.sdb.OfficeDatabaseDocument'", new Exception()); 155*b1cdbd2cSJim Jagielski 156*b1cdbd2cSJim Jagielski xDBDoc = (XOfficeDatabaseDocument) UnoRuntime.queryInterface( 157*b1cdbd2cSJim Jagielski XOfficeDatabaseDocument.class, 158*b1cdbd2cSJim Jagielski oDatabaseDoc); 159*b1cdbd2cSJim Jagielski } 160*b1cdbd2cSJim Jagielski catch( Exception e ) { 161*b1cdbd2cSJim Jagielski log.println("Could not get service 'com.sun.star.sdb.OfficeDatabaseDocument'" ); 162*b1cdbd2cSJim Jagielski e.printStackTrace (); 163*b1cdbd2cSJim Jagielski throw new StatusException("Service not available", e) ; 164*b1cdbd2cSJim Jagielski } 165*b1cdbd2cSJim Jagielski 166*b1cdbd2cSJim Jagielski oObj = (XInterface) xDBDoc.getDataSource(); 167*b1cdbd2cSJim Jagielski log.println("ImplementationName: " + utils.getImplName(oObj)); 168*b1cdbd2cSJim Jagielski 169*b1cdbd2cSJim Jagielski // Creating new DBase data source in the TEMP directory 170*b1cdbd2cSJim Jagielski 171*b1cdbd2cSJim Jagielski XPropertySet xSrcProp = (XPropertySet) 172*b1cdbd2cSJim Jagielski UnoRuntime.queryInterface(XPropertySet.class, oObj); 173*b1cdbd2cSJim Jagielski 174*b1cdbd2cSJim Jagielski try{ 175*b1cdbd2cSJim Jagielski xSrcProp.setPropertyValue("URL", tmpDatabaseUrl) ; 176*b1cdbd2cSJim Jagielski } catch ( UnknownPropertyException e){ 177*b1cdbd2cSJim Jagielski throw new StatusException("Could not set property 'URL' ", e) ; 178*b1cdbd2cSJim Jagielski } catch ( PropertyVetoException e){ 179*b1cdbd2cSJim Jagielski throw new StatusException("Could not set property 'URL' ", e) ; 180*b1cdbd2cSJim Jagielski } catch ( IllegalArgumentException e){ 181*b1cdbd2cSJim Jagielski throw new StatusException("Could not set property 'URL' ", e) ; 182*b1cdbd2cSJim Jagielski } catch ( WrappedTargetException e){ 183*b1cdbd2cSJim Jagielski throw new StatusException("Could not set property 'URL' ", e) ; 184*b1cdbd2cSJim Jagielski } 185*b1cdbd2cSJim Jagielski 186*b1cdbd2cSJim Jagielski databaseName = "NewDatabaseSource" + uniqueSuffix ; 187*b1cdbd2cSJim Jagielski 188*b1cdbd2cSJim Jagielski // make sure that the DatabaseContext isn't already registered 189*b1cdbd2cSJim Jagielski try { 190*b1cdbd2cSJim Jagielski xDBContextNameServ.revokeObject(databaseName) ; 191*b1cdbd2cSJim Jagielski } catch (Exception e) { 192*b1cdbd2cSJim Jagielski log.println("Nothing to be removed - OK"); 193*b1cdbd2cSJim Jagielski } 194*b1cdbd2cSJim Jagielski 195*b1cdbd2cSJim Jagielski // registering source in DatabaseContext 196*b1cdbd2cSJim Jagielski XStorable store = (XStorable) UnoRuntime.queryInterface(XStorable.class, xDBDoc); 197*b1cdbd2cSJim Jagielski String aFile = utils.getOfficeTemp ((XMultiServiceFactory) Param.getMSF ())+"DataSource.odb"; 198*b1cdbd2cSJim Jagielski try{ 199*b1cdbd2cSJim Jagielski store.storeAsURL(aFile,new PropertyValue[]{}); 200*b1cdbd2cSJim Jagielski } catch (IOException e){ 201*b1cdbd2cSJim Jagielski log.println("Could not store datasource 'aFile'" ); 202*b1cdbd2cSJim Jagielski e.printStackTrace (); 203*b1cdbd2cSJim Jagielski throw new StatusException("Could not save ", e) ; 204*b1cdbd2cSJim Jagielski } catch (Exception e){ 205*b1cdbd2cSJim Jagielski log.println("Could not store datasource 'aFile'" ); 206*b1cdbd2cSJim Jagielski e.printStackTrace (); 207*b1cdbd2cSJim Jagielski throw new StatusException("Could not save ", e) ; 208*b1cdbd2cSJim Jagielski } 209*b1cdbd2cSJim Jagielski 210*b1cdbd2cSJim Jagielski 211*b1cdbd2cSJim Jagielski try{ 212*b1cdbd2cSJim Jagielski xDBContextNameServ.registerObject(databaseName, oObj) ; 213*b1cdbd2cSJim Jagielski } catch (Exception e){ 214*b1cdbd2cSJim Jagielski log.println("Could not register data source" ); 215*b1cdbd2cSJim Jagielski e.printStackTrace (); 216*b1cdbd2cSJim Jagielski throw new StatusException("Could not register ", e) ; 217*b1cdbd2cSJim Jagielski } 218*b1cdbd2cSJim Jagielski 219*b1cdbd2cSJim Jagielski log.println( " creating a new environment for object" ); 220*b1cdbd2cSJim Jagielski TestEnvironment tEnv = new TestEnvironment( oObj ); 221*b1cdbd2cSJim Jagielski 222*b1cdbd2cSJim Jagielski // adding obj relation for interface XCompletedConnection 223*b1cdbd2cSJim Jagielski Object handler = null ; 224*b1cdbd2cSJim Jagielski try { 225*b1cdbd2cSJim Jagielski handler = ((XMultiServiceFactory)Param.getMSF()).createInstance 226*b1cdbd2cSJim Jagielski ("com.sun.star.sdb.InteractionHandler") ; 227*b1cdbd2cSJim Jagielski } catch (Exception e) { 228*b1cdbd2cSJim Jagielski log.println("Relation for XCompletedConnection wasn't created") ; 229*b1cdbd2cSJim Jagielski e.printStackTrace(log) ; 230*b1cdbd2cSJim Jagielski } 231*b1cdbd2cSJim Jagielski 232*b1cdbd2cSJim Jagielski // dbase does not need user and password 233*b1cdbd2cSJim Jagielski tEnv.addObjRelation("UserAndPassword", new String[]{"",""}) ; 234*b1cdbd2cSJim Jagielski 235*b1cdbd2cSJim Jagielski tEnv.addObjRelation("XCompletedConnection.Handler", 236*b1cdbd2cSJim Jagielski UnoRuntime.queryInterface(XInteractionHandler.class, handler)) ; 237*b1cdbd2cSJim Jagielski 238*b1cdbd2cSJim Jagielski return tEnv; 239*b1cdbd2cSJim Jagielski } // finish method getTestEnvironment 240*b1cdbd2cSJim Jagielski 241*b1cdbd2cSJim Jagielski } 242