Contents
The JDBC Table lvconf type is deprecated as a separate lvconf file type. To use a JDBC table as a data source, create an External Server Connection lvconf file type and specify JDBC from the drop-down Type list.
The information in the next section is provided as a reference for maintaining legacy Live Datamart projects.
| Property | Type | Description |
|---|---|---|
| Data Source Reference | drop‑down list | The name of a data source as defined in sbd.sbconf.
|
| Group | string | Optional logical grouping for a table. |
| SQL | string | SQL statement (that must return a result set) that LiveView queries will execute against. LiveView queries are executed against the result of this statement as a sub-query. Wrap this query with the CDATA tag. |
| Schema | Add | Optionally define the fields of this table. When specified, field names and types that match the result set from the SQL statement must be compatible. Fields that do not match by name always return null. Additionally, defining fields here skips typechecking the SQL statement on startup. |
| Description | string | Optionally add short or long descriptions for the table. |