qadevOOo/tests/java/ifc/sdbc/_XWarningsSupplier.java

   1 /*************************************************************************
   2  *
   3  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   4  *
   5  * Copyright 2000, 2010 Oracle and/or its affiliates.
   6  *
   7  * OpenOffice.org - a multi-platform office productivity suite
   8  *
   9  * This file is part of OpenOffice.org.
  10  *
  11  * OpenOffice.org is free software: you can redistribute it and/or modify
  12  * it under the terms of the GNU Lesser General Public License version 3
  13  * only, as published by the Free Software Foundation.
  14  *
  15  * OpenOffice.org is distributed in the hope that it will be useful,
  16  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  17  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  18  * GNU Lesser General Public License version 3 for more details
  19  * (a copy is included in the LICENSE file that accompanied this code).
  20  *
  21  * You should have received a copy of the GNU Lesser General Public License
  22  * version 3 along with OpenOffice.org.  If not, see
  23  * <http://www.openoffice.org/license.html>
  24  * for a copy of the LGPLv3 License.
  25  *
  26  ************************************************************************/
  27
  28 package ifc.sdbc;
  29
  30 import lib.MultiMethodTest;
  31 import lib.Status;
  32 import lib.StatusException;
  33 import util.DBTools;
  34 import util.utils;
  35
  36 import com.sun.star.sdbc.SQLException;
  37 import com.sun.star.sdbc.XResultSetUpdate;
  38 import com.sun.star.sdbc.XRow;
  39 import com.sun.star.sdbc.XRowUpdate;
  40 import com.sun.star.sdbc.XWarningsSupplier;
  41 import com.sun.star.uno.UnoRuntime;
  42
  43 /**
  44 * Testing <code>com.sun.star.sdbc.XWarningsSupplier</code>
  45 * interface methods :
  46 * <ul>
  47 *  <li><code> getWarnings()</code></li>
  48 *  <li><code> clearWarnings()</code></li>
  49 * </ul> <p>
  50 * @see com.sun.star.sdbc.XWarningsSupplier
  51 */
  52 public class _XWarningsSupplier extends MultiMethodTest {
  53
  54     // oObj filled by MultiMethodTest
  55     public XWarningsSupplier oObj = null ;
  56
  57     /**
  58     * Updates value of int column by value '9999999999999999'.
  59     * Calls method and checks returned value. <p>
  60     * Has OK status if the method return not empty value.
  61     */
  62     public void _getWarnings() {
  63         final XRowUpdate rowUpdate = UnoRuntime.queryInterface(XRowUpdate.class, oObj);
  64         final XResultSetUpdate resultSetUpdate = UnoRuntime.queryInterface(XResultSetUpdate.class, rowUpdate);
  65         final XRow row = UnoRuntime.queryInterface(XRow.class, resultSetUpdate);
  66         if ( row == null)
  67             throw new StatusException(Status.failed("Test must be modified"));
  68
  69         // not sure what the below test was intended to test, but it actually fails with an SQLException (which is
  70         // correct for what is done there), and thus makes the complete interface test fail (which is not correct)
  71         // So, for the moment, just let the test succeed all the time - until issue #i84235# is fixed
  72
  73         if ( false )
  74         {
  75             int oldVal = 0, newVal = 0;
  76             String valToSet = "9999999999999999";
  77             try
  78             {
  79                 oldVal = row.getInt(DBTools.TST_INT);
  80                 rowUpdate.updateString(DBTools.TST_INT, valToSet);
  81                 resultSetUpdate.updateRow();
  82                 newVal = row.getInt(DBTools.TST_INT);
  83             }
  84             catch(com.sun.star.sdbc.SQLException e)
  85             {
  86                 log.println("Unexpected SQL exception");
  87                 e.printStackTrace(log);
  88                 tRes.tested("getWarnings()", false);
  89                 return;
  90             }
  91
  92             log.println("Old INT value: " + oldVal);
  93             log.println("Value that was set: " + valToSet);
  94             log.println("New INT value: " + newVal);
  95
  96             boolean res = false;
  97
  98             try
  99             {
 100                 Object warns = oObj.getWarnings();
 101                 res = (!utils.isVoid(warns));
 102             }
 103             catch (SQLException e)
 104             {
 105                 log.println("Exception occurred :");
 106                 e.printStackTrace(log);
 107                 tRes.tested("getWarnings()", res);
 108                 return;
 109             }
 110             tRes.tested("getWarnings()", res);
 111         }
 112         else
 113             tRes.tested( "getWarnings()", true );
 114     }
 115
 116     /**
 117     * Calls method and checks value returned by the method
 118     * <code>getWarnings()</code>. <p>
 119     * Has OK status if the method <code>getWarnings()</code> return void value.
 120     */
 121     public void _clearWarnings() {
 122         executeMethod("getWarnings()");
 123         boolean res = false;
 124
 125         try {
 126             oObj.clearWarnings();
 127             Object warns = oObj.getWarnings();
 128             res = (utils.isVoid(warns));
 129         } catch (SQLException e) {
 130             log.println("Exception occurred :");
 131             e.printStackTrace(log);
 132             tRes.tested("clearWarnings()", res);
 133             return;
 134         }
 135
 136         tRes.tested("clearWarnings()", res);
 137     }
 138
 139 }