-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 
Author Message
 Post subject: Generated SQL is incorrect
PostPosted: Thu Jun 18, 2009 4:09 pm 
Newbie

Joined: Wed Jun 17, 2009 5:05 pm
Posts: 3
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 Statements
Code:
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.xml
Code:
<?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.xml
Code:
<?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.java
Code:
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.java
Code:
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.java
Code:

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 questions

15: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


Top
 Profile  
 
 Post subject: Re: Generated SQL is incorrect
PostPosted: Fri Jun 19, 2009 2:53 pm 
Newbie

Joined: Wed Jun 17, 2009 5:05 pm
Posts: 3
I have tried to change a few properties to see if anything shakes loose:

Changed hibernate.query.factory_class to org.hibernate.hql.ast.ASTQueryTranslatorFactory

Changed hibernate.dialect to org.hibernate.dialect.MySQL5InnoDBDialect

Niether effected the generated SQL.

Please help! I am at my wits end....


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.