hibernate+mysql自动生成数据库问题

王朝学院·作者佚名  2016-08-27
窄屏简体版  字體: 小  |  中  |  大  |  超大  

Hibernate Entity类

表名注解大写时,在windows下MySQL自动生成的表都为小写(不区分大小写),在linux下mysql自动生成区分大小写。导致数据库问题。

原因(window下mysql不区分大小写,hibernate生成时全部生成小写,linux下生成时,按照注解大小写生成)

1packagecom.pera.report.designer.data;23importjava.sql.Clob;45importjavax.persistence.Basic;6importjavax.persistence.Column;7importjavax.persistence.Entity;8importjavax.persistence.FetchType;9importjavax.persistence.Lob;10importjavax.persistence.Table;1112importcom.pera.maframework.core.common.entity.IdEntity;1314/**15*xml保存数据库16*17*@authorzcj18*19* @Time 2015-8-17 14:2120*/21@Entity22@Table(name = "qreport_Xml")23publicclassReportXmlextendsIdEntityimplementsjava.io.Serializable {24/**25*26*/27PRivatestaticfinallongserialVersionUID = 8362245934322337549L;2829privateClob reportXml;3031privateString reportName;3233privateString reportMemo;3435@Lob36@Basic(fetch =FetchType.EAGER)37@Column(name = "reportXml", columnDefinition = "TEXT", nullable =true)38publicClob getReportXml() {39returnreportXml;40}41publicvoidsetReportXml(Clob reportXml) {42this.reportXml =reportXml;43}4445@Column(name = "reportName")46publicString getReportName() {47returnreportName;48}49publicvoidsetReportName(String reportName) {50this.reportName =reportName;51}5253@Column(name = "reportMemo")54publicString getReportMemo() {55returnreportMemo;56}57publicvoidsetReportMemo(String reportMemo) {58this.reportMemo =reportMemo;59}60}

View Code

解决方法:

http://blog.csdn.net/mlx212/article/details/23828151

或都改为小写,重新生成!

 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
© 2005- 王朝網路 版權所有 導航