我第一次使用具有休眠支持的MyEclipse For Spring。
以下是mysql db的相关部分:
CREATE TABLE
`delidete`.`DatiGeneraliVistoContabile` (
`DatiGeneraliId` int NOT NULL, <---- P.K., Foreign key to table Datigenerali
`SoggettiCodice` int NOT NULL, <---- P.K., Foreign key to table Soggetti
`DGVCDataInizio` date NOT NULL,
`DGVCDataFine` date) ;
CREATE TABLE
`delidete`.`DatiGeneraliParereTecnico` (
`DatiGeneraliId` int NOT NULL, <---- P.K., Foreign key to above table (DatigeneraliId)
`TecnicoParereCodice` int NOT NULL, <---- P.K., Foreign key to above table (SoggettiCodice)
`DGTPDescrizione` varchar (255) NOT NULL,
`DGTPDataInizio` date NOT NULL,
`DGTPDataFine` date) ;
ALTER TABLE `delidete`.`DatiGeneraliVistoContabile`
ADD PRIMARY KEY (`DatiGeneraliId`, `SoggettiCodice`) ;
ALTER TABLE `delidete`.`DatiGeneraliParereTecnico`
ADD CONSTRAINT `IDatiGeneraliParereTecnico`
FOREIGN KEY (`DatiGeneraliId`, `TecnicoParereCodice`)
REFERENCES `DatiGeneraliVistoContabile` (`DatiGeneraliId`, `SoggettiCodice`) ;
ALTER TABLE `delidete`.`DatiGeneraliVistoContabile`
ADD CONSTRAINT `IDatiGeneraliVistoContabile2`
FOREIGN KEY (`DatiGeneraliId`)
REFERENCES `DatiGenerali` (`DatiGeneraliId`) ;
ALTER TABLE `delidete`.`DatiGeneraliVistoContabile`
ADD CONSTRAINT `IDatiGeneraliVistoContabile1`
FOREIGN KEY (`SoggettiCodice`)
REFERENCES `Soggetti` (`SoggettiCodice`) ;
这是两个生成的类:
Datigeneralivistocontabile:
@IdClass(delidete.domain.DatigeneralivistocontabilePK.class)
@Entity
@Table(catalog = "delidete", name = "datigeneralivistocontabile")
@XmlAccessorType(XmlAccessType.FIELD)
@XmlType(namespace = "DeliDete/delidete/domain", name = "Datigeneralivistocontabile")
public class Datigeneralivistocontabile implements Serializable
{
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumns({@JoinColumn(name = "DatiGeneraliId", referencedColumnName = "DatiGeneraliId", nullable = false, insertable = false, updatable = false)})
@XmlTransient
Datigenerali datigenerali;
@Column(name = "DatiGeneraliId", nullable = false)
@Basic(fetch = FetchType.EAGER)
@Id
@XmlElement
Integer datiGeneraliId;
----------------------------------------------------------------------
//don't know why MyEclipse put this link into this class
@OneToOne(mappedBy = "datigeneralivistocontabile", fetch = FetchType.LAZY)
@XmlElement(name = "", namespace = "")
Datigeneralipareretecnico datigeneralipareretecnico;
----------------------------------------------------------------------
@Temporal(TemporalType.DATE)
@Column(name = "DGVCDataFine")
@Basic(fetch = FetchType.EAGER)
@XmlElement
Calendar dgvcdataFine;
@Temporal(TemporalType.DATE)
@Column(name = "DGVCDataInizio", nullable = false)
@Basic(fetch = FetchType.EAGER)
@XmlElement
Calendar dgvcdataInizio;
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumns({@JoinColumn(name = "SoggettiCodice", referencedColumnName = "SoggettiCodice", nullable = false, insertable = false, updatable = false)})
@XmlTransient
Soggetti soggetti;
@Column(name = "SoggettiCodice", nullable = false)
@Basic(fetch = FetchType.EAGER)
@Id
@XmlElement
Integer soggettiCodice;
constructors, getters, setters, toString, other stuff
}
另一堂课
Datigeneralipareretecnico:
@IdClass(delidete.domain.DatigeneralipareretecnicoPK.class)
@Entity
@Table(catalog = "delidete", name = "datigeneralipareretecnico")
@XmlAccessorType(XmlAccessType.FIELD)
@XmlType(namespace = "DeliDete/delidete/domain", name = "Datigeneralipareretecnico")
public class Datigeneralipareretecnico implements Serializable
{
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumns({@JoinColumn(name = "IDEnte", referencedColumnName = "DatiGeneraliId", nullable = false)})
@XmlTransient
Datigenerali datigenerali;
@Column(name = "DatiGeneraliId", nullable = false)
@Basic(fetch = FetchType.EAGER)
@Id
@XmlElement
Integer datiGeneraliId;
@PrimaryKeyJoinColumn
@OneToOne(fetch = FetchType.LAZY)
@XmlElement(name = "", namespace = "")
Datigeneralivistocontabile datigeneralivistocontabile;
@Temporal(TemporalType.DATE)
@Column(name = "DGTPDataFine")
@Basic(fetch = FetchType.EAGER)
@XmlElement
Calendar dgtpdataFine;
@Temporal(TemporalType.DATE)
@Column(name = "DGTPDataInizio", nullable = false)
@Basic(fetch = FetchType.EAGER)
@XmlElement
Calendar dgtpdataInizio;
@Column(name = "DGTPDescrizione", nullable = false)
@Basic(fetch = FetchType.EAGER)
@XmlElement
String dgtpdescrizione;
@Column(name = "TecnicoParereCodice", nullable = false)
@Basic(fetch = FetchType.EAGER)
@Id
@XmlElement
Integer tecnicoParereCodice;
constructors, getters, setters, toString, other stuff
}
以及两个PK类:
public class DatigeneralivistocontabilePK implements Serializable
{
@Column(name = "DatiGeneraliId", nullable = false)
@Basic(fetch = FetchType.EAGER)
@Id
public Integer datiGeneraliId;
@Column(name = "SoggettiCodice", nullable = false)
@Basic(fetch = FetchType.EAGER)
@Id
public Integer soggettiCodice;
}
public class DatigeneralipareretecnicoPK implements Serializable
{
@Column(name = "DatiGeneraliId", nullable = false)
@Basic(fetch = FetchType.EAGER)
@Id
public Integer datiGeneraliId;
@Column(name = "TecnicoParereCodice", nullable = false)
@Basic(fetch = FetchType.EAGER)
@Id
public Integer tecnicoParereCodice;
}
现在,当我尝试保存Datigeneralivistocontabile实体时,一切正常,但是当我尝试打开jsp以显示该实体时,我得到了:
GRAVE: Servlet.service() for servlet [DeliDete Servlet] in context with path [/DeliDete] threw exception [Request processing failed; nested exception is java.lang.IllegalArgumentException: org.hibernate.TypeMismatchException: Provided id of the wrong type for class delidete.domain.Datigeneralipareretecnico. Expected: class delidete.domain.DatigeneralipareretecnicoPK, got class delidete.domain.DatigeneralivistocontabilePK] with root cause
org.hibernate.TypeMismatchException: Provided id of the wrong type for class delidete.domain.Datigeneralipareretecnico. Expected: class delidete.domain.DatigeneralipareretecnicoPK, got class delidete.domain.DatigeneralivistocontabilePK
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:135)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1080)
at org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:1028)
at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:623)
at org.hibernate.type.EntityType.resolve(EntityType.java:431)
at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:140)
at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:898)
at org.hibernate.loader.Loader.doQuery(Loader.java:773)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270)
at org.hibernate.loader.Loader.doList(Loader.java:2449)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192)
at org.hibernate.loader.Loader.list(Loader.java:2187)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:241)
-----------------------------------------------------------------------
at delidete.dao.DatigeneralivistocontabileDAOImpl.findAllDatigeneralivistocontabiles(DatigeneralivistocontabileDAOImpl.java:109)
at delidete.dao.DatigeneralivistocontabileDAOImpl.findAllDatigeneralivistocontabiles(DatigeneralivistocontabileDAOImpl.java:93)
-----------------------------------------------------------------------
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at $Proxy61.findAllDatigeneralivistocontabiles(Unknown Source)
-----------------------------------------------------------------------
at delidete.service.DatigeneralivistocontabileServiceImpl.loadDatigeneralivistocontabiles(DatigeneralivistocontabileServiceImpl.java:226)
-----------------------------------------------------------------------
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at $Proxy88.loadDatigeneralivistocontabiles(Unknown Source)
-----------------------------------------------------------------------
at delidete.web.DatigeneralivistocontabileController.listDatigeneralivistocontabile(DatigeneralivistocontabileController.java:466)
-----------------------------------------------------------------------
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:426)
at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:414)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:549)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.java:129)
at com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:77)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:113)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:185)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:151)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:269)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:515)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
我的课程位于“ delidete”包中。
引发此异常的方法是:
@Transactional
public Set<Datigeneralivistocontabile> findAllDatigeneralivistocontabiles(
int startResult, int maxRows) throws DataAccessException
{
Query query = createNamedQuery("findAllDatigeneralivistocontabiles",
startResult, maxRows);
return new LinkedHashSet<Datigeneralivistocontabile>(
query.getResultList()); <---- this line throws the exception
}
它调用的namedquery是:
@NamedQuery(name = "findAllDatigeneralivistocontabiles", query = "select myDatigeneralivistocontabile from Datigeneralivistocontabile myDatigeneralivistocontabile")
查询“从datigeneralivistocontabile中选择*”;在MySQL提示符下很好:
mysql> select * from datigeneralivistocontabile;
+----------------+----------------+----------------+--------------+
| DatiGeneraliId | SoggettiCodice | DGVCDataInizio | DGVCDataFine |
+----------------+----------------+----------------+--------------+
| 1 | 1 | 2011-11-02 | 2011-11-03 |
+----------------+----------------+----------------+--------------+
1 row in set (0.00 sec)
mysql>
我不知道该怎么办,因为我成功管理了像这两个这样的数十个实体。我要注意的是,这是我第一次获得@OneToOne批注。
也许正是这导致了异常...
预先感谢大家
编辑:尝试将列名称TecnicoParereCodice更改为SoggettiCodice以匹配第一张表中该列的名称,但未进行任何更改:我重新搭建了一切,运行相同的测试并得到了相同的错误
最佳答案
由于主键是相同的,但是具有不同的属性名称,因此我修改了数据库,如下所示:
CREATE TABLE
`delidete`.`DatiGeneraliVistoContabile` (
`DatiGeneraliId` int NOT NULL, <---- P.K., Foreign key to table Datigenerali
`SoggettiCodice` int NOT NULL, <---- P.K., Foreign key to table Soggetti
`DGVCDataInizio` date NOT NULL,
`DGVCDataFine` date) ;
CREATE TABLE
`delidete`.`DatiGeneraliParereTecnico` (
`DatiGeneraliId` int NOT NULL, <---- P.K., Foreign key to above table (DatigeneraliId)
`SoggettiCodice` int NOT NULL, <---- P.K., Foreign key to above table (SoggettiCodice)
`DGTPDescrizione` varchar (255) NOT NULL,
`DGTPDataInizio` date NOT NULL,
`DGTPDataFine` date) ;
重新搭建了这两个实体,并将类Datigeneralipareretecnico更改如下:
**@IdClass(delidete.domain.DatigeneralivistocontabilePK.class)**
@Entity
@Table(catalog = "delidete", name = "datigeneralipareretecnico")
@XmlAccessorType(XmlAccessType.FIELD)
@XmlType(namespace = "DeliDete/delidete/domain", name = "Datigeneralipareretecnico")
public class Datigeneralipareretecnico implements Serializable
{
....
}
正如您在Datigeneralipareretecnico类中看到的那样,我将PK类用于Datigeneralivistocontabile类,一切正常。
我知道这不是解决问题的正确方法,但是嘿!
希望可以帮助别人。