JDBC data source - Descriptor settings tab

Integration module Consume data Select existing JDBC data source Edit menu data source General tab / Select Descriptor class de.uplanet.jdbc.GenericDescriptor



This dialog is only available, if a data source, which is not directly supported by Intrexx (e.g. the Descriptor class de.uplanet.jdbc.GenericDescriptor) is selected on the General tab.

General
Sorting Sets the correct sorting order (for example, how data is sorted within view tables or results lists when searching).
Result set type for update If write access will cause any problems, select another result set type here.
Batch updates use You should keep this setting ("yes") for performance reasons. Only change this setting if any problems occur while saving data sets.
ORDER BY Alias support 1) SELECT Field1 AS FieldAlias FROM Table1 TablesAlias ORDER BY TablesAlias.FieldAlias
2) SELECT Field1 AS FieldAlias FROM Table1 TablesAlias ORDER BY TablesAlias.Field1
SELECT Field1 AS FieldAlias FROM Table1 TablesAlias ORDER BY FieldAlias
3) SELECT Field1 AS FieldAlias FROM Table1 TablesAlias ORDER BY TablesAlias.Field1

Examples:

Type 1) SQL Server
Type 2) HSQL, SAP DB, Oracle
Type 3) Access
Oracle 8 Syntax for Outer Joins Oracle versions 8 and earlier use a different SQL syntax for OUTER JOIN queries than most other data bases. If a database uses the same syntax, please select "yes"
Clobs searchable In this database, long text fields can be searched. This setting affects the search function.
Use driver Clob/Blob objects For most databases you can enter "no" here. One of the few exceptions is Oracle. For performance reasons, it can sometimes be useful to use driver objects anyway.
Data Field Transformation
Boolean Literal TRUE Possible values: TRUE / true / 1
Normally "TRUE" is the correct selection. (Except: MS SQL Server, Oracle: 1)
Boolean Literal FALSE Possible values: FALSE / false / 0
Normally "FALSE" is the correct selection.(Except. MS SQL Server, Oracle: 0)
Calendar is supported by date fields Some databases do not support calendar objects for the query of date and time fields. This calendar object is necessary for calculation of the local time zone. Normally, "no" is the safest selection.
Date according to SQL Formats a date object for saving it in the database via SQL command. ("%t" must be set as placeholder)
ISO date text nach SQL Formats a string for saving it in the database via SQL command. ("%t" must be set as placeholder)
Large Objects (Clob / Blob)
Clob method for empty Clob Please read the documentation for the corresponding driver. Normally no entries have to be made and the fields cannot be selected.
Clob method for Writer
Blob class for driver
Blob method for empty Blob
Blob method for Output stream

The entries explained above will normally be correctly configured by the wizard. For special data sources you can enter more exact details here. In this case, read the documentation of your database system and/or database driver.