Hi all, I have a problem using native queries. I should query a view on my database. The resultset is then manually mapped to a n...@entity tagged pojo.
The view has the following columns: | +--------------------+--------------+------+-----+---------+-------+ | | Field | Type | Null | Key | Default | Extra | | +--------------------+--------------+------+-----+---------+-------+ | | artStoreid | bigint(20) | NO | | 0 | | | | articleId | bigint(20) | NO | | 0 | | | | articleNbr | int(11) | NO | | NULL | | | | articleDescription | varchar(126) | NO | | NULL | | | | storeId | bigint(20) | NO | | 0 | | | | storeCode | varchar(10) | NO | | NULL | | | | storeDescription | varchar(62) | NO | | NULL | | | | siteId | bigint(20) | NO | | 0 | | | +--------------------+--------------+------+-----+---------+-------+ | The log message is the following: | 18:32:51,212 INFO [OASI] Native query: SELECT artStoreId, articleId, articleNbr, articleDescription, storeId, storeCode, storeDescription, siteId FROM artstoresearch WHERE siteId=3 AND (articleNbr LIKE'%' OR articleDescription LIKE '') order by articleNbr | 18:32:51,214 INFO [STDOUT] Hibernate: | SELECT | artStoreId, | articleId, | articleNbr, | articleDescription, | storeId, | storeCode, | storeDescription, | siteId | FROM | artstoresearch | WHERE | siteId=3 | AND ( | articleNbr LIKE'%' | OR articleDescription LIKE '' | ) | order by | articleNbr | 18:32:51,214 INFO [BigIntegerType] could not read column value from result set: id; Column 'id' not found. | 18:32:51,215 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: S0022 | 18:32:51,215 ERROR [JDBCExceptionReporter] Column 'id' not found. | 18:32:51,216 ERROR [OASI] Loading ArticleStoreView records via NativeQuery. | javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query | at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614) | at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:76) | at ch.oasi.xlnet.dao.ArticleStoreViewDao.findByArticleAndSite(ArticleStoreViewDao.java:38) | 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.GeneratedMethodAccessor330.invoke(Unknown Source) | 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_7988008.invoke(InvocationContextInterceptor_z_fillMethod_7988008.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_7988008.invoke(InvocationContextInterceptor_z_setup_7988008.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$Required.invoke(TxInterceptor.java:190) | 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:159) | 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:65) | 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:486) | at org.jboss.ejb3.session.InvokableContextClassProxyHack._dynamicInvoke(InvokableContextClassProxyHack.java:56) | at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:91) | at org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invoke(AOPRemotingInvocationHandler.java:82) | at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:908) | at org.jboss.remoting.transport.socket.ServerThread.completeInvocation(ServerThread.java:742) | at org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:695) | at org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:522) | at org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:230) | Caused by: org.hibernate.exception.SQLGrammarException: could not execute query | at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90) | at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) | at org.hibernate.loader.Loader.doList(Loader.java:2231) | at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125) | at org.hibernate.loader.Loader.list(Loader.java:2120) | at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:312) | at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1722) | at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165) | at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:175) | at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:67) | ... 59 more | Caused by: java.sql.SQLException: Column 'id' not found. | at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) | at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) | at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) | at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1136) | at com.mysql.jdbc.ResultSetImpl.getBigDecimal(ResultSetImpl.java:1406) | at org.jboss.resource.adapter.jdbc.WrappedResultSet.getBigDecimal(WrappedResultSet.java:320) | at org.hibernate.type.BigIntegerType.get(BigIntegerType.java:57) | at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:184) | at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:210) | at org.hibernate.loader.custom.CustomLoader$ScalarResultColumnProcessor.extract(CustomLoader.java:497) | at org.hibernate.loader.custom.CustomLoader$ResultRowProcessor.buildResultRow(CustomLoader.java:443) | at org.hibernate.loader.custom.CustomLoader.getResultColumnOrRow(CustomLoader.java:340) | at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:629) | at org.hibernate.loader.Loader.doQuery(Loader.java:724) | at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259) | at org.hibernate.loader.Loader.doList(Loader.java:2228) | ... 66 more | View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4219937#4219937 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4219937 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
