Database
From Resin 3.0
(Difference between revisions)
(renamed tag to directive) |
|||
| Line 1: | Line 1: | ||
[[Category:Configuration]] [[Category:Database]] | [[Category:Configuration]] [[Category:Database]] | ||
| − | == | + | == Directives == |
| − | {| class=" | + | {| class="directives" |
| − | ! | + | !directive||description||default |
|- | |- | ||
||backup-driver||a database backend to use if the primary is not accepting connections | ||backup-driver||a database backend to use if the primary is not accepting connections | ||
| Line 53: | Line 53: | ||
== driver and backup-driver == | == driver and backup-driver == | ||
| − | {| class=" | + | {| class="directives" |
| − | ! | + | !directive||description |
|- | |- | ||
||type||the classname of the driver | ||type||the classname of the driver | ||
| Line 74: | Line 74: | ||
{| | {| | ||
| − | ! | + | !directive||description |
|- | |- | ||
||catalog||the connection's default catalog | ||catalog||the connection's default catalog | ||
Revision as of 20:21, 21 February 2006
Contents |
Directives
| directive | description | default |
|---|---|---|
| backup-driver | a database backend to use if the primary is not accepting connections | |
| connection | connection-specific configuration, e.g. transaction isolation | |
| connection-wait-time | how long to wait for a connection to be freed in a free pool | |
| driver | configures the driver | |
| jndi-name | the JNDI name to store the configured database as | |
| max-active-time | the maximum time a connection can be active before timing out | |
| max-connections | the maximum number of connections in the pool | |
| max-create-connections | ??? | |
| max-idle-time | the maximum time a connection can be idle in the pool | |
| max-overflow-connection | maximum number of connections allocated after the pool is full | |
| max-pool-time | the maximum time the connection can be in the pool | |
| password | the password for the connection | |
| ping | flag to enable checking for live connections | |
| ping-table | the table to query to check for a live connection | |
| ping-query | the query to use for a ping | |
| ping-interval | how often an idle connection should ping | |
| prepared-statement-cache-size | how many PreparedStatements should be saved | |
| save-allocation-stack-trace | if true, save the location of all allocated connections (for debugging) | |
| spy | if true, log the SQL calls for debugging | |
| transaction-timeout | default value of transaction timeouts | |
| user | the connection's user | |
| xa | true if the connection will be used in Distributed Transactions |
driver and backup-driver
| directive | description |
|---|---|
| type | the classname of the driver |
| xxx | a bean style-initialization parameter, like <url> |
resin.conf
...
<database jndi-name="jdbc/test">
<driver type="org.postgresql.Driver">
<url>jdbc:postgresql://localhost/test</url>
</driver>
...
</database>
...
<connection>
| directive | description |
|---|---|
| catalog | the connection's default catalog |
| read-only | true if the connection is read-only |
| transaction-isolation | the connection's transaction isolation |
