Adding upstream version 4:7.4.7.upstream/4%7.4.7upstream

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>

16 files changed, 3754 insertions, 0 deletions

diff --git a/qadevOOo/tests/java/ifc/sdbc/_ResultSet.java b/qadevOOo/tests/java/ifc/sdbc/_ResultSet.java
new file mode 100644
index 000000000..56724524e
--- /dev/null
+++ b/qadevOOo/tests/java/ifc/sdbc/_ResultSet.java
@@ -0,0 +1,40 @@
+/*
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ *   Licensed to the Apache Software Foundation (ASF) under one or more
+ *   contributor license agreements. See the NOTICE file distributed
+ *   with this work for additional information regarding copyright
+ *   ownership. The ASF licenses this file to you under the Apache
+ *   License, Version 2.0 (the "License"); you may not use this file
+ *   except in compliance with the License. You may obtain a copy of
+ *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ */
+
+package ifc.sdbc;
+
+import lib.MultiPropertyTest;
+
+/**
+* Testing <code>com.sun.star.sdbc.ResultSet</code>
+* service properties :
+* <ul>
+*  <li><code> CursorName</code></li>
+*  <li><code> ResultSetConcurrency</code></li>
+*  <li><code> ResultSetType</code></li>
+*  <li><code> FetchDirection</code></li>
+*  <li><code> FetchSize</code></li>
+* </ul> <p>
+* Properties testing is automated by <code>lib.MultiPropertyTest</code>.
+* @see com.sun.star.sdbc.ResultSet
+*/
+public class _ResultSet extends MultiPropertyTest {
+
+
+}  // finish class _ResultSet
+
diff --git a/qadevOOo/tests/java/ifc/sdbc/_RowSet.java b/qadevOOo/tests/java/ifc/sdbc/_RowSet.java
new file mode 100644
index 000000000..fae52a637
--- /dev/null
+++ b/qadevOOo/tests/java/ifc/sdbc/_RowSet.java
@@ -0,0 +1,72 @@
+/*
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ *   Licensed to the Apache Software Foundation (ASF) under one or more
+ *   contributor license agreements. See the NOTICE file distributed
+ *   with this work for additional information regarding copyright
+ *   ownership. The ASF licenses this file to you under the Apache
+ *   License, Version 2.0 (the "License"); you may not use this file
+ *   except in compliance with the License. You may obtain a copy of
+ *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ */
+
+package ifc.sdbc;
+
+import lib.MultiPropertyTest;
+
+import com.sun.star.uno.Any;
+
+
+/**
+* Testing <code>com.sun.star.sdbc.RowSet</code>
+* service properties :
+* <ul>
+*  <li><code> DataSourceName</code></li>
+*  <li><code> URL</code></li>
+*  <li><code> Command</code></li>
+*  <li><code> TransactionIsolation</code></li>
+*  <li><code> TypeMap</code></li>
+*  <li><code> EscapeProcessing</code></li>
+*  <li><code> QueryTimeOut</code></li>
+*  <li><code> MaxFieldSize</code></li>
+*  <li><code> MaxRows</code></li>
+*  <li><code> User</code></li>
+*  <li><code> Password</code></li>
+*  <li><code> ResultSetType</code></li>
+* </ul> <p>
+* Properties testing is automated by <code>lib.MultiPropertyTest</code>.
+* @see com.sun.star.sdbc.RowSet
+*/
+public class _RowSet extends MultiPropertyTest {
+
+    /**
+    * Redefined method returns object, that contains changed property value.
+    */
+    public void _TypeMap() {
+        boolean result = false;
+        try {
+            Any TypeMap = (Any) oObj.getPropertyValue("TypeMap");
+            String TypeName = TypeMap.getType().getTypeName();
+            String expected = "com.sun.star.container.XNameAccess";
+            result = TypeName.equals(expected);
+            if (! result ) {
+                log.println("Expected Type is "+expected);
+                log.println("but the returned is "+TypeName);
+            }
+        } catch(com.sun.star.lang.WrappedTargetException e) {
+            log.println("Exception " + e.getMessage());
+        } catch(com.sun.star.beans.UnknownPropertyException e) {
+            log.println("Exception " + e.getMessage());
+        }
+
+        tRes.tested("TypeMap",result);
+    }
+
+}  // finish class _RowSet
+
diff --git a/qadevOOo/tests/java/ifc/sdbc/_XCloseable.java b/qadevOOo/tests/java/ifc/sdbc/_XCloseable.java
new file mode 100644
index 000000000..efd39fd1f
--- /dev/null
+++ b/qadevOOo/tests/java/ifc/sdbc/_XCloseable.java
@@ -0,0 +1,85 @@
+/*
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ *   Licensed to the Apache Software Foundation (ASF) under one or more
+ *   contributor license agreements. See the NOTICE file distributed
+ *   with this work for additional information regarding copyright
+ *   ownership. The ASF licenses this file to you under the Apache
+ *   License, Version 2.0 (the "License"); you may not use this file
+ *   except in compliance with the License. You may obtain a copy of
+ *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ */
+
+package ifc.sdbc;
+
+import lib.MultiMethodTest;
+import lib.StatusException;
+
+import com.sun.star.sdbc.SQLException;
+import com.sun.star.sdbc.XCloseable;
+import com.sun.star.sdbc.XResultSet;
+import com.sun.star.uno.UnoRuntime;
+
+/**
+* Testing <code>com.sun.star.sdbc.XCloseable</code>
+* interface methods :
+* <ul>
+*  <li><code> close()</code></li>
+* </ul> <p>
+* After test object must be recreated.
+* @see com.sun.star.sdbc.XCloseable
+*/
+public class _XCloseable extends MultiMethodTest {
+
+    // oObj filled by MultiMethodTest
+    public XCloseable oObj = null ;
+
+    /**
+    * Closes row set. If the component implements the interface
+    * <code>com.sun.star.sdbc.XResultSet</code> then tries to move
+    * the cursor to the first row in the result set.
+    * Has OK status if no exceptions were thrown during first call and
+    * if expected SQL exception was thrown during cursor moving.
+    */
+    public void _close() throws StatusException {
+        boolean res = false;
+        try {
+            oObj.close();
+            res = true;
+        } catch (SQLException e) {
+            log.println("Unexpected SQL Exception occurred:" + e) ;
+            res = false;
+        }
+
+        XResultSet resSet = UnoRuntime.queryInterface(XResultSet.class, oObj);
+
+        if (resSet != null) {
+            try {
+                resSet.first();
+                log.println("Expected SQLException not occurred !");
+                res = false;
+            } catch(SQLException e) {
+                log.println("Expected SQLException occurred");
+                res = true;
+            }
+        }
+
+        tRes.tested("close()", res);
+    }
+
+    /**
+    * Forces environment recreation.
+    */
+    @Override
+    public void after() {
+        disposeEnvironment() ;
+    }
+
+}  // finish class _XCloseable
+
diff --git a/qadevOOo/tests/java/ifc/sdbc/_XColumnLocate.java b/qadevOOo/tests/java/ifc/sdbc/_XColumnLocate.java
new file mode 100644
index 000000000..f1d57c5b7
--- /dev/null
+++ b/qadevOOo/tests/java/ifc/sdbc/_XColumnLocate.java
@@ -0,0 +1,76 @@
+/*
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ *   Licensed to the Apache Software Foundation (ASF) under one or more
+ *   contributor license agreements. See the NOTICE file distributed
+ *   with this work for additional information regarding copyright
+ *   ownership. The ASF licenses this file to you under the Apache
+ *   License, Version 2.0 (the "License"); you may not use this file
+ *   except in compliance with the License. You may obtain a copy of
+ *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ */
+
+package ifc.sdbc;
+
+import lib.MultiMethodTest;
+import lib.Status;
+import lib.StatusException;
+
+import com.sun.star.sdbc.SQLException;
+import com.sun.star.sdbc.XColumnLocate;
+
+/**
+/**
+* Testing <code>com.sun.star.sdbc.XColumnLocate</code>
+* interface methods :
+* <ul>
+*  <li><code> findColumn()</code></li>
+* </ul> <p>
+* The test required the following relations :
+* <ul>
+* <li> <code> XColumnLocate.ColumnName </code> : The name of the first
+* column. </li>
+* </ul>
+* @see com.sun.star.sdbc.XColumnLocate
+*/
+public class _XColumnLocate extends MultiMethodTest {
+
+    // oObj filled by MultiMethodTest
+    public XColumnLocate oObj = null ;
+
+    /**
+    * Using column name from object relation trying to find out
+    * the index of this column. <p>
+    * Has OK status if column index returned by method equals to 1,
+    * FAILED otherwise.
+    */
+    public void _findColumn() {
+        boolean result = false ;
+        String colName = (String) tEnv.getObjRelation("XColumnLocate.ColumnName") ;
+
+        if (colName == null) {
+            throw new StatusException(
+                Status.failed("Object relation 'XColumnLocate.ColumnName' " +
+                    "for this interface not found"));
+        }
+
+        try {
+            int colIdx = oObj.findColumn(colName) ;
+            result = colIdx == 1 ;
+        } catch (SQLException e) {
+            log.println("Exception occurred:");
+            e.printStackTrace(log);
+            result = false;
+        }
+
+        tRes.tested("findColumn()", result);
+    }
+
+}  // finish class _XColumnLocate
+
diff --git a/qadevOOo/tests/java/ifc/sdbc/_XDataSource.java b/qadevOOo/tests/java/ifc/sdbc/_XDataSource.java
new file mode 100644
index 000000000..304ea7ded
--- /dev/null
+++ b/qadevOOo/tests/java/ifc/sdbc/_XDataSource.java
@@ -0,0 +1,105 @@
+/*
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ *   Licensed to the Apache Software Foundation (ASF) under one or more
+ *   contributor license agreements. See the NOTICE file distributed
+ *   with this work for additional information regarding copyright
+ *   ownership. The ASF licenses this file to you under the Apache
+ *   License, Version 2.0 (the "License"); you may not use this file
+ *   except in compliance with the License. You may obtain a copy of
+ *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ */
+
+package ifc.sdbc;
+
+import lib.MultiMethodTest;
+
+import com.sun.star.sdbc.XConnection;
+import com.sun.star.sdbc.XDataSource;
+
+/**
+* Testing <code>com.sun.star.sdbc.XDataSource</code>
+* interface methods :
+* <ul>
+*  <li><code>getConnection()</code></li>
+*  <li><code>setLoginTimeout()</code></li>
+*  <li><code>getLoginTimeout()</code></li>
+* </ul> <p>
+* @see com.sun.star.sdbc.XDataSource
+*/
+public class _XDataSource extends MultiMethodTest {
+    // oObj filled by MultiMethodTest
+    public XDataSource oObj = null;
+
+    /**
+     * Calls the method and checks returned value.
+     * Has OK status if exception wasn't thrown and
+     * if returned value isn't null.
+     */
+    public void _getConnection() {
+        boolean res = true;
+
+        try {
+            XConnection connection = oObj.getConnection("", "");
+            res = connection != null;
+        } catch(com.sun.star.sdbc.SQLException e) {
+            log.println("Unexpected exception:");
+            e.printStackTrace(log);
+            res = false;
+        }
+
+        tRes.tested("getConnection()", res);
+    }
+
+    /**
+     * Sets new timeout, compares with timeout returned by the method
+     * <code>getLoginTimeout()</code>.
+     * Has OK status if exception wasn't thrown and if timeout values are equal.
+     */
+    public void _setLoginTimeout() {
+        requiredMethod("getLoginTimeout()");
+        boolean res = true;
+
+        try {
+            final int TO = 111;
+            log.println("setLoginTimeout(" + TO +  ")");
+            oObj.setLoginTimeout(TO);
+            int timeout = oObj.getLoginTimeout();
+            res = timeout == TO;
+            log.println("getLoginTimeout(): " + timeout);
+        } catch(com.sun.star.sdbc.SQLException e) {
+            log.println("Unexpected exception:");
+            e.printStackTrace(log);
+            res = false;
+        }
+
+        tRes.tested("setLoginTimeout()", res);
+    }
+
+    /**
+     * Calls the method and checks returned value.
+     * Has OK status if exception wasn't thrown and
+     * if returned value is equal to zero.
+     */
+    public void _getLoginTimeout() {
+        boolean res = true;
+
+        try {
+            int timeout = oObj.getLoginTimeout();
+            log.println("getLoginTimeout(): " + timeout);
+            res = timeout == 0;
+        } catch(com.sun.star.sdbc.SQLException e) {
+            log.println("Unexpected exception:");
+            e.printStackTrace(log);
+            res = false;
+        }
+
+        tRes.tested("getLoginTimeout()", res);
+    }
+}
\ No newline at end of file
diff --git a/qadevOOo/tests/java/ifc/sdbc/_XDriver.java b/qadevOOo/tests/java/ifc/sdbc/_XDriver.java
new file mode 100644
index 000000000..4b0eb147f
--- /dev/null
+++ b/qadevOOo/tests/java/ifc/sdbc/_XDriver.java
@@ -0,0 +1,205 @@
+/*
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ *   Licensed to the Apache Software Foundation (ASF) under one or more
+ *   contributor license agreements. See the NOTICE file distributed
+ *   with this work for additional information regarding copyright
+ *   ownership. The ASF licenses this file to you under the Apache
+ *   License, Version 2.0 (the "License"); you may not use this file
+ *   except in compliance with the License. You may obtain a copy of
+ *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ */
+
+package ifc.sdbc;
+
+import lib.MultiMethodTest;
+import lib.Status;
+import lib.StatusException;
+
+import com.sun.star.beans.PropertyValue;
+import com.sun.star.sdbc.DriverPropertyInfo;
+import com.sun.star.sdbc.SQLException;
+import com.sun.star.sdbc.XConnection;
+import com.sun.star.sdbc.XDriver;
+
+/**
+* Testing <code>com.sun.star.sdbc.XDriver</code>
+* interface methods :
+* <ul>
+*  <li><code> connect()</code></li>
+*  <li><code> acceptsURL()</code></li>
+*  <li><code> getPropertyInfo()</code></li>
+*  <li><code> getMajorVersion()</code></li>
+*  <li><code> getMinorVersion()</code></li>
+* </ul> <p>
+* Required object relations :
+* <ul>
+* <li> <code>'XDriver.URL'</code>:
+*      is the URL of the database to which to connect</code></li>
+* <li><code>'XDriver.UNSUITABLE_URL'</code>:
+*      the wrong kind of URL to connect using given driver</li>
+* <li><code>'XDriver.INFO'</code>:
+*      a list of arbitrary string tag/value pairs as connection arguments</li>
+* </ul> <p>
+* @see com.sun.star.sdbc.XDriver
+*/
+public class _XDriver extends MultiMethodTest {
+    // oObj filled by MultiMethodTest
+    public XDriver oObj = null;
+    String url = null;
+    String wrongUrl = null;
+    String nbu = null;
+    PropertyValue[] info = null;
+
+    /**
+    * Retrieves relations.
+    * @throw StatusException If any relation not found.
+    */
+    @Override
+    protected void before() {
+        nbu = (String) tEnv.getObjRelation("NoBadURL");
+        url = (String)tEnv.getObjRelation("XDriver.URL");
+        if (url == null) {
+            throw new StatusException(Status.failed(
+                "Couldn't get relation 'XDriver.URL'"));
+        }
+        wrongUrl = (String)tEnv.getObjRelation("XDriver.UNSUITABLE_URL");
+        if (wrongUrl == null) {
+            throw new StatusException(Status.failed(
+                "Couldn't get relation 'XDriver.WRONG_URL'"));
+        }
+        info = (PropertyValue[])tEnv.getObjRelation("XDriver.INFO");
+        if (info == null) {
+            throw new StatusException(Status.failed(
+                "Couldn't get relation 'XDriver.INFO'"));
+        }
+    }
+
+    /**
+    * Connects to <code>'XDriver.URL'</code>,
+    * to <code>'XDriver.UNSUITABLE_URL'</code> and to wrong URL using
+    * <code>'XDriver.INFO'</code>.
+    * Has OK status if the method returns not null for <code>'XDriver.URL'</code>,
+    * null for <code>'XDriver.UNSUITABLE_URL'</code> and
+    * exception was thrown during the call with a wrong URL.
+    */
+    public void _connect() {
+        boolean res = true;
+
+        try {
+            log.println("Trying to connect to " + url);
+            XConnection connection = oObj.connect(url, info);
+            res = (connection != null);
+            log.println("Connected? " + res);
+            log.println("Trying to connect to " + wrongUrl);
+            connection = oObj.connect(wrongUrl, info);
+            res &= (connection == null);
+            log.println("Connected? " + !res);
+        } catch(SQLException e) {
+            log.println("Unexpected exception");
+            res &= false;
+        }
+
+        if (nbu==null) {
+            try {
+                String badUrl = url + "bla";
+                log.println("Trying to connect to " + badUrl);
+                oObj.connect(badUrl, info);
+                res &= false;
+                log.println("Expected exception isn't thrown");
+            } catch(SQLException e) {
+                log.println("Expected exception");
+                res &= true;
+            }
+        }
+
+        tRes.tested("connect()", res);
+    }
+
+    /**
+    * Calls the method for <code>'XDriver.URL'</code> and
+    * for <code>'XDriver.UNSUITABLE_URL'</code>.
+    * Has OK status if the method returns true for <code>'XDriver.URL'</code>
+    * and false for <code>'XDriver.UNSUITABLE_URL'</code>.
+    */
+    public void _acceptsURL() {
+        boolean res = false;
+
+        try {
+            res = oObj.acceptsURL(url);
+            log.println("Accepts " + url + "? " + res);
+            res &= !oObj.acceptsURL(wrongUrl);
+            log.println("Accepts " + wrongUrl + "? " + !res);
+        } catch(SQLException e) {
+            log.println("Unexpected exception");
+            e.printStackTrace(log);
+            res = false;
+        }
+
+        tRes.tested("acceptsURL()", res);
+    }
+
+    /**
+    * Calls the method with passed <code>'XDriver.URL'</code> and
+    * <code>'XDriver.INFO'</code>. Prints obtained driver properties info
+    * to log.
+    * Has OK status if returned value isn't null.
+    */
+    public void _getPropertyInfo() {
+        requiredMethod("acceptsURL()");
+        boolean res = false;
+        DriverPropertyInfo[] dpi = null;
+        try {
+            dpi = oObj.getPropertyInfo(url, info);
+        } catch(SQLException e) {
+            log.println("Unexpected exception");
+            e.printStackTrace(log);
+            res = false;
+        }
+
+        if (dpi != null) {
+            res = true;
+            log.println("Driver properties info:");
+            for(int i = 0; i < dpi.length; i++) {
+                log.println("Property: " + dpi[i].Name);
+                log.println("Description: " + dpi[i].Description);
+                log.println("IsRequired? " + dpi[i].IsRequired);
+                log.println("Value: " + dpi[i].Value);
+                log.println("Choices: ");
+                for(int j = 0; j < dpi[i].Choices.length; j++) {
+                    log.println("\t" + dpi[i].Choices[j]);
+                }
+            }
+        }
+
+        tRes.tested("getPropertyInfo()", res);
+    }
+
+    /**
+    * Calls the method.
+    * Has OK status if returned value is greater than or is equal to 1.
+    */
+    public void _getMajorVersion() {
+        int majorVer = oObj.getMajorVersion();
+        boolean res = majorVer >= 1;
+        log.println("Major version " + majorVer);
+        tRes.tested("getMajorVersion()", res);
+    }
+
+    /**
+    * Calls the method.
+    * Has OK status if returned value is greater than or is equal to 0.
+    */
+    public void _getMinorVersion() {
+        int minorVer = oObj.getMinorVersion();
+        boolean res = minorVer >= 0;
+        log.println("Minor version " + minorVer);
+        tRes.tested("getMinorVersion()", res);
+    }
+}
\ No newline at end of file
diff --git a/qadevOOo/tests/java/ifc/sdbc/_XDriverManager.java b/qadevOOo/tests/java/ifc/sdbc/_XDriverManager.java
new file mode 100644
index 000000000..57477b4a7
--- /dev/null
+++ b/qadevOOo/tests/java/ifc/sdbc/_XDriverManager.java
@@ -0,0 +1,152 @@
+/*
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ *   Licensed to the Apache Software Foundation (ASF) under one or more
+ *   contributor license agreements. See the NOTICE file distributed
+ *   with this work for additional information regarding copyright
+ *   ownership. The ASF licenses this file to you under the Apache
+ *   License, Version 2.0 (the "License"); you may not use this file
+ *   except in compliance with the License. You may obtain a copy of
+ *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ */
+
+package ifc.sdbc;
+
+import lib.MultiMethodTest;
+import lib.Status;
+import lib.StatusException;
+
+import com.sun.star.beans.PropertyValue;
+import com.sun.star.sdbc.XConnection;
+import com.sun.star.sdbc.XDriverManager;
+
+/**
+* Testing <code>com.sun.star.sdbc.XDriverManager</code>
+* interface methods :
+* <ul>
+*  <li><code> getConnection()</code></li>
+*  <li><code> getConnectionWithInfo()</code></li>
+*  <li><code> setLoginTimeout()</code></li>
+*  <li><code> getLoginTimeout()</code></li>
+* </ul> <p>
+* Required object relations :
+* <ul>
+* <li> <code>'SDBC.URL'</code>:
+*      is the URL of the database to which to connect using sdbc-driver
+* </code></li>
+* <li> <code>'JDBC.URL'</code>:
+*      is the URL of the database to which to connect using jdbc-driver
+* </code></li>
+* <li> <code>'JDBC.INFO'</code> of type <code>PropertyValue[]</code>:
+*      a list of arbitrary string tag/value pairs as connection arguments;
+*      normally at least a "user" and "password" property should be included
+* </code></li>
+* </ul> <p>
+* @see com.sun.star.sdbc.XDriverManager
+*/
+public class _XDriverManager extends MultiMethodTest {
+    // oObj filled by MultiMethodTest
+    public XDriverManager oObj = null;
+    String sdbcURL = null;
+    String jdbcURL = null;
+    PropertyValue[] jdbcINFO = null;
+
+    /**
+     * Retrieves the required object relations.
+     */
+    @Override
+    protected void before() {
+        sdbcURL = (String)tEnv.getObjRelation("SDBC.URL");
+        if (sdbcURL == null) {
+            throw new StatusException(
+                Status.failed("Couldn't get relation 'SDBC.URL'"));
+        }
+        jdbcURL = (String)tEnv.getObjRelation("JDBC.URL");
+        if (jdbcURL == null) {
+            throw new StatusException(
+                Status.failed("Couldn't get relation 'JDBC.URL'"));
+        }
+        jdbcINFO = (PropertyValue[])tEnv.getObjRelation("JDBC.INFO");
+        if (jdbcINFO == null) {
+            throw new StatusException(
+                Status.failed("Couldn't get relation 'JDBC.INFO'"));
+        }
+    }
+
+    /**
+     * Calls the method with the url received from the relation
+     * <code>SDBC.URL</code>.
+     * Has OK status if exception wasn't thrown and
+     * if returned value isn't null.
+     */
+    public void _getConnection() {
+        boolean res = true;
+
+        try {
+            log.println("getConnection(" + sdbcURL + ")");
+            XConnection connection = oObj.getConnection(sdbcURL);
+            res = connection != null;
+        } catch(com.sun.star.sdbc.SQLException e) {
+            log.println("Unexpected exception");
+            e.printStackTrace(log);
+            res = false;
+        }
+
+        tRes.tested("getConnection()", res);
+    }
+
+    /**
+     * Calls the method with the url received from the relation
+     * <code>JDBC.URL</code> and with info received from the relation
+     * <code>JDBC.INFO</code>.
+     * Has OK status if exception wasn't thrown and
+     * if returned value isn't null.
+     */
+    public void _getConnectionWithInfo() {
+        boolean res = true;
+
+        try {
+            log.println("getConnectionWithInfo(" + jdbcURL + ")");
+            XConnection connection =
+                oObj.getConnectionWithInfo(jdbcURL, jdbcINFO);
+            res = connection != null;
+        } catch(com.sun.star.sdbc.SQLException e) {
+            log.println("Unexpected exception");
+            e.printStackTrace(log);
+            res = false;
+        }
+
+        tRes.tested("getConnectionWithInfo()", res);
+    }
+
+    /**
+     * Calls the method and checks returned value.
+     * Has OK status if timeout that was set and timeout that was returned by
+     * the method <code>getLoginTimeout()</code> are equal.
+     */
+    public void _setLoginTimeout() {
+        requiredMethod("getLoginTimeout()");
+        final int TO = 111;
+        log.println("setLoginTimeout(" + TO + ")");
+        oObj.setLoginTimeout(TO);
+        int timeout = oObj.getLoginTimeout();
+        log.println("getLoginTimeout(): " + timeout);
+        tRes.tested("setLoginTimeout()", timeout == TO);
+    }
+
+    /**
+     * Calls the method.
+     */
+    public void _getLoginTimeout() {
+        int timeout = oObj.getLoginTimeout();
+        log.println("getLoginTimeout(): " + timeout);
+
+        tRes.tested("getLoginTimeout()", true);
+    }
+}
\ No newline at end of file
diff --git a/qadevOOo/tests/java/ifc/sdbc/_XIsolatedConnection.java b/qadevOOo/tests/java/ifc/sdbc/_XIsolatedConnection.java
new file mode 100644
index 000000000..64af7feb5
--- /dev/null
+++ b/qadevOOo/tests/java/ifc/sdbc/_XIsolatedConnection.java
@@ -0,0 +1,111 @@
+/*
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ *   Licensed to the Apache Software Foundation (ASF) under one or more
+ *   contributor license agreements. See the NOTICE file distributed
+ *   with this work for additional information regarding copyright
+ *   ownership. The ASF licenses this file to you under the Apache
+ *   License, Version 2.0 (the "License"); you may not use this file
+ *   except in compliance with the License. You may obtain a copy of
+ *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ */
+
+package ifc.sdbc;
+
+import lib.MultiMethodTest;
+import lib.StatusException;
+
+import com.sun.star.sdbc.XConnection;
+import com.sun.star.sdbc.XIsolatedConnection;
+import com.sun.star.task.XInteractionHandler;
+
+/**
+ * Testing <code>com.sun.star.sdb.XCompletedConnection</code>
+ * interface methods :
+ * <ul>
+ *  <li><code> getIsolatedConnectionWithCompletion()</code></li>
+ *  <li><code> getIsolatedConnection()</code></li>
+ * </ul> <p>
+*    The following object relations required :
+* <ul>
+* <li> <code>'XCompletedConnection.Handler'</code> : passed as parameter
+* to <code>connectWithCompletion</code> method. </li>
+* </ul>
+* @see com.sun.star.sdb.XIsolatedConnection
+* @see com.sun.star.task.XInteractionHandler
+* @see com.sun.star.sdbc.XConnection
+*/
+public class _XIsolatedConnection extends MultiMethodTest {
+
+    // oObj filled by MultiMethodTest
+    public XIsolatedConnection oObj = null ;
+
+    /**
+    * Test call the method with handler passed as object relation.
+    * Then value returned is checked.<p>
+    * Has OK status if not null value returned. <&nbsp>
+    * FAILED if exception occurred, null value returned or object
+    * relation was not found.
+    */
+    public void _getIsolatedConnectionWithCompletion() throws StatusException {
+        XInteractionHandler handler = (XInteractionHandler)
+            tEnv.getObjRelation("XCompletedConnection.Handler") ;
+
+        if (handler == null) {
+            log.println("Required object relation not found !") ;
+            tRes.tested("getIsolatedConnectionWithCompletion()", false) ;
+            return ;
+        }
+
+        XConnection con = null ;
+        try {
+            con = oObj.getIsolatedConnectionWithCompletion(handler) ;
+        } catch (com.sun.star.sdbc.SQLException e) {
+            throw new StatusException("Exception while method calling", e) ;
+        }
+
+        tRes.tested("getIsolatedConnectionWithCompletion()", con != null) ;
+    }
+
+    /**
+    * Test call the method with handler passed as object relation.
+    * Then value returned is checked.<p>
+    * Has OK status if not null value returned. <&nbsp>
+    * FAILED if exception occurred, null value returned or object
+    * relation was not found.
+    */
+    public void _getIsolatedConnection() throws StatusException {
+        String[] userSettings = (String[])
+                        tEnv.getObjRelation("UserAndPassword") ;
+
+        String user = null;
+        String pwd = null;
+
+        if (userSettings[0] != null)
+            user = userSettings[0].equals("")?"<empty>":userSettings[0];
+        else
+            user = "<null>";
+        if (userSettings[1] != null)
+            pwd = userSettings[1].equals("")?"<empty>":userSettings[1];
+        else
+            pwd = "<null>";
+
+        log.println("Testing \"getIsolatedConnection('user', 'password')\"\n" +
+                    "with user = '" + user + "'; password = '" + pwd + "'");
+        XConnection con = null ;
+        try {
+            con = oObj.getIsolatedConnection(user, pwd) ;
+        } catch (com.sun.star.sdbc.SQLException e) {
+            throw new StatusException("Exception while method calling", e) ;
+        }
+
+        tRes.tested("getIsolatedConnection()", con != null) ;
+    }
+}  // finish class _XIsolatedConnection
+
diff --git a/qadevOOo/tests/java/ifc/sdbc/_XParameters.java b/qadevOOo/tests/java/ifc/sdbc/_XParameters.java
new file mode 100644
index 000000000..4284931fe
--- /dev/null
+++ b/qadevOOo/tests/java/ifc/sdbc/_XParameters.java
@@ -0,0 +1,564 @@
+/*
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ *   Licensed to the Apache Software Foundation (ASF) under one or more
+ *   contributor license agreements. See the NOTICE file distributed
+ *   with this work for additional information regarding copyright
+ *   ownership. The ASF licenses this file to you under the Apache
+ *   License, Version 2.0 (the "License"); you may not use this file
+ *   except in compliance with the License. You may obtain a copy of
+ *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ */
+
+package ifc.sdbc;
+
+import java.util.List;
+
+import lib.MultiMethodTest;
+import lib.Status;
+
+import com.sun.star.io.XDataInputStream;
+import com.sun.star.io.XInputStream;
+import com.sun.star.io.XTextInputStream;
+import com.sun.star.sdbc.DataType;
+import com.sun.star.sdbc.SQLException;
+import com.sun.star.sdbc.XParameters;
+import com.sun.star.uno.UnoRuntime;
+import com.sun.star.util.Date;
+import com.sun.star.util.DateTime;
+import com.sun.star.util.Time;
+
+/**
+/**
+* Testing <code>com.sun.star.sdbc.XParameters</code>
+* interface methods :
+* <ul>
+*  <li><code> setNull()</code></li>
+*  <li><code> setObjectNull()</code></li>
+*  <li><code> setBoolean()</code></li>
+*  <li><code> setByte()</code></li>
+*  <li><code> setShort()</code></li>
+*  <li><code> setInt()</code></li>
+*  <li><code> setLong()</code></li>
+*  <li><code> setFloat()</code></li>
+*  <li><code> setDouble()</code></li>
+*  <li><code> setString()</code></li>
+*  <li><code> setBytes()</code></li>
+*  <li><code> setDate()</code></li>
+*  <li><code> setTime()</code></li>
+*  <li><code> setTimestamp()</code></li>
+*  <li><code> setBinaryStream()</code></li>
+*  <li><code> setCharacterStream()</code></li>
+*  <li><code> setObject()</code></li>
+*  <li><code> setObjectWithInfo()</code></li>
+*  <li><code> setRef()</code></li>
+*  <li><code> setBlob()</code></li>
+*  <li><code> setClob()</code></li>
+*  <li><code> setArray()</code></li>
+*  <li><code> clearParameters()</code></li>
+* </ul> <p>
+* Object relations required :
+* <ul>
+* <li> <code>'XParameters.ParamValues'</code> :  is a
+* <code>java.util.Vector</code> object
+* that contains parameter types and values of the statement. Each
+* element of vector corresponds to appropriate parameter (element
+* with index 0 to parameter #1, 1 -> #2, etc.). <p>
+* The following <code>XParameters</code> methods correspond to classes
+* in Vector :
+* <ul>
+*   <li> <code>setBinaryStream</code> -
+*        <code>com.sun.star.io.XDataInputStream</code> class. </li>
+*   <li> <code>setCharacterStream</code> -
+*        <code>com.sun.star.io.XTextInputStream</code> class. </li>
+*   <li> <code>setObject</code> -
+*        <code>java.lang.Object[]</code> class, the element with
+*         index 0 must be used. </li>
+* </ul>
+* Other methods uses types of their arguments (i.e.
+* <code>String</code>
+* for <code>setString</code> method, <code>com.sun.star.sdbc.XRef</code>
+* for <code>setRef</code> method).
+* </li>
+* </ul>
+* @see com.sun.star.sdbc.XParameters
+*/
+public class _XParameters extends MultiMethodTest {
+
+    // oObj filled by MultiMethodTest
+    public XParameters oObj = null ;
+
+    private List<Object> data = null ;
+
+    /**
+    * Gets object relation
+    */
+    @Override
+    public void before() {
+        data = (List<Object>) tEnv.getObjRelation("XParameters.ParamValues") ;
+        if (data == null) {
+            log.println("!!! Relation not found !!!") ;
+        }
+    }
+
+    /**
+    * Sets String parameter (if exists) to SQL NULL value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setNull() {
+        boolean result = true ;
+        int idx = findParamOfType(String.class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.setNull(idx, DataType.VARCHAR) ;
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setNull()", result) ;
+    }
+
+    public void _setObjectNull() {
+        /*
+            !!! TO DO !!!
+        */
+        tRes.tested("setObjectNull()", Status.skipped(true)) ;
+    }
+
+    /**
+    * Sets String parameter (if exists) to new value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setString() {
+        boolean result = true ;
+        int idx = findParamOfType(String.class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.setString(idx, "XParameters") ;
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setString()", result) ;
+    }
+
+    /**
+    * Sets parameter (if exists) to new value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setBoolean() {
+        boolean result = true ;
+        int idx = findParamOfType(Boolean.class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.setBoolean(idx, true) ;
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setBoolean()", result) ;
+    }
+
+    /**
+    * Sets parameter (if exists) to new value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setByte() {
+        boolean result = true ;
+        int idx = findParamOfType(Byte.class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.setByte(idx, (byte)122) ;
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setByte()", result) ;
+    }
+
+    /**
+    * Sets parameter (if exists) to new value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setShort() {
+        boolean result = true ;
+        int idx = findParamOfType(Short.class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.setShort(idx, (short)133) ;
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setShort()", result) ;
+    }
+
+    /**
+    * Sets parameter (if exists) to new value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setInt() {
+        boolean result = true ;
+        int idx = findParamOfType(Integer.class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.setInt(idx, 13300) ;
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setInt()", result) ;
+    }
+
+    /**
+    * Sets parameter (if exists) to new value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setLong() {
+        boolean result = true ;
+        int idx = findParamOfType(Long.class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.setLong(idx, 13362453) ;
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setLong()", result) ;
+    }
+
+    /**
+    * Sets parameter (if exists) to new value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setFloat() {
+        boolean result = true ;
+        int idx = findParamOfType(Float.class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.setFloat(idx, (float)133.55) ;
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setFloat()", result) ;
+    }
+
+    /**
+    * Sets parameter (if exists) to new value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setDouble() {
+        boolean result = true ;
+        int idx = findParamOfType(Double.class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.setDouble(idx, 133) ;
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setDouble()", result) ;
+    }
+
+    /**
+    * Sets parameter (if exists) to new value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setBytes() {
+        boolean result = true ;
+        int idx = findParamOfType(byte[].class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.setBytes(idx, new byte[] {5}) ;
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setBytes()", result) ;
+    }
+
+    /**
+    * Sets parameter (if exists) to new value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setDate() {
+        boolean result = true ;
+        int idx = findParamOfType(Date.class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.setDate(
+                    idx, new Date ((short)19, (short)1, (short)1979)) ;
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setDate()", result) ;
+    }
+
+    /**
+    * Sets parameter (if exists) to new value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setTime() {
+        boolean result = true ;
+        int idx = findParamOfType(Time.class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.setTime(
+                    idx, new Time((short)1,(short)2,(short)3,(short)44, false));
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setTime()", result) ;
+    }
+
+    /**
+    * Sets parameter (if exists) to new value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setTimestamp() {
+        boolean result = true ;
+        int idx = findParamOfType(DateTime.class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.setTimestamp(idx, new DateTime((short)1,(short)2,(short)3,
+                    (short)4, (short)19, (short)1, (short)1979, false)) ;
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setTimestamp()", result) ;
+    }
+
+    /**
+    * Sets parameter (if exists) to new value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setBinaryStream() {
+        boolean result = true ;
+        int idx = findParamOfType(XDataInputStream.class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                Object oStream = tParam.getMSF().
+                        createInstance("com.sun.star.io.DataInputStream") ;
+                XInputStream xStream = UnoRuntime.queryInterface
+                    (XInputStream.class, oStream);
+
+                oObj.setBinaryStream(idx, xStream, 2) ;
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            } catch (com.sun.star.uno.Exception e) {
+                log.println("Unexpected exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setBinaryStream()", result) ;
+    }
+
+    /**
+    * Sets parameter (if exists) to new value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setCharacterStream() {
+        boolean result = true ;
+        int idx = findParamOfType(XTextInputStream.class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                Object oStream = tParam.getMSF()
+                        .createInstance("com.sun.star.io.TextInputStream") ;
+                XInputStream xStream = UnoRuntime.queryInterface
+                    (XInputStream.class, oStream);
+
+                oObj.setCharacterStream(idx, xStream, 2) ;
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            } catch (com.sun.star.uno.Exception e) {
+                log.println("Unexpected exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setCharacterStream()", result) ;
+    }
+
+    /**
+    * Sets parameter (if exists) to new value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setObject() {
+        boolean result = true ;
+        int idx = findParamOfType(Object[].class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                Object obj = tParam.getMSF().
+                                createInstance("com.sun.star.io.Pipe") ;
+
+                oObj.setObject(idx, obj) ;
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            } catch (com.sun.star.uno.Exception e) {
+                log.println("Unexpected exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setObject()", result) ;
+    }
+
+    /**
+    * Sets parameter (if exists) to new value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setObjectWithInfo() {
+        boolean result = true ;
+        int idx = findParamOfType(Object[].class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                Object obj = tParam.getMSF().
+                    createInstance("com.sun.star.io.Pipe") ;
+
+                oObj.setObjectWithInfo(idx, obj, DataType.OBJECT, 0) ;
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            } catch (com.sun.star.uno.Exception e) {
+                log.println("Unexpected exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setObjectWithInfo()", result) ;
+    }
+
+    public void _setRef() {
+        /*
+            !!! TO DO !!!
+        */
+        tRes.tested("setRef()", Status.skipped(true)) ;
+    }
+    public void _setBlob() {
+        /*
+            !!! TO DO !!!
+        */
+        tRes.tested("setBlob()", Status.skipped(true)) ;
+    }
+    public void _setClob() {
+        /*
+            !!! TO DO !!!
+        */
+        tRes.tested("setClob()", Status.skipped(true)) ;
+    }
+    public void _setArray() {
+        /*
+            !!! TO DO !!!
+        */
+        tRes.tested("setArray()", Status.skipped(true)) ;
+    }
+
+    /**
+    * Calls method. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _clearParameters() {
+        boolean result = true ;
+        try {
+            oObj.clearParameters() ;
+        } catch (SQLException e) {
+            log.println("Unexpected SQL exception:") ;
+            log.println(e) ;
+            result = false ;
+        }
+
+        tRes.tested("clearParameters()", result) ;
+    }
+
+
+    /**
+    * Finds in relation vector index of parameter of the appropriate
+    * type.
+    */
+    private int findParamOfType(Class<?> clz) {
+        for (int i = 0; i < data.size(); i++)
+            if (clz.isInstance(data.get(i))) return i + 1 ;
+        return -1 ;
+    }
+
+}  // finish class _XParameters
+
+
diff --git a/qadevOOo/tests/java/ifc/sdbc/_XResultSet.java b/qadevOOo/tests/java/ifc/sdbc/_XResultSet.java
new file mode 100644
index 000000000..a2114d7d0
--- /dev/null
+++ b/qadevOOo/tests/java/ifc/sdbc/_XResultSet.java
@@ -0,0 +1,497 @@
+/*
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ *   Licensed to the Apache Software Foundation (ASF) under one or more
+ *   contributor license agreements. See the NOTICE file distributed
+ *   with this work for additional information regarding copyright
+ *   ownership. The ASF licenses this file to you under the Apache
+ *   License, Version 2.0 (the "License"); you may not use this file
+ *   except in compliance with the License. You may obtain a copy of
+ *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ */
+
+package ifc.sdbc;
+
+import lib.MultiMethodTest;
+
+import com.sun.star.sdbc.SQLException;
+import com.sun.star.sdbc.XResultSet;
+import com.sun.star.sdbc.XRow;
+import com.sun.star.sdbc.XRowUpdate;
+import com.sun.star.uno.UnoRuntime;
+
+/**
+/**
+* Testing <code>com.sun.star.sdbc.XResultSet</code>
+* interface methods :
+* <ul>
+*  <li><code> next()</code></li>
+*  <li><code> isBeforeFirst()</code></li>
+*  <li><code> isAfterLast()</code></li>
+*  <li><code> isFirst()</code></li>
+*  <li><code> isLast()</code></li>
+*  <li><code> beforeFirst()</code></li>
+*  <li><code> afterLast()</code></li>
+*  <li><code> first()</code></li>
+*  <li><code> last()</code></li>
+*  <li><code> getRow()</code></li>
+*  <li><code> absolute()</code></li>
+*  <li><code> relative()</code></li>
+*  <li><code> previous()</code></li>
+*  <li><code> refreshRow()</code></li>
+*  <li><code> rowUpdated()</code></li>
+*  <li><code> rowInserted()</code></li>
+*  <li><code> rowDeleted()</code></li>
+*  <li><code> getStatement()</code></li>
+* </ul> <p>
+* This test needs the following object relations :
+* <ul>
+*  <li> <code>'XResultSet.hasStatement'</code> (<b>optional</b> of type
+* <code>Object</code>):
+*  it the relation exists than <code>getStatement</code> method
+*  must not return <code>null</code> </li>
+* <ul> <p>
+* Test places DB cursor to different positions and then checks
+* its current position. <p>
+* Test is <b> NOT </b> multithread compliant. <p>
+* @see com.sun.star.sdbc.XResultSet
+*/
+public class _XResultSet extends MultiMethodTest {
+
+    // oObj filled by MultiMethodTest
+    public XResultSet oObj = null ;
+
+    /**
+     * Positions the cursor to the first row.
+     * Forces method tests to be executed in definite order.
+     */
+    @Override
+    public void before() {
+        try {
+            oObj.last() ;
+            log.println("Totally number of rows is " + oObj.getRow()) ;
+            oObj.first() ;
+        } catch (SQLException e) {
+            log.println("Ignored exception :") ;
+            e.printStackTrace(log);
+        }
+
+        executeMethod("isBeforeFirst()") ;
+        executeMethod("isAfterLast()") ;
+        executeMethod("isLast()") ;
+        executeMethod("isFirst()") ;
+        executeMethod("next()") ;
+        executeMethod("previous()") ;
+    }
+
+    /**
+    * Places the cursor before the first row. <p>
+    * Has <b>OK</b> status if no exceptions were thrown.
+    */
+    public void _beforeFirst() {
+        try {
+            oObj.beforeFirst() ;
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+            tRes.tested("beforeFirst()", false) ;
+            return ;
+        }
+        tRes.tested("beforeFirst()", true) ;
+    }
+
+    /**
+    * The method is called immediately after <code>beforeFirst</code>
+    * method test. <p>
+    * Has <b>OK</b> status if method returns <code>true</code>. <p>
+    * The following method tests are to be completed successfully before :
+    * <ul>
+    *  <li> <code> beforeFirst </code> : to position cursor before
+    *   the first row. </li>
+    * </ul>
+    */
+    public void _isBeforeFirst() {
+        requiredMethod("beforeFirst()") ;
+
+        boolean result = true ;
+
+        try {
+            result = oObj.isBeforeFirst() ;
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+        tRes.tested("isBeforeFirst()", result) ;
+    }
+
+    /**
+    * Places the cursor after the last row. <p>
+    * Has <b>OK</b> status if no exceptions were thrown.
+    */
+    public void _afterLast() {
+        try {
+            oObj.afterLast() ;
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+            tRes.tested("afterLast()", false) ;
+            return ;
+        }
+        tRes.tested("afterLast()", true) ;
+    }
+
+    /**
+    * The method is called immediately after <code>afterLast</code>
+    * method test. <p>
+    * Has <b>OK</b> status if method returns <code>true</code> <p>
+    * The following method tests are to be completed successfully before :
+    * <ul>
+    *  <li> <code> afterLast </code> : to position cursor after
+    *   the last row. </li>
+    * </ul>
+    */
+    public void _isAfterLast() {
+        requiredMethod("afterLast()") ;
+
+        boolean result = true ;
+
+        try {
+            result = oObj.isAfterLast() ;
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+        tRes.tested("isAfterLast()", result) ;
+    }
+
+    /**
+    * Places the cursor on the first row. <p>
+    * Has <b>OK</b> status if no exceptions were thrown.
+    */
+    public void _first() {
+        try {
+            oObj.first() ;
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+            tRes.tested("first()", false) ;
+            return ;
+        }
+        tRes.tested("first()", true) ;
+    }
+
+    /**
+    * The method is called immediately after <code>first</code>
+    * method test. <p>
+    * Has <b>OK</b> status if method returns <code>true</code>. <p>
+    * The following method tests are to be completed successfully before :
+    * <ul>
+    *  <li> <code> first </code> : to position cursor on
+    *   the first row. </li>
+    * </ul>
+    */
+    public void _isFirst() {
+        requiredMethod("first()") ;
+
+        boolean result = true ;
+
+        try {
+            result = oObj.isFirst() ;
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+        tRes.tested("isFirst()", result) ;
+    }
+
+    /**
+    * Places the cursor on the last row. <p>
+    * Has <b>OK</b> status if no exceptions were thrown.
+    */
+    public void _last() {
+        try {
+            oObj.last() ;
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+            tRes.tested("last()", false) ;
+            return ;
+        }
+        tRes.tested("last()", true) ;
+    }
+
+    /**
+    * The method is called immediately after <code>last</code>
+    * method test. <p>
+    * Has <b>OK</b> status if method returns <code>true</code>. <p>
+    * The following method tests are to be completed successfully before :
+    * <ul>
+    *  <li> <code> last </code> : to position cursor on
+    *   the last row. </li>
+    * </ul>
+    */
+    public void _isLast() {
+        requiredMethod("last()") ;
+        boolean result = true ;
+
+        try {
+            result = oObj.isLast() ;
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+        tRes.tested("isLast()", result) ;
+    }
+
+    /**
+    * Places the cursor on the row number 1. <p>
+    * Has <b>OK</b> status if no exceptions were thrown.
+    */
+    public void _absolute() {
+        boolean result = true ;
+
+        try {
+            oObj.absolute(1) ;
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+        tRes.tested("absolute()", result) ;
+    }
+
+    /**
+    * The method is called immediately after <code>absolute</code>
+    * method test. <p>
+    * Has <b>OK</b> status if method returns 1. <p>
+    * The following method tests are to be completed successfully before :
+    * <ul>
+    *  <li> <code> absolute </code> : to position cursor on
+    *   the row number 1. </li>
+    * </ul>
+    */
+    public void _getRow() {
+        requiredMethod("absolute()");
+        boolean result = true;
+
+        try {
+            result &= oObj.getRow() == 1;
+        } catch (SQLException e) {
+            log.println("Exception occurred:");
+            e.printStackTrace(log);
+            result = false;
+        }
+
+        tRes.tested("getRow()", result);
+    }
+
+    /**
+    * Positions the cursor to the next row. Current row
+    * number is retrieved before and after method call. <p>
+    * Has <b>OK</b> status if current row number increases
+    * by 1 after method call.
+    */
+    public void _next() {
+        boolean result = true ;
+
+        try {
+            int prevRow = oObj.getRow() ;
+            oObj.next() ;
+
+            log.println("Row was : " + prevRow + ", row is : " + oObj.getRow());
+            result &= prevRow + 1 == oObj.getRow() ;
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+        tRes.tested("next()", result) ;
+    }
+
+    /**
+    * Positions the cursor to the previous row. Current row
+    * number is retrieved before and after method call. <p>
+    * Has <b>OK</b> status if current row number decreases
+    * by 1 after method call.
+    */
+    public void _previous() {
+        boolean result = true ;
+
+        try {
+            int prevRow = oObj.getRow() ;
+            oObj.previous() ;
+
+            log.println("Row was : " + prevRow + ", row is : " + oObj.getRow());
+            result &= prevRow - 1 == oObj.getRow() ;
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+        tRes.tested("previous()", result) ;
+    }
+
+    /**
+    * Positions the cursor relatively by 2 rows forward.
+    * Current row number is retrieved before and after method call. <p>
+    * Has <b>OK</b> status if current row number increases
+    * by 2 after method call.
+    */
+    public void _relative() {
+        boolean result = true ;
+
+        try {
+            oObj.first() ;
+            int prevRow = oObj.getRow() ;
+            oObj.relative(2) ;
+
+            log.println("Row was : " + prevRow + ", row is : " + oObj.getRow());
+
+            result &= prevRow + 2 == oObj.getRow() ;
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+        tRes.tested("relative()", result) ;
+    }
+
+    /**
+    * If component supports XRow and XRowUpdate then:
+    *   test saves current value of string field, updates string,
+    *   calls refreshRow() and checks that value of
+    *   string field was refetched from DB
+    * else: just calls method.<p>
+    * Has <b>OK</b> status if no exceptions were thrown and value after
+    * refreshRow() equals to saved value.
+    */
+    public void _refreshRow() {
+        XRowUpdate xRowUpdate = UnoRuntime.queryInterface(XRowUpdate.class, oObj);
+        XRow xRow = UnoRuntime.queryInterface(XRow.class, oObj);
+
+        if (xRowUpdate == null || xRow == null) {
+            log.println("Test must be modified because XRow or XRowUpdate is't supported");
+            log.println("Only call method");
+            try {
+                oObj.refreshRow() ;
+                tRes.tested("refreshRow()", true) ;
+            } catch (SQLException e) {
+                log.println("Exception occurred :") ;
+                e.printStackTrace(log) ;
+                tRes.tested("refreshRow()", false) ;
+            }
+        } else {
+            log.println("Testing of refreshRow()...");
+            try {
+                String oldValue = xRow.getString(util.DBTools.TST_STRING);
+                log.println("Old value: " + oldValue);
+                xRowUpdate.updateString(util.DBTools.TST_STRING,
+                    "Test method refreshRow");
+                log.println("New value: "
+                    + xRow.getString(util.DBTools.TST_STRING));
+                oObj.refreshRow();
+                String valAfterRefresh =
+                    xRow.getString(util.DBTools.TST_STRING);
+                log.println("Value after refresh: " + valAfterRefresh);
+                tRes.tested("refreshRow()", valAfterRefresh.equals(oldValue));
+            } catch(SQLException e) {
+                log.println("Exception occurred :");
+                e.printStackTrace(log);
+                tRes.tested("refreshRow()", false);
+            }
+        }
+    }
+
+    /**
+    * Just the method is called. <p>
+    * Has <b>OK</b> status if no exceptions were thrown.
+    */
+    public void _rowUpdated() {
+
+        try {
+            oObj.rowUpdated();
+            tRes.tested("rowUpdated()", true) ;
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+            tRes.tested("rowUpdated()", false) ;
+        }
+    }
+
+    /**
+    * Just the method is called. <p>
+    * Has <b>OK</b> status if no exceptions were thrown.
+    */
+    public void _rowInserted() {
+        try {
+            oObj.rowInserted();
+            tRes.tested("rowInserted()", true) ;
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+            tRes.tested("rowInserted()", false) ;
+        }
+    }
+
+    /**
+    * Just the method is called. <p>
+    * Has <b>OK</b> status if no exceptions were thrown.
+    */
+    public void _rowDeleted() {
+        try {
+            oObj.rowDeleted();
+            tRes.tested("rowDeleted()", true) ;
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+            tRes.tested("rowDeleted()", false) ;
+        }
+    }
+
+    /**
+    * Just the method is called. <p>
+    * Has <b>OK</b> status if the statement returned isn't null or
+    * the relation exists that informs that statement absent (e.g. for
+    * MetaData row set).
+    */
+    public void _getStatement() {
+        try {
+            boolean hasStatement =
+                tEnv.getObjRelation("XResultSet.hasStatement") != null ;
+            Object res = oObj.getStatement() ;
+            tRes.tested("getStatement()",
+                (hasStatement && res != null) || !hasStatement) ;
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+            tRes.tested("getStatement()", false) ;
+        }
+    }
+
+    /**
+     * Moves the cursor to the first row to avoid affection to
+     * the following interfaces tests
+     */
+    @Override
+    public void after() {
+        log.println("Finally moving cursor to the first row ...");
+        try {
+            oObj.first();
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+        }
+    }
+
+}  // finish class _XResultSet
+
diff --git a/qadevOOo/tests/java/ifc/sdbc/_XResultSetMetaDataSupplier.java b/qadevOOo/tests/java/ifc/sdbc/_XResultSetMetaDataSupplier.java
new file mode 100644
index 000000000..0a721b368
--- /dev/null
+++ b/qadevOOo/tests/java/ifc/sdbc/_XResultSetMetaDataSupplier.java
@@ -0,0 +1,60 @@
+/*
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ *   Licensed to the Apache Software Foundation (ASF) under one or more
+ *   contributor license agreements. See the NOTICE file distributed
+ *   with this work for additional information regarding copyright
+ *   ownership. The ASF licenses this file to you under the Apache
+ *   License, Version 2.0 (the "License"); you may not use this file
+ *   except in compliance with the License. You may obtain a copy of
+ *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ */
+
+package ifc.sdbc;
+
+import lib.MultiMethodTest;
+
+import com.sun.star.sdbc.XResultSetMetaData;
+import com.sun.star.sdbc.XResultSetMetaDataSupplier;
+
+/**
+* Testing <code>com.sun.star.sdbc.XResultSetMetaDataSupplier</code>
+* interface methods :
+* <ul>
+*  <li><code> getMetaData()</code></li>
+* </ul> <p>
+* Test is multithread compliant. <p>
+* @see com.sun.star.sdbc.XResultSetMetaDataSupplier
+*/
+public class _XResultSetMetaDataSupplier extends MultiMethodTest {
+
+    // oObj filled by MultiMethodTest
+    public XResultSetMetaDataSupplier oObj = null ;
+
+    /**
+    * Tries to get the ResultSetMetaData of the Object</br>
+    * an XResultSetMetaData is returned.</br>
+    * The test is OK if a not null ResultSetMetaData is returned
+    */
+    public void _getMetaData() {
+
+        try {
+            XResultSetMetaData the_Meta = oObj.getMetaData();
+            if (the_Meta == null) log.println("'getMetaData()' returns NULL");
+            tRes.tested("getMetaData()",the_Meta != null);
+        } catch (com.sun.star.sdbc.SQLException e) {
+            log.println("Exception while checking 'createResultSet()'");
+            e.printStackTrace(log);
+            tRes.tested("getMetaData()",false);
+        }
+
+    }
+}  // finish class _XResultSetMetaDataSupplier
+
+
diff --git a/qadevOOo/tests/java/ifc/sdbc/_XResultSetUpdate.java b/qadevOOo/tests/java/ifc/sdbc/_XResultSetUpdate.java
new file mode 100644
index 000000000..372373910
--- /dev/null
+++ b/qadevOOo/tests/java/ifc/sdbc/_XResultSetUpdate.java
@@ -0,0 +1,255 @@
+/*
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ *   Licensed to the Apache Software Foundation (ASF) under one or more
+ *   contributor license agreements. See the NOTICE file distributed
+ *   with this work for additional information regarding copyright
+ *   ownership. The ASF licenses this file to you under the Apache
+ *   License, Version 2.0 (the "License"); you may not use this file
+ *   except in compliance with the License. You may obtain a copy of
+ *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ */
+
+package ifc.sdbc;
+
+import lib.MultiMethodTest;
+import lib.StatusException;
+
+import com.sun.star.sdbc.SQLException;
+import com.sun.star.sdbc.XResultSetUpdate;
+import com.sun.star.sdbc.XRowUpdate;
+import com.sun.star.uno.UnoRuntime;
+
+/**
+/**
+* Testing <code>com.sun.star.sdbc.XResultSetUpdate</code>
+* interface methods :
+* <ul>
+*  <li><code> insertRow()</code></li>
+*  <li><code> updateRow()</code></li>
+*  <li><code> deleteRow()</code></li>
+*  <li><code> cancelRowUpdates()</code></li>
+*  <li><code> moveToInsertRow()</code></li>
+*  <li><code> moveToCurrentRow()</code></li>
+* </ul> <p>
+* The test requires the following object relations :
+* <ul>
+*  <li><code>'XResultSetUpdate.UpdateTester'</code>
+*   inner <code>UpdateTester</code> interface implementation :
+*   is used for checking test results. See interface
+*   documentation for more information.</li>
+* </ul>
+* The test is <b>not designed</b> for multithreaded testing. <p>
+* After it's execution environment must be recreated.
+* @see com.sun.star.sdbc.XResultSetUpdate
+*/
+public class _XResultSetUpdate extends MultiMethodTest {
+
+    // oObj filled by MultiMethodTest
+    public XResultSetUpdate oObj = null ;
+
+    private UpdateTester tester = null ;
+
+    /**
+    * Interface contains some methods for checking
+    * test results. It's implementation must be passed
+    * to this test.
+    */
+    public interface UpdateTester {
+        /**
+        * @return Current number of rows.
+        */
+        int rowCount() throws SQLException ;
+        /**
+        * Updates some data in the current row but doesn't commit
+        * changes to the source.
+        */
+        void update() throws SQLException ;
+        /**
+        * Checks if updates made by method <code>update</code> was
+        * committed to the data source.
+        */
+        boolean wasUpdated() throws SQLException ;
+        /**
+        * Returns current row number. Really it must returns value
+        * < 1 if the current position is on insert row.
+        */
+        int currentRow() throws SQLException ;
+    }
+
+    /**
+    * Retrieves relation.
+    * @throw StatusException If relation not found.
+    */
+    @Override
+    public void before() throws StatusException {
+        tester = (UpdateTester)tEnv.getObjRelation
+            ("XResultSetUpdate.UpdateTester") ;
+
+        if (tester == null) {
+            log.println("Required relation not found !!!") ;
+            throw new StatusException("Required relation not found !!!",
+                new NullPointerException()) ;
+        }
+    }
+
+    /**
+    * Calls method when the cursor position is on existing row.
+    * Checks total number of rows before and after method call. <p>
+    * Executes <code>moveToCurrentRow</code> method test before to
+    * be sure that cursor is not on the insert row. <p>
+    * Has OK status if after method execution number of rows decreased
+    * by one.
+    */
+    public void _deleteRow() {
+        executeMethod("moveToCurrentRow()") ;
+
+        //temporary to avoid SOffice hanging
+        executeMethod("updateRow()") ;
+        executeMethod("cancelRowUpdates()") ;
+
+        boolean result = true ;
+        try {
+            int rowsBefore = tester.rowCount() ;
+            oObj.deleteRow() ;
+            int rowsAfter = tester.rowCount() ;
+
+            result = rowsBefore == rowsAfter + 1 ;
+        } catch (SQLException e) {
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+
+        tRes.tested("deleteRow()", result) ;
+    }
+
+    /**
+    * Using relation methods first updates some data in the current
+    * row, then calls <code>updateRow</code> method to commit data.
+    * Then checks if the data changed was committed. <p>
+    * Executes <code>moveToCurrentRow</code> method test before to
+    * be sure that cursor is not on the insert row. <p>
+    * Has OK status if data in the source was changed.
+    */
+    public void _updateRow() {
+        executeMethod("moveToCurrentRow()") ;
+        boolean result = true ;
+        try {
+            tester.update() ;
+            oObj.updateRow() ;
+
+            result = tester.wasUpdated() ;
+        } catch (SQLException e) {
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+        tRes.tested("updateRow()", result) ;
+    }
+
+    /**
+    * Using relation methods first updates some data in the current
+    * row, then calls <code>cancelRowUpdates</code> method.
+    * Then checks if the data changed was not committed. <p>
+    * Executes <code>moveToCurrentRow</code> method test before to
+    * be sure that cursor is not on the insert row. <p>
+    * Has OK status if data in the source was not changed.
+    */
+    public void _cancelRowUpdates() {
+        executeMethod("moveToCurrentRow()") ;
+        boolean result = true ;
+        try {
+            tester.update() ;
+            oObj.cancelRowUpdates() ;
+
+            result = !tester.wasUpdated() ;
+        } catch (SQLException e) {
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+        tRes.tested("cancelRowUpdates()", result) ;
+    }
+
+    /**
+    * Tries to move cursor to insert row. Then checks current row
+    * number. It must be less than 1. (0 as I know) <p>
+    */
+    public void _moveToInsertRow() {
+        boolean result = true ;
+        try {
+            oObj.moveToInsertRow() ;
+
+            result = tester.currentRow() < 1 ;
+        } catch (SQLException e) {
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+        tRes.tested("moveToInsertRow()", result) ;
+    }
+
+    /**
+    * Returns cursor from insert row back to previous row. <p>
+    * <code>moveToInsertRow</code> method test must be executed
+    * first for positioning cursor to insert row. <p>
+    * Has OK status if after method call current row number is
+    * above 0.
+    */
+    public void _moveToCurrentRow() {
+        boolean result = true ;
+        try {
+            oObj.moveToCurrentRow() ;
+
+            result = tester.currentRow() >= 1 ;
+        } catch (SQLException e) {
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+        tRes.tested("moveToCurrentRow()", result) ;
+    }
+
+    /**
+    * Moves cursor to the insert row, then calls the method
+    * <code>insertRow</code>. Before and after call stores
+    * total number of rows. <p>
+    * Has OK status if after method call rows number increases
+    * by one.
+    */
+    public void _insertRow() {
+        executeMethod("moveToInsertRow()") ;
+        boolean result = true ;
+        try {
+            oObj.moveToCurrentRow();
+            int rowsBefore = tester.rowCount() ;
+            oObj.moveToInsertRow() ;
+            XRowUpdate rowU = UnoRuntime.queryInterface(XRowUpdate.class, oObj);
+            rowU.updateString(1,"open");
+            rowU.updateInt(2,5);
+            rowU.updateDouble(5,3.4);
+            rowU.updateBoolean(10,true);
+            oObj.insertRow() ;
+            oObj.moveToCurrentRow();
+            int rowsAfter = tester.rowCount() ;
+            result = rowsBefore + 1 == rowsAfter ;
+        } catch (SQLException e) {
+            e.printStackTrace(log) ;
+            log.println("******"+e.getMessage());
+            result = false ;
+        }
+        tRes.tested("insertRow()", result) ;
+    }
+
+    /**
+    * Forces environment to be recreated.
+    */
+    @Override
+    public void after() {
+        //disposeEnvironment() ;
+    }
+}  // finish class _XResultSetUpdate
+
+
diff --git a/qadevOOo/tests/java/ifc/sdbc/_XRow.java b/qadevOOo/tests/java/ifc/sdbc/_XRow.java
new file mode 100644
index 000000000..70a60b0cf
--- /dev/null
+++ b/qadevOOo/tests/java/ifc/sdbc/_XRow.java
@@ -0,0 +1,527 @@
+/*
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ *   Licensed to the Apache Software Foundation (ASF) under one or more
+ *   contributor license agreements. See the NOTICE file distributed
+ *   with this work for additional information regarding copyright
+ *   ownership. The ASF licenses this file to you under the Apache
+ *   License, Version 2.0 (the "License"); you may not use this file
+ *   except in compliance with the License. You may obtain a copy of
+ *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ */
+
+package ifc.sdbc;
+
+import java.util.List;
+
+import lib.MultiMethodTest;
+
+import com.sun.star.io.XDataInputStream;
+import com.sun.star.io.XTextInputStream;
+import com.sun.star.sdbc.SQLException;
+import com.sun.star.sdbc.XArray;
+import com.sun.star.sdbc.XBlob;
+import com.sun.star.sdbc.XClob;
+import com.sun.star.sdbc.XRef;
+import com.sun.star.sdbc.XRow;
+import com.sun.star.util.Date;
+import com.sun.star.util.DateTime;
+import com.sun.star.util.Time;
+
+/**
+* Testing <code>com.sun.star.sdbc.XRow</code>
+* interface methods :
+* <ul>
+*  <li><code> wasNull()</code></li>
+*  <li><code> getString()</code></li>
+*  <li><code> getBoolean()</code></li>
+*  <li><code> getByte()</code></li>
+*  <li><code> getShort()</code></li>
+*  <li><code> getInt()</code></li>
+*  <li><code> getLong()</code></li>
+*  <li><code> getFloat()</code></li>
+*  <li><code> getDouble()</code></li>
+*  <li><code> getBytes()</code></li>
+*  <li><code> getDate()</code></li>
+*  <li><code> getTime()</code></li>
+*  <li><code> getTimestamp()</code></li>
+*  <li><code> getBinaryStream()</code></li>
+*  <li><code> getCharacterStream()</code></li>
+*  <li><code> getObject()</code></li>
+*  <li><code> getRef()</code></li>
+*  <li><code> getBlob()</code></li>
+*  <li><code> getClob()</code></li>
+*  <li><code> getArray()</code></li>
+* </ul> <p>
+*
+* This interface is full tested in XRowUpdate interface test. Here
+* only exceptions checked.
+* <p>
+*
+* Object relations required :
+* <ul>
+* <li> <code>'CurrentRowData'</code> : (may be used in other
+* interface tests) is a <code>java.util.Vector</code> object
+* that contains column types and values in current row. Each
+* element of vector corresponds to appropriate column (element
+* with index 0 to column 1, 1 -> 2, etc.). <p>
+* The following <code>XRow</code> methods correspond to classes
+* in Vector :
+* <ul>
+*   <li> <code>getBinaryStream</code> -
+*        <code>com.sun.star.io.XDataInputStream</code> class. </li>
+*   <li> <code>getCharacterStream</code> -
+*        <code>com.sun.star.io.XTextInputStream</code> class. </li>
+*   <li> <code>getObject</code> -
+*        <code>java.lang.Object[]</code> class, the element with
+*         index 0 must be used. </li>
+* </ul>
+* Other methods uses types they return (i.e. <code>String</code>
+* for <code>getString</code> method, <code>com.sun.star.sdbc.XRef</code>
+* for <code>getRef</code> method).
+* </li>
+* </ul>
+* @see com.sun.star.sdbc.XRaw
+* @see ifc.sdbc._XRowUpdate
+*/
+public class _XRow extends MultiMethodTest {
+
+    // oObj filled by MultiMethodTest
+    public XRow oObj = null ;
+    private List<Object> data = null ;
+    private static final boolean notNullRes = true;
+
+    /**
+    * Retrieves object relation first.
+    */
+    @Override
+    public void before() {
+        data = (List<Object>) tEnv.getObjRelation("CurrentRowData") ;
+    }
+
+    /**
+    * Always has <b>OK</b> status.
+    */
+    public void _wasNull() {
+        executeMethod("getString()") ;
+        executeMethod("getBoolean()") ;
+        executeMethod("getByte()") ;
+        executeMethod("getShort()") ;
+        executeMethod("getInt()") ;
+        executeMethod("getLong()") ;
+        executeMethod("getFloat()") ;
+        executeMethod("getDouble()") ;
+        executeMethod("getBytes()") ;
+        executeMethod("getDate()") ;
+        executeMethod("getTime()") ;
+        executeMethod("getTimestamp()") ;
+        executeMethod("getBinaryStream()") ;
+        executeMethod("getCharacterStream()") ;
+        executeMethod("getObject()") ;
+        executeMethod("getRef()") ;
+        executeMethod("getBlob()") ;
+        executeMethod("getClob()") ;
+        executeMethod("getArray()") ;
+
+        tRes.tested("wasNull()", notNullRes) ;
+    }
+
+    /**
+    * Has <b>OK</b> status if no exceptions occurred in method call.
+    */
+    public void _getString() {
+        boolean result = true ;
+        int col = findColumnOfType(String.class) ;
+        if (col < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.getString(col);
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("getString()", result) ;
+    }
+
+    /**
+    * Has <b>OK</b> status if no exceptions occurred in method call.
+    */
+    public void _getBoolean() {
+        boolean result = true ;
+        int col = findColumnOfType(Boolean.class) ;
+        if (col < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.getBoolean(col);
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("getBoolean()", result) ;
+    }
+
+    /**
+    * Has <b>OK</b> status if no exceptions occurred in method call.
+    */
+    public void _getByte() {
+        boolean result = true ;
+        int col = findColumnOfType(Byte.class) ;
+        if (col < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.getByte(col);
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("getByte()", result) ;
+    }
+
+    /**
+    * Has <b>OK</b> status if no exceptions occurred in method call.
+    */
+    public void _getShort() {
+        boolean result = true ;
+        int col = findColumnOfType(Short.class) ;
+        if (col < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.getShort(col);
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("getShort()", result) ;
+    }
+
+    /**
+    * Has <b>OK</b> status if no exceptions occurred in method call.
+    */
+    public void _getInt() {
+        boolean result = true ;
+        int col = findColumnOfType(Integer.class) ;
+        if (col < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.getInt(col);
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("getInt()", result) ;
+    }
+
+    /**
+    * Has <b>OK</b> status if no exceptions occurred in method call.
+    */
+    public void _getLong() {
+        boolean result = true ;
+        int col = findColumnOfType(Long.class) ;
+        if (col < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.getLong(col);
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("getLong()", result) ;
+    }
+
+    /**
+    * Has <b>OK</b> status if no exceptions occurred in method call.
+    */
+    public void _getFloat() {
+        boolean result = true ;
+        int col = findColumnOfType(Float.class) ;
+        if (col < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.getFloat(col);
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("getFloat()", result) ;
+    }
+
+    /**
+    * Has <b>OK</b> status if no exceptions occurred in method call.
+    */
+    public void _getDouble() {
+        boolean result = true ;
+        int col = findColumnOfType(Double.class) ;
+        if (col < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.getDouble(col);
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("getDouble()", result) ;
+    }
+
+    /**
+    * Has <b>OK</b> status if no exceptions occurred in method call.
+    */
+    public void _getBytes() {
+        boolean result = true ;
+        int col = findColumnOfType(byte[].class) ;
+        if (col < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.getBytes(col);
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("getBytes()", result) ;
+    }
+
+    /**
+    * Has <b>OK</b> status if no exceptions occurred in method call.
+    */
+    public void _getDate() {
+        boolean result = true ;
+        int col = findColumnOfType(Date.class) ;
+        if (col < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.getDate(col);
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("getDate()", result) ;
+    }
+
+    /**
+    * Has <b>OK</b> status if no exceptions occurred in method call.
+    */
+    public void _getTime() {
+        boolean result = true ;
+        int col = findColumnOfType(Time.class) ;
+        if (col < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.getTime(col);
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("getTime()", result) ;
+    }
+
+    /**
+    * Has <b>OK</b> status if no exceptions occurred in method call.
+    */
+    public void _getTimestamp() {
+        boolean result = true ;
+        int col = findColumnOfType(DateTime.class) ;
+        if (col < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.getTimestamp(col);
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("getTimestamp()", result) ;
+    }
+
+    /**
+    * Has <b>OK</b> status if no exceptions occurred in method call.
+    */
+    public void _getBinaryStream() {
+        boolean result = true ;
+        int col = findColumnOfType(XDataInputStream.class) ;
+        if (col < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.getBinaryStream(col);
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("getBinaryStream()", result) ;
+    }
+
+    /**
+    * Has <b>OK</b> status if no exceptions occurred in method call.
+    */
+    public void _getCharacterStream() {
+        boolean result = true ;
+        int col = findColumnOfType(XTextInputStream.class) ;
+        if (col < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.getCharacterStream(col);
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("getCharacterStream()", result) ;
+    }
+
+    /**
+    * Has <b>OK</b> status if no exceptions occurred in method call.
+    */
+    public void _getObject() {
+        boolean result = true ;
+        int col = findColumnOfType(Object[].class) ;
+        if (col < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.getObject(col, null);
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("getObject()", result) ;
+    }
+
+    /**
+    * Has <b>OK</b> status if no exceptions occurred in method call.
+    */
+    public void _getRef() {
+        boolean result = true ;
+        int col = findColumnOfType(XRef.class) ;
+        if (col < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.getRef(col);
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("getRef()", result) ;
+    }
+
+    /**
+    * Has <b>OK</b> status if no exceptions occurred in method call.
+    */
+    public void _getBlob() {
+        boolean result = true ;
+        int col = findColumnOfType(XBlob.class) ;
+        if (col < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.getBlob(col);
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("getBlob()", result) ;
+    }
+
+    /**
+    * Has <b>OK</b> status if no exceptions occurred in method call.
+    */
+    public void _getClob() {
+        boolean result = true ;
+        int col = findColumnOfType(XClob.class) ;
+        if (col < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.getClob(col);
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("getClob()", result) ;
+    }
+
+    /**
+    * Has <b>OK</b> status if no exceptions occurred in method call.
+    */
+    public void _getArray() {
+        boolean result = true ;
+        int col = findColumnOfType(XArray.class) ;
+        if (col < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.getArray(col);
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("getArray()", result) ;
+    }
+
+    /**
+    * Finds in relation vector index of column of the appropriate
+    * type.
+    */
+    protected int findColumnOfType(Class<?> clz) {
+
+        for (int i = 0; i < data.size(); i++)
+            if (clz.isInstance(data.get(i))) return i + 1 ;
+        return -1 ;
+    }
+}  // finish class _XRow
+
+
diff --git a/qadevOOo/tests/java/ifc/sdbc/_XRowSet.java b/qadevOOo/tests/java/ifc/sdbc/_XRowSet.java
new file mode 100644
index 000000000..cda9da30b
--- /dev/null
+++ b/qadevOOo/tests/java/ifc/sdbc/_XRowSet.java
@@ -0,0 +1,192 @@
+/*
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ *   Licensed to the Apache Software Foundation (ASF) under one or more
+ *   contributor license agreements. See the NOTICE file distributed
+ *   with this work for additional information regarding copyright
+ *   ownership. The ASF licenses this file to you under the Apache
+ *   License, Version 2.0 (the "License"); you may not use this file
+ *   except in compliance with the License. You may obtain a copy of
+ *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ */
+
+package ifc.sdbc;
+
+import ifc.sdb._XRowSetApproveBroadcaster;
+import lib.MultiMethodTest;
+import lib.StatusException;
+
+import com.sun.star.lang.EventObject;
+import com.sun.star.sdbc.SQLException;
+import com.sun.star.sdbc.XRowSet;
+import com.sun.star.sdbc.XRowSetListener;
+
+/**
+* Testing <code>com.sun.star.sdbc.XRowSet</code>
+* interface methods :
+* <ul>
+*  <li><code> execute()</code></li>
+*  <li><code> addRowSetListener()</code></li>
+*  <li><code> removeRowSetListener()</code></li>
+* </ul> <p>
+* Required object relations :
+* <ul>
+* <li> <code>'XRowSetApproveBroadcaster.ApproveChecker'</code>:
+*      implementation of inner interface
+*      <code>ifs.sdb._XRowSetApproveBroadcaster.RowSetApproveChecker</code>
+*      which can move cursor within a rowset, change row, and change the
+*      whole rowset. </li>
+* </ul> <p>
+* It is better to recreate the object after test, because of unknown
+* actions made by <code>RowSetApproveChecker</code> interface implementation.
+* @see com.sun.star.sdbc.XRowSet
+* @see ifc.sdb._XRowSetApproveBroadcaster
+*/
+public class _XRowSet extends MultiMethodTest {
+
+    // oObj filled by MultiMethodTest
+    public XRowSet oObj = null ;
+    private _XRowSetApproveBroadcaster.RowSetApproveChecker checker = null ;
+    private final TestListener listener = new TestListener() ;
+
+    private static class TestListener implements XRowSetListener {
+        public boolean cursorMoved = false ;
+        public boolean rowChanged = false ;
+        public boolean rowSetChanged = false ;
+
+        public void reset() {
+            cursorMoved = false ;
+            rowChanged = false ;
+            rowSetChanged = false ;
+        }
+        public void cursorMoved(EventObject ev) {
+            cursorMoved = true ;
+        }
+        public void rowChanged(EventObject ev) {
+            rowChanged = true ;
+        }
+        public void rowSetChanged(EventObject ev) {
+            rowSetChanged = true ;
+        }
+        public void disposing(EventObject ev) {}
+    }
+
+    /**
+    * Retrieves relation.
+    * @throw StatusException If relation not found.
+    */
+    @Override
+    public void before() throws StatusException {
+        checker = (_XRowSetApproveBroadcaster.RowSetApproveChecker)
+            tEnv.getObjRelation("XRowSetApproveBroadcaster.ApproveChecker") ;
+
+        if (checker == null) {
+            log.println("Required relation not found !!!") ;
+            throw new StatusException("Required relation not found !!!",
+                new NullPointerException()) ;
+        }
+    }
+
+    /**
+    * Reexecutes the RowSet and checks that listener was called. <p>
+    * Has OK status if no exceptions were raised and listener was called.
+    */
+    public void _execute() {
+        requiredMethod("addRowSetListener()");
+        listener.reset();
+        try {
+            oObj.execute() ;
+        } catch (SQLException e) {
+            log.println("Exception occurred :" + e) ;
+        }
+
+        tRes.tested("execute()", listener.rowSetChanged);
+    }
+
+    /**
+    * Adds listener and calls methods moveCursor, changeRow,
+    * changeRowSet of the relation and then checks if appropriate
+    * methods of the listener were called. <p>
+    * Has OK status if all listener methods were called.
+    */
+    public void _addRowSetListener() {
+        boolean result = true ;
+
+        oObj.addRowSetListener(listener) ;
+
+        checker.moveCursor() ;
+        result &= listener.cursorMoved ;
+        if (!listener.cursorMoved)
+            log.println("cursorMoved event wasn't called") ;
+        listener.reset() ;
+
+        checker.changeRow() ;
+        result &= listener.rowChanged ;
+        if (!listener.rowChanged)
+            log.println("rowChanged event wasn't called") ;
+        listener.reset() ;
+
+        checker.changeRowSet() ;
+        result &= listener.rowSetChanged ;
+        if (!listener.rowSetChanged)
+            log.println("rowSetChanged event wasn't called") ;
+        listener.reset() ;
+
+        tRes.tested("addRowSetListener()", result) ;
+    }
+
+    /*
+    * Removes listener added before, and checks for no listener
+    * methods were called on response to rowSet manipulations. <p>
+    * Methods to be successfully completed before :
+    * <ul>
+    * <li> <code>addRowSetListener()</code> </li>
+    * </ul> <p>
+    * Has OK status if no listeners methods were called.
+    */
+    public void _removeRowSetListener() {
+        requiredMethod("addRowSetListener()") ;
+
+        boolean result = true ;
+
+        oObj.removeRowSetListener(listener) ;
+
+        checker.moveCursor() ;
+        if (listener.cursorMoved) {
+            log.println("cursorMoved is erroneously set");
+            result = false;
+        }
+        listener.reset() ;
+
+        checker.changeRow() ;
+        if (listener.rowChanged) {
+            log.println("rowChanged is erroneously set");
+            result = false;
+        }
+        listener.reset() ;
+
+        checker.changeRowSet() ;
+        if (listener.rowSetChanged) {
+            log.println("rowSetChanged is erroneously set");
+            result = false;
+        }
+
+        tRes.tested("removeRowSetListener()", result) ;
+    }
+
+    /**
+    * Disposes test environment.
+    */
+    @Override
+    public void after() {
+        disposeEnvironment() ;
+    }
+
+}  // finish class _XRowSet
+
diff --git a/qadevOOo/tests/java/ifc/sdbc/_XRowUpdate.java b/qadevOOo/tests/java/ifc/sdbc/_XRowUpdate.java
new file mode 100644
index 000000000..e57b2f062
--- /dev/null
+++ b/qadevOOo/tests/java/ifc/sdbc/_XRowUpdate.java
@@ -0,0 +1,683 @@
+/*
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ *   Licensed to the Apache Software Foundation (ASF) under one or more
+ *   contributor license agreements. See the NOTICE file distributed
+ *   with this work for additional information regarding copyright
+ *   ownership. The ASF licenses this file to you under the Apache
+ *   License, Version 2.0 (the "License"); you may not use this file
+ *   except in compliance with the License. You may obtain a copy of
+ *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ */
+
+package ifc.sdbc;
+
+import java.util.List;
+
+import lib.MultiMethodTest;
+import lib.Status;
+import util.utils;
+import util.ValueComparer;
+
+import com.sun.star.io.XDataInputStream;
+import com.sun.star.io.XInputStream;
+import com.sun.star.io.XTextInputStream;
+import com.sun.star.sdbc.SQLException;
+import com.sun.star.sdbc.XRow;
+import com.sun.star.sdbc.XRowUpdate;
+import com.sun.star.uno.UnoRuntime;
+import com.sun.star.util.Date;
+import com.sun.star.util.DateTime;
+import com.sun.star.util.Time;
+
+/**
+* Testing <code>com.sun.star.sdbc.XRowUpdate</code>
+* interface methods :
+* <ul>
+*  <li><code> updateNull()</code></li>
+*  <li><code> updateBoolean()</code></li>
+*  <li><code> updateByte()</code></li>
+*  <li><code> updateShort()</code></li>
+*  <li><code> updateInt()</code></li>
+*  <li><code> updateLong()</code></li>
+*  <li><code> updateFloat()</code></li>
+*  <li><code> updateDouble()</code></li>
+*  <li><code> updateString()</code></li>
+*  <li><code> updateBytes()</code></li>
+*  <li><code> updateDate()</code></li>
+*  <li><code> updateTime()</code></li>
+*  <li><code> updateTimestamp()</code></li>
+*  <li><code> updateBinaryStream()</code></li>
+*  <li><code> updateCharacterStream()</code></li>
+*  <li><code> updateObject()</code></li>
+*  <li><code> updateNumericObject()</code></li>
+* </ul> <p>
+* Object relations required :
+* <ul>
+* <li> <code>'CurrentRowData'</code> : (may be used in other
+*   interface tests) is a <code>java.util.Vector</code> object
+*   that contains column types and values in current row. Each
+*   element of vector corresponds to appropriate column (element
+*   with index 0 to column 1, 1 -> 2, etc.). <p>
+*   The following <code>XRowUpdate</code> methods correspond to classes
+*   in Vector :
+*   <ul>
+*   <li> <code>setBinaryStream</code> -
+*        <code>com.sun.star.io.XDataInputStream</code> class. </li>
+*   <li> <code>setCharacterStream</code> -
+*        <code>com.sun.star.io.XTextInputStream</code> class. </li>
+*   <li> <code>setObject</code> -
+*        <code>java.lang.Object[]</code> class, the element with
+*         index 0 must be used. </li>
+*   </ul>
+*   Other methods uses types they return (i.e. <code>String</code>
+*   for <code>setString</code> method, <code>com.sun.star.sdbc.XRef</code>
+*   for <code>setRef</code> method).
+* </li>
+* <li> <code>'XRowUpdate.XRow'</code> : implementation of <code>
+*   com.sun.star.sdbc.XRow</code> interface for checking updated data.
+* </li>
+* </ul> <p>
+* The test <b>damages</b> the object, so it is recreated finally.
+* @see com.sun.star.sdbc.XRowUpdate
+* @see com.sun.star.sdbc.XRow
+*/
+public class _XRowUpdate extends MultiMethodTest {
+
+    // oObj filled by MultiMethodTest
+    public XRowUpdate oObj = null ;
+
+    private List<Object> rowData = null ;
+    private XRow row = null ;
+
+    /**
+    * Gets relations.
+    */
+    @Override
+    public void before() {
+        rowData = (List<Object>) tEnv.getObjRelation("CurrentRowData") ;
+        if (rowData == null) {
+            log.println("!!! 'CurrentRowData' relation not found !!!") ;
+        }
+        row = (XRow) tEnv.getObjRelation("XRowUpdate.XRow") ;
+        if (rowData == null) {
+            log.println("!!! 'XRowUpdate.XRow' relation not found !!!") ;
+        }
+    }
+
+    /**
+    * Try to set NULL value for each column. Then using <code>XRow</code>
+    * relation check if NULL was really set. <p>
+    * Has OK status if for every column NULL value was successfully set.
+    * @see com.sun.star.sdbc.XRow
+    */
+    public void _updateNull() {
+        boolean result = true ;
+        for (int i = 0; i < rowData.size(); i++) {
+            if (rowData.get(i) == null) continue ;
+            log.print("  Setting NULL at column #" + (i+1) + " ...") ;
+            try {
+                oObj.updateNull(i + 1) ;
+
+                if (rowData.get(i) instanceof String) row.getString(i + 1) ;
+                if (rowData.get(i) instanceof Boolean) row.getBoolean(i + 1) ;
+                if (rowData.get(i) instanceof Byte) row.getByte(i + 1) ;
+                if (rowData.get(i) instanceof Short) row.getShort(i + 1) ;
+                if (rowData.get(i) instanceof Integer) row.getInt(i + 1) ;
+                if (rowData.get(i) instanceof Long) row.getLong(i + 1) ;
+                if (rowData.get(i) instanceof Float) row.getFloat(i + 1) ;
+                if (rowData.get(i) instanceof Double) row.getDouble(i + 1) ;
+                if (rowData.get(i) instanceof byte[]) row.getBytes(i + 1) ;
+                if (rowData.get(i) instanceof Date) row.getDate(i + 1) ;
+                if (rowData.get(i) instanceof Time) row.getTime(i + 1) ;
+                if (rowData.get(i) instanceof DateTime)
+                    row.getTimestamp(i + 1) ;
+                if (rowData.get(i) instanceof XDataInputStream)
+                    row.getBinaryStream(i + 1) ;
+                if (rowData.get(i) instanceof XTextInputStream)
+                    row.getCharacterStream(i + 1) ;
+
+                if (!row.wasNull()) {
+                    log.println("FAILED") ;
+                    log.println("Not NULL was returned !!!") ;
+                    result = false ;
+                } else {
+                    log.println("OK") ;
+                }
+            } catch (SQLException e) {
+                log.println("FAILED") ;
+                e.printStackTrace(log) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("updateNull()", result) ;
+    }
+
+    /**
+    * Updates column with the appropriate type (if exists) and then
+    * checks result with interface <code>XRow</code>.<p>
+    * Has OK status if column successfully updated, ahd the same
+    * result returned.
+    */
+    public void _updateBoolean() {
+        boolean result = true ;
+        int idx = findColumnOfType(Boolean.class) ;
+
+        if (idx < 0) {
+            log.println("Required type not found") ;
+            tRes.tested("updateBoolean()", Status.skipped(true)) ;
+            return ;
+        }
+
+        try {
+            boolean newVal = !row.getBoolean(idx) ;
+            oObj.updateBoolean(idx, newVal) ;
+            boolean getVal = row.getBoolean(idx) ;
+            result = newVal == getVal ;
+        } catch (SQLException e) {
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+
+        tRes.tested("updateBoolean()", result) ;
+    }
+
+    /**
+    * Updates column with the appropriate type (if exists) and then
+    * checks result with interface <code>XRow</code>.<p>
+    * Has OK status if column successfully updated, ahd the same
+    * result returned.
+    */
+    public void _updateByte() {
+        boolean result = true ;
+        int idx = findColumnOfType(Byte.class) ;
+
+        if (idx < 0) {
+            log.println("Required type not found") ;
+            tRes.tested("updateByte()", Status.skipped(true)) ;
+            return ;
+        }
+
+        try {
+            byte newVal = (byte) (row.getByte(idx) + 1) ;
+            oObj.updateByte(idx, newVal) ;
+            byte getVal = row.getByte(idx) ;
+            result = newVal == getVal ;
+        } catch (SQLException e) {
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+
+        tRes.tested("updateByte()", result) ;
+    }
+
+    /**
+    * Updates column with the appropriate type (if exists) and then
+    * checks result with interface <code>XRow</code>.<p>
+    * Has OK status if column successfully updated, ahd the same
+    * result returned.
+    */
+    public void _updateShort() {
+        boolean result = true ;
+        int idx = findColumnOfType(Short.class) ;
+
+        if (idx < 0) {
+            log.println("Required type not found") ;
+            tRes.tested("updateShort()", Status.skipped(true)) ;
+            return ;
+        }
+
+        try {
+            short newVal = (short) (row.getShort(idx) + 1) ;
+            oObj.updateShort(idx, newVal) ;
+            short getVal = row.getShort(idx) ;
+            result = newVal == getVal ;
+        } catch (SQLException e) {
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+
+        tRes.tested("updateShort()", result) ;
+    }
+
+    /**
+    * Updates column with the appropriate type (if exists) and then
+    * checks result with interface <code>XRow</code>.<p>
+    * Has OK status if column successfully updated, ahd the same
+    * result returned.
+    */
+    public void _updateInt() {
+        boolean result = true ;
+        int idx = findColumnOfType(Integer.class) ;
+
+        if (idx < 0) {
+            log.println("Required type not found") ;
+            tRes.tested("updateInt()", Status.skipped(true)) ;
+            return ;
+        }
+
+        try {
+            int newVal = 1 + row.getInt(idx)  ;
+            oObj.updateInt(idx, newVal) ;
+            int getVal = row.getInt(idx) ;
+            result = newVal == getVal ;
+        } catch (SQLException e) {
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+
+        tRes.tested("updateInt()", result) ;
+    }
+
+    /**
+    * Updates column with the appropriate type (if exists) and then
+    * checks result with interface <code>XRow</code>.<p>
+    * Has OK status if column successfully updated, ahd the same
+    * result returned.
+    */
+    public void _updateLong() {
+        boolean result = true ;
+        int idx = findColumnOfType(Long.class) ;
+
+        if (idx < 0) {
+            log.println("Required type not found") ;
+            tRes.tested("updateLong()", Status.skipped(true)) ;
+            return ;
+        }
+
+        try {
+            long newVal = 1 + row.getLong(idx) ;
+            oObj.updateLong(idx, newVal) ;
+            long getVal = row.getLong(idx) ;
+            result = newVal == getVal ;
+        } catch (SQLException e) {
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+
+        tRes.tested("updateLong()", result) ;
+    }
+
+    /**
+    * Updates column with the appropriate type (if exists) and then
+    * checks result with interface <code>XRow</code>.<p>
+    * Has OK status if column successfully updated, ahd the same
+    * result returned.
+    */
+    public void _updateFloat() {
+        boolean result = true ;
+        int idx = findColumnOfType(Float.class) ;
+
+        if (idx < 0) {
+            log.println("Required type not found") ;
+            tRes.tested("updateFloat()", Status.skipped(true)) ;
+            return ;
+        }
+
+        try {
+            float newVal = (float) (1.1 + row.getFloat(idx));
+            oObj.updateFloat(idx, newVal) ;
+            float getVal = row.getFloat(idx) ;
+            result = newVal == getVal ;
+        } catch (SQLException e) {
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+
+        tRes.tested("updateFloat()", result) ;
+    }
+
+    /**
+    * Updates column with the appropriate type (if exists) and then
+    * checks result with interface <code>XRow</code>.<p>
+    * Has OK status if column successfully updated, ahd the same
+    * result returned.
+    */
+    public void _updateDouble() {
+        boolean result = true ;
+        int idx = findColumnOfType(Double.class) ;
+
+        if (idx < 0) {
+            log.println("Required type not found") ;
+            tRes.tested("updateDouble()", Status.skipped(true)) ;
+            return ;
+        }
+
+        try {
+            double newVal = 1.1 + row.getDouble(idx) ;
+            oObj.updateDouble(idx, newVal) ;
+            double getVal = row.getDouble(idx) ;
+            result = utils.approxEqual(newVal, getVal);
+        } catch (SQLException e) {
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+
+        tRes.tested("updateDouble()", result) ;
+    }
+
+    /**
+    * Updates column with the appropriate type (if exists) and then
+    * checks result with interface <code>XRow</code>.<p>
+    * Has OK status if column successfully updated, ahd the same
+    * result returned.
+    */
+    public void _updateString() {
+        boolean result = true ;
+        int idx = findColumnOfType(String.class) ;
+
+        if (idx < 0) {
+            log.println("Required type not found") ;
+            tRes.tested("updateString()", Status.skipped(true)) ;
+            return ;
+        }
+
+        try {
+            String newVal = "_" + row.getString(idx) ;
+            oObj.updateString(idx, newVal) ;
+            String getVal = row.getString(idx) ;
+            result = newVal.equals(getVal) ;
+            log.println("New value = '" + newVal + "', get value = '"
+                + getVal + "'") ;
+        } catch (SQLException e) {
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+
+        tRes.tested("updateString()", result) ;
+    }
+
+    /**
+    * Updates column with the appropriate type (if exists) and then
+    * checks result with interface <code>XRow</code>.<p>
+    * Has OK status if column successfully updated, ahd the same
+    * result returned.
+    */
+    public void _updateBytes() {
+        boolean result = true ;
+        int idx = findColumnOfType(byte[].class) ;
+
+        if (idx < 0) {
+            log.println("Required type not found") ;
+            tRes.tested("updateBytes()", Status.skipped(true)) ;
+            return ;
+        }
+
+        try {
+            byte[] newVal = row.getBytes(idx) ;
+            if (newVal == null || newVal.length == 0) {
+                newVal = new byte[] {34, 111, 98} ;
+            } else {
+                newVal = new byte[] {(byte) (newVal[0] + 1), 111, 98} ;
+            }
+            oObj.updateBytes(idx, newVal) ;
+            byte[] getVal = row.getBytes(idx) ;
+            result = ValueComparer.equalValue(newVal, getVal) ;
+        } catch (SQLException e) {
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+
+        tRes.tested("updateBytes()", result) ;
+    }
+
+    /**
+    * Updates column with the appropriate type (if exists) and then
+    * checks result with interface <code>XRow</code>.<p>
+    * Has OK status if column successfully updated, ahd the same
+    * result returned.
+    */
+    public void _updateDate() {
+        boolean result = true ;
+        int idx = findColumnOfType(Date.class) ;
+
+        if (idx < 0) {
+            log.println("Required type not found") ;
+            tRes.tested("updateDate()", Status.skipped(true)) ;
+            return ;
+        }
+
+        try {
+            Date newVal = row.getDate(idx) ;
+            newVal.Year ++ ;
+            oObj.updateDate(idx, newVal) ;
+            Date getVal = row.getDate(idx) ;
+            result = ValueComparer.equalValue(newVal, getVal) ;
+        } catch (SQLException e) {
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+
+        tRes.tested("updateDate()", result) ;
+    }
+
+    /**
+    * Updates column with the appropriate type (if exists) and then
+    * checks result with interface <code>XRow</code>.<p>
+    * Has OK status if column successfully updated, ahd the same
+    * result returned.
+    */
+    public void _updateTime() {
+        boolean result = true ;
+        int idx = findColumnOfType(Time.class) ;
+
+        if (idx < 0) {
+            log.println("Required type not found") ;
+            tRes.tested("updateTime()", Status.skipped(true)) ;
+            return ;
+        }
+
+        try {
+            Time newVal = row.getTime(idx) ;
+            newVal.Seconds ++ ;
+            oObj.updateTime(idx, newVal) ;
+            Time getVal = row.getTime(idx) ;
+            result = ValueComparer.equalValue(newVal, getVal) ;
+        } catch (SQLException e) {
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+
+        tRes.tested("updateTime()", result) ;
+    }
+
+    /**
+    * Updates column with the appropriate type (if exists) and then
+    * checks result with interface <code>XRow</code>.<p>
+    * Has OK status if column successfully updated, ahd the same
+    * result returned.
+    */
+    public void _updateTimestamp() {
+        boolean result = true ;
+        int idx = findColumnOfType(DateTime.class) ;
+
+        if (idx < 0) {
+            log.println("Required type not found") ;
+            tRes.tested("updateTimestamp()", Status.skipped(true)) ;
+            return ;
+        }
+
+        try {
+            DateTime newVal = row.getTimestamp(idx) ;
+            newVal.Year ++ ;
+            oObj.updateTimestamp(idx, newVal) ;
+            DateTime getVal = row.getTimestamp(idx) ;
+            result = ValueComparer.equalValue(newVal, getVal) ;
+        } catch (SQLException e) {
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+
+        tRes.tested("updateTimestamp()", result) ;
+    }
+
+
+    /**
+    * Updates column with the appropriate type (if exists) and then
+    * checks result with interface <code>XRow</code>.<p>
+    * Has OK status if column successfully updated, ahd the same
+    * result returned.
+    */
+    public void _updateBinaryStream() {
+        boolean result = true ;
+        int idx = findColumnOfType(XDataInputStream.class) ;
+
+        if (idx < 0) {
+            log.println("Required type not found") ;
+            tRes.tested("updateBinaryStream()", Status.skipped(true)) ;
+            return ;
+        }
+
+        try {
+            Object oStream = tParam.getMSF().
+                createInstance("com.sun.star.io.DataInputStream") ;
+            XInputStream newVal = UnoRuntime.queryInterface
+                (XInputStream.class, oStream);
+
+            oObj.updateBinaryStream(idx, newVal, 0) ;
+            XInputStream getVal = row.getBinaryStream(idx) ;
+            result = UnoRuntime.areSame(newVal, getVal) ;
+        } catch (SQLException e) {
+            e.printStackTrace(log) ;
+            result = false ;
+        } catch (com.sun.star.uno.Exception e) {
+            log.println("Unexpected exception:") ;
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+
+        tRes.tested("updateBinaryStream()", result) ;
+    }
+
+    /**
+    * Updates column with the appropriate type (if exists) and then
+    * checks result with interface <code>XRow</code>.<p>
+    * Has OK status if column successfully updated, ahd the same
+    * result returned.
+    */
+    public void _updateCharacterStream() {
+        boolean result = true ;
+        int idx = findColumnOfType(XTextInputStream.class) ;
+
+        if (idx < 0) {
+            log.println("Required type not found") ;
+            tRes.tested("updateCharacterStream()", Status.skipped(true)) ;
+            return ;
+        }
+
+        try {
+            Object oStream = tParam.getMSF().
+                createInstance("com.sun.star.io.TextInputStream") ;
+            XInputStream newVal = UnoRuntime.queryInterface
+                (XInputStream.class, oStream);
+
+            oObj.updateCharacterStream(idx, newVal, 0) ;
+            XInputStream getVal = row.getCharacterStream(idx) ;
+            result = UnoRuntime.areSame(newVal, getVal) ;
+        } catch (SQLException e) {
+            e.printStackTrace(log) ;
+            result = false ;
+        } catch (com.sun.star.uno.Exception e) {
+            log.println("Unexpected exception:") ;
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+
+        tRes.tested("updateCharacterStream()", result) ;
+    }
+
+    /**
+    * Updates column with the appropriate type (if exists) and then
+    * checks result with interface <code>XRow</code>.<p>
+    * Has OK status if column successfully updated, ahd the same
+    * result returned.
+    */
+    public void _updateObject() {
+        boolean result = true ;
+        int idx = findColumnOfType(Object[].class) ;
+
+        if (idx < 0) {
+            log.println("Required type not found") ;
+            tRes.tested("updateObject()", Status.skipped(true)) ;
+            return ;
+        }
+
+        try {
+            Object newVal = tParam.getMSF().
+                createInstance("com.sun.star.io.Pipe") ;
+
+            oObj.updateObject(idx, newVal) ;
+        } catch (SQLException e) {
+            e.printStackTrace(log) ;
+            result = false ;
+        } catch (com.sun.star.uno.Exception e) {
+            log.println("Unexpected exception:") ;
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+
+        tRes.tested("updateObject()", result) ;
+    }
+
+    /**
+    * Updates column with the appropriate type (if exists) and then
+    * checks result with interface <code>XRow</code>.<p>
+    * Has OK status if column successfully updated, ahd the same
+    * result returned.
+    */
+    public void _updateNumericObject() {
+        boolean result = true ;
+        int idx = findColumnOfType(Object[].class) ;
+
+        if (idx < 0) {
+            log.println("Required type not found") ;
+            tRes.tested("updateNumericObject()", Status.skipped(true)) ;
+            return ;
+        }
+
+        try {
+            Object newVal = tParam.getMSF().
+                                createInstance("com.sun.star.io.Pipe") ;
+
+            oObj.updateNumericObject(idx, newVal, 0) ;
+        } catch (SQLException e) {
+            e.printStackTrace(log) ;
+            result = false ;
+        } catch (com.sun.star.uno.Exception e) {
+            log.println("Unexpected exception:") ;
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+
+        tRes.tested("updateNumericObject()", result) ;
+    }
+
+    /**
+    * Finds in relation vector index of column of the appropriate
+    * type.
+    */
+    protected int findColumnOfType(Class<?> clz) {
+
+        for (int i = 0; i < rowData.size(); i++)
+            if (clz.isInstance(rowData.get(i))) return i + 1 ;
+        return -1 ;
+    }
+
+    /**
+    * Disposes environment.
+    */
+    @Override
+    public void after() {
+        disposeEnvironment() ;
+    }
+
+}  // finish class _XRow
+
+
diff --git a/qadevOOo/tests/java/ifc/sdbc/_XWarningsSupplier.java b/qadevOOo/tests/java/ifc/sdbc/_XWarningsSupplier.java
new file mode 100644
index 000000000..1758ccb1b
--- /dev/null
+++ b/qadevOOo/tests/java/ifc/sdbc/_XWarningsSupplier.java
@@ -0,0 +1,130 @@
+/*
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ *   Licensed to the Apache Software Foundation (ASF) under one or more
+ *   contributor license agreements. See the NOTICE file distributed
+ *   with this work for additional information regarding copyright
+ *   ownership. The ASF licenses this file to you under the Apache
+ *   License, Version 2.0 (the "License"); you may not use this file
+ *   except in compliance with the License. You may obtain a copy of
+ *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ */
+
+package ifc.sdbc;
+
+import lib.MultiMethodTest;
+import lib.Status;
+import lib.StatusException;
+import util.DBTools;
+import util.utils;
+
+import com.sun.star.sdbc.SQLException;
+import com.sun.star.sdbc.XResultSetUpdate;
+import com.sun.star.sdbc.XRow;
+import com.sun.star.sdbc.XRowUpdate;
+import com.sun.star.sdbc.XWarningsSupplier;
+import com.sun.star.uno.UnoRuntime;
+
+/**
+* Testing <code>com.sun.star.sdbc.XWarningsSupplier</code>
+* interface methods :
+* <ul>
+*  <li><code> getWarnings()</code></li>
+*  <li><code> clearWarnings()</code></li>
+* </ul> <p>
+* @see com.sun.star.sdbc.XWarningsSupplier
+*/
+public class _XWarningsSupplier extends MultiMethodTest {
+
+    // oObj filled by MultiMethodTest
+    public XWarningsSupplier oObj = null ;
+
+    /**
+    * Updates value of int column by value '9999999999999999'.
+    * Calls method and checks returned value. <p>
+    * Has OK status if the method return not empty value.
+    */
+    public void _getWarnings() {
+        final XRowUpdate rowUpdate = UnoRuntime.queryInterface(XRowUpdate.class, oObj);
+        final XResultSetUpdate resultSetUpdate = UnoRuntime.queryInterface(XResultSetUpdate.class, rowUpdate);
+        final XRow row = UnoRuntime.queryInterface(XRow.class, resultSetUpdate);
+        if ( row == null)
+            throw new StatusException(Status.failed("Test must be modified"));
+
+        // not sure what the below test was intended to test, but it actually fails with an SQLException (which is
+        // correct for what is done there), and thus makes the complete interface test fail (which is not correct)
+        // So, for the moment, just let the test succeed all the time - until issue #i84235# is fixed
+
+        if ( false )
+        {
+            int oldVal = 0, newVal = 0;
+            String valToSet = "9999999999999999";
+            try
+            {
+                oldVal = row.getInt(DBTools.TST_INT);
+                rowUpdate.updateString(DBTools.TST_INT, valToSet);
+                resultSetUpdate.updateRow();
+                newVal = row.getInt(DBTools.TST_INT);
+            }
+            catch(com.sun.star.sdbc.SQLException e)
+            {
+                log.println("Unexpected SQL exception");
+                e.printStackTrace(log);
+                tRes.tested("getWarnings()", false);
+                return;
+            }
+
+            log.println("Old INT value: " + oldVal);
+            log.println("Value that was set: " + valToSet);
+            log.println("New INT value: " + newVal);
+
+            boolean res = false;
+
+            try
+            {
+                Object warns = oObj.getWarnings();
+                res = (!utils.isVoid(warns));
+            }
+            catch (SQLException e)
+            {
+                log.println("Exception occurred :");
+                e.printStackTrace(log);
+                tRes.tested("getWarnings()", res);
+                return;
+            }
+            tRes.tested("getWarnings()", res);
+        }
+        else
+            tRes.tested( "getWarnings()", true );
+    }
+
+    /**
+    * Calls method and checks value returned by the method
+    * <code>getWarnings()</code>. <p>
+    * Has OK status if the method <code>getWarnings()</code> return void value.
+    */
+    public void _clearWarnings() {
+        executeMethod("getWarnings()");
+        boolean res = false;
+
+        try {
+            oObj.clearWarnings();
+            Object warns = oObj.getWarnings();
+            res = utils.isVoid(warns);
+        } catch (SQLException e) {
+            log.println("Exception occurred :");
+            e.printStackTrace(log);
+            tRes.tested("clearWarnings()", res);
+            return;
+        }
+
+        tRes.tested("clearWarnings()", res);
+    }
+
+}