unicodeMode | Added in Builder 6.0.15.5 Runtime 2015.15 Specify the encoding for database access. Note |
---|
| We recommend to use the Platform default unless you suspect an encoding incompatibility (see Troubleshooting the SQL Adapter). This option represents the former behavior and is fully backwards-compatible - means, it can be used with older xUML Runtimes. The two other (force mode) options will be ignored by older Runtimes without warning. |
| Platform default (default) | Use the platform default mode. This is - Unicode: for Windows systems
- non-Unicode: for all others
This option is backwards compatible to older Runtimes. |
Unicode | Force Unicode mode. |
non-Unicode | Force non-Unicode mode. |
Connection Pooling |
connectionPooling | Multiexcerpt |
---|
MultiExcerptName | connectionPooling |
---|
| Added in Builder 5.1.8.58 Runtime 5.1.82.0 This tagged value controls the connection pooling. If true, each connection is put into a pool after use. If an SQL adapter requires a connection, it is taken from the pool. If no connection is available, a new connection is being created and put into the pool after use. The time the connection is kept in the pool depends on the other pooling parameters. |
| true | Database connections are pooled. |
false | Database connections are not pooled. |
maxConnectionAge | Multiexcerpt |
---|
MultiExcerptName | maxConnectionAge |
---|
| After a given connection age (in minutes) the connection will be closed and removed from the pool. |
| Connection age in minutes, default is 15 minutes, -1 means forever. |
maxConnectionIdleTime | Multiexcerpt |
---|
MultiExcerptName | maxConnectionIdleTime |
---|
| Connections not used for the time specified (in minutes) will be closed and removed from the pool. This is useful for connections going through firewalls because such connections might be cut off after some time. |
| Values in minutes, default is 60. |
maxConnectionReuse | Multiexcerpt |
---|
MultiExcerptName | maxConnectionReuse |
---|
| This tagged value controls how often a connection can be re-used. After the connection has been re-used for maxConnectionReuse, it will be closed and not put back into the pool. This feature has been introduced because some databases had problems if the connection was re-used too often. Value -1 means the connection will be re-used forever. In this case you should define reasonable values for maxConnectionAge or maxConnectionIdleTime (see above). |
| 0 | pooling is implicitly switched off. |
-1 | connections are pooled forever |
a value | number of connections to be pooled, default is 1000. |
Multiexcerpt |
---|
MultiExcerptName | maxConnectionReuse_2 |
---|
| Info |
---|
| Note that the pooling is implicitly switched off, if maxConnectionReuse is set to 0. |
|
|
|
|
Qualifier |
schema | String that prefixes tables and stored procedures. For example, if schema is set to S1, all tables accessing the current DB are prefixed by "S1.". Info |
---|
| This works only if the tables are marked using the TABLE:: keyword, e.g TABLE::TEMPLOYEE in SQL statements. If you do not prefix the table name by TABLE:: , the tablename is used as it is. |
|
|
|
tableQualifier | String that prefixes tables. For example, if tableQualifier is set to TQ1, all tables accessing the current DB are prefixed by "TQ1", e.g. TQ1TEMPLOYEE . If schema and table qualifier are given, all tables will become: <schema>.<tableQualifier><tableName>. Multiexcerpt |
---|
MultiExcerptName | table_hint |
---|
| Info |
---|
| This works only if the tables are marked using the TABLE:: keyword, e.g TABLE::TEMPLOYEE in SQL statements. If you do not prefix the table name by TABLE:: , the tablename is used as it is. |
|
|
|
|