I am trying to port an existing application to jboss, ejb3, hibernate/jpa, and mysql. I have two tables that represent a one-to-many relationship between a "link" and an "analytic entry". When I select a "link" the "analytic entry" query (lazy=false) is incorrect and I get an exception that the column is not in field list. I am not sure what is causing the query to be incorrect. Please help me find a solution...
Create StatementsCode:
CREATE TABLE `lt4`.`link` (
`SEQ_NBR` int(11) unsigned NOT NULL auto_increment,
`GUID` varchar(100) NOT NULL,
`VERSION_NBR` int(10) unsigned NOT NULL default '1',
`DATE_ADDED` datetime NOT NULL,
`DATE_REMOVED` datetime default NULL,
`CODE` varchar(45) default NULL,
`URL` varchar(4000) default NULL,
PRIMARY KEY (`GUID`),
KEY `SEQ_NBR_KY` (`SEQ_NBR`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Link Table';
CREATE TABLE `lt4`.`analytic_entry` (
`SEQ_NBR` int(10) unsigned NOT NULL auto_increment,
`GUID` varchar(100) NOT NULL,
`VERSION_NBR` int(10) unsigned NOT NULL default '1',
`DATE_ADDED` datetime NOT NULL,
`DATE_REMOVED` datetime default NULL,
`METRIC` varchar(45) default NULL,
`LINK_GUID` varchar(100) NOT NULL,
PRIMARY KEY (`GUID`),
KEY `LINK_GUID_FK` (`LINK_GUID`),
KEY `SEQ_NBR_KY` (`SEQ_NBR`),
CONSTRAINT `LINK_GUID_FK` FOREIGN KEY (`LINK_GUID`) REFERENCES `link` (`GUID`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='Analytic Entry Table';
Hibernate Mapping: lt4LinkDto.hbm.xmlCode:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated Oct 16, 2008 11:15:43 AM by Hibernate Tools 3.2.1.GA -->
<hibernate-mapping>
<class name="com.devj2ee.lt4.service.link.dto.impl.Lt4LinkDto" table="link" catalog="lt4">
<composite-id name="key" class="com.devj2ee.fw.lib.types.impl.Guid">
<key-property name="value" column="GUID" type="string" />
</composite-id>
<property name="sequenceNumber" type="java.lang.Long">
<column name="SEQ_NBR" not-null="true" />
</property>
<property name="versionNbr" type="java.lang.Long">
<column name="VERSION_NBR" not-null="true" />
</property>
<property name="dateAdded" type="timestamp">
<column name="DATE_ADDED" length="0" not-null="true" />
</property>
<property name="dateRemoved" type="timestamp">
<column name="DATE_REMOVED" length="0" />
</property>
<property name="code" type="java.lang.String">
<column name="CODE" not-null="true" />
</property>
<property name="url" type="java.lang.String">
<column name="URL" not-null="true" />
</property>
<set name="analyticEntries" table="analytic_entry" inverse="true" lazy="false" cascade="all,all-delete-orphan">
<key>
<column name="LINK_GUID" length="100" not-null="true" />
</key>
<one-to-many class="com.devj2ee.lt4.service.link.dto.impl.Lt4LinkDto" />
</set>
</class>
</hibernate-mapping>
Hibernate Mapping: lt4AnalyticEntryDto.hbm.xmlCode:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated Oct 16, 2008 11:15:43 AM by Hibernate Tools 3.2.1.GA -->
<hibernate-mapping>
<class name="com.devj2ee.lt4.service.link.dto.impl.Lt4AnalyticEntryDto" table="analytic_entry" catalog="lt4">
<composite-id name="key" class="com.devj2ee.fw.lib.types.impl.Guid">
<key-property name="value" column="GUID" type="string" />
</composite-id>
<many-to-one name="link" class="com.devj2ee.lt4.service.link.dto.impl.Lt4LinkDto" lazy="false">
<column name="LINK_GUID" length="100" not-null="true" />
</many-to-one>
<property name="sequenceNumber" type="java.lang.Long">
<column name="SEQ_NBR" not-null="true" />
</property>
<property name="versionNbr" type="java.lang.Long">
<column name="VERSION_NBR" not-null="true" />
</property>
<property name="dateAdded" type="timestamp">
<column name="DATE_ADDED" length="0" not-null="true" />
</property>
<property name="dateRemoved" type="timestamp">
<column name="DATE_REMOVED" length="0" />
</property>
<property name="metric" type="java.lang.String">
<column name="METRIC" not-null="true" />
</property>
</class>
</hibernate-mapping>
Object Source: Lt4DtoBase.javaCode:
package com.devj2ee.lt4.service.link.dto.impl;
import java.util.Date;
import com.devj2ee.fw.lib.types.impl.Guid;
import com.devj2ee.lt4.service.link.dto.api.ILt4DtoBase;
public abstract class Lt4DtoBase implements ILt4DtoBase {
private static final long serialVersionUID = 899000510548662483L;
private Guid key;
private Long sequenceNumber;
private Long versionNbr;
private Date dateAdded;
private Date dateRemoved;
public Lt4DtoBase() {
super();
this.key = new Guid();
this.sequenceNumber = new Long(0);
this.versionNbr = new Long(0);
this.dateAdded = new Date();
}
public Long getSequenceNumber() {
return this.sequenceNumber;
}
public void setSequenceNumber(Long sequenceNumber) {
this.sequenceNumber = sequenceNumber;
}
public Long getVersionNbr() {
return this.versionNbr;
}
public void setVersionNbr(Long versionNbr) {
this.versionNbr = versionNbr;
}
public Date getDateAdded() {
return this.dateAdded;
}
public void setDateAdded(Date dateAdded) {
this.dateAdded = dateAdded;
}
public Date getDateRemoved() {
return this.dateRemoved;
}
public void setDateRemoved(Date dateRemoved) {
this.dateRemoved = dateRemoved;
}
public Guid getKey() {
return key;
}
public void setKey(Guid key) {
this.key = key;
}
public Object clone() {
try {
return super.clone();
} catch (CloneNotSupportedException e) {
}
return null;
}
public int hashCode() {
int hash = 7;
hash = 31 * hash + (null == this.getKey() ? 0 : this.getKey().hashCode());
return hash;
}
}
Object Source: Lt4LinkDto.javaCode:
package com.devj2ee.lt4.service.link.dto.impl;
import java.util.Set;
import com.devj2ee.lt4.service.link.dto.api.ILt4LinkDto;
public class Lt4LinkDto extends Lt4DtoBase implements ILt4LinkDto {
private static final long serialVersionUID = 6199022456547223953L;
private String url;
private String code;
private Set<Lt4AnalyticEntryDto> analyticEntries;
public Lt4LinkDto() {
super();
}
public String getUrl() {
return this.url;
}
public void setUrl(String url) {
this.url = url;
}
public String getCode() {
return this.code;
}
public void setCode(String code) {
this.code = code;
}
public Set<Lt4AnalyticEntryDto> getAnalyticEntries() {
return this.analyticEntries;
}
public void setAnalyticEntries(Set<Lt4AnalyticEntryDto> analyticEntries) {
this.analyticEntries = analyticEntries;
}
}
Object Source: Lt4AnalyticEntryDto.javaCode:
package com.devj2ee.lt4.service.link.dto.impl;
import com.devj2ee.lt4.service.link.dto.api.ILt4AnalyticEntryDto;
public class Lt4AnalyticEntryDto extends Lt4DtoBase implements ILt4AnalyticEntryDto {
private static final long serialVersionUID = -4743009990791373076L;
private String metric;
private Lt4LinkDto link;
public Lt4AnalyticEntryDto() {
super();
}
public String getMetric() {
return this.metric;
}
public void setMetric(String metric) {
this.metric = metric;
}
public Lt4LinkDto getLink() {
return this.link;
}
public void setLink(Lt4LinkDto link) {
this.link = link;
}
}
Stack Trace: I have questions15:11:55,890 INFO [STDOUT] Hibernate:
/*
FROM
com.devj2ee.lt4.service.link.dto.impl.Lt4LinkDto m
where
m.code = :_code */ select
lt4linkdto0_.GUID as GUID5_,
lt4linkdto0_.SEQ_NBR as SEQ2_5_,
lt4linkdto0_.VERSION_NBR as VERSION3_5_,
lt4linkdto0_.DATE_ADDED as DATE4_5_,
lt4linkdto0_.DATE_REMOVED as DATE5_5_,
lt4linkdto0_.CODE as CODE5_,
lt4linkdto0_.URL as URL5_
from
lt4.link lt4linkdto0_
where
lt4linkdto0_.CODE=? limit ?
15:11:55,987 INFO [STDOUT] Hibernate:
/* load one-to-many com.devj2ee.lt4.service.link.dto.impl.Lt4LinkDto.analyticEntries */ select
analyticen0_.LINK_GUID as LINK8_1_, analyticen0_.GUID as GUID1_, analyticen0_.GUID as GUID5_0_, analyticen0_.SEQ_NBR as SEQ2_5_0_,
analyticen0_.VERSION_NBR as VERSION3_5_0_,
analyticen0_.DATE_ADDED as DATE4_5_0_,
analyticen0_.DATE_REMOVED as DATE5_5_0_,
analyticen0_.CODE as CODE5_0_,
analyticen0_.URL as URL5_0_
from
lt4.link analyticen0_
where
analyticen0_.LINK_GUID=?15:11:56,041 WARN [JDBCExceptionReporter] SQL Error: 1054, SQLState: 42S22
15:11:56,043 ERROR [JDBCExceptionReporter] Unknown column 'analyticen0_.LINK_GUID' in 'field list'15:11:56,047 ERROR [Lt4DaoBase] get failed
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not initialize a collection: [com.devj2ee.lt4.service.link.dto.impl.Lt4LinkDto.analyticEntries#component[value]{value=6d2fd51f-3d17-48de-996e-21793d434660}]
at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)
at org.hibernate.ejb.QueryImpl.getSingleResult(QueryImpl.java:128)
at com.devj2ee.lt4.service.link.kernel.dao.Lt4DaoBase.findByProperty(Lt4DaoBase.java:91)
at com.devj2ee.lt4.service.link.kernel.dao.Lt4LinkDao.findByCode(Lt4LinkDao.java:15)
at com.devj2ee.lt4.service.link.kernel.transactions.Lt4LinkFindByCodeAtxn.doExecute(Lt4LinkFindByCodeAtxn.java:16)
at com.devj2ee.fw.service.kernel.AtomicTransactionBase.execute(AtomicTransactionBase.java:34)
at com.devj2ee.fw.service.kernel.KernelBase.executeRequest(KernelBase.java:91)
at com.devj2ee.fw.service.port.command.impl.PortBase.executeRequest(PortBase.java:54)
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.jboss.aop.joinpoint.MethodInvocation.invokeTarget(MethodInvocation.java:122)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:111)
at org.jboss.ejb3.EJBContainerInvocationWrapper.invokeNext(EJBContainerInvocationWrapper.java:69)
at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.invoke(InterceptorSequencer.java:73)
at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.aroundInvoke(InterceptorSequencer.java:59)
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.jboss.aop.advice.PerJoinpointAdvice.invoke(PerJoinpointAdvice.java:174)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.fillMethod(InvocationContextInterceptor.java:72)
at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_fillMethod_3926741.invoke(InvocationContextInterceptor_z_fillMethod_3926741.java)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.setup(InvocationContextInterceptor.java:88)
at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_setup_3926741.invoke(InvocationContextInterceptor_z_setup_3926741.java)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:62)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:56)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:68)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
at org.jboss.aspects.tx.TxInterceptor$RequiresNew.invoke(TxInterceptor.java:261)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.security.RoleBasedAuthorizationInterceptorv2.invoke(RoleBasedAuthorizationInterceptorv2.java:201)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.security.Ejb3AuthenticationInterceptorv2.invoke(Ejb3AuthenticationInterceptorv2.java:186)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:41)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.BlockContainerShutdownInterceptor.invoke(BlockContainerShutdownInterceptor.java:67)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.aspects.currentinvocation.CurrentInvocationInterceptor.invoke(CurrentInvocationInterceptor.java:67)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:487)
at org.jboss.ejb3.remoting.IsLocalInterceptor.invokeLocal(IsLocalInterceptor.java:85)
at org.jboss.ejb3.remoting.IsLocalInterceptor.invoke(IsLocalInterceptor.java:72)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.aspects.remoting.PojiProxy.invoke(PojiProxy.java:62)
at $Proxy172.invoke(Unknown Source)
at org.jboss.ejb3.proxy.handler.ProxyInvocationHandlerBase.invoke(ProxyInvocationHandlerBase.java:261)
at org.jboss.ejb3.proxy.handler.session.SessionSpecProxyInvocationHandlerBase.invoke(SessionSpecProxyInvocationHandlerBase.java:101)
at $Proxy171.executeRequest(Unknown Source)
at com.devj2ee.fw.service.connector.ejb3command.impl.ConnectionEjb3Base.doExecuteRequest(ConnectionEjb3Base.java:35)
at com.devj2ee.fw.service.connector.command.impl.ConnectionBase.executeRequest(ConnectionBase.java:41)
at com.devj2ee.lt4.webapp.si.proxy.impl.Lt4LinkServiceProxy.findLinkBoByCode(Lt4LinkServiceProxy.java:50)
at com.devj2ee.lt4.webapp.si.proxy.impl.Lt4LinkServiceProxy$$FastClassByCGLIB$$24493ac8.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635)
at com.devj2ee.lt4.webapp.si.proxy.impl.Lt4LinkServiceProxy$$EnhancerByCGLIB$$39a61e74.findLinkBoByCode(<generated>)
at com.devj2ee.lt4.webapp.tracker.filters.LinkServiceFilter.doFilter(LinkServiceFilter.java:23)
at com.devj2ee.fw.webapp.j2ee.filter.BaseFilter.doFilter(BaseFilter.java:41)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:601)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.hibernate.exception.SQLGrammarException: could not initialize a collection: [com.devj2ee.lt4.service.link.dto.impl.Lt4LinkDto.analyticEntries#component[value]{value=6d2fd51f-3d17-48de-996e-21793d434660}]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.loadCollection(Loader.java:2022)
at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:59)
at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:587)
at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:83)
at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1743)
at org.hibernate.collection.AbstractPersistentCollection.forceInitialization(AbstractPersistentCollection.java:476)
at org.hibernate.engine.StatefulPersistenceContext.initializeNonLazyCollections(StatefulPersistenceContext.java:867)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:264)
at org.hibernate.loader.Loader.doList(Loader.java:2228)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
at org.hibernate.loader.Loader.list(Loader.java:2120)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:361)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at org.hibernate.ejb.QueryImpl.getSingleResult(QueryImpl.java:88)
... 99 more
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'analyticen0_.LINK_GUID' in 'field list'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3176)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1153)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1266)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1808)
at org.hibernate.loader.Loader.doQuery(Loader.java:697)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.loadCollection(Loader.java:2015)
... 115 more