我的第七课：错误总结



第一种情况：

A表 A_id
B表 B_id
C表 C_id，A_id，B_id
select a.*1，a.*2，a.*3，b.*1，b.*2，b.*3
form C as c
left join A as a on (c.A_id = a.A_id)
left join B as b on (c.B_id = b.B_id)

第二种情况：

A表  A_id     Company company

B表  B_id   A_id     Job job

C表  C_id   A_id     Pfavorite pfavorite

select a.*1,a.*2,b.*1,b.*2   

from C as c

left join A as a (left join B as b on ( b.A_id=a.A_id))on(c.A_id=a.A_id) 

 

select  company.uname , job.jobname  from 

  Pfavorite as   pfavorite 

left join Company as company (left join Job as job on(job.cid=company.id) on (pfavorite.fuid=compay.uname))

2013/5/12号：

1、
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Initialization of bean failed; nested exception is org.hibernate.MappingException: Repeated column in mapping for entity: com.xindeco.myregister.pojo.MyRegisterInfo column: password (should be mapped with insert="false" update="false")

百分百配置文件 属性 错误

  <property name="pensionNumber" type="string" column="50"></property>

出错原因：1、 数据库的字段值和javaBean中的属性类型不统一 。对于基本类型，要用wrapper类型而不是primitive类型。2、hibernate的配置文件xxx.hbm.xml中的属性配置不为空，而数据库中的字段却为空。3.两个字段对应同一列，如：password 和repassword同时对应数据库表中的password一列，同时update和insert都设为true。

xml文件如下：
    <property name="password"
                          type="java.lang.String"
                          update="true"
                          insert="true"
                          access="property"
                          column="password"
                          length = "32"
                          />

                         <property name="repassword"
                          type="java.lang.String"
                          update="false"
                          insert="false"
                          access="property"
                          column="password"
                          length = "32"
                          />

解决的方法：
将repassword的insert和update设为false。

4:.hbm.xml的映射文件出错，具体字段出错，比如长度，或者少写，或者多写

严重: Exception starting filter struts2

Unable to load configuration. - [unknown location]

Caused by: Unable to load configuration. - [unknown location]

Caused by: Cannot locate the chosen ObjectFactory implementation: spring - [unknown location]

解决的办法是：

jar包冲突 
xerce.jar和xml-apis.jar这两个jar包冲突
删除xerce.jar