[hibernate-issues] [Hibernate-JIRA] Created: (HHH-4089) Hibernate adding top 2 when I call stored procedure

[Venod Raveendran (JIRA)]

Hibernate adding top 2 when I call stored procedure
---------------------------------------------------

                 Key: HHH-4089
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4089
             Project: Hibernate Core
          Issue Type: Bug
          Components: core
    Affects Versions: 3.3.0.SP1
         Environment: Windows SP, Microsoft SQL Server 2008, Java 6
            Reporter: Venod Raveendran


When I am creating a nativeQuery and calling my stored procedure to update some table
Hibernate is add top 2 in between the call

code
Query q = em.createNativeQuery("Rx_ManageCacheData(?,?,?,?,?,?," +
	"?,?,?,?,?,?," +
	"?,?,?,?,?,?,?," +
	"?,?,?,?,?,?," +
	"?,?,?)  ");

The above sql becomes

Rx_ManageCache top 2Data(
        ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
    )

11297 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 156, SQLState: S0001
11297 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Incorrect syntax near the keyword 'top'.
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.getSingleResult(QueryImpl.java:128)
	at com.venodebiz.middletier.rx.data.serviceimpl.RxDataServiceImpl.manageCachData(RxDataServiceImpl.java:100)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
	at java.lang.reflect.Method.invoke(Method.java:599)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
	at $Proxy18.manageCachData(Unknown Source)

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