久久精品人人爽,华人av在线,亚洲性视频网站,欧美专区一二三

Hibernate如何配置

共計(jì) 13330 個(gè)字符,預(yù)計(jì)需要花費(fèi) 34 分鐘才能閱讀完成。

這篇文章主要為大家展示了“Hibernate 如何配置”,內(nèi)容簡(jiǎn)而易懂,條理清晰,希望能夠幫助大家解決疑惑,下面讓丸趣 TV 小編帶領(lǐng)大家一起研究并學(xué)習(xí)一下“Hibernate 如何配置”這篇文章吧。

1、Hibernate.cfg.xml 主配置

Hibernate.cfg.xml 是主配置文件,其中配置大體分為 3 部分:數(shù)據(jù)庫(kù)連接信息、其他參數(shù)、映射信息!

!DOCTYPE hibernate-configuration PUBLIC
  -//Hibernate/Hibernate Configuration DTD 3.0//EN 
  http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd 
 hibernate-configuration 
  !--  通常,一個(gè) session-factory 節(jié)點(diǎn)代表一個(gè)數(shù)據(jù)庫(kù)  -- 
  session-factory 
  !-- 1.  數(shù)據(jù)庫(kù)連接配置  -- 
  property name= hibernate.connection.driver_class com.mysql.jdbc.Driver /property 
  property name= hibernate.connection.url jdbc:mysql:///test /property 
  property name= hibernate.connection.username root /property 
  property name= hibernate.connection.password root /property 
 !-- 
 數(shù)據(jù)庫(kù)方言配置, hibernate 在運(yùn)行的時(shí)候,會(huì)根據(jù)不同的方言生成符合當(dāng)前數(shù)據(jù)庫(kù)語(yǔ)法的 sql
  -- 
  property name= hibernate.dialect org.hibernate.dialect.MySQL5Dialect /property 
 
  !-- 2.  其他相關(guān)配置  -- 
 !-- 2.1  顯示 hibernate 在運(yùn)行時(shí)候執(zhí)行的 sql 語(yǔ)句  -- 
 property name= hibernate.show_sql false /property 
 !-- 2.2  格式化 sql -- 
 property name= hibernate.format_sql true /property 
 !-- 2.3  自動(dòng)建表  -- 
 property name= hibernate.hbm2ddl.auto update /property 

!-- 3.  加載所有映射  -- mapping resource= com/rk/hibernate/a_hello/Employee.hbm.xml /   /session-factory /hibernate-configuration

1.1、數(shù)據(jù)庫(kù)連接參數(shù)配置

## 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

1.2、自動(dòng)建表

#hibernate.hbm2ddl.auto create-drop  每次在創(chuàng)建 sessionFactory 時(shí)候執(zhí)行創(chuàng)建表;當(dāng)調(diào)用 sesisonFactory 的 close 方法的時(shí)候,刪除表!#hibernate.hbm2ddl.auto create  每次都重新建表;  如果表已經(jīng)存在就先刪除再創(chuàng)建
#hibernate.hbm2ddl.auto update  如果表不存在就創(chuàng)建;  表存在就不創(chuàng)建;#hibernate.hbm2ddl.auto validate (生成環(huán)境時(shí)候)  執(zhí)行驗(yàn)證:  當(dāng)映射文件的內(nèi)容與數(shù)據(jù)庫(kù)表結(jié)構(gòu)不一樣的時(shí)候就報(bào)錯(cuò)!

根據(jù) hibernate.cfg.xml 文件自動(dòng)建表

import org.hibernate.cfg.Configuration;
import org.hibernate.tool.hbm2ddl.SchemaExport;
public class App
 public static void main(String[] args)
 //  創(chuàng)建配置管理類對(duì)象
 Configuration config = new Configuration();
 //  加載主配置文件
 config.configure();
 //  創(chuàng)建工具類對(duì)象
 SchemaExport export = new SchemaExport(config);
 //  建表
 //  第一個(gè)參數(shù):  是否在控制臺(tái)打印建表語(yǔ)句
 //  第二個(gè)參數(shù):  是否執(zhí)行腳本
 export.create(true, true);
}

1.3、常用配置參考文件

常用配置參考文件:hibernate-distribution-3.6.0.Final\project\etc\hibernate.properties

 

######################
### Query Language ###
######################
## define query language constants / function names
hibernate.query.substitutions yes  Y , no  N

#hibernate.query.factory_class org.hibernate.hql.classic.ClassicQueryTranslatorFactory

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.h3database.com)
#hibernate.dialect org.hibernate.dialect.H2Dialect
#hibernate.connection.driver_class org.h3.Driver
#hibernate.connection.username sa
#hibernate.connection.password
#hibernate.connection.url jdbc:h3:mem:./build/db/h3/hibernate
#hibernate.connection.url jdbc:h3:testdb/h3test
#hibernate.connection.url jdbc:h3:mem:imdb1
#hibernate.connection.url jdbc:h3:tcp://dbserv:8084/sample; 
#hibernate.connection.url jdbc:h3:ssl://secureserv:8085/sample; 
#hibernate.connection.url jdbc:h3: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


#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

#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

#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:test
#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

#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

#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

#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

#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

#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

#hibernate.dialect org.hibernate.dialect.PointbaseDialect
#hibernate.connection.driver_class com.pointbase.jdbc.jdbcUniversalDriver
#hibernate.connection.url jdbc:pointbase:embedded:sample
#hibernate.connection.username PBPUBLIC
#hibernate.connection.password PBPUBLIC

#hibernate.dialect org.hibernate.dialect.IngresDialect
#hibernate.connection.driver_class ca.edbc.jdbc.EdbcDriver
#hibernate.connection.url jdbc:edbc://localhost:II7/database
#hibernate.connection.username user
#hibernate.connection.password password
## Ingres 2006 or later
#hibernate.dialect org.hibernate.dialect.IngresDialect
#hibernate.connection.driver_class com.ingres.jdbc.IngresDriver
#hibernate.connection.url jdbc:ingres://localhost:II7/database;CURSOR=READONLY;auto=multi
#hibernate.connection.username user
#hibernate.connection.password password
## Mimer SQL
#hibernate.dialect org.hibernate.dialect.MimerSQLDialect
#hibernate.connection.driver_class com.mimer.jdbc.Driver
#hibernate.connection.url jdbc:mimer:multi1
#hibernate.connection.username hibernate
#hibernate.connection.password hibernate

#hibernate.dialect org.hibernate.dialect.Cache71Dialect
#hibernate.connection.driver_class com.intersys.jdbc.CacheDriver
#hibernate.connection.username _SYSTEM
#hibernate.connection.password SYS
#hibernate.connection.url jdbc:Cache://127.0.0.1:1972/HIBERNATE

#hibernate.proxool.xml proxool.xml
#hibernate.proxool.properties proxool.properties

## use a custom ConnectionProvider (if not set, Hibernate will choose a built-in ConnectionProvider using hueristics)
#hibernate.connection.provider_class org.hibernate.connection.DriverManagerConnectionProvider
#hibernate.connection.provider_class org.hibernate.connection.DatasourceConnectionProvider
#hibernate.connection.provider_class org.hibernate.connection.C3P0ConnectionProvider
#hibernate.connection.provider_class org.hibernate.connection.ProxoolConnectionProvider

## Enable automatic flush during the JTA beforeCompletion() callback
## (This setting is relevant with or without the Transaction API)
#hibernate.transaction.flush_before_completion

## Enable automatic session close at the end of transaction
## (This setting is relevant with or without the Transaction API)
#hibernate.transaction.auto_close_session

## the Transaction API abstracts application code from the underlying JTA or JDBC transactions
#hibernate.transaction.factory_class org.hibernate.transaction.JTATransactionFactory
#hibernate.transaction.factory_class org.hibernate.transaction.JDBCTransactionFactory

## to use JTATransactionFactory, Hibernate must be able to locate the UserTransaction in JNDI
## default is java:comp/UserTransaction
## you do NOT need this setting if you specify hibernate.transaction.manager_lookup_class
#jta.UserTransaction jta/usertransaction
#jta.UserTransaction javax.transaction.UserTransaction
#jta.UserTransaction UserTransaction

## to use the second-level cache with JTA, Hibernate must be able to obtain the JTA TransactionManager
#hibernate.transaction.manager_lookup_class org.hibernate.transaction.JBossTransactionManagerLookup
#hibernate.transaction.manager_lookup_class org.hibernate.transaction.WeblogicTransactionManagerLookup
#hibernate.transaction.manager_lookup_class org.hibernate.transaction.WebSphereTransactionManagerLookup
#hibernate.transaction.manager_lookup_class org.hibernate.transaction.OrionTransactionManagerLookup
#hibernate.transaction.manager_lookup_class org.hibernate.transaction.ResinTransactionManagerLookup

## specify a default schema and catalog for unqualified tablenames
#hibernate.default_schema test
#hibernate.default_catalog test

## enable ordering of SQL UPDATEs by primary key
#hibernate.order_updates true

## set the maximum depth of the outer join fetch tree
hibernate.max_fetch_depth 1

## set the default batch size for batch fetching
#hibernate.default_batch_fetch_size 8

## rollback generated identifier values of deleted entities to default values
#hibernate.use_identifer_rollback true

## enable bytecode reflection optimizer (disabled by default)
#hibernate.bytecode.use_reflection_optimizer true

## set the maximum JDBC 2 batch size (a nonzero value enables batching)
#hibernate.jdbc.batch_size 5
#hibernate.jdbc.batch_size 0

## enable use of JDBC 2 scrollable ResultSets (specifying a Dialect will cause Hibernate to use a sensible default)
#hibernate.jdbc.use_scrollable_resultset true

## use streams when writing binary types to / from JDBC
hibernate.jdbc.use_streams_for_binary true

## use JDBC 3 PreparedStatement.getGeneratedKeys() to get the identifier of an inserted row
#hibernate.jdbc.use_get_generated_keys false

## enable JDBC result set column alias caching 
## (minor performance enhancement for broken JDBC drivers)
# hibernate.jdbc.wrap_result_sets

## optimize chache for minimal  puts  instead of minimal  gets  (good for clustered cache)
#hibernate.cache.use_minimal_puts true

## store the second-level cache entries in a more human-friendly format
#hibernate.cache.use_structured_entries true

#hibernate.cache.provider_class org.hibernate.cache.EhCacheProvider
#hibernate.cache.provider_class org.hibernate.cache.EmptyCacheProvider
hibernate.cache.provider_class org.hibernate.cache.HashtableCacheProvider
#hibernate.cache.provider_class org.hibernate.cache.TreeCacheProvider
#hibernate.cache.provider_class org.hibernate.cache.OSCacheProvider
#hibernate.cache.provider_class org.hibernate.cache.SwarmCacheProvider

正文完
 
丸趣
版權(quán)聲明:本站原創(chuàng)文章,由 丸趣 2023-07-19發(fā)表,共計(jì)13330字。
轉(zhuǎn)載說(shuō)明:除特殊說(shuō)明外本站除技術(shù)相關(guān)以外文章皆由網(wǎng)絡(luò)搜集發(fā)布,轉(zhuǎn)載請(qǐng)注明出處。
評(píng)論(沒有評(píng)論)
主站蜘蛛池模板: 昆山市| 青田县| 嘉禾县| 海宁市| 兴安县| 洮南市| 武强县| 渝中区| 惠来县| 同德县| 柳林县| 云和县| 新民市| 三明市| 樟树市| 太湖县| 卢湾区| 高淳县| 缙云县| 阜城县| 广灵县| 柏乡县| 湾仔区| 炉霍县| 商城县| 江永县| 山西省| 景德镇市| 玛多县| 峡江县| 麦盖提县| 新化县| 南涧| 罗源县| 澄江县| 休宁县| 沂源县| 云阳县| 社会| 邢台县| 黔南|