hibernate 数据库的几种配置

hibernate中配置

 

#jtds---sqlserver
db.driverClassName=net.sourceforge.jtds.jdbc.Driver
db.url=jdbc:jtds:sqlserver://localhost:1433;databasename=mydatabase

db.dialect=org.hibernate.dialect.SQLServerDialect
db.username=sa
db.password=sa

 

#ms sqlserver

#将jtds包放到lib下 

#要保证sqlserver2000 已安装 sp3以上补丁
db.driverClassName=com.microsoft.jdbc.sqlserver.SQLServerDriver
db.url=jdbc:microsoft:sqlserver://localhost:1433;databasename=mydatabase

db.dialect=org.hibernate.dialect.SQLServerDialect
db.username=sa
db.password=sa

 

#oracle

#将ojdbc14.jar包放到lib下 
db.driverClassName=oracle.jdbc.driver.OracleDriver
db.url=jdbc:oracle:thin:@127.0.0.1:1521:SysId

db.dialect=org.hibernate.dialect.Oracle9Dialect
db.username=mydatabase
db.password=password

 

#mysql

#将mysql-connector-java-5.1.5-bin.jar包放到lib下 
#db.driverClassName=org.gjt.mm.mysql.Driver

db.driverClassName=com.mysql.jdbc.Driver
db.url=jdbc:mysql://127.0.0.1/mydatabase

db.dialect=org.hibernate.dialect.MySQLDialect
db.username=root
db.password=root

 

#access

#将rt.jar包放到lib下 

db.driverClassName=sun.jdbc.odbc.JdbcOdbcDriver

db.url=jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\mydb.mdb