Some of Teiid's low-level behavior can be configured via system properties, rather than through configuration files. A typical place to set system properties for JBoss AS launches is in the <jboss-install>/bin/<mode>.conf. A property setting has the format \-Dproperty=value |
*General* |
* _org.teiid.allowNanInfinity_ \- defaults to false. Set to true to allow numeric functions to return NaN (Not A Number) and \+-Infinity. Note that these values are not covered by the SQL specification. |
... |
h4. *Client* |
The following properties are for Teiid Client, which you can use with Teiid JDBC Derver. * _org.teiid.sockets.soTimeout_ \- The time in milliseconds for socket timeouts. Timeouts during the initialization, handshake, or a server ping may be treated as an error. This is the lower bound for all other timeouts the JDBC login timeout. Typically this should be left at the default of 1000(1 second). Setting this value too low may cause read errors. * _org.teiid.sockets.maxCachedInstances_ \- The max number of cached server instances to reuse. A server instance is a connected socket to a particular cluster member with client encryption and or SSL already established. Caching instances helps in 2 circumstances: when Connection pooling is not being used, load-balancing performance to a cluster when using Connection pooling of the DataSource. This value should typically be a multiple of the cluster size. Set to 0 to disable instance caching. Default value is 16. * _org.teiid.sockets.synchronousttl_ \- Set the max time to live (in milliseconds) for non-execution synchronous calls. Default value is 240000. * _org.teiid.sockets.receiveBufferSize_ \- Set the socket receive buffer size (in bytes). 0 indicates that the default socket setting will be used. Default is 0. * _org.teiid.sockets.sendBufferSize_ \- Set the socket send buffer size (in bytes). 0 indicates that the default socket setting will be used. Default is 0. * _org.teiid.sockets.conserveBandwidth_ \- Set to true to enable Nagle's algorithm to conserve bandwidth by minimizing the number of segments that are sent. Default is false. * _org.teiid.sockets.maxObjectSize_ \- Maximum number of bytes per server message. May need to be increased when using custom types and/or large batch sizes. Default value is 33554432. * _org.teiid.sockets.DisablePing_ \- Set to true to disable client ping. Default value is 'false' that means client ping are enable. The client ping guaranteed that the client session has a relevant active server session(server hung, networking limited, connection reset will cause server session lose). Usually, if the client have load balancing logic, the client ping is necessary. {note} All client properties list above also can be configured in a properties file, more details refer to [TEIID:Additional Socket Client Settings]. {note} |
System properties can also be set for client VMs. See [TEIID:Additional Socket Client Settings]. |
Some of Teiid's low-level behavior can be configured via system properties, rather than through configuration files. A typical place to set system properties for JBoss AS launches is in the <jboss-install>/bin/<mode>.conf. A property setting has the format -Dproperty=value
General
Strings are always fully held in memory. Do not set this value too high as you may experience out of memory errors. |
Security
PostgreSQL Compatibility
These affect Teiid globally, and not just through the ODBC transport. |
System properties can also be set for client VMs. See Additional Socket Client Settings.