itVincent Blog - Java Working Fun!

          技術引領時代!
          posts - 117, comments - 181, trackbacks - 0, articles - 12

          [Hibernate]SchemaUpdate建立索引問題

          Posted on 2008-12-02 10:57 itVincent 閱讀(846) 評論(0)  編輯  收藏

          [Hibernate]SchemaUpdate建立索引問題

          關鍵字: hibernate schemaupdate 索引
          當hibernate的hbm2dll配置為
          1. hibernate.hbm2ddl.auto update  
          將會發現Hibernate不會為我們創建任何自定義的索引(不包括主鍵跟外鍵索引),不論你使用xml方式或者annotation進行聲明配置
          這個問題在Hibernate的JIRA多次出現,甚至有人專門為此發布了打了補丁的hibernate.jar
          這個所謂的bug,在目前已發布的hibernate的版本中,一直都沒有解決,或者說不予理睬(Gavin King個人認為這個不是bug)

          這里引用hibernate 3.2.5版的jira
          http://opensource.atlassian.com/projects/hibernate/browse/HHH-1012

          引用Hibernate上官方的解釋
          引用

          The hibernate.hbm2ddl.auto=update setting doesn't create indexes
          SchemaUpdate is activated by this configuration setting. SchemaUpdate is not really very powerful and comes without any warranties. For example, it does not create any indexes automatically. Furthermore, SchemaUpdate is only useful in development, per definition (a production schema is never updated automatically). You don't need indexes in development.

          Hibernate doesn't generate the database indexes I want in the schema!

          Automatic schema export (and update) by Hibernate tools is only useful in development. You never need indexes in development, they are purely for performance and scalability tuning in production systems. Production schemas are never automatically generated, at least not completely. A DBA adds indexes to the automatically generated schema during SQL tuning and testing of the application, before going into production with the (possibly automatically generated) base schema, and her handwritten optimized DDL. Also note that optimized DDL is highly vendor specific and totally dependent on the environment (SQL execution plans, tablespace configuration, caches, etc). Even if Hibernate developers would encourage you to automatically generate production-ready schemas (we don't, and we also don't like ad-hoc SQL tuning by throwing a bunch of indexes onto a schema), Hibernate could never offer such a feature.
          轉自: http://xmkevinchen.javaeye.com/blog/196372


          郁悶非常的一個"BUG",只有把hibernate.hbm2ddl.auto update  改成create才能生成索引

          只有注冊用戶登錄后才能發表評論。


          網站導航:
           
          主站蜘蛛池模板: 阿尔山市| 台安县| 滦平县| 南平市| 大安市| 汾西县| 多伦县| 墨江| 太仓市| 东海县| 德令哈市| 开化县| 四子王旗| 呼和浩特市| 平遥县| 苏州市| 金坛市| 青铜峡市| 台中市| 祥云县| 漳州市| 大连市| 锦屏县| 兰溪市| 包头市| 文昌市| 榆社县| 平邑县| 读书| 仪征市| 腾冲县| 绥芬河市| 南部县| 广西| 永年县| 汪清县| 青阳县| 虹口区| 南昌市| 涡阳县| 武平县|