Database

From CauchoWiki

Contents 1 Directives 2 driver and backup-driver 2.1 resin.conf 3 <connection>

[edit] 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
wrap-statements	true
xa	true if the connection will be used in Distributed Transactions

[edit] driver and backup-driver

directive	description
type	the classname of the driver
xxx	a bean style-initialization parameter, like <url>

[edit] resin.conf

...
<database jndi-name="jdbc/test">
  <driver type="org.postgresql.Driver">
    <url>jdbc:postgresql://localhost/test</url>
  </driver>
  ...
</database>
...

[edit] <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