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 package mod._dbaccess; 24cdf0e10cSrcweir 25cdf0e10cSrcweir import java.io.PrintWriter; 26cdf0e10cSrcweir 27cdf0e10cSrcweir import lib.Status; 28cdf0e10cSrcweir import lib.StatusException; 29cdf0e10cSrcweir import lib.TestCase; 30cdf0e10cSrcweir import lib.TestEnvironment; 31cdf0e10cSrcweir import lib.TestParameters; 32cdf0e10cSrcweir import util.AccessibilityTools; 33cdf0e10cSrcweir 34cdf0e10cSrcweir import com.sun.star.accessibility.AccessibleRole; 35cdf0e10cSrcweir import com.sun.star.accessibility.XAccessible; 36cdf0e10cSrcweir import com.sun.star.awt.PosSize; 37cdf0e10cSrcweir import com.sun.star.awt.Rectangle; 38cdf0e10cSrcweir import com.sun.star.awt.XWindow; 39cdf0e10cSrcweir import com.sun.star.beans.PropertyValue; 40cdf0e10cSrcweir import com.sun.star.beans.XPropertySet; 41cdf0e10cSrcweir import com.sun.star.container.XNameAccess; 42cdf0e10cSrcweir import com.sun.star.container.XNameContainer; 43cdf0e10cSrcweir import com.sun.star.frame.XModel; 44cdf0e10cSrcweir import com.sun.star.frame.XStorable; 45cdf0e10cSrcweir import com.sun.star.lang.XComponent; 46cdf0e10cSrcweir import com.sun.star.lang.XMultiServiceFactory; 47cdf0e10cSrcweir import com.sun.star.sdb.XDocumentDataSource; 48cdf0e10cSrcweir import com.sun.star.sdb.XQueryDefinitionsSupplier; 49cdf0e10cSrcweir import com.sun.star.sdbc.XConnection; 50cdf0e10cSrcweir import com.sun.star.sdbc.XIsolatedConnection; 51cdf0e10cSrcweir import com.sun.star.sdbc.XStatement; 52cdf0e10cSrcweir import com.sun.star.ucb.XSimpleFileAccess; 53cdf0e10cSrcweir import com.sun.star.uno.UnoRuntime; 54cdf0e10cSrcweir import com.sun.star.uno.XInterface; 55cdf0e10cSrcweir import util.DesktopTools; 56cdf0e10cSrcweir import util.utils; 57cdf0e10cSrcweir 58cdf0e10cSrcweir 59cdf0e10cSrcweir /** 60cdf0e10cSrcweir * Object implements the following interfaces : 61cdf0e10cSrcweir * <ul> 62cdf0e10cSrcweir * <li><code>::com::sun::star::accessibility::XAccessible</code></li> 63cdf0e10cSrcweir * <li><code>::com::sun::star::accessibility::XAccessibleContext 64cdf0e10cSrcweir * </code></li> 65cdf0e10cSrcweir * <li><code>::com::sun::star::accessibility::XAccessibleEventBroadcaster 66cdf0e10cSrcweir * </code></li> 67cdf0e10cSrcweir * </ul><p> 68cdf0e10cSrcweir * @see com.sun.star.accessibility.XAccessible 69cdf0e10cSrcweir * @see com.sun.star.accessibility.XAccessibleContext 70cdf0e10cSrcweir * @see com.sun.star.accessibility.XAccessibleEventBroadcaster 71cdf0e10cSrcweir * @see ifc.accessibility._XAccessible 72cdf0e10cSrcweir * @see ifc.accessibility._XAccessibleContext 73cdf0e10cSrcweir * @see ifc.accessibility._XAccessibleEventBroadcaster 74cdf0e10cSrcweir */ 75cdf0e10cSrcweir public class ConnectionLineAccessibility extends TestCase 76cdf0e10cSrcweir { 77cdf0e10cSrcweir XWindow xWindow = null; 78cdf0e10cSrcweir Object oDBSource = null; 79cdf0e10cSrcweir String aFile = ""; 80cdf0e10cSrcweir XConnection connection = null; 81cdf0e10cSrcweir XIsolatedConnection isolConnection = null; 82cdf0e10cSrcweir XComponent QueryComponent = null; 83cdf0e10cSrcweir String user = ""; 84cdf0e10cSrcweir String password=""; 85cdf0e10cSrcweir 86cdf0e10cSrcweir /** 87cdf0e10cSrcweir * Creates a new DataSource and stores it. 88cdf0e10cSrcweir * Creates a connection and using it 89cdf0e10cSrcweir * creates two tables in database. 90cdf0e10cSrcweir * Creates a new query and adds it to DefinitionContainer. 91cdf0e10cSrcweir * Opens the QueryComponent.with loadComponentFromURL 92cdf0e10cSrcweir * and gets the object with the role UNKNOWN and the Impplementation 93cdf0e10cSrcweir * name that contains ConnectionLine 94cdf0e10cSrcweir * @param Param test parameters 95cdf0e10cSrcweir * @param log writer to log information while testing 96cdf0e10cSrcweir * @return 97cdf0e10cSrcweir * @throws StatusException 98cdf0e10cSrcweir * @see TestEnvironment 99cdf0e10cSrcweir */ createTestEnvironment(TestParameters Param, PrintWriter log)100cdf0e10cSrcweir protected TestEnvironment createTestEnvironment(TestParameters Param, 101cdf0e10cSrcweir PrintWriter log) 102cdf0e10cSrcweir { 103cdf0e10cSrcweir XInterface oObj = null; 104cdf0e10cSrcweir 105cdf0e10cSrcweir Object oDBContext = null; 106cdf0e10cSrcweir Object oDBSource = null; 107cdf0e10cSrcweir Object newQuery = null; 108cdf0e10cSrcweir Object toolkit = null; 109cdf0e10cSrcweir XStorable store = null; 110cdf0e10cSrcweir 111cdf0e10cSrcweir try 112cdf0e10cSrcweir { 113cdf0e10cSrcweir oDBContext = ((XMultiServiceFactory) Param.getMSF()) 114cdf0e10cSrcweir .createInstance("com.sun.star.sdb.DatabaseContext"); 115cdf0e10cSrcweir oDBSource = ((XMultiServiceFactory) Param.getMSF()) 116cdf0e10cSrcweir .createInstance("com.sun.star.sdb.DataSource"); 117cdf0e10cSrcweir newQuery = ((XMultiServiceFactory) Param.getMSF()) 118cdf0e10cSrcweir .createInstance("com.sun.star.sdb.QueryDefinition"); 119cdf0e10cSrcweir toolkit = ((XMultiServiceFactory) Param.getMSF()) 120cdf0e10cSrcweir .createInstance("com.sun.star.awt.Toolkit"); 121cdf0e10cSrcweir } 122cdf0e10cSrcweir catch (com.sun.star.uno.Exception e) 123cdf0e10cSrcweir { 124cdf0e10cSrcweir e.printStackTrace(log); 125cdf0e10cSrcweir throw new StatusException(Status.failed("Couldn't create instance")); 126cdf0e10cSrcweir } 127cdf0e10cSrcweir 128cdf0e10cSrcweir String mysqlURL = (String) Param.get("mysql.url"); 129cdf0e10cSrcweir 130cdf0e10cSrcweir if (mysqlURL == null) 131cdf0e10cSrcweir { 132cdf0e10cSrcweir throw new StatusException(Status.failed( 133cdf0e10cSrcweir "Couldn't get 'mysql.url' from ini-file")); 134cdf0e10cSrcweir } 135cdf0e10cSrcweir 136cdf0e10cSrcweir user = (String) Param.get("jdbc.user"); 137cdf0e10cSrcweir password = (String) Param.get("jdbc.password"); 138cdf0e10cSrcweir 139cdf0e10cSrcweir if ((user == null) || (password == null)) 140cdf0e10cSrcweir { 141cdf0e10cSrcweir throw new StatusException(Status.failed( 142cdf0e10cSrcweir "Couldn't get 'jdbc.user' or 'jdbc.password' from ini-file")); 143cdf0e10cSrcweir } 144cdf0e10cSrcweir 145cdf0e10cSrcweir PropertyValue[] info = new PropertyValue[2]; 146cdf0e10cSrcweir info[0] = new PropertyValue(); 147cdf0e10cSrcweir info[0].Name = "user"; 148cdf0e10cSrcweir info[0].Value = user; 149cdf0e10cSrcweir info[1] = new PropertyValue(); 150cdf0e10cSrcweir info[1].Name = "password"; 151cdf0e10cSrcweir info[1].Value = password; 152cdf0e10cSrcweir 153cdf0e10cSrcweir XPropertySet propSetDBSource = (XPropertySet) UnoRuntime.queryInterface( 154cdf0e10cSrcweir XPropertySet.class, oDBSource); 155cdf0e10cSrcweir 156cdf0e10cSrcweir try 157cdf0e10cSrcweir { 158cdf0e10cSrcweir propSetDBSource.setPropertyValue("URL", mysqlURL); 159cdf0e10cSrcweir propSetDBSource.setPropertyValue("Info", info); 160cdf0e10cSrcweir } 161cdf0e10cSrcweir catch (com.sun.star.lang.WrappedTargetException e) 162cdf0e10cSrcweir { 163cdf0e10cSrcweir e.printStackTrace(log); 164cdf0e10cSrcweir throw new StatusException(Status.failed( 165cdf0e10cSrcweir "Couldn't set property value")); 166cdf0e10cSrcweir } 167cdf0e10cSrcweir catch (com.sun.star.lang.IllegalArgumentException e) 168cdf0e10cSrcweir { 169cdf0e10cSrcweir e.printStackTrace(log); 170cdf0e10cSrcweir throw new StatusException(Status.failed( 171cdf0e10cSrcweir "Couldn't set property value")); 172cdf0e10cSrcweir } 173cdf0e10cSrcweir catch (com.sun.star.beans.PropertyVetoException e) 174cdf0e10cSrcweir { 175cdf0e10cSrcweir e.printStackTrace(log); 176cdf0e10cSrcweir throw new StatusException(Status.failed( 177cdf0e10cSrcweir "Couldn't set property value")); 178cdf0e10cSrcweir } 179cdf0e10cSrcweir catch (com.sun.star.beans.UnknownPropertyException e) 180cdf0e10cSrcweir { 181cdf0e10cSrcweir e.printStackTrace(log); 182cdf0e10cSrcweir throw new StatusException(Status.failed( 183cdf0e10cSrcweir "Couldn't set property value")); 184cdf0e10cSrcweir } 185cdf0e10cSrcweir 186cdf0e10cSrcweir try 187cdf0e10cSrcweir { 188cdf0e10cSrcweir log.println("writing database file ..."); 189cdf0e10cSrcweir XDocumentDataSource xDDS = (XDocumentDataSource) 190cdf0e10cSrcweir UnoRuntime.queryInterface(XDocumentDataSource.class, oDBSource); 191cdf0e10cSrcweir store = (XStorable) UnoRuntime.queryInterface(XStorable.class, 192cdf0e10cSrcweir xDDS.getDatabaseDocument()); 193cdf0e10cSrcweir 194cdf0e10cSrcweir aFile = utils.getOfficeTemp((XMultiServiceFactory) Param.getMSF())+"ConnectionLine.odb"; 195cdf0e10cSrcweir log.println("... filename will be "+aFile); 196cdf0e10cSrcweir store.storeAsURL(aFile,new PropertyValue[] 197cdf0e10cSrcweir {}); 198cdf0e10cSrcweir log.println("... done"); 199cdf0e10cSrcweir } 200cdf0e10cSrcweir catch (com.sun.star.uno.Exception e) 201cdf0e10cSrcweir { 202cdf0e10cSrcweir e.printStackTrace(log); 203cdf0e10cSrcweir throw new StatusException(Status.failed("Couldn't register object")); 204cdf0e10cSrcweir } 205cdf0e10cSrcweir 206cdf0e10cSrcweir isolConnection = (XIsolatedConnection) UnoRuntime.queryInterface( 207cdf0e10cSrcweir XIsolatedConnection.class, 208cdf0e10cSrcweir oDBSource); 209cdf0e10cSrcweir 210cdf0e10cSrcweir XConnection connection = null; 211cdf0e10cSrcweir XStatement statement = null; 212cdf0e10cSrcweir 213cdf0e10cSrcweir final String tbl_name1 = "tst_table1"; 214cdf0e10cSrcweir final String tbl_name2 = "tst_table2"; 215cdf0e10cSrcweir final String col_name1 = "id1"; 216cdf0e10cSrcweir final String col_name2 = "id2"; 217cdf0e10cSrcweir 218cdf0e10cSrcweir try 219cdf0e10cSrcweir { 220cdf0e10cSrcweir connection = isolConnection.getIsolatedConnection(user, password); 221cdf0e10cSrcweir statement = connection.createStatement(); 222cdf0e10cSrcweir statement.executeUpdate("drop table if exists " + tbl_name1); 223cdf0e10cSrcweir statement.executeUpdate("drop table if exists " + tbl_name2); 224cdf0e10cSrcweir statement.executeUpdate("create table " + tbl_name1 + " (" + 225cdf0e10cSrcweir col_name1 + " int)"); 226cdf0e10cSrcweir statement.executeUpdate("create table " + tbl_name2 + " (" + 227cdf0e10cSrcweir col_name2 + " int)"); 228cdf0e10cSrcweir } 229cdf0e10cSrcweir catch (com.sun.star.sdbc.SQLException e) 230cdf0e10cSrcweir { 231cdf0e10cSrcweir try 232cdf0e10cSrcweir { 233cdf0e10cSrcweir shortWait(); 234cdf0e10cSrcweir connection = isolConnection.getIsolatedConnection(user, 235cdf0e10cSrcweir password); 236cdf0e10cSrcweir statement = connection.createStatement(); 237cdf0e10cSrcweir statement.executeUpdate("drop table if exists " + tbl_name1); 238cdf0e10cSrcweir statement.executeUpdate("drop table if exists " + tbl_name2); 239cdf0e10cSrcweir statement.executeUpdate("create table " + tbl_name1 + " (" + 240cdf0e10cSrcweir col_name1 + " int)"); 241cdf0e10cSrcweir statement.executeUpdate("create table " + tbl_name2 + " (" + 242cdf0e10cSrcweir col_name2 + " int)"); 243cdf0e10cSrcweir } 244cdf0e10cSrcweir catch (com.sun.star.sdbc.SQLException e2) 245cdf0e10cSrcweir { 246cdf0e10cSrcweir e2.printStackTrace(log); 247cdf0e10cSrcweir throw new StatusException(Status.failed("SQLException")); 248cdf0e10cSrcweir } 249cdf0e10cSrcweir } 250cdf0e10cSrcweir 251cdf0e10cSrcweir XQueryDefinitionsSupplier querySuppl = (XQueryDefinitionsSupplier) UnoRuntime.queryInterface( 252cdf0e10cSrcweir XQueryDefinitionsSupplier.class, 253cdf0e10cSrcweir oDBSource); 254cdf0e10cSrcweir 255cdf0e10cSrcweir XNameAccess defContainer = querySuppl.getQueryDefinitions(); 256cdf0e10cSrcweir 257cdf0e10cSrcweir XPropertySet queryProp = (XPropertySet) UnoRuntime.queryInterface( 258cdf0e10cSrcweir XPropertySet.class, newQuery); 259cdf0e10cSrcweir 260cdf0e10cSrcweir try 261cdf0e10cSrcweir { 262cdf0e10cSrcweir final String query = "select * from " + tbl_name1 + ", " + 263cdf0e10cSrcweir tbl_name2 + " where " + tbl_name1 + "." + 264cdf0e10cSrcweir col_name1 + "=" + tbl_name2 + "." + 265cdf0e10cSrcweir col_name2; 266cdf0e10cSrcweir queryProp.setPropertyValue("Command", query); 267cdf0e10cSrcweir } 268cdf0e10cSrcweir catch (com.sun.star.lang.WrappedTargetException e) 269cdf0e10cSrcweir { 270cdf0e10cSrcweir e.printStackTrace(log); 271cdf0e10cSrcweir throw new StatusException(Status.failed( 272cdf0e10cSrcweir "Couldn't set property value")); 273cdf0e10cSrcweir } 274cdf0e10cSrcweir catch (com.sun.star.lang.IllegalArgumentException e) 275cdf0e10cSrcweir { 276cdf0e10cSrcweir e.printStackTrace(log); 277cdf0e10cSrcweir throw new StatusException(Status.failed( 278cdf0e10cSrcweir "Couldn't set property value")); 279cdf0e10cSrcweir } 280cdf0e10cSrcweir catch (com.sun.star.beans.PropertyVetoException e) 281cdf0e10cSrcweir { 282cdf0e10cSrcweir e.printStackTrace(log); 283cdf0e10cSrcweir throw new StatusException(Status.failed( 284cdf0e10cSrcweir "Couldn't set property value")); 285cdf0e10cSrcweir } 286cdf0e10cSrcweir catch (com.sun.star.beans.UnknownPropertyException e) 287cdf0e10cSrcweir { 288cdf0e10cSrcweir e.printStackTrace(log); 289cdf0e10cSrcweir throw new StatusException(Status.failed( 290cdf0e10cSrcweir "Couldn't set property value")); 291cdf0e10cSrcweir } 292cdf0e10cSrcweir 293cdf0e10cSrcweir XNameContainer queryContainer = (XNameContainer) UnoRuntime.queryInterface( 294cdf0e10cSrcweir XNameContainer.class, 295cdf0e10cSrcweir defContainer); 296cdf0e10cSrcweir 297cdf0e10cSrcweir try 298cdf0e10cSrcweir { 299cdf0e10cSrcweir queryContainer.insertByName("Query1", newQuery); 300cdf0e10cSrcweir store.store(); 301cdf0e10cSrcweir connection.close(); 302cdf0e10cSrcweir } 303cdf0e10cSrcweir catch (com.sun.star.lang.WrappedTargetException e) 304cdf0e10cSrcweir { 305cdf0e10cSrcweir e.printStackTrace(log); 306cdf0e10cSrcweir throw new StatusException(Status.failed("Couldn't insert query")); 307cdf0e10cSrcweir } 308cdf0e10cSrcweir catch (com.sun.star.container.ElementExistException e) 309cdf0e10cSrcweir { 310cdf0e10cSrcweir e.printStackTrace(log); 311cdf0e10cSrcweir throw new StatusException(Status.failed("Couldn't insert query")); 312cdf0e10cSrcweir } 313cdf0e10cSrcweir catch (com.sun.star.lang.IllegalArgumentException e) 314cdf0e10cSrcweir { 315cdf0e10cSrcweir e.printStackTrace(log); 316cdf0e10cSrcweir throw new StatusException(Status.failed("Couldn't insert query")); 317cdf0e10cSrcweir } 318cdf0e10cSrcweir catch (com.sun.star.io.IOException e) 319cdf0e10cSrcweir { 320cdf0e10cSrcweir e.printStackTrace(log); 321cdf0e10cSrcweir throw new StatusException(Status.failed("Couldn't insert query")); 322cdf0e10cSrcweir } 323cdf0e10cSrcweir catch (com.sun.star.sdbc.SQLException e) 324cdf0e10cSrcweir { 325cdf0e10cSrcweir e.printStackTrace(log); 326cdf0e10cSrcweir throw new StatusException(Status.failed("Couldn't insert query")); 327cdf0e10cSrcweir } 328cdf0e10cSrcweir 329cdf0e10cSrcweir PropertyValue[] loadProps = new PropertyValue[3]; 330cdf0e10cSrcweir loadProps[0] = new PropertyValue(); 331cdf0e10cSrcweir loadProps[0].Name = "QueryDesignView"; 332cdf0e10cSrcweir loadProps[0].Value = Boolean.TRUE; 333cdf0e10cSrcweir 334cdf0e10cSrcweir loadProps[1] = new PropertyValue(); 335cdf0e10cSrcweir loadProps[1].Name = "CurrentQuery"; 336cdf0e10cSrcweir loadProps[1].Value = "Query1"; 337cdf0e10cSrcweir 338cdf0e10cSrcweir loadProps[2] = new PropertyValue(); 339cdf0e10cSrcweir loadProps[2].Name = "DataSource"; 340cdf0e10cSrcweir loadProps[2].Value = oDBSource; 341cdf0e10cSrcweir 342cdf0e10cSrcweir QueryComponent = DesktopTools.loadDoc((XMultiServiceFactory) Param.getMSF(),".component:DB/QueryDesign",loadProps); 343cdf0e10cSrcweir 344cdf0e10cSrcweir util.utils.shortWait(1000); 345cdf0e10cSrcweir 346cdf0e10cSrcweir xWindow = UnoRuntime.queryInterface(XModel.class, QueryComponent). 347cdf0e10cSrcweir getCurrentController().getFrame().getContainerWindow(); 348cdf0e10cSrcweir 349cdf0e10cSrcweir XAccessible xRoot = AccessibilityTools.getAccessibleObject(xWindow); 350cdf0e10cSrcweir 351cdf0e10cSrcweir AccessibilityTools.printAccessibleTree (log,xRoot, Param.getBool(util.PropertyName.DEBUG_IS_ACTIVE)); 352cdf0e10cSrcweir 353cdf0e10cSrcweir oObj = AccessibilityTools.getAccessibleObjectForRoleIgnoreShowing(xRoot, AccessibleRole.UNKNOWN, "", "ConnectionLine"); 354cdf0e10cSrcweir 355cdf0e10cSrcweir log.println("ImplementationName " + util.utils.getImplName(oObj)); 356cdf0e10cSrcweir 357cdf0e10cSrcweir log.println("creating TestEnvironment"); 358cdf0e10cSrcweir 359cdf0e10cSrcweir TestEnvironment tEnv = new TestEnvironment(oObj); 360cdf0e10cSrcweir 361cdf0e10cSrcweir shortWait(); 362cdf0e10cSrcweir 363cdf0e10cSrcweir final XWindow queryWin = xWindow; 364cdf0e10cSrcweir 365cdf0e10cSrcweir tEnv.addObjRelation("EventProducer", 366cdf0e10cSrcweir new ifc.accessibility._XAccessibleEventBroadcaster.EventProducer() 367cdf0e10cSrcweir { 368cdf0e10cSrcweir public void fireEvent() 369cdf0e10cSrcweir { 370cdf0e10cSrcweir Rectangle rect = queryWin.getPosSize(); 371cdf0e10cSrcweir queryWin.setPosSize(rect.X, rect.Y, rect.Height-5, rect.Width-5, PosSize.POSSIZE); 372cdf0e10cSrcweir } 373cdf0e10cSrcweir }); 374cdf0e10cSrcweir 375cdf0e10cSrcweir return tEnv; 376cdf0e10cSrcweir } // finish method getTestEnvironment 377cdf0e10cSrcweir 378cdf0e10cSrcweir /** 379cdf0e10cSrcweir * Closes the DatasourceAdministration dialog and Query Dialog. 380cdf0e10cSrcweir */ cleanup(TestParameters Param, PrintWriter log)381cdf0e10cSrcweir protected void cleanup(TestParameters Param, PrintWriter log) 382cdf0e10cSrcweir { 383cdf0e10cSrcweir try 384cdf0e10cSrcweir { 385cdf0e10cSrcweir 386cdf0e10cSrcweir log.println("closing QueryComponent ..."); 387cdf0e10cSrcweir DesktopTools.closeDoc(QueryComponent); 388cdf0e10cSrcweir log.println("... done"); 389cdf0e10cSrcweir XMultiServiceFactory xMSF = (XMultiServiceFactory)Param.getMSF(); 390cdf0e10cSrcweir Object sfa = xMSF.createInstance("com.sun.star.comp.ucb.SimpleFileAccess"); 391cdf0e10cSrcweir XSimpleFileAccess xSFA = (XSimpleFileAccess) UnoRuntime.queryInterface(XSimpleFileAccess.class, sfa); 392cdf0e10cSrcweir log.println("deleting database file"); 393cdf0e10cSrcweir xSFA.kill(aFile); 394cdf0e10cSrcweir log.println("Could delete file "+aFile+": "+!xSFA.exists(aFile)); 395cdf0e10cSrcweir } 396cdf0e10cSrcweir catch (Exception e) 397cdf0e10cSrcweir { 398cdf0e10cSrcweir e.printStackTrace(); 399cdf0e10cSrcweir } 400cdf0e10cSrcweir } 401cdf0e10cSrcweir 402cdf0e10cSrcweir /** 403cdf0e10cSrcweir * Sleeps for 1.5 sec. to allow StarOffice to react on <code> 404cdf0e10cSrcweir * reset</code> call. 405cdf0e10cSrcweir */ shortWait()406cdf0e10cSrcweir private void shortWait() 407cdf0e10cSrcweir { 408cdf0e10cSrcweir try 409cdf0e10cSrcweir { 410cdf0e10cSrcweir Thread.sleep(1500); 411cdf0e10cSrcweir } 412cdf0e10cSrcweir catch (InterruptedException e) 413cdf0e10cSrcweir { 414cdf0e10cSrcweir log.println("While waiting :" + e); 415cdf0e10cSrcweir } 416cdf0e10cSrcweir } 417cdf0e10cSrcweir } 418