[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2974) Native SQLQuey combined with addEntity forces to retrieve all columns
Philippe Mouawad (JIRA)
noreply at atlassian.com
Fri Nov 30 08:01:56 EST 2007
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2974?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_29012 ]
Philippe Mouawad commented on HHH-2974:
---------------------------------------
I see we are on serious argument, so my answer will be of this kind:
Our Father (Hibernate Master), who art in heaven (of Object Mapping),
hallowed be thy name (You're simply the best, better than all the rest
Better than anyone, anyone I've ever met ...);
thy kingdom come;
thy will be done on earth as it is in heaven.
Give us this day our daily bread;
and forgive us our trespasses (I dared to emit a little criticism, SHALL I BE DAMNED forever ? )
as we forgive those who trespass against us;
and lead us not into temptation (of using poor SQL),
but deliver us from evil (which leads us to emit a poor little complaint about API).
For the kingdom, the power, and the glory are yours
now and for ever.
Amen.
And to be serious, thank you for your helpful help :-),
as you didn't read, I already know about scalar, and since I read
Chapter 16 as my Bible, I also know about Transformers ,<resultset>...
ADIOS AMIGOs
> Native SQLQuey combined with addEntity forces to retrieve all columns
> ---------------------------------------------------------------------
>
> Key: HHH-2974
> URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2974
> Project: Hibernate3
> Issue Type: Bug
> Components: core, documentation
> Affects Versions: 3.0 alpha, 3.0 beta 1, 3.0 beta 2, 3.0 beta 3, 3.0 beta 4, 3.0 rc 1, 3.0 final, 3.0.1, 3.0.2, 3.0.3, 3.0.4, 3.0.5, 3.1 beta 1, 3.1 beta 2, 3.1 rc 1, 3.1 rc2, 3.1 rc3, 3.1, 3.1.1, 3.1.2, 3.2.0.alpha1, 3.2.0.alpha2, 3.1.3, 3.2.0 cr1, 3.2.0.cr2, 3.2.0.cr3, 3.2.0.cr4, 3.2.0.cr5, 3.2.0.ga, 3.2.1, 3.2.2, 3.2.3, 3.2.4, 3.2.4.sp1, 3.2.5
> Environment: Hibernate 3.2.5, All Databases
> Reporter: Philippe Mouawad
> Attachments: ArtCondVente.hbm.xml, ArtLibelle.hbm.xml
>
>
> Hello,
> I think it is rather a feature after looking inside Hibernate Code but since I didn't find anything about it in the Docs Chapter 16 (http://www.hibernate.org/hib_docs/reference/en/html/querysql.html)
> The problem is that If you do not specify <alias>.* in a Native SQL Query it will fail.
> To be clear, it seems that when using addEntity or <return alias="..." /> you cannot retrieve only the column you are interested in. Instead addScalar or <return-scalar must be used.
> I think the documentation shoud explicitely indicate it or the feature shoud be developped since it would be rather a great feature when native SQL has to be used.
> Hibernate Mapping:
> Attached file
> <sql-query name="getInfoComplEcom">
> <return alias="acv" class="com.kingfisher.chrgtecom.dataobject.ecom.DoArtCondVente" />
> <![CDATA[
> SELECT
> theAcv.CARTICLE as {acv.carticle},
> theAcv.CESCLAVE as {acv.cesclave},
> theAcv.LARTICLE as {acv.larticle},
> theAcv.LARTICLE_RED as {acv.larticleRed}
> FROM ART_COND_VENTE theAcv
> WHERE theAcv.CARTICLE in (:codeArticles)
> ]]>
> </sql-query>
> Java code:
> // codeArticles is a List of Integer Ids
> Session session = getCurrentSession();
> Query query = session.getNamedQuery("getInfoComplEcom");
> query.setParameterList("codeArticles",codeArticles);
> List result = query.list();
> return result;
> Missing column is :TMODIF6_0_ , alias column of tmodif property, not in Native Query
> Stack:
> ERROR:http-8080-Processor4-org.hibernate.util.JDBCExceptionReporter-Nom de colonne non valide
> ERROR:http-8080-Processor4-com.foo.action.ChargerProduitAction-Development error for URI :'/chrgtecom/main/chargerProduit.do'
> org.hibernate.exception.GenericJDBCException: could not execute query
> at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
> at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
> at org.hibernate.exception.JDBCExceptionHelper.convert (JDBCExceptionHelper.java:43)
> at org.hibernate.loader.Loader.doList(Loader.java:2223)
> at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
> at org.hibernate.loader.Loader.list(Loader.java :2099)
> at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289)
> at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695)
> at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java :142)
> at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:152)
> at com.foo.dao.EcomDao.getInfoComplEcom(EcomDao.java:112)
> at com.foo.services.EcomServices.getInfoComplEcom (EcomServices.java:20)
> at com.foo.services.EcomServices$$FastClassByCGLIB$$5dc5078d.invoke(<generated>)
> at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
> at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint (Cglib2AopProxy.java:695)
> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
> at org.springframework.transaction.interceptor.TransactionInterceptor.invoke (TransactionInterceptor.java:107)
> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
> at org.springframework.transaction.interceptor.TransactionInterceptor.invoke (TransactionInterceptor.java:107)
> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
> at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept (Cglib2AopProxy.java:630)
> at com.foo.services.EcomServices$$EnhancerByCGLIB$$4ffbebb6.getInfoComplEcom(<generated>)
> at com.foo.services.AgileServices.getInfosCompl(AgileServices.java :131)
> at com.foo.services.AgileServices.prepareInfosCompl(AgileServices.java:152)
> at com.foo.services.AgileServices$$FastClassByCGLIB$$b720e887.invoke(<generated>)
> at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
> at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:695)
> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed (ReflectiveMethodInvocation.java:144)
> at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed (ReflectiveMethodInvocation.java:166)
> at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:630)
> at com.foo.services.AgileServices$$EnhancerByCGLIB$$61330582.prepareInfosCompl (<generated>)
> at com.foo.action.ChargerProduitAction.process(ChargerProduitAction.java:122)
> at com.ubikingenierie.fwk.action.GenericAction.execute(GenericAction.java:113)
> at org.springframework.web.struts.DelegatingActionProxy.execute (DelegatingActionProxy.java:110)
> at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
> at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
> at com.ubikingenierie.fwk.struts.processor.FwkRequestProcessor.process(FwkRequestProcessor.java:142)
> at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
> at org.apache.struts.action.ActionServlet.doPost (ActionServlet.java:432)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:199)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:145)
> at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java :63)
> at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:165)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:145)
> at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
> at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke (FilterSecurityInterceptor.java:107)
> at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
> at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter (FilterChainProxy.java:275)
> at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)
> at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java :275)
> at com.ubikingenierie.fwk.timeout.LoggedOnApplicationFilter.doFilter(LoggedOnApplicationFilter.java:101)
> at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
> at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
> at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
> at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:229)
> at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
> at org.acegisecurity.ui.logout.LogoutFilter.doFilter (LogoutFilter.java:106)
> at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
> at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java :286)
> at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
> at org.acegisecurity.securechannel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:138)
> at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
> at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
> at org.acegisecurity.util.FilterToBeanProxy.doFilter (FilterToBeanProxy.java:98)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:165)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java :145)
> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
> at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
> at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:955)
> at org.apache.catalina.core.StandardContextValve.invoke (StandardContextValve.java:139)
> at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
> at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java :198)
> at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
> at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:955)
> at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2460)
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java :133)
> at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
> at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:119)
> at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
> at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext (StandardPipeline.java:594)
> at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:545)
> at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java :594)
> at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:955)
> at org.apache.catalina.core.StandardEngineValve.invoke (StandardEngineValve.java:127)
> at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
> at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java :433)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:955)
> at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:157)
> at org.apache.coyote.http11.Http11Processor.process (Http11Processor.java:874)
> at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
> at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java :528)
> at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
> at java.lang.Thread.run (Thread.java:534)
> Caused by: java.sql.SQLException: Nom de colonne non valide
> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
> at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:162)
> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
> at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java:3060)
> at oracle.jdbc.driver.OracleResultSetImpl.findColumn (OracleResultSetImpl.java:1861)
> at org.apache.commons.dbcp.DelegatingResultSet.findColumn(DelegatingResultSet.java:292)
> at org.hibernate.jdbc.ColumnNameCache.getIndexForColumnName(ColumnNameCache.java:28)
> at org.hibernate.jdbc.ResultSetWrapper.findColumn(ResultSetWrapper.java:61)
> at org.hibernate.jdbc.ResultSetWrapper.getString(ResultSetWrapper.java:225)
> at org.hibernate.type.StringType.get(StringType.java :18)
> at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:163)
> at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:154)
> at org.hibernate.type.AbstractType.hydrate(AbstractType.java :81)
> at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2096)
> at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1380)
> at org.hibernate.loader.Loader.instanceNotYetLoaded (Loader.java:1308)
> at org.hibernate.loader.Loader.getRow(Loader.java:1206)
> at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:580)
> at org.hibernate.loader.Loader.doQuery(Loader.java:701)
> at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
> at org.hibernate.loader.Loader.doList(Loader.java:2220)
> ... 98 more
> Hope this is not a duplicate, I searched for a bug or in the forum.
> Philippe
> http://www.ubik-ingenierie.com
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the hibernate-issues
mailing list