<style>
/* Changing the layout to use less space for mobiles */
@media screen and (max-device-width: 480px), screen and (-webkit-min-device-pixel-ratio: 2) {
#email-body { min-width: 30em !important; }
#email-page { padding: 8px !important; }
#email-banner { padding: 8px 8px 0 8px !important; }
#email-avatar { margin: 1px 8px 8px 0 !important; padding: 0 !important; }
#email-fields { padding: 0 8px 8px 8px !important; }
#email-gutter { width: 0 !important; }
}
</style>
<div id="email-body">
<table id="email-wrap" align="center" border="0" cellpadding="0" cellspacing="0" style="background-color:#f0f0f0;color:#000000;width:100%;">
<tr valign="top">
<td id="email-page" style="padding:16px !important;">
<table align="center" border="0" cellpadding="0" cellspacing="0" style="background-color:#ffffff;border:1px solid #bbbbbb;color:#000000;width:100%;">
<tr valign="top">
<td bgcolor="#3e4c4e" style="background-color:#3e4c4e;color:#ffffff;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;line-height:1;"><img src="https://www.jboss.org/dms/hibernate/images/jira/jiraheader_hibernate.png" alt="" style="vertical-align:top;" /></td>
</tr><tr valign="top">
<td id="email-banner" style="padding:32px 32px 0 32px;">
<table align="left" border="0" cellpadding="0" cellspacing="0" width="100%" style="width:100%;">
<tr valign="top">
<td style="color:#505050;font-family:Arial,FreeSans,Helvetica,sans-serif;padding:0;">
<img id="email-avatar" src="https://hibernate.onjira.com/secure/useravatar?avatarId=10162" alt="" height="48" width="48" border="0" align="left" style="padding:0;margin: 0 16px 16px 0;" />
<div id="email-action" style="padding: 0 0 8px 0;font-size:12px;line-height:18px;">
<a class="user-hover" rel="netangel" id="email_netangel" href="https://hibernate.onjira.com/secure/ViewProfile.jspa?name=netangel" style="color:#6c797f;">Anthony Ogier</a>
created <img src="https://hibernate.onjira.com/images/icons/bug.gif" height="16" width="16" border="0" align="absmiddle" alt="Bug"> <a style='color:#6c797f;text-decoration:none;' href='https://hibernate.onjira.com/browse/HHH-7753'>HHH-7753</a>
</div>
<div id="email-summary" style="font-size:16px;line-height:20px;padding:2px 0 16px 0;">
<a style='color:#6c797f;text-decoration:none;' href='https://hibernate.onjira.com/browse/HHH-7753'><strong>useScrollableResultSetToSkip not used</strong></a>
</div>
</td>
</tr>
</table>
</td>
</tr>
<tr valign="top">
<td id="email-fields" style="padding:0 32px 32px 32px;">
<table border="0" cellpadding="0" cellspacing="0" style="padding:0;text-align:left;width:100%;" width="100%">
<tr valign="top">
<td id="email-gutter" style="width:64px;white-space:nowrap;"></td>
<td>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Issue Type:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
<img src="https://hibernate.onjira.com/images/icons/bug.gif" height="16" width="16" border="0" align="absmiddle" alt="Bug"> Bug
</td>
</tr> <tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Affects Versions:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
4.0.1 </td>
</tr>
<tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Assignee:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
Unassigned </td>
</tr> <tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Components:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
core </td>
</tr>
<tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Created:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
04/Nov/12 5:46 PM
</td>
</tr> <tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Description:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
<p style='margin-top:0;margin-bottom:10px;'>If I use <tt>org.hibernate.dialect.SQLServerDialect</tt> with SQLServer2008 in order to paginate correctly (see <a href="https://hibernate.onjira.com/browse/HHH-7752" title="SQLServer2008Dialect doesn't support @Formula field containing subselects">HHH-7752</a> which was my previous errors, but this time I use a simple <tt>@Entity</tt> without any <tt>@Formula</tt> on it), I've got a "The requested operation is not supported on forward only result".</p>
<p style='margin-top:0;margin-bottom:10px;'>Here is the stack :</p>
<div class="code panel" style="border-width: 1px;"><div class="codeContent panelContent">
<pre class="code-java">ResultSetProxyHandler(AbstractResultSetProxyHandler).continueInvocation(<span class="code-object">Object</span>, Method, <span class="code-object">Object</span>[]) line: 104
ResultSetProxyHandler(AbstractProxyHandler).invoke(<span class="code-object">Object</span>, Method, <span class="code-object">Object</span>[]) line: 81
$Proxy172.absolute(<span class="code-object">int</span>) line: not available
QueryLoader(Loader).advance(ResultSet, RowSelection) line: 1651
QueryLoader(Loader).getResultSet(PreparedStatement, <span class="code-object">boolean</span>, <span class="code-object">boolean</span>, RowSelection, SessionImplementor) line: 1982
QueryLoader(Loader).doQuery(SessionImplementor, QueryParameters, <span class="code-object">boolean</span>, ResultTransformer) line: 829
QueryLoader(Loader).doQueryAndInitializeNonLazyCollections(SessionImplementor, QueryParameters, <span class="code-object">boolean</span>, ResultTransformer) line: 289
QueryLoader(Loader).doList(SessionImplementor, QueryParameters, ResultTransformer) line: 2463
QueryLoader(Loader).doList(SessionImplementor, QueryParameters) line: 2449
QueryLoader(Loader).listIgnoreQueryCache(SessionImplementor, QueryParameters) line: 2279
QueryLoader(Loader).list(SessionImplementor, QueryParameters, Set, Type[]) line: 2274
QueryLoader.list(SessionImplementor, QueryParameters) line: 470
QueryTranslatorImpl.list(SessionImplementor, QueryParameters) line: 355
HQLQueryPlan.performList(QueryParameters, SessionImplementor) line: 196
SessionImpl.list(<span class="code-object">String</span>, QueryParameters) line: 1115
QueryImpl.list() line: 101
QueryImpl<X>.getResultList() line: 252
JPAQuery(AbstractJPAQuery<Q>).getResultList(Query) line: 222
JPAQuery(AbstractJPAQuery<Q>).list(Expression<RT>) line: 274</pre>
</div></div>
<p style='margin-top:0;margin-bottom:10px;'>It seems to be a problem in <tt>org.hibernate.loader.Loader</tt> because if I put a breakpoint in line 1739 : </p>
<div class="code panel" style="border-width: 1px;"><div class="codeContent panelContent">
<pre class="code-java">st = session.getTransactionCoordinator().getJdbcCoordinator().getStatementPreparer().prepareQueryStatement(
sql,
callable,
scrollMode
);</pre>
</div></div>
<p style='margin-top:0;margin-bottom:10px;'>Here are the values of the variables :</p>
<ul>
<li>useLimit : true</li>
<li>hasFirstRow : true</li>
<li>useLimitOffset : false</li>
<li>canScroll : true</li>
<li><b>useScrollableResultSetToSkip : true</b></li>
<li><b>scrollMode : null</b> // I think, here it must have been <tt>ScrollMode.SCROLL_SENSITIVE</tt></li>
</ul>
<p style='margin-top:0;margin-bottom:10px;'>Actually, if I replace the value of scrollMode from null to ScrollMode.SCROLL_SENSITIVE just before the excecution of line 1739, then the error doesn't occure.</p>
<p style='margin-top:0;margin-bottom:10px;'>So there must be a problem in <tt>private ScrollMode getScrollMode(boolean scroll, boolean hasFirstRow, boolean useLimitOffSet, QueryParameters queryParameters)</tt> (line 1685) which doesn't use that <tt>useScrollableResultSetToSkip</tt> variable...</p>
<p style='margin-top:0;margin-bottom:10px;'>Here it's a problem with SQLServerDialect, but it could be another dialect which would want <tt>useScrollableResultSetToSkip</tt> to be taken into account (that is to say hasFirstRow = true, useLimit = true, useLimitOffset = false (dialect.supportsLimitOffset = false), getFactory().getSettings().isScrollableResultSetsEnabled() = true), because later <tt>getResultSet()</tt> method (line 1982) calls <tt>advance()</tt> method if <tt>!dialect.supportsLimitOffset() || !useLimit( selection, dialect )</tt> which will finally call <tt>ResultSet.absolute</tt> which will throw that exception because the ResultSet wasn't prepared with ScrollMode SENSITIVE.</p>
</td>
</tr>
<tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Environment:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
JBoss 7.1.1.Final, SQLServer 2008 R2
</td>
</tr>
<tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Project:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
<a style="color:#6c797f;" href="https://hibernate.onjira.com/browse/HHH">Hibernate ORM</a>
</td>
</tr> <tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Labels:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
sqlserver
pagination
core
</td>
</tr>
<tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Priority:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
<img src="https://hibernate.onjira.com/images/icons/priority_blocker.gif" height="16" width="16" border="0" align="absmiddle" alt="Blocker"> Blocker
</td>
</tr> <tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Reporter:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
<a class="user-hover" rel="netangel" id="email_netangel" href="https://hibernate.onjira.com/secure/ViewProfile.jspa?name=netangel" style="color:#6c797f;">Anthony Ogier</a>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td><!-- End #email-page -->
</tr>
<tr valign="top">
<td style="color:#505050;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:10px;line-height:14px;padding: 0 16px 16px 16px;text-align:center;">
This message is automatically generated by JIRA.<br />
If you think it was sent incorrectly, please contact your JIRA administrators<br />
For more information on JIRA, see: <a style='color:#6c797f;' href='http://www.atlassian.com/software/jira'>http://www.atlassian.com/software/jira</a>
</td>
</tr>
</table><!-- End #email-wrap -->
</div><!-- End #email-body -->