/************************************************************** * * 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 * * Unless required by applicable law or agreed to in writing, * software distributed under the License is distributed on an * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY * KIND, either express or implied. See the License for the * specific language governing permissions and limitations * under the License. * *************************************************************/ #ifndef __com_sun_star_sdbc_XRow_idl__ #define __com_sun_star_sdbc_XRow_idl__ #ifndef __com_sun_star_uno_XInterface_idl__ #include #endif #ifndef __com_sun_star_util_Date_idl__ #include #endif #ifndef __com_sun_star_util_DateTime_idl__ #include #endif #ifndef __com_sun_star_util_Time_idl__ #include #endif module com { module sun { module star { module io { published interface XInputStream; };};};}; module com { module sun { module star { module container { published interface XNameAccess; };};};}; #ifndef __com_sun_star_sdbc_SQLException_idl__ #include #endif module com { module sun { module star { module sdbc { published interface XRef; published interface XArray; published interface XBlob; published interface XClob; /** is used to access data which is collected in a row. All methods raise a SQLException if a database access error occurs. */ published interface XRow: com::sun::star::uno::XInterface { //------------------------------------------------------------------------- /** reports whether the last column read had a value of SQL NULL. Note that you must first call getXXX on a column to try to read its value and then call wasNull() to see if the value read was SQL NULL. @returns if last column read was SQL NULL and otherwise @throws SQLException if a database access error occurs. */ boolean wasNull() raises (SQLException); //------------------------------------------------------------------------- /** gets the value of a column in the current row as a string. @param columnIndex the first column is 1, the second is 2, @returns the column value; if the value is SQL NULL, the result is null @throws SQLException if a database access error occurs. */ string getString([in]long columnIndex) raises (SQLException); //------------------------------------------------------------------------- /** gets the value of a column in the current row as boolean. @param columnIndex the first column is 1, the second is 2, @returns the column value; if the value is SQL NULL, the result is null @throws SQLException if a database access error occurs. */ boolean getBoolean([in]long columnIndex) raises (SQLException); //------------------------------------------------------------------------- /** get the value of a column in the current row as a byte. @param columnIndex the first column is 1, the second is 2, @returns the column value; if the value is SQL NULL, the result is null @throws SQLException if a database access error occurs. */ byte getByte([in]long columnIndex) raises (SQLException); //------------------------------------------------------------------------- /** gets the value of a column in the current row as a short. @param columnIndex the first column is 1, the second is 2, @returns the column value; if the value is SQL NULL, the result is null @throws SQLException if a database access error occurs. */ short getShort([in]long columnIndex) raises (SQLException); //------------------------------------------------------------------------- /** get the value of a column in the current row as an integer. @param columnIndex the first column is 1, the second is 2, @returns the column value; if the value is SQL NULL, the result is null @throws SQLException if a database access error occurs. */ long getInt([in]long columnIndex) raises (SQLException); //------------------------------------------------------------------------- /** get the value of a column in the current row as a long. @param columnIndex the first column is 1, the second is 2, @returns the column value; if the value is SQL NULL, the result is null @throws SQLException if a database access error occurs. */ hyper getLong([in]long columnIndex) raises (SQLException); //------------------------------------------------------------------------- /** gets the value of a column in the current row as a float. @param columnIndex the first column is 1, the second is 2, @returns the column value; if the value is SQL NULL, the result is null @throws SQLException if a database access error occurs. */ float getFloat([in]long columnIndex) raises (SQLException); //------------------------------------------------------------------------- /** gets the value of a column in the current row as a double. @param columnIndex the first column is 1, the second is 2, @returns the column value; if the value is SQL NULL, the result is null @throws SQLException if a database access error occurs. */ double getDouble([in]long columnIndex) raises (SQLException); //------------------------------------------------------------------------- /** gets the value of a column in the current row as a byte array. The bytes represent the raw values returned by the driver. @param columnIndex the first column is 1, the second is 2, ... @returns the column value; if the value is SQL NULL, the result is empty. @throws SQLException if a database access error occurs. */ sequence getBytes([in]long columnIndex) raises (SQLException); //------------------------------------------------------------------------- /** gets the value of a column in the current row as a date object. @param columnIndex the first column is 1, the second is 2, @returns the column value; if the value is SQL NULL, the result is null @throws SQLException if a database access error occurs. */ com::sun::star::util::Date getDate([in]long columnIndex) raises (SQLException); //------------------------------------------------------------------------- /** gets the value of a column in the current row as a time object. @param columnIndex the first column is 1, the second is 2, @returns the column value; if the value is SQL NULL, the result is null @throws SQLException if a database access error occurs. */ com::sun::star::util::Time getTime([in]long columnIndex) raises (SQLException); //------------------------------------------------------------------------- /** gets the value of a column in the current row as a datetime object. @param columnIndex the first column is 1, the second is 2, @returns the column value; if the value is SQL NULL, the result is null @throws SQLException if a database access error occurs. */ com::sun::star::util::DateTime getTimestamp([in]long columnIndex) raises (SQLException); //------------------------------------------------------------------------- /** gets the value of a column in the current row as a stream of uninterpreted bytes. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARBINARY values.

Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream. Also, a stream may return 0 when the method XInputStream::available() is called whether there is data available or not.

@param columnIndex the first column is 1, the second is 2, @returns the column value; if the value is SQL NULL, the result is null @throws SQLException if a database access error occurs. */ com::sun::star::io::XInputStream getBinaryStream([in]long columnIndex) raises (SQLException); //------------------------------------------------------------------------- /** gets the value of a column in the current row as a stream of uninterpreted bytes. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARBINARY or LONGVARCHAR values.

Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream. Also, a stream may return 0 when the method XInputStream::available() is called whether there is data available or not.

@param columnIndex the first column is 1, the second is 2, @returns the column value; if the value is SQL NULL, the result is null @throws SQLException if a database access error occurs. */ com::sun::star::io::XInputStream getCharacterStream([in]long columnIndex) raises (SQLException); //------------------------------------------------------------------------- /** returns the value of a column in the current row as an object. This method uses the given Map object for the custom mapping of the SQL structure or distinct type that is being retrieved. @param columnIndex the first column is 1, the second is 2, @param typeMap the map of types which should be used to get the column value @returns the column value; if the value is SQL NULL, the result is null @throws SQLException if a database access error occurs. */ any getObject([in]long columnIndex, [in]com::sun::star::container::XNameAccess typeMap) raises (SQLException); //------------------------------------------------------------------------- /** gets a REF(<structured-type>) column value from the current row. @param columnIndex the first column is 1, the second is 2, @returns the column value; if the value is SQL NULL, the result is null @throws SQLException if a database access error occurs. */ XRef getRef([in]long columnIndex) raises (SQLException); //------------------------------------------------------------------------- /** gets a BLOB value in the current row. @param columnIndex the first column is 1, the second is 2, @returns the column value; if the value is SQL NULL, the result is null @throws SQLException if a database access error occurs. */ XBlob getBlob([in]long columnIndex) raises (SQLException); //------------------------------------------------------------------------- /** gets a CLOB value in the current row of this ResultSet object. @param columnIndex the first column is 1, the second is 2, @returns the column value; if the value is SQL NULL, the result is null @throws SQLException if a database access error occurs. */ XClob getClob([in]long columnIndex) raises (SQLException); //------------------------------------------------------------------------- /** gets a SQL ARRAY value from the current row of this ResultSet object. @param columnIndex the first column is 1, the second is 2, @returns the column value; if the value is SQL NULL, the result is null @throws SQLException if a database access error occurs. */ XArray getArray([in]long columnIndex) raises (SQLException); }; //============================================================================= }; }; }; }; /*=========================================================================== ===========================================================================*/ #endif