Type to start searching...
Database connection information for a particular environment.
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.
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.jarport : unsignedShort
Database server port number (optional).
queryTimeout : nonNegativeInt
The query timeout in seconds (0 for unlimited).
A typical value for Oracle is 10Valid 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.
Sequence of:
Properties [0..1]
Fragments [0..1]
SQLHook [0..1]
Sequence of:
DataSource [1..*]