The JDBC generator supports the options shown in Table 12.1.1[JDBC options].
| option | function | value | default |
|---|---|---|---|
| jdbc | Executes the JDBC generator. | true | false | false |
| jdbc.ee | Uses the J2EE function for database access. | true | false | false |
| jdbc.mapping | Specifies a mapping strategy: direct means direct mapping, and index means index mapping. |
direct | index | direct |
| jdbc.config | Specifies a configuration for data access. | File name | - |
| jdbc.profile | Specifies a profile for data access. | File name | - |
| jdbc.data.config | Specifies a configuration for data mapping. | File name | - |
| jdbc.data.profile | Specifies a profile for data mapping. | File name | - |
| jdbc.quote.id | Specifies a quote string for the identifier in SQL. | quote string | " |
| jdbc.quote.where | Specifies a quote string for the where clause in SQL. | quote string | - |
| jdbc.quote.idInWhere | Specifies a quote string for the identifier in a where cluase in SQL. | quote string | " |
| jdbc.document.columnName | Column name of a column to store the whole the XML document. | Column name | document |
| jdbc.document.type | Type of a column to store the whole the XML document. | Datatype | VARCHAR(8192) |
| jdbc.document.length | Length of data in the column to store the whole the XML document. | integer | - |
| jdbc.fragment.type | Type of a column to store a fragment of the XML document. | Datatype | VARCHAR(512) |
| jdbc.fragment.length | Length of data in the column to store a fragment of the XML document. | integer | - |
| jdbc.list.type | Type of a column to store a data list. | Datatype | VARCHAR(64) |
| jdbc.list.length | Length of data in the column to store a data list. | integer | - |