t_DataSourceConnections_RelationalDatabaseConnection

RelationalDatabaseConnection

Database connection information for a particular environment.

Properties

adapter : string

Data source adapter type.

This element specifies which type of database we are connecting to.

alias : alias

Overrides the default JNDI name of the default fragment. The default name is the alias on the datasource.

Valid values based on“string”.
[\p{L}_][\p{L}\p{N}\-_]*

database : string

Database name.

description : string

Data source connection description.

driver : qualJavaName

Overrides the default JDBC XA data source Java class name.

Valid values based on“string”.
\|[\p{L}_][\p{L}\p{N}_](\.[\p{L}_][\p{L}\p{N}_])*

external : boolean

True to use an external connection pool managed by the container.

host : string

Database server host name.

idleTimeout : nonNegativeLong

The timeout in milliseconds, after which idle connections are disposed of.

Valid values based on“long”.
0 (minInclusive)

indexspace : dbOptionalName

Default index tablespace or file group name. Use "default" for the database default.

Valid values based on“string”.
\|[A-Za-z][_A-Za-z\d]*

instance : string

Database server instance name (optional).

literal : boolean

True to disable bind parameters and use literal binds in all SQL select queries.

longspace : dbOptionalName

Default long column tablespace or file group name. Use "default" for the database default.

Valid values based on“string”.
\|[A-Za-z][_A-Za-z\d]*

maxPoolSize : positiveInt

Maximum database connection pool size per server.

Valid values based on“int”.
1 (minInclusive)

minPoolSize : nonNegativeInt

Minimum database connection pool size per server.

Valid values based on“int”.
0 (minInclusive)

pageSize : nonNegativeInt

The database page size, in bytes. Zero or unspecified to use the persistence adapter default page size.

Valid values based on“int”.
0 (minInclusive)

password : password

Database user password.

The password corresponding to the database user ID.

Valid values based on“string”.

path : string

Specifies a comma-delimited JDBC driver JAR file list.

If blank, the default for the database type will be used. e.g. MSSQL - jtds-1.2.2-9.jar, Oracle - ojdbc14.jar

port : unsignedShort

Database server port number (optional).

queryTimeout : nonNegativeInt

The query timeout in seconds (0 for unlimited).

A typical value for Oracle is 10

Valid values based on“int”.
0 (minInclusive)

readLimit : nonNegativeInt

The maximum number of instances that can be returned by read() (0 for unlimited). Overrides the data source setting.

Valid values based on“int”.
0 (minInclusive)

role : dbOptionalName

Database role override to use as default role for table permissions.

Valid values based on“string”.
\|[A-Za-z][_A-Za-z\d]*

statementCacheSize : positiveInt

The prepared SQL statement cache size.

Valid values based on“int”.
1 (minInclusive)

tablespace : dbOptionalName

Default tablespace or file group name. Use "default" for the database default.

Valid values based on“string”.
\|[A-Za-z][_A-Za-z\d]*

user : string

Database user name.

warningTimeout : nonNegativeLong

The long-running query warning timeout in milliseconds (0 for unlimited).

Long running queries are defined as any query taking longer than this threshold. If the query takes longer, a warning will be sent to the system log with information about the query for performance tuning. Overridable by the nexj.dataSourceConnection.<name>.warningTimeout system property. A typical value for Oracle is 250.

Valid values based on“long”.
0 (minInclusive)

wchar : boolean

True to use a wide character database. Undefined for the optimal setting.

Content

Sequence of:
- t_RelationalDatabaseConnection_Properties [0..1]
- t_RelationalDatabaseConnection_Fragments [0..1]
- t_RelationalDatabaseConnection_SQLHook [0..1]
Sequence of:
- t_DataSourceConnection_DataSource [1..*]

Parents

Parent topic: t_Connections_DataSourceConnections

Parent topic: t_Environment_DataSourceConnections

Parent topic: reuseable-references