各种数据库连接

JNDI Datasource

#hibernate.connection.datasource jdbc/test #hibernate.connection.username db2 #hibernate.connection.password db2

##

HypersonicSQL

hibernate.dialect org.hibernate.dialect.HSQLDialect hibernate.connection.driver_class org.hsqldb.jdbcDriver hibernate.connection.username sa hibernate.connection.password hibernate.connection.url

jdbc:hsqldb:./build/db/hsqldb/hibernate

#hibernate.connection.url jdbc:hsqldb:hsql://localhost #hibernate.connection.url jdbc:hsqldb:test ##

H2 (www.h2database.com)

#hibernate.dialect org.hibernate.dialect.H2Dialect #hibernate.connection.driver_class org.h2.Driver #hibernate.connection.username sa #hibernate.connection.password

#hibernate.connection.url jdbc:h2:mem:./build/db/h2/hibernate #hibernate.connection.url jdbc:h2:testdb/h2test

#hibernate.connection.url jdbc:h2:mem:imdb1

#hibernate.connection.url jdbc:h2:tcp://dbserv:8084/sample; #hibernate.connection.url

jdbc:h2:ssl://secureserv:8085/sample;

#hibernate.connection.url jdbc:h2:ssl://secureserv/testdb;cipher=AES

## MySQL

#hibernate.dialect org.hibernate.dialect.MySQLDialect

#hibernate.dialect org.hibernate.dialect.MySQLInnoDBDialect #hibernate.dialect org.hibernate.dialect.MySQLMyISAMDialect #hibernate.connection.driver_class com.mysql.jdbc.Driver #hibernate.connection.url jdbc:mysql:///test #hibernate.connection.username gavin #hibernate.connection.password ## Oracl

#hibernate.dialect org.hibernate.dialect.Oracle8iDialect #hibernate.dialect org.hibernate.dialect.Oracle9iDialect

#hibernate.dialect org.hibernate.dialect.Oracle10gDialect

#hibernate.connection.driver_class oracle.jdbc.driver.OracleDriver #hibernate.connection.username ora #hibernate.connection.password ora

#hibernate.connection.url jdbc:oracle:thin:@localhost:1521:orcl #hibernate.connection.url

jdbc:oracle:thin:@localhost:1522:XE

##

PostgreSQL

#hibernate.dialect org.hibernate.dialect.PostgreSQLDialect #hibernate.connection.driver_class org.postgresql.Driver #hibernate.connection.url jdbc:postgresql:template1 #hibernate.connection.username pg #hibernate.connection.password ## DB2

#hibernate.dialect org.hibernate.dialect.DB2Dialect

#hibernate.connection.driver_class com.ibm.db2.jcc.DB2Driver

#hibernate.connection.driver_class COM.ibm.db2.jdbc.app.DB2Driver #hibernate.connection.url jdbc:db2://localhost:50000/somename #hibernate.connection.url jdbc:db2:somename #hibernate.connection.username db2 #hibernate.connection.password db2

##

TimesTen

#hibernate.dialect org.hibernate.dialect.TimesTenDialect

#hibernate.connection.driver_class com.timesten.jdbc.TimesTenDriver #hibernate.connection.url jdbc:timesten:direct:tes #hibernate.connection.username #hibernate.connection.password ## DB2/400

#hibernate.dialect org.hibernate.dialect.DB2400Dialect #hibernate.connection.username user

#hibernate.connection.password password ##

Native driver

#hibernate.connection.driver_class COM.ibm.db2.jdbc.app.DB2Driver #hibernate.connection.url jdbc:db2://systemname ##

Toolbox driver

#hibernate.connection.driver_class com.ibm.as400.access.AS400JDBCDriver #hibernate.connection.url jdbc:as400://systemname

##

Derby (not supported!)

#hibernate.dialect org.hibernate.dialect.DerbyDialect

#hibernate.connection.driver_class org.apache.derby.jdbc.EmbeddedDriver #hibernate.connection.username #hibernate.connection.password

#hibernate.connection.url jdbc:derby:build/db/derby/hibernate;create=true ## Sybase

#hibernate.dialect org.hibernate.dialect.SybaseDialect

#hibernate.connection.driver_class com.sybase.jdbc2.jdbc.SybDriver #hibernate.connection.username sa

#hibernate.connection.password sasasa

#hibernate.connection.url jdbc:sybase:Tds:co3061835-a:5000/tempdb

##

Mckoi SQL

#hibernate.dialect org.hibernate.dialect.MckoiDialect #hibernate.connection.driver_class com.mckoi.JDBCDriver #hibernate.connection.url jdbc:mckoi:///

#hibernate.connection.url jdbc:mckoi:local://C:/mckoi1.0.3/db.conf #hibernate.connection.username admin #hibernate.connection.password nimda ##

SAP DB

#hibernate.dialect org.hibernate.dialect.SAPDBDialect

#hibernate.connection.driver_class com.sap.dbtech.jdbc.DriverSapDB #hibernate.connection.url jdbc:sapdb://localhost/TST #hibernate.connection.username TEST #hibernate.connection.password TEST #hibernate.query.substitutions yes 'Y', no 'N'

##

MS SQL Server

#hibernate.dialect org.hibernate.dialect.SQLServerDialect #hibernate.connection.username sa #hibernate.connection.password sa ##

JSQL Driver

#hibernate.connection.driver_class com.jnetdirect.jsql.JSQLDriver #hibernate.connection.url jdbc:JSQLConnect://1E1/test ##

JTURBO Driver

#hibernate.connection.driver_class com.newatlanta.jturbo.driver.Driver #hibernate.connection.url jdbc:JTurbo://1E1:1433/test ##

WebLogic Driver

#hibernate.connection.driver_class weblogic.jdbc.mssqlserver4.Driver #hibernate.connection.url jdbc:weblogic:mssqlserver4:1E1:1433

##

Microsoft Driver (not recommended!)

#hibernate.connection.driver_class com.microsoft.jdbc.sqlserver.SQLServerDriver #hibernate.connection.url

jdbc:microsoft:sqlserver://1E1;DatabaseName=test;SelectMethod=cursor ##

The New Microsoft Driver

#hibernate.connection.driver_class com.microsoft.sqlserver.jdbc.SQLServerDriver #hibernate.connection.url jdbc:sqlserver://localhost

##

jTDS (since version 0.9)

#hibernate.connection.driver_class net.sourceforge.jtds.jdbc.Driver #hibernate.connection.url jdbc:jtds:sqlserver://1E1/test

##

Interbase

#hibernate.dialect org.hibernate.dialect.InterbaseDialect #hibernate.connection.username sysdba #hibernate.connection.password masterkey ##

DO NOT specify hibernate.connection.sqlDialect ## InterClient

#hibernate.connection.driver_class interbase.interclient.Driver #hibernate.connection.url

jdbc:interbase://localhost:3060/C:/firebird/test.gdb ## Pure Java

#hibernate.connection.driver_class org.firebirdsql.jdbc.FBDriver #hibernate.connection.url

jdbc:firebirdsql:localhost/3050:/firebird/test.gdb