Hibernate version: jboss 5.0
Name and version of the database you are using: SQL Server 2005
I'm trying to execute this native query calling stored proc: EXEC sp_c3_SEQ_SES; it used to work with jBoss 4.2.x, now I'm migrating to jBoss 5.0.0 GA and Hibernate seems to add a "top 2" right in the middle of my query: see below
Code:
15:07:02,400 INFO [STDOUT] Hibernate: EXEC sp_c3_SEQ top 2_SES;
15:07:02,416 WARN [JDBCExceptionReporter] SQL Error: 156, SQLState: S0001
15:07:02,416 ERROR [JDBCExceptionReporter] Incorrect syntax near the keyword 'top'.
Is there something i have to configure not to have this top 2 inserted in my query ? I'm doing a .getSingleResult() if it helps.
Thank you
Login
FAQ
Search