<html> <head> <title>Service RowSet</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="RowSet-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="#ServicesSummary" class="navisub">Services' Summary</a></td> <td class="navisub"><a href="#InterfacesSummary" class="navisub">Interfaces' Summary</a></td> <td class="navisub"><a href="#PropertiesSummary" class="navisub">Properties' Summary</a></td> <td class="navisub"><a href="#ServicesDetails" class="navisub">Services' Details</a></td> <td class="navisub"><a href="#InterfacesDetails" class="navisub">Interfaces' Details</a></td> <td class="navisub"><a href="#PropertiesDetails" class="navisub">Properties' Details</a></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">service RowSet</td> </tr> <tr> <td><dl> <dt><b>Description</b></dt> <dd>is a client side ResultSet, which combines the characteristics of a <a href="Statement.html">Statement</a> and a <a href="ResultSet.html">ResultSet</a>. </dd> <dd><p> It acts like a typical bean. Before you use the RowSet, you have to specify a set of properties like a DataSource and a Command and other properties known of Statement. <br/> Afterwards, you can populate the RowSet by its execute method to fill the set with data. </p> <p> On the one hand, a RowSet can be used as a short cut to retrieve the data of a DataSource. You don't have to establish a connection, create a Statement, and then create a ResultSet. On the other hand, a rowset can be used to implement capabilties for a result set, which are not supported by a driver result set, like caching strategies or update capabilities. </p> </dd> </dl> </td> </tr> </table> <hr> <a name="ServicesSummary"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Included Services - Summary</td> </tr> <tr> <td class="imsum_left"><a href="ResultSet.html">ResultSet</a></td> <td class="imsum_right"><dl> <dt>(referenced entity's summary:)</dt> <dd>provides access to a table of data. A ResultSet object is usually generated by executing a Statement. </dd> </dl> </td> </tr> </table> <a name="InterfacesSummary"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Exported Interfaces - Summary</td> </tr> <tr> <td class="imsum_left"><a href="XRowSet.html">XRowSet</a></td> <td class="imsum_right"><p>used to execute and to add/remove listeners. (<a href="#XRowSet">details</a>)</p> </td> </tr> <tr> <td class="imsum_left"><a href="XParameters.html">XParameters</a></td> <td class="imsum_right"><dl> <dt>(referenced entity's summary:)</dt> <dd>is used for parameter setting, commonly implemented in conjunction with PreparedStatements. </dd> </dl> </td> </tr> <tr> <td class="imsum_left"><a href="XColumnLocate.html">XColumnLocate</a></td> <td class="imsum_right"><p>allows locating columns which's name is known only. </p> </td> </tr> </table> <a name="PropertiesSummary"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Properties' Summary</td> </tr> <tr> <td class="imsum_left">string<br> <a href="#DataSourceName">DataSourceName</a></td> <td class="imsum_right">is the name of a named datasource to use. </td> </tr> <tr> <td class="imsum_left">string<br> <a href="#URL">URL</a></td> <td class="imsum_right">is the connection URL. Could be used instead of the DataSourceName. </td> </tr> <tr> <td class="imsum_left">string<br> <a href="#Command">Command</a></td> <td class="imsum_right">is the command which should be executed. </td> </tr> <tr> <td class="imsum_left">long<br> <a href="#TransactionIsolation">TransactionIsolation</a></td> <td class="imsum_right">indicates the transaction isolation level, which should be used for the connection. </td> </tr> <tr> <td class="imsum_left">::com::sun::star::<a href="../container/module-ix.html">container</a>::<a href="../container/XNameAccess.html">XNameAccess</a><br> <a href="#TypeMap">TypeMap</a></td> <td class="imsum_right">is the type map that will be used for the custom mapping of SQL structured types and distinct types. </td> </tr> <tr> <td class="imsum_left">boolean<br> <a href="#EscapeProcessing">EscapeProcessing</a></td> <td class="imsum_right">returns if escape processing is on or off. If escape scanning is on (the default), the driver will do escape substitution before sending the SQL to the database. This is only evaluated, if the CommandType is COMMAND. </td> </tr> <tr> <td class="imsum_left">long<br> <a href="#QueryTimeOut">QueryTimeOut</a></td> <td class="imsum_right">retrieves the number of seconds the driver will wait for a Statement to execute. If the limit is exceeded, a <a href="SQLException.html">SQLException</a> is thrown. There is no limitation, if set to zero. </td> </tr> <tr> <td class="imsum_left">long<br> <a href="#MaxFieldSize">MaxFieldSize</a></td> <td class="imsum_right">returns the maximum number of bytes allowed for any column value. </td> </tr> <tr> <td class="imsum_left">long<br> <a href="#MaxRows">MaxRows</a></td> <td class="imsum_right">retrieves the maximum number of rows that a ResultSet can contain. If the limit is exceeded, the excess rows are silently dropped. <br/> There is no limitation, if set to zero. </td> </tr> <tr> <td class="imsum_left">string<br> <a href="#User">User</a></td> <td class="imsum_right">determines the user for whom to open the connection. </td> </tr> <tr> <td class="imsum_left">string<br> <a href="#Password">Password</a></td> <td class="imsum_right">determines the user for whom to open the connection. </td> </tr> <tr> <td class="imsum_left">long<br> <a href="#ResultSetType">ResultSetType</a></td> <td class="imsum_right">determine the result set type. </td> </tr> </table> <a name="ServicesDetails"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Included Services - Details</td> </tr> <tr/> <tr> <td class="imdetail"><a name="ResultSet" class="membertitle"><a href="ResultSet.html">ResultSet</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt>(referenced entity's summary:)</dt> <dd>provides access to a table of data. A ResultSet object is usually generated by executing a Statement. </dd> </dl> </td> </tr> </table> </td> </tr> </table> <a name="InterfacesDetails"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Exported Interfaces - Details</td> </tr> <tr/> <tr> <td class="imdetail"><a name="XRowSet" class="membertitle"><a href="XRowSet.html">XRowSet</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt><b>Description</b></dt> <dd>used to execute and to add/remove listeners. </dd> <dd><p>To refresh the content of a <a href="RowSet.html">RowSet</a>, use this interface's <a href="XRowSet.html">XRowSet</a>::<a href="XRowSet.html#execute">execute</a> method.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr/> <tr> <td class="imdetail"><a name="XParameters" class="membertitle"><a href="XParameters.html">XParameters</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt>(referenced entity's summary:)</dt> <dd>is used for parameter setting, commonly implemented in conjunction with PreparedStatements. </dd> </dl> </td> </tr> </table> </td> </tr> <tr/> <tr> <td class="imdetail"><a name="XColumnLocate" class="membertitle"><a href="XColumnLocate.html">XColumnLocate</a></a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><dl> <dt><b>Description</b></dt> <dd>allows locating columns which's name is known only. </dd> </dl> </td> </tr> </table> </td> </tr> </table> <a name="PropertiesDetails"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle">Properties' Details</td> </tr> <tr> <td class="imdetail"><a name="DataSourceName" class="membertitle">DataSourceName</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>string <b>DataSourceName</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>is the name of a named datasource to use.</dd> <dt><b>See also</b></dt> <dd/></dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="URL" class="membertitle">URL</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>string <b>URL</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>is the connection URL. Could be used instead of the DataSourceName. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="Command" class="membertitle">Command</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>string <b>Command</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>is the command which should be executed. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="TransactionIsolation" class="membertitle">TransactionIsolation</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>long <b>TransactionIsolation</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>indicates the transaction isolation level, which should be used for the connection.</dd> <dt><b>See also</b></dt> <dd><a href="TransactionIsolation.html">TransactionIsolation</a></dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="TypeMap" class="membertitle">TypeMap</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>::com::sun::star::<a href="../container/module-ix.html">container</a>::<a href="../container/XNameAccess.html">XNameAccess</a> <b>TypeMap</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>is the type map that will be used for the custom mapping of SQL structured types and distinct types. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="EscapeProcessing" class="membertitle">EscapeProcessing</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>boolean <b>EscapeProcessing</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>returns if escape processing is on or off. If escape scanning is on (the default), the driver will do escape substitution before sending the SQL to the database. This is only evaluated, if the CommandType is COMMAND. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="QueryTimeOut" class="membertitle">QueryTimeOut</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>long <b>QueryTimeOut</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>retrieves the number of seconds the driver will wait for a Statement to execute. If the limit is exceeded, a <a href="SQLException.html">SQLException</a> is thrown. There is no limitation, if set to zero. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="MaxFieldSize" class="membertitle">MaxFieldSize</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>long <b>MaxFieldSize</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>returns the maximum number of bytes allowed for any column value. </dd> <dd><p> This limit is the maximum number of bytes that can be returned for any column value. The limit applies only to <a href="DataType.html">DataType</a>::<a href="DataType.html#BINARY">BINARY</a> , <a href="DataType.html">DataType</a>::<a href="DataType.html#VARBINARY">VARBINARY</a> , <a href="DataType.html">DataType</a>::<a href="DataType.html#LONGVARBINARY">LONGVARBINARY</a> , <a href="DataType.html">DataType</a>::<a href="DataType.html#CHAR">CHAR</a> , <a href="DataType.html">DataType</a>::<a href="DataType.html#VARCHAR">VARCHAR</a> , and <a href="DataType.html">DataType</a>::<a href="DataType.html#LONGVARCHAR">LONGVARCHAR</a> columns. If the limit is exceeded, the excess data is silently discarded. <br/> There is no limitation, if set to zero. </p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="MaxRows" class="membertitle">MaxRows</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>long <b>MaxRows</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>retrieves the maximum number of rows that a ResultSet can contain. If the limit is exceeded, the excess rows are silently dropped. <br/> There is no limitation, if set to zero. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="User" class="membertitle">User</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>string <b>User</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>determines the user for whom to open the connection. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="Password" class="membertitle">Password</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>string <b>Password</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>determines the user for whom to open the connection. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="ResultSetType" class="membertitle">ResultSetType</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>long <b>ResultSetType</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>determine the result set type. </dd> <dt><b>See also</b></dt> <dd><a href="ResultSetType.html">ResultSetType</a></dd> </dl> </td> </tr> </table> </td> </tr> </table> <br> <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
>
5408
