各种数据库maven的pom文件编写与ibernate链接配置

各种数据库Hibernate链接配置

Derby

db driver maven dependency

<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

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=utf-8 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 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 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/trails hibernate.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/trails hibernate.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=true hibernate.connection.username=sa hibernate.connection.password= hibernate.hbm2ddl.auto=update

手动安装Maven依赖包

例如要安装这样一个依赖到maven本地仓库：

1.将此依赖添加到项目的pom.xml

<dependency>

   <groupId>com.microsoft.sqlserver</groupId>

   <artifactId>sqljdbc4</artifactId>

   <version>3.0</version>

</dependency>

2.在命令行中执行install命令

mvn
install:install-file -Dfile=sqljdbc4-3.0.jar
-DgroupId=com.microsoft.sqlserver -DartifactId=sqljdbc4 -Dversion=3.0
-Dpackaging=jar

3.将sqljdbc4-3.0.jar拷贝到此依赖安装目录

将sqljdbc4-3.0.jar拷贝到X:\Documents and Settings\%USER%\.m2\repository\com\microsoft\sqlserver\sqljdbc4\3.0 中即可.