<html> <head> <title>Interface XArray</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <link rel="stylesheet" type="text/css" href="../../../../idl.css"> </head> <body> <div id="adc-idlref"> <a name="_top_"> </a><table class="navimain" border="0" cellpadding="3"> <tr> <td class="navimain"><a href="../module-ix.html" class="navimain">Overview</a></td> <td class="navimain"><a href="module-ix.html" class="navimain">Module</a></td> <td class="navimain"><a href="XArray-xref.html" class="navimain">Use</a></td> <td class="navimainnone">Devguide</td> <td class="navimain"><a href="../../../../index-files/index-1.html" class="navimain">Index</a></td> </tr> </table> <table class="navisub" border="0" cellpadding="0"> <tr> <td class="navisub"><a href="#MethodsSummary" class="navisub">Methods' Summary</a></td> <td class="navisub">Attributes' Summary</td> <td class="navisub"><a href="#MethodsDetails" class="navisub">Methods' Details</a></td> <td class="navisub">Attributes' Details</td> </tr> </table> <hr> <table border="0" width="100%" cellpadding="5" cellspacing="3" class="title-table" style="margin-bottom:6pt;"> <tr> <td><p class="namechain"><a href="../../../../module-ix.html" class="namechain">::</a> <a href="../../../module-ix.html" class="namechain">com</a> :: <a href="../../module-ix.html" class="namechain">sun</a> :: <a href="../module-ix.html" class="namechain">star</a> :: <a href="module-ix.html" class="namechain">sdbc</a> :: </p> </td> </tr> <tr> <td class="title">interface XArray</td> </tr> <tr> <td/></tr> <tr> <td><dl> <dt><b>Description</b></dt> <dd>is used for mapping the SQL type <a href="DataType.html">DataType</a>::<a href="DataType.html#ARRAY">ARRAY</a> . By default, an <code>Array</code> is a transaction duration reference to an SQL array. By default, an <code>Array</code> is implemented using a SQL LOCATOR(array) internally. </dd> </dl> </td> </tr> </table> <hr> <a name="MethodsSummary"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Methods' Summary</td> </tr> <tr> <td class="imsum_left"><a href="#getBaseTypeName">getBaseTypeName</a></td> <td class="imsum_right">returns the SQL type name of the elements in the array designated by this <code>Array</code> object. </td> </tr> <tr> <td class="imsum_left"><a href="#getBaseType">getBaseType</a></td> <td class="imsum_right">returns the SDBC type of the elements in the array designated by this <code>Array</code> object. </td> </tr> <tr> <td class="imsum_left"><a href="#getArray">getArray</a></td> <td class="imsum_right">retrieves the contents of the SQL array designated by this <code>Array</code> object, using the specified <code>typeMap</code> for type map customizations. </td> </tr> <tr> <td class="imsum_left"><a href="#getArrayAtIndex">getArrayAtIndex</a></td> <td class="imsum_right">returns an array containing a slice of the SQL array, beginning with the specified <code>index</code> and containing up to <code>count</code> successive elements of the SQL array. </td> </tr> <tr> <td class="imsum_left"><a href="#getResultSet">getResultSet</a></td> <td class="imsum_right">returns a result set that contains the elements of the array designated by this <code>Array</code> object and uses the given <code>typeMap</code> to map the array elements. If the base type of the array does not match a user-defined type in <code>typeMap</code> or the <code>typeMap</code> is <b>NULL</b> , the connection type mapping is used instead. </td> </tr> <tr> <td class="imsum_left"><a href="#getResultSetAtIndex">getResultSetAtIndex</a></td> <td class="imsum_right">returns a result set holding the elements of the subarray that starts at index <code>index</code> and contains up to <code>count</code> successive elements. This method uses the given <code>typeMap</code> to map the array elements. If the base type of the array does not match a user-defined type in <code>typeMap</code> or the <code>typeMap</code> is <b>NULL</b> , the connection type mapping is used instead. </td> </tr> </table> <a name="MethodsDetails"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle">Methods' Details</td> </tr> <tr> <td class="imdetail"><a name="getBaseTypeName" class="membertitle">getBaseTypeName</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-method" bgcolor="#ffffff" align="center"> <tr> <td><table class="table-in-method" border="0"> <tr> <td valign="top" colspan="3">string</td> </tr> <tr> <td valign="top"><b>getBaseTypeName</b>()</td> </tr> <tr> <td valign="top" align="right">raises( </td> <td valign="top" colspan="2"><a href="SQLException.html">SQLException</a> );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>returns the SQL type name of the elements in the array designated by this <code>Array</code> object. </dd> <dd><p> If the elements are a built-in type, it returns the database-specific type name of the elements. If the elements are a user-defined type (UDT), this method returns the fully-qualified SQL type name. </p> </dd> <dt><b>Returns</b></dt> <dd>a String that is the database-specific name for a built-in base type or the fully-qualified SQL type name for a base type that is a UDT </dd> <dt><b>Throws</b></dt> <dd>SQLException if a database access error occurs. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="getBaseType" class="membertitle">getBaseType</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-method" bgcolor="#ffffff" align="center"> <tr> <td><table class="table-in-method" border="0"> <tr> <td valign="top" colspan="3">long</td> </tr> <tr> <td valign="top"><b>getBaseType</b>()</td> </tr> <tr> <td valign="top" align="right">raises( </td> <td valign="top" colspan="2"><a href="SQLException.html">SQLException</a> );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>returns the SDBC type of the elements in the array designated by this <code>Array</code> object. </dd> <dt><b>Returns</b></dt> <dd>a constant from the SDBC types that is the type code for the elements in the array designated by this Array object. </dd> <dt><b>Throws</b></dt> <dd>SQLException if a database access error occurs. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="getArray" class="membertitle">getArray</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-method" bgcolor="#ffffff" align="center"> <tr> <td><table class="table-in-method" border="0"> <tr> <td valign="top" colspan="3">sequence< any ></td> </tr> <tr> <td valign="top"><b>getArray</b>(</td> <td valign="top">[in] ::com::sun::star::<a href="../container/module-ix.html">container</a>::<a href="../container/XNameAccess.html">XNameAccess</a></td> <td valign="bottom"> typeMap )</td> </tr> <tr> <td valign="top" align="right">raises( </td> <td valign="top" colspan="2"><a href="SQLException.html">SQLException</a> );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>retrieves the contents of the SQL array designated by this <code>Array</code> object, using the specified <code>typeMap</code> for type map customizations. </dd> <dd><p> If the base type of the array does not match a user-defined type in <code>typeMap</code> , the standard mapping is used instead. </dd> <dt><b>Parameter typeMap</b></dt> <dd>is a map object that contains mappings of SQL type names to services. If the <code>typeMap</code> is <b>NULL</b> , the type-map associated with the connection for customizations of the type-mappings is used. </dd> <dt><b>Returns</b></dt> <dd>an sequence that contains the ordered elements of the SQL array designated by this object. </dd> <dt><b>Throws</b></dt> <dd>SQLException if an error occurs while attempting to access the array. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="getArrayAtIndex" class="membertitle">getArrayAtIndex</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-method" bgcolor="#ffffff" align="center"> <tr> <td><table class="table-in-method" border="0"> <tr> <td valign="top" colspan="3">sequence< any ></td> </tr> <tr> <td valign="top"><b>getArrayAtIndex</b>(</td> <td valign="top">[in] long</td> <td valign="bottom"> index,</td> </tr> <tr> <td/><td valign="top">[in] long</td> <td valign="bottom"> count,</td> </tr> <tr> <td/><td valign="top">[in] ::com::sun::star::<a href="../container/module-ix.html">container</a>::<a href="../container/XNameAccess.html">XNameAccess</a></td> <td valign="bottom"> typeMap )</td> </tr> <tr> <td valign="top" align="right">raises( </td> <td valign="top" colspan="2"><a href="SQLException.html">SQLException</a> );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>returns an array containing a slice of the SQL array, beginning with the specified <code>index</code> and containing up to <code>count</code> successive elements of the SQL array. </dd> <dt><b>Parameter index</b></dt> <dd>is the array index of the first element to retrieve; the first element is at index 1. </dd> <dt><b>Parameter count</b></dt> <dd>is the number of successive SQL array elements to retrieve. </dd> <dt><b>Parameter typeMap</b></dt> <dd>is a map object that contains mappings of SQL type names to services. If the <code>typeMap</code> is <b>NULL</b> , the type-map associated with the connection for customizations of the type-mappings is used. </dd> <dt><b>Returns</b></dt> <dd>an array containing up to <code>count</code> consecutive elements of the SQL array, beginning with element <code>index</code> . </dd> <dt><b>Throws</b></dt> <dd>SQLException if an error occurs while attempting to access the array. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="getResultSet" class="membertitle">getResultSet</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-method" bgcolor="#ffffff" align="center"> <tr> <td><table class="table-in-method" border="0"> <tr> <td valign="top" colspan="3"><a href="XResultSet.html">XResultSet</a></td> </tr> <tr> <td valign="top"><b>getResultSet</b>(</td> <td valign="top">[in] ::com::sun::star::<a href="../container/module-ix.html">container</a>::<a href="../container/XNameAccess.html">XNameAccess</a></td> <td valign="bottom"> typeMap )</td> </tr> <tr> <td valign="top" align="right">raises( </td> <td valign="top" colspan="2"><a href="SQLException.html">SQLException</a> );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>returns a result set that contains the elements of the array designated by this <code>Array</code> object and uses the given <code>typeMap</code> to map the array elements. If the base type of the array does not match a user-defined type in <code>typeMap</code> or the <code>typeMap</code> is <b>NULL</b> , the connection type mapping is used instead. </dd> <dd><p> The result set contains one row for each array element, with two columns in each row. The second column stores the element value; the first column stores the index into the array for that element (with the first array element being at index 1). The rows are in ascending order corresponding to the order of the indices. </p> </dd> <dt><b>Parameter typeMap</b></dt> <dd>contains mapping of SQL user-defined types to classes in the UNO programming language </dd> <dt><b>Returns</b></dt> <dd>a ResultSet object containing one row for each of the elements in the array designated by this Array object, with the rows in ascending order based on the indices. </dd> <dt><b>Throws</b></dt> <dd>SQLException if a database access error occurs. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="getResultSetAtIndex" class="membertitle">getResultSetAtIndex</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-method" bgcolor="#ffffff" align="center"> <tr> <td><table class="table-in-method" border="0"> <tr> <td valign="top" colspan="3"><a href="XResultSet.html">XResultSet</a></td> </tr> <tr> <td valign="top"><b>getResultSetAtIndex</b>(</td> <td valign="top">[in] long</td> <td valign="bottom"> index,</td> </tr> <tr> <td/><td valign="top">[in] long</td> <td valign="bottom"> count,</td> </tr> <tr> <td/><td valign="top">[in] ::com::sun::star::<a href="../container/module-ix.html">container</a>::<a href="../container/XNameAccess.html">XNameAccess</a></td> <td valign="bottom"> typeMap )</td> </tr> <tr> <td valign="top" align="right">raises( </td> <td valign="top" colspan="2"><a href="SQLException.html">SQLException</a> );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>returns a result set holding the elements of the subarray that starts at index <code>index</code> and contains up to <code>count</code> successive elements. This method uses the given <code>typeMap</code> to map the array elements. If the base type of the array does not match a user-defined type in <code>typeMap</code> or the <code>typeMap</code> is <b>NULL</b> , the connection type mapping is used instead. </dd> <dd><p> The result set contains one row for each array element, with two columns in each row. The second column stores the element value; the first column stores the index into the array for that element (with the first array element being at index 1). The rows are in ascending order corresponding to the order of the indices. </p> </dd> <dt><b>Parameter index</b></dt> <dd>the array index of the first element to retrieve; the first element is at index 1. </dd> <dt><b>Parameter count</b></dt> <dd>the number of successive SQL array elements to retrieve, </dd> <dt><b>Parameter typeMap</b></dt> <dd>the Map object that contains the mapping of SQL type names to classes in the UNO programming language. </dd> <dt><b>Returns</b></dt> <dd>a ResultSet object containing up to count consecutive elements of the SQL array designated by this Array object, starting at index index. </dd> <dt><b>Throws</b></dt> <dd>SQLException if a database access error occurs. </dd> </dl> </td> </tr> </table> </td> </tr> </table> <a href="#_top_">Top of Page</a><hr size="3"><p class="copyright" align="center">Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.</p> </div> <!-- id="adc-idlref" --> </body> </html>
distrib
>
Mandriva
>
current
>
i586
>
media
>
main-updates
>
by-pkgid
>
fc480f9d5aabed8eeaffe8ad3401a94c
>
files
>
5417
