diff options
| author | Henri Herscher <henri@oreka.org> | 2005-11-25 21:37:47 +0000 |
|---|---|---|
| committer | Henri Herscher <henri@oreka.org> | 2005-11-25 21:37:47 +0000 |
| commit | df36e9001ea2208d0d672d3a6c6eead67f2c875e (patch) | |
| tree | c69b1851d214c1988a3cc3ab5e97d8f73c308346 /orkbasej | |
| parent | 175fe424ff9948791a67df09a47b31de7f89563d (diff) | |
Now uses proxool jdbc connection pooling by default instead of the internal hibernate connection pool.
git-svn-id: https://oreka.svn.sourceforge.net/svnroot/oreka/trunk@74 09dcff7a-b715-0410-9601-b79a96267cd0
Diffstat (limited to 'orkbasej')
| -rw-r--r-- | orkbasej/java/mysql.hbm.template.xml | 13 | ||||
| -rw-r--r-- | orkbasej/java/proxool-template.properties | 7 |
2 files changed, 19 insertions, 1 deletions
diff --git a/orkbasej/java/mysql.hbm.template.xml b/orkbasej/java/mysql.hbm.template.xml index 353f5cc..99c911e 100644 --- a/orkbasej/java/mysql.hbm.template.xml +++ b/orkbasej/java/mysql.hbm.template.xml @@ -14,17 +14,28 @@ <property name="hibernate.hbm2ddl.auto">update</property> <!-- update, create, create-drop --> <property name="hibernate.show_sql">true</property> + <!-- Only use one of the three following connection pools (proxools, c3p0 or dbcp): --> + + <property name="hibernate.proxool.pool_alias">ork-pool</property> + <property name="hibernate.proxool.properties">proxool.properties</property> + <!--<property name="c3p0.acquire_increment">1</property>--> <!--<property name="c3p0.idle_test_period">100</property>--> <!-- seconds --> <!--<property name="c3p0.max_size">100</property>--> <!--<property name="c3p0.max_statements">0</property>--> <!--<property name="c3p0.min_size">10</property>--> <!--<property name="c3p0.timeout">100</property>--> <!-- seconds --> + + <!-- dbcp does not appear to work with Hibernate 3 --> + <!--<property name="hibernate.dbcp.ps.maxActive">100</property>--> + <!--<property name="hibernate.dbcp.maxActive">10</property>--> + <!--<property name="hibernate.dbcp.initialSize">2</property>--> + <!--<property name="hibernate.dbcp.maxWait">3000</property>--> + <!--<property name="hibernate.dbcp.validationQuery">select CURRENT_DATE</property>--> <property name="hibernate.jdbc.batch_versioned_data">true</property> <property name="hibernate.query.substitutions">true 1, false 0, yes 'Y', no 'N'</property> <property name="hibernate.cache.region_prefix">hibernate.test</property> - <property name="hibernate.proxool.pool_alias">pool1</property> <property name="hibernate.default_batch_fetch_size">8</property> <property name="hibernate.jdbc.use_streams_for_binary">true</property> <property name="hibernate.max_fetch_depth">1</property> diff --git a/orkbasej/java/proxool-template.properties b/orkbasej/java/proxool-template.properties new file mode 100644 index 0000000..19ceb94 --- /dev/null +++ b/orkbasej/java/proxool-template.properties @@ -0,0 +1,7 @@ +jdbc-0.proxool.alias=ork-pool +jdbc-0.proxool.driver-url=jdbc:mysql://localhost/test +jdbc-0.proxool.driver-class=com.mysql.jdbc.Driver +jdbc-0.user=root +jdbc-0.password=password +jdbc-0.proxool.maximum-connection-count=10 +jdbc-0.proxool.house-keeping-test-sql=select CURRENT_DATE
\ No newline at end of file |