t_DataSourceConnections_RelationalDatabaseConnection

adapter : stringData source adapter type. This element specifies which type of database we are connecting to. alias : aliasOverrides 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 : stringDatabase name.description : stringData source connection description.driver : qualJavaNameOverrides 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 : booleanTrue to use an external connection pool managed by the container.host : stringDatabase server host name.idleTimeout : nonNegativeLongThe timeout in milliseconds, after which idle connections are disposed of.Valid values based on“long”.0 (minInclusive)indexspace : dbOptionalNameDefault 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 : stringDatabase server instance name (optional).literal : booleanTrue to disable bind parameters and use literal binds in all SQL select queries.longspace : dbOptionalNameDefault 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 : positiveIntMaximum database connection pool size per server.Valid values based on“int”.1 (minInclusive)minPoolSize : nonNegativeIntMinimum database connection pool size per server.Valid values based on“int”.0 (minInclusive)pageSize : nonNegativeIntThe database page size, in bytes. Zero or unspecified to use the persistence adapter default page size.Valid values based on“int”.0 (minInclusive)password : passwordDatabase user password. The password corresponding to the database user ID. Valid values based on“string”.  path : stringSpecifies 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 : unsignedShortDatabase server port number (optional).queryTimeout : nonNegativeIntThe query timeout in seconds (0 for unlimited). A typical value for Oracle is 10 Valid values based on“int”.0 (minInclusive)readLimit : nonNegativeIntThe 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 : dbOptionalNameDatabase role override to use as default role for table permissions.Valid values based on“string”.|[A-Za-z][_A-Za-z\d]*statementCacheSize : positiveIntThe prepared SQL statement cache size.Valid values based on“int”.1 (minInclusive)tablespace : dbOptionalNameDefault tablespace or file group name. Use "default" for the database default.Valid values based on“string”.|[A-Za-z][_A-Za-z\d]*user : stringDatabase user name.warningTimeout : nonNegativeLongThe 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 : booleanTrue to use a wide character database. Undefined for the optimal setting.