maven 添加 jdbc驱动

Derby

db driver maven dependency

<dependency>
<goupId> 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=truehibernate.connection.username=any hibernate.connection.password=value hibernate.hbm2ddl.auto=update

MySQL

MySQL throws an EOFException when the database connection has been closed after the lease has expired, but it works again on subsequent requests. There is a reported issue with DBCP and the MySQL driver. Check the JIRA issue for more info and a possible solution http://jira.codehaus.org/browse/TRAILS-85

db driver maven dependency

<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&
 useUnicode=true &characterEncoding=utf8
hibernate.connection.username=root 
hibernate.connection.password= hibernate.hbm2ddl.auto=update

H2

db driver maven dependency

<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 maven dependency

<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 statementcaching 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 # Stopinghibernate 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 maven dependency

<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/trailshibernate.connection.username=postgres hibernate.connection.password=postgres hibernate.hbm2ddl.auto=update

Microsoft SQL Server

db driver maven dependency

<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/trailshibernate.connection.username=sa hibernate.connection.password= hibernate.hbm2ddl.auto=update

HSQLDB

db driver maven dependency

<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=truehibernate.connection.username=sa hibernate.connection.password= hibernate.hbm2ddl.auto=update