maven数据库配置

中央仓库地址:search.maven.org/

Derby

db driver mavendependency
<dependency>

        <groupId>
org.apache.derby</groupId>

        <artifactId>
derbyclient</artifactId>

        <version>
10.2.2.0</version>

</dependency>
hibernate.properties
hibernate.dialect=org.hibernate.dialect.DerbyDialect
hibernate.connection.driver_class=org.apache.derby.jdbc.ClientDriver
hibernate.connection.url=jdbc:derby://localhost/trails;create=true


hibernate.connection.username=any
hibernate.connection.password=value
hibernate.hbm2ddl.auto=update

MySQL

MySQL throws an EOFException when the databaseconnection has been closed after the lease has expired, but itworks again on subsequent requests.

There is a reported issue with DBCP and the MySQL driver. Checkthe JIRA issue for more info and a possible solution
http://jira.codehaus.org/browse/TRAILS-85

db driver mavendependency
<dependency>

        <groupId>
mysql</groupId>

        <artifactId>
mysql-connector-java</artifactId>

        <version>
5.0.5</version>

</dependency>
hibernate.properties
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
hibernate.connection.driver_class=com.mysql.jdbc.Driver
hibernate.connection.url=jdbc:mysql://localhost/trails?createDatabaseIfNotExist=true
&amp;useUnicode=true
&amp;characterEncoding=utf-8

hibernate.connection.username=root
hibernate.connection.password=
hibernate.hbm2ddl.auto=update

H2

db driver mavendependency
<dependency>

        <groupId>
com.h2database</groupId>

        <artifactId>
h2</artifactId>

        <version>
1.0.20070304</version>

</dependency>
hibernate.dialect=org.hibernate.dialect.H2Dialect
hibernate.connection.driver_class=org.h2.Driver
hibernate.connection.url=jdbc:h2:trails
hibernate.connection.username=sa
hibernate.connection.password=
hibernate.hbm2ddl.auto=update

Oracle

db driver mavendependency
<dependency>

        <groupId>
com.oracle</groupId>

        <artifactId>
ojdbc14</artifactId>

        <version>
10.2.0.2.0</version>

</dependency>
hibernate.properties
hibernate.dialect=org.hibernate.dialect.Oracle9Dialect
hibernate.connection.driver_class=oracle.jdbc.OracleDriver
hibernate.connection.url=jdbc:oracle:thin:@localhost:1521:XE
hibernate.connection.username=system
hibernate.connection.password=system
hibernate.hbm2ddl.auto=update

# The Oracle JDBC driver doesn't like prepared statement caching very much.
hibernate.statement_cache.size=0
# or baching with BLOBs very much.
hibernate.jdbc.batch_size=0

# After a while
, Oracle throws
 this
 exception: too many open cursors
# Disable PreparedStatement caching for
 the connection pool too.
# http://www.hibernate.org/120.html#A10

hibernate.dbcp.ps.maxIdle = 0

# Stoping hibernate from using the column-names in queries to retrieve data from the resultsets
# More info in http://www.jroller.com/page/dashorst?entry=hibernate_3_1_something_performance1

hibernate.jdbc.wrap_result_sets=true

PostgreSQL.

db driver mavendependency
<dependency>

        <groupId>
postgresql</groupId>

        <artifactId>
postgresql</artifactId>

        <version>
8.2-504.jdbc3</version>

</dependency>
hibernate.properties
hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
hibernate.connection.driver_class=org.postgresql.Driver
hibernate.connection.url=jdbc:postgresql://localhost/trails

hibernate.connection.username=postgres
hibernate.connection.password=postgres
hibernate.hbm2ddl.auto=update

Microsoft SQLServer

db driver mavendependency
<dependency>

        <groupId>
net.sourceforge.jtds</groupId>

        <artifactId>
jtds</artifactId>

        <version>
1.2</version>

</dependency>
hibernate.properties
hibernate.dialect=org.hibernate.dialect.SQLServerDialect
hibernate.connection.driver_class=net.sourceforge.jtds.jdbc.Driver
hibernate.connection.url=jdbc:jtds:sqlserver://localhost:1433/trails

hibernate.connection.username=sa
hibernate.connection.password=
hibernate.hbm2ddl.auto=update

HSQLDB

db driver mavendependency
<dependency>

        <groupId>
hsqldb</groupId>

        <artifactId>
hsqldb</artifactId>

        <version>
1.8.0.7</version>

</dependency>
hibernate.properties
hibernate.dialect=org.hibernate.dialect.HSQLDialect
hibernate.connection.driver_class=org.hsqldb.jdbcDriver
hibernate.connection.url=jdbc:hsqldb:trails;shutdown=true

hibernate.connection.username=sa
hibernate.connection.password=
hibernate.hbm2ddl.auto=update

posted @ 2012-10-23 15:00  Jason-Holt  阅读(327)  评论(0编辑  收藏  举报