Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

API

SDK

Tips ‘n’ Tricks

Miscellaneous


:: com :: sun :: star :: sdbc ::

unpublished service JDBCConnectionProperties
Usage Restrictions
not published
Description
represents the properties for a JDBC connection (session) with a specific database. These properties can be used when calling the method XDriver::connect() or XDriverManager::getConnectionWithInfo().

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.

See also
XDriver, XDriverManager, ConnectionProperties

Included Services - Summary
ConnectionProperties
(referenced entity's summary:)
represents the properties for a connection (session) with a specific database. These properties can be used when calling the method XDriver::connect() or XDriverManager::getConnectionWithInfo().
Properties' Summary
string
JavaDriverClass
[ OPTIONAL ]
which jdbc driver class should be loaded to create the connection.  
string
JavaDriverClassPath
[ OPTIONAL ]
an optional class path to locate the JDBCConnectionProperties::JavaDriverClass.  
sequence< ::com::sun::star::beans::NamedValue >
SystemProperties
[ OPTIONAL ]
specifies a set of properties to pass to java.lang.System.setProperty before loading the system's JDBC driver.  
boolean
IsAutoRetrievingEnabled
[ OPTIONAL ]
specifies if retrieving of auto generated values should be enabled or not. If true than the statement will support the XGeneratedResultSet (future concept) interface, otherwise not.  
string
AutoRetrievingStatement
[ OPTIONAL ]
specifies the statement which should be executed when asking an "INSERT" statement for the XGeneratedResultSet (future concept) interface.  
sequence< any >
TypeInfoSettings
[ OPTIONAL ]
specifies how the type info returned by XDatabaseMetaData::getTypeInfo() will be modified.  
Included Services - Details
ConnectionProperties
(referenced entity's summary:)
represents the properties for a connection (session) with a specific database. These properties can be used when calling the method XDriver::connect() or XDriverManager::getConnectionWithInfo().
Properties' Details
JavaDriverClass
string JavaDriverClass;
Usage Restrictions
optional
Description
which jdbc driver class should be loaded to create the connection.
See also
JDBCConnectionProperties::JavaDriverClassPath
JavaDriverClassPath
string JavaDriverClassPath;
Usage Restrictions
optional
Description
an optional class path to locate the JDBCConnectionProperties::JavaDriverClass.

The class path is a list of zero or more internal (see the ::com::sun::star::uri::ExternalUriReferenceTranslator service) URI references, where any space characters (U+0020) 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::util::theMacroExpander singleton.

Since
OOo 2.3
SystemProperties
sequence< ::com::sun::star::beans::NamedValue > SystemProperties;
Usage Restrictions
optional
Description
specifies a set of properties to pass to java.lang.System.setProperty before loading the system's JDBC driver.
IsAutoRetrievingEnabled
boolean IsAutoRetrievingEnabled;
Usage Restrictions
optional
Description
specifies if retrieving of auto generated values should be enabled or not. If true than the statement will support the XGeneratedResultSet (future concept) interface, otherwise not.
AutoRetrievingStatement
string AutoRetrievingStatement;
Usage Restrictions
optional
Description
specifies the statement which should be executed when asking an "INSERT" statement for the XGeneratedResultSet (future concept) interface.
TypeInfoSettings
sequence< any > TypeInfoSettings;
Usage Restrictions
optional
Description
specifies how the type info returned by XDatabaseMetaData::getTypeInfo() will be modified.

The sequence contains an even amount of string values. Each pair describes

  • what should be searched for and
  • what should be replaced if found.

  • The syntax is:

  • COLUMN(2) = -5
  • COLUMN(6) = PRECISION
  • 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.


     
    Top of Page

    Apache Software Foundation

    Copyright & License | Privacy | Contact Us | Donate | Thanks

    Apache, OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.