title: java.sql.SQLException: Incorrect syntax near the keyword 'top'
body: <p>I have stored procedure </p>
  
  <pre><code>CREATE PROC dbo.TestSproc
  
  as
  select COUNT(*) from dbo.TestCase
  </code></pre>
  
  <p>It doesn't make any useful things but I cannot invoke it via hibernate</p>
  
  <pre><code>Query query = m_entityManager.createNativeQuery("CALL TestSproc()");
  query.getSingleResult();
  </code></pre>
  
  <p>it causes java.sql.SQLException: Incorrect syntax near the keyword 'top'. other procedures has the same problem.</p>
  
  <p>and there is no <code>TOP</code> statement in this procedures. Has anyone any ideas how it could be fixed?</p>