]
Mizael Montenegro commented on HHH-3292:
----------------------------------------
What was defined in relation to this bug?
Bug Oracle9iDialect Pagination
------------------------------
Key: HHH-3292
URL:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3292
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.6
Environment: Java2 6.0, Oracle 10i, Hibernate 3.2.6
Reporter: Mizael Montenegro
Priority: Critical
Original Estimate: 1 hour, 30 minutes
Remaining Estimate: 1 hour, 30 minutes
Hi, I found a flaw in the dialect of the oracle, the pagination doesn't work
correctly, my English is terrible, then I cannot describe the complete problem here, more
I will post the string sql that solves the problem.
select * from ( SELECT x.*, rownum as r FROM ( "CONSULT SQL" ) x ) where r
between ? AND ?
setInt(1, BEGIN);
setInt(2, END);
I altered the dialect and it perfectly worked with that solution. The largest problem is
when ordination, the order is used using pagination corresponds never to the exact return
of the original consultation.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: