mysql+mavean_各数据库连接maven配置

Derby

db driver maven dependency

org.apache.derby

derbyclient

10.2.2.0

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

mysql

mysql-connector-java

5.0.5

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

com.h2database

h2

1.0.20070304

hibernate.properties

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

com.oracle

ojdbc14

10.2.0.2.0

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

postgresql

postgresql

8.2-504.jdbc3

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

net.sourceforge.jtds

jtds

1.2

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

hsqldb

hsqldb

1.8.0.7

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依赖包

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

com.microsoft.sqlserver

sqljdbc4

3.0

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拷贝到\Documents and Settings\%USER%\.m2\repository\com\microsoft\sqlserver\sqljdbc\4\3.0中即可

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值