<html> <head> <title>Service JDBCConnectionProperties</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="JDBCConnectionProperties-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">Interfaces' Summary</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">Interfaces' Details</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"><table class="title-table" width="99%"> <tr> <td width="25%" class="title2">unpublished </td> <td width="50%" class="title">service JDBCConnectionProperties</td> <td width="*"/></tr> </table> </td> </tr> <tr> <td><dl> <dt><b>Usage Restrictions</b></dt> <dd><i>not published</i></dd> <dt><b>Description</b></dt> <dd>represents the properties for a JDBC connection (session) with a specific database. These properties can be used when calling the method <a href="XDriver.html">XDriver</a>::<a href="XDriver.html#connect">connect()</a> or <a href="XDriverManager.html">XDriverManager</a>::<a href="XDriverManager.html#getConnectionWithInfo">getConnectionWithInfo()</a>. </dd> <dd><p> The properties for a connection contain additonal information about how to connect to a database and how to control the behavior of the resulting connection should be. </p> </dd> <dt><b>See also</b></dt> <dd><a href="XDriver.html">XDriver</a>, <a href="XDriverManager.html">XDriverManager</a>, <a href="ConnectionProperties.html">ConnectionProperties</a></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="ConnectionProperties.html">ConnectionProperties</a></td> <td class="imsum_right"><dl> <dt>(referenced entity's summary:)</dt> <dd>represents the properties for a connection (session) with a specific database. These properties can be used when calling the method <a href="XDriver.html">XDriver</a>::<a href="XDriver.html#connect">connect()</a> or <a href="XDriverManager.html">XDriverManager</a>::<a href="XDriverManager.html#getConnectionWithInfo">getConnectionWithInfo()</a>. </dd> </dl> </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="#JavaDriverClass">JavaDriverClass</a></td> <td class="imsum_right"><b>[ OPTIONAL ]<br> </b>which jdbc driver class should be loaded to create the connection. </td> </tr> <tr> <td class="imsum_left">string<br> <a href="#JavaDriverClassPath">JavaDriverClassPath</a></td> <td class="imsum_right"><b>[ OPTIONAL ]<br> </b>an optional class path to locate the <a href="JDBCConnectionProperties.html">JDBCConnectionProperties</a>::<a href="JDBCConnectionProperties.html#JavaDriverClass">JavaDriverClass</a>. </td> </tr> <tr> <td class="imsum_left">sequence< ::com::sun::star::<a href="../beans/module-ix.html">beans</a>::<a href="../beans/NamedValue.html">NamedValue</a> ><br> <a href="#SystemProperties">SystemProperties</a></td> <td class="imsum_right"><b>[ OPTIONAL ]<br> </b>specifies a set of properties to pass to <code>java.lang.System.setProperty</code> before loading the system's JDBC driver. </td> </tr> <tr> <td class="imsum_left">boolean<br> <a href="#IsAutoRetrievingEnabled">IsAutoRetrievingEnabled</a></td> <td class="imsum_right"><b>[ OPTIONAL ]<br> </b>specifies if retrieving of auto generated values should be enabled or not. If <b>true</b> than the statement will support the XGeneratedResultSet (future concept) interface, otherwise not. </td> </tr> <tr> <td class="imsum_left">string<br> <a href="#AutoRetrievingStatement">AutoRetrievingStatement</a></td> <td class="imsum_right"><b>[ OPTIONAL ]<br> </b>specifies the statement which should be executed when asking an "INSERT" statement for the XGeneratedResultSet (future concept) interface. </td> </tr> <tr> <td class="imsum_left">sequence< any ><br> <a href="#TypeInfoSettings">TypeInfoSettings</a></td> <td class="imsum_right"><b>[ OPTIONAL ]<br> </b>specifies how the type info returned by <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getTypeInfo">getTypeInfo()</a> will be modified. </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="ConnectionProperties" class="membertitle"><a href="ConnectionProperties.html">ConnectionProperties</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>represents the properties for a connection (session) with a specific database. These properties can be used when calling the method <a href="XDriver.html">XDriver</a>::<a href="XDriver.html#connect">connect()</a> or <a href="XDriverManager.html">XDriverManager</a>::<a href="XDriverManager.html#getConnectionWithInfo">getConnectionWithInfo()</a>. </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="JavaDriverClass" class="membertitle">JavaDriverClass</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>string <b>JavaDriverClass</b>;<hr> <dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> <dt><b>Description</b></dt> <dd>which jdbc driver class should be loaded to create the connection. </dd> <dt><b>See also</b></dt> <dd><a href="JDBCConnectionProperties.html">JDBCConnectionProperties</a>::<a href="JDBCConnectionProperties.html#JavaDriverClassPath">JavaDriverClassPath</a></dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="JavaDriverClassPath" class="membertitle">JavaDriverClassPath</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>string <b>JavaDriverClassPath</b>;<hr> <dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> <dt><b>Description</b></dt> <dd>an optional class path to locate the <a href="JDBCConnectionProperties.html">JDBCConnectionProperties</a>::<a href="JDBCConnectionProperties.html#JavaDriverClass">JavaDriverClass</a>. </dd> <dd><p>The class path is a list of zero or more internal (see the ::com::sun::star::<a href="../uri/module-ix.html">uri</a>::<a href="../uri/ExternalUriReferenceTranslator.html">ExternalUriReferenceTranslator</a> service) URI references, where any space characters (<code>U+0020</code>) are ignored (and, in particular, separate adjacent URI references). Any “vnd.sun.star.expand” URL references in the list are expanded using the ::com::sun::star::<a href="../util/module-ix.html">util</a>::<a href="../util/theMacroExpander.html">theMacroExpander</a> singleton.</p> </dd> <dt><b>Since </b></dt> <dd>OpenOffice 2.3</dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="SystemProperties" class="membertitle">SystemProperties</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>sequence< ::com::sun::star::<a href="../beans/module-ix.html">beans</a>::<a href="../beans/NamedValue.html">NamedValue</a> > <b>SystemProperties</b>;<hr> <dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> <dt><b>Description</b></dt> <dd>specifies a set of properties to pass to <code>java.lang.System.setProperty</code> before loading the system's JDBC driver. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="IsAutoRetrievingEnabled" class="membertitle">IsAutoRetrievingEnabled</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>boolean <b>IsAutoRetrievingEnabled</b>;<hr> <dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> <dt><b>Description</b></dt> <dd>specifies if retrieving of auto generated values should be enabled or not. If <b>true</b> than the statement will support the XGeneratedResultSet (future concept) interface, otherwise not. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="AutoRetrievingStatement" class="membertitle">AutoRetrievingStatement</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>string <b>AutoRetrievingStatement</b>;<hr> <dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> <dt><b>Description</b></dt> <dd>specifies the statement which should be executed when asking an "INSERT" statement for the XGeneratedResultSet (future concept) interface. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="TypeInfoSettings" class="membertitle">TypeInfoSettings</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>sequence< any > <b>TypeInfoSettings</b>;<hr> <dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> <dt><b>Description</b></dt> <dd>specifies how the type info returned by <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getTypeInfo">getTypeInfo()</a> will be modified. </dd> <dd><p>The sequence contains an even amount of string values. Each pair describes <li>what should be searched for and </li> <li>what should be replaced if found.</li> <br> The syntax is: <p> <li>COLUMN(2) = -5</li> <li>COLUMN(6) = PRECISION</li> </p> COLUMN(X) defines the column which will be compared and the column which will be replaced. In the example above column 2 will be compared with the value -5. If this is true than column 6 will now return the value PRECISION. </p> </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>