Product: Database Access
Type: new
Title: Configuration based database drivers
Posted by: ocke.jans...@sun.com
Affected: connectivity
TaskId: i101587
<http://www.openoffice.org/issues/show_bug.cgi?id=101587>
Effective from: dbaperf2
CWS:
<http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300/dbaperf2>
CWS status: ready for QA
*Flags*
-------
API/ BASIC [ ]
Configuration [x]
File format change [ ]
Help/ Guide [ ]
Performance test [ ]
Translation [ ]
UI relevant [ ]
*Description*
-------------
Currently the db drivers are hard coded in OOo. The integration of new
ones as
extension isn't possible. Therefor all drivers have to bring their own
configuration with them. Each driver has to define:
- URLPattern : defines the URL which the driver supports
- ParentURLPattern : allows to define a parent hierarchy
- Driver : defines the UNO factory name used to create the db driver
- DriverTypeDisplayName : defines the name which is shown to the user when
creating a new db
Additionally 3 sets can be filled, which are
- Properties : describes properties which the driver understand
- Features : describes which checkboxes should be shown in the special
settings
dialog
- MetaData : describes additional settings which are handled by the db
application itself
As this 3 categories are set, it can not be defined what the sets will
contain.
But currently they support:
// known JDBC settings
JavaDriverClass
// known settings for file-based drivers
Extension
CharSet
HeaderLine
FieldDelimiter
StringDelimiter
DecimalDelimiter
ThousandDelimiter
ShowDeleted
// known ODBC settings
SystemDriverSettings
UseCatalog
// settings related to auto increment handling
AutoIncrementCreation
AutoRetrievingStatement
IsAutoRetrievingEnabled
// known Adabas D driver setting
ShutdownDatabase
DataCacheSizeIncrement
DataCacheSize
ControlUser
ControlPassword
// known LDAP driver settings
HostName
PortNumber
BaseDN
MaxRowCount
// misc known driver settings
ParameterNameSubstitution
AddIndexAppendix
// known SDB level settings
IgnoreDriverPrivileges
NoNameLengthLimit
AppendTableAliasName
GenerateASBeforeCorrelationName
ColumnAliasInOrderBy
EnableSQL92Check
BooleanComparisonMode
TableTypeFilterMode
RespectDriverResultSetType
UseSchemaInSelect
UseCatalogInSelect
EnableOuterJoinEscape
PreferDosLikeLineEnds
FormsCheckRequiredFields
EscapeDateTime
IgnoreCurrency
TypeInfoSettings
LocalSocket
Please have a look at the configuration schema
org.openoffice.Office.DataAccess/Drivers.xcs for more information.
Send feedback to us...@dba.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: features-unsubscr...@dba.openoffice.org
For additional commands, e-mail: features-h...@dba.openoffice.org
