...
Name | Cardinality | Type | Description |
|---|---|---|---|
<ConnectionString> | 1 | string | Required element containing an ODBC connection string. Exact contents differ across drivers. Note that you may wish to use a so-called "named" connection defined in odbc.ini (or for Windows inside the ODBC control panel applet or registry) to keep the database password out of this file, since it will be readable by the web server account/user. |
<RetryOnError> | 0 or 1 | whitespace-delimited list of strings | Instructs the plugin to retry certain operations if a matching ODBC status code is returned from the operation. This be is used to detect rolled back transactions caused by optimistic locking and retry them, by including the driver-specific status code that indicates the condition. Under load, you'll typically see problems on most databases that have to be worked around using this setting. |
Examples
The below is excerpted from the configuration file to illustrate the key pieces involved.
| Code Block | ||
|---|---|---|
| ||
<OutOfProcess> <Extensions> <Library path="odbc-store.so" fatal="true"/> </Extensions> </OutOfProcess> <StorageService type="ODBC" id="db" cleanupInterval="900"> <ConnectionString> DRIVER=drivername;SERVER=dbserver;UID=shibboleth;PWD=password;DATABASE=shibboleth;APP=Shibboleth </ConnectionString> </StorageService> |
...
Database-Specific Notes
Microsoft SQL Server
This is was the primary test platform way back in the misty past, and has been was tested under only light load on both Windows and CentOS 5. On Linux, the FreeTDS client and ODBC manager and driver included with the OS were used.
...