10:51 p.m.
DB2 setMaxResults problem in Hibernate 3.1.3
--------------------------------------------
Key: HHH-2176
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2176
Project: Hibernate3
Type: Bug
Components: core
Versions: 3.1.3
Environment: DB2 any version
Hibernate 3.1.3
JDK 1.5
Reporter: Winter Lau
Priority: Blocker
public static List listHotTags(int count){
Session ssn = getSession();
String sql = "SELECT tag_name,COUNT(*) FROM dlog_tag GROUP BY tag_name ORDER
BY 2 DESC";
SQLQuery query = ssn.createSQLQuery(sql);
query.setMaxResults(count);
List tags = new ArrayList();
List results = query.list();
for(int i=0;results!=null && i
tags.add(((Object[])results.get(i))[0]);
}
return tags;
}
tags.add(((Object[])results.get(i))[0]); this code work fine in other database, but in
DB2 , it return the rownumber, i must change to get the second element of array then it
return the correct data.
--
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....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
12:14 p.m.
New subject: [Hibernate-JIRA] Updated: (HHH-2176) DB2 setMaxResults problem in Hibernate 3.1.3
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2176?page=all ]
Milosz Tylenda updated HHH-2176:
--------------------------------
Attachment: HHH-2176.patch
My patch fixes the problem and has some other advantages over the current code:
- Correctly handles SELECT DISTINCT queries. The current code uses ROWNUMBER()
with an empty OVER() which, according to docs, might return rows in wrong order.
- Handles SELECT * queries.
- Handles SQL comments without looking for SELECT keyword which may produce syntax
errors.
- Avoids looking for ORDER BY clause which may produce syntax errors if OLAP
functions like RANK() are used.
- Code is shorter.
The drawbacks are:
- An additional subquery is used.
- An ORDER OF construct is used which is supported on DB2 UDB 8.1 and later.
7.2 has no support for it and for 8.0 I couldn't find docs (was it an
official release?)
The patch also updates PaginationTest.
DB2 setMaxResults problem in Hibernate 3.1.3
--------------------------------------------
Key: HHH-2176
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2176
Project: Hibernate3
Type: Bug
Components: core
Versions: 3.1.3
Environment: DB2 any version
Hibernate 3.1.3
JDK 1.5
Reporter: Winter Lau
Priority: Blocker
Attachments: HHH-2176.patch
public static List listHotTags(int count){
Session ssn = getSession();
String sql = "SELECT tag_name,COUNT(*) FROM dlog_tag GROUP BY tag_name ORDER
BY 2 DESC";
SQLQuery query = ssn.createSQLQuery(sql);
query.setMaxResults(count);
List tags = new ArrayList();
List results = query.list();
for(int i=0;results!=null && i
tags.add(((Object[])results.get(i))[0]);
}
return tags;
}
tags.add(((Object[])results.get(i))[0]); this code work fine in other database, but in
DB2 , it return the rownumber, i must change to get the second element of array then it
return the correct data.
--
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....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
3:34 a.m.
New subject: [Hibernate-JIRA] Updated: (HHH-2176) DB2 setMaxResults problem in Hibernate 3.1.3
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2176?page=all ]
Milosz Tylenda updated HHH-2176:
--------------------------------
Attachment: HHH-2176_2.patch
I have updated the patch using the idea presented in HHH-2389. My test on a 300000-row
table showed about 10x speed-up.
DB2 setMaxResults problem in Hibernate 3.1.3
--------------------------------------------
Key: HHH-2176
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2176
Project: Hibernate3
Type: Bug
Components: core
Versions: 3.1.3
Environment: DB2 any version
Hibernate 3.1.3
JDK 1.5
Reporter: Winter Lau
Priority: Blocker
Attachments: HHH-2176.patch, HHH-2176_2.patch
public static List listHotTags(int count){
Session ssn = getSession();
String sql = "SELECT tag_name,COUNT(*) FROM dlog_tag GROUP BY tag_name ORDER
BY 2 DESC";
SQLQuery query = ssn.createSQLQuery(sql);
query.setMaxResults(count);
List tags = new ArrayList();
List results = query.list();
for(int i=0;results!=null && i
tags.add(((Object[])results.get(i))[0]);
}
return tags;
}
tags.add(((Object[])results.get(i))[0]); this code work fine in other database, but in
DB2 , it return the rownumber, i must change to get the second element of array then it
return the correct data.
--
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....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
12:29 p.m.
New subject: [Hibernate-JIRA] Assigned: (HHH-2176) DB2 setMaxResults problem in Hibernate 3.1.3
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2176?page=c...
]
Strong Liu reassigned HHH-2176:
-------------------------------
Assignee: Strong Liu
DB2 setMaxResults problem in Hibernate 3.1.3
--------------------------------------------
Key: HHH-2176
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2176
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.1.3
Environment: DB2 any version
Hibernate 3.1.3
JDK 1.5
Reporter: Winter Lau
Assignee: Strong Liu
Priority: Blocker
Attachments: HHH-2176.patch, HHH-2176_2.patch
public static List listHotTags(int count){
Session ssn = getSession();
String sql = "SELECT tag_name,COUNT(*) FROM dlog_tag GROUP BY tag_name ORDER
BY 2 DESC";
SQLQuery query = ssn.createSQLQuery(sql);
query.setMaxResults(count);
List tags = new ArrayList();
List results = query.list();
for(int i=0;results!=null && i
tags.add(((Object[])results.get(i))[0]);
}
return tags;
}
tags.add(((Object[])results.get(i))[0]); this code work fine in other database, but in
DB2 , it return the rownumber, i must change to get the second element of array then it
return the correct data.
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:26 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2176) DB2 setMaxResults problem in Hibernate 3.1.3
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2176?page=c...
]
Strong Liu commented on HHH-2176:
---------------------------------
if you have a test case, please attach it, thanks
DB2 setMaxResults problem in Hibernate 3.1.3
--------------------------------------------
Key: HHH-2176
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2176
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.1.3
Environment: DB2 any version
Hibernate 3.1.3
JDK 1.5
Reporter: Winter Lau
Assignee: Strong Liu
Priority: Blocker
Attachments: HHH-2176.patch, HHH-2176_2.patch
public static List listHotTags(int count){
Session ssn = getSession();
String sql = "SELECT tag_name,COUNT(*) FROM dlog_tag GROUP BY tag_name ORDER
BY 2 DESC";
SQLQuery query = ssn.createSQLQuery(sql);
query.setMaxResults(count);
List tags = new ArrayList();
List results = query.list();
for(int i=0;results!=null && i
tags.add(((Object[])results.get(i))[0]);
}
return tags;
}
tags.add(((Object[])results.get(i))[0]); this code work fine in other database, but in
DB2 , it return the rownumber, i must change to get the second element of array then it
return the correct data.
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:51 p.m.
New subject: [Hibernate-JIRA] Updated: (HHH-2176) DB2 setMaxResults problem in Hibernate 3.1.3
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2176?page=c...
]
Strong Liu updated HHH-2176:
----------------------------
Priority: Major (was: Blocker)
apparently this is not a block
DB2 setMaxResults problem in Hibernate 3.1.3
--------------------------------------------
Key: HHH-2176
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2176
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.1.3
Environment: DB2 any version
Hibernate 3.1.3
JDK 1.5
Reporter: Winter Lau
Assignee: Strong Liu
Attachments: HHH-2176.patch, HHH-2176_2.patch
public static List listHotTags(int count){
Session ssn = getSession();
String sql = "SELECT tag_name,COUNT(*) FROM dlog_tag GROUP BY tag_name ORDER
BY 2 DESC";
SQLQuery query = ssn.createSQLQuery(sql);
query.setMaxResults(count);
List tags = new ArrayList();
List results = query.list();
for(int i=0;results!=null && i
tags.add(((Object[])results.get(i))[0]);
}
return tags;
}
tags.add(((Object[])results.get(i))[0]); this code work fine in other database, but in
DB2 , it return the rownumber, i must change to get the second element of array then it
return the correct data.
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:44 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2176) DB2 setMaxResults problem in Hibernate 3.1.3
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2176?page=c...
]
Strong Liu commented on HHH-2176:
---------------------------------
would you please try the lastest 3.5.1 release and confirm if this issue still there?
DB2 setMaxResults problem in Hibernate 3.1.3
--------------------------------------------
Key: HHH-2176
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2176
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.1.3
Environment: DB2 any version
Hibernate 3.1.3
JDK 1.5
Reporter: Winter Lau
Assignee: Strong Liu
Attachments: HHH-2176.patch, HHH-2176_2.patch
public static List listHotTags(int count){
Session ssn = getSession();
String sql = "SELECT tag_name,COUNT(*) FROM dlog_tag GROUP BY tag_name ORDER
BY 2 DESC";
SQLQuery query = ssn.createSQLQuery(sql);
query.setMaxResults(count);
List tags = new ArrayList();
List results = query.list();
for(int i=0;results!=null && i
tags.add(((Object[])results.get(i))[0]);
}
return tags;
}
tags.add(((Object[])results.get(i))[0]); this code work fine in other database, but in
DB2 , it return the rownumber, i must change to get the second element of array then it
return the correct data.
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:55 a.m.
New subject: [Hibernate-JIRA] Resolved: (HHH-2176) DB2 setMaxResults problem in Hibernate 3.1.3
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2176?page=c...
]
Strong Liu resolved HHH-2176.
-----------------------------
Resolution: Fixed
Fix Version/s: 4.0.0.Beta1
patch applied, thanks
DB2 setMaxResults problem in Hibernate 3.1.3
--------------------------------------------
Key: HHH-2176
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2176
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.1.3
Environment: DB2 any version
Hibernate 3.1.3
JDK 1.5
Reporter: Winter Lau
Assignee: Strong Liu
Fix For: 4.0.0.Beta1
Attachments: HHH-2176.patch, HHH-2176_2.patch
public static List listHotTags(int count){
Session ssn = getSession();
String sql = "SELECT tag_name,COUNT(*) FROM dlog_tag GROUP BY tag_name ORDER
BY 2 DESC";
SQLQuery query = ssn.createSQLQuery(sql);
query.setMaxResults(count);
List tags = new ArrayList();
List results = query.list();
for(int i=0;results!=null && i
tags.add(((Object[])results.get(i))[0]);
}
return tags;
}
tags.add(((Object[])results.get(i))[0]); this code work fine in other database, but in
DB2 , it return the rownumber, i must change to get the second element of array then it
return the correct data.
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:49 p.m.
New subject: [Hibernate-JIRA] Reopened: (HHH-2176) DB2 setMaxResults problem in Hibernate 3.1.3
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2176?page=c...
]
Gail Badner reopened HHH-2176:
------------------------------
This should be backported to 3.6
DB2 setMaxResults problem in Hibernate 3.1.3
--------------------------------------------
Key: HHH-2176
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2176
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.1.3
Environment: DB2 any version
Hibernate 3.1.3
JDK 1.5
Reporter: Winter Lau
Assignee: Strong Liu
Fix For: 4.0.0.Beta1
Attachments: HHH-2176.patch, HHH-2176_2.patch
public static List listHotTags(int count){
Session ssn = getSession();
String sql = "SELECT tag_name,COUNT(*) FROM dlog_tag GROUP BY tag_name ORDER
BY 2 DESC";
SQLQuery query = ssn.createSQLQuery(sql);
query.setMaxResults(count);
List tags = new ArrayList();
List results = query.list();
for(int i=0;results!=null && i
tags.add(((Object[])results.get(i))[0]);
}
return tags;
}
tags.add(((Object[])results.get(i))[0]); this code work fine in other database, but in
DB2 , it return the rownumber, i must change to get the second element of array then it
return the correct data.
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:53 p.m.
New subject: [Hibernate-JIRA] Updated: (HHH-2176) DB2 setMaxResults problem in Hibernate 3.1.3
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2176?page=c...
]
Gail Badner updated HHH-2176:
-----------------------------
Fix Version/s: 3.6.5
DB2 setMaxResults problem in Hibernate 3.1.3
--------------------------------------------
Key: HHH-2176
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2176
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.1.3
Environment: DB2 any version
Hibernate 3.1.3
JDK 1.5
Reporter: Winter Lau
Assignee: Strong Liu
Fix For: 3.6.5, 4.0.0.Beta1
Attachments: HHH-2176.patch, HHH-2176_2.patch
public static List listHotTags(int count){
Session ssn = getSession();
String sql = "SELECT tag_name,COUNT(*) FROM dlog_tag GROUP BY tag_name ORDER
BY 2 DESC";
SQLQuery query = ssn.createSQLQuery(sql);
query.setMaxResults(count);
List tags = new ArrayList();
List results = query.list();
for(int i=0;results!=null && i
tags.add(((Object[])results.get(i))[0]);
}
return tags;
}
tags.add(((Object[])results.get(i))[0]); this code work fine in other database, but in
DB2 , it return the rownumber, i must change to get the second element of array then it
return the correct data.
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:42 p.m.
New subject: [Hibernate-JIRA] Updated: (HHH-2176) DB2 setMaxResults problem in Hibernate 3.1.3
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2176?page=c...
]
Gail Badner updated HHH-2176:
-----------------------------
Comment: was deleted
(was: This should be backported to 3.6)
DB2 setMaxResults problem in Hibernate 3.1.3
--------------------------------------------
Key: HHH-2176
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2176
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.1.3
Environment: DB2 any version
Hibernate 3.1.3
JDK 1.5
Reporter: Winter Lau
Assignee: Strong Liu
Fix For: 4.0.0.Beta1
Attachments: HHH-2176.patch, HHH-2176_2.patch
public static List listHotTags(int count){
Session ssn = getSession();
String sql = "SELECT tag_name,COUNT(*) FROM dlog_tag GROUP BY tag_name ORDER
BY 2 DESC";
SQLQuery query = ssn.createSQLQuery(sql);
query.setMaxResults(count);
List tags = new ArrayList();
List results = query.list();
for(int i=0;results!=null && i
tags.add(((Object[])results.get(i))[0]);
}
return tags;
}
tags.add(((Object[])results.get(i))[0]); this code work fine in other database, but in
DB2 , it return the rownumber, i must change to get the second element of array then it
return the correct data.
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:42 p.m.
New subject: [Hibernate-JIRA] Updated: (HHH-2176) DB2 setMaxResults problem in Hibernate 3.1.3
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2176?page=c...
]
Gail Badner updated HHH-2176:
-----------------------------
Fix Version/s: (was: 3.6.5)
DB2 setMaxResults problem in Hibernate 3.1.3
--------------------------------------------
Key: HHH-2176
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2176
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.1.3
Environment: DB2 any version
Hibernate 3.1.3
JDK 1.5
Reporter: Winter Lau
Assignee: Strong Liu
Fix For: 4.0.0.Beta1
Attachments: HHH-2176.patch, HHH-2176_2.patch
public static List listHotTags(int count){
Session ssn = getSession();
String sql = "SELECT tag_name,COUNT(*) FROM dlog_tag GROUP BY tag_name ORDER
BY 2 DESC";
SQLQuery query = ssn.createSQLQuery(sql);
query.setMaxResults(count);
List tags = new ArrayList();
List results = query.list();
for(int i=0;results!=null && i
tags.add(((Object[])results.get(i))[0]);
}
return tags;
}
tags.add(((Object[])results.get(i))[0]); this code work fine in other database, but in
DB2 , it return the rownumber, i must change to get the second element of array then it
return the correct data.
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:44 p.m.
New subject: [Hibernate-JIRA] Resolved: (HHH-2176) DB2 setMaxResults problem in Hibernate 3.1.3
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2176?page=c...
]
Gail Badner resolved HHH-2176.
------------------------------
Resolution: Fixed
DB2 setMaxResults problem in Hibernate 3.1.3
--------------------------------------------
Key: HHH-2176
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2176
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.1.3
Environment: DB2 any version
Hibernate 3.1.3
JDK 1.5
Reporter: Winter Lau
Assignee: Strong Liu
Fix For: 4.0.0.Beta1
Attachments: HHH-2176.patch, HHH-2176_2.patch
public static List listHotTags(int count){
Session ssn = getSession();
String sql = "SELECT tag_name,COUNT(*) FROM dlog_tag GROUP BY tag_name ORDER
BY 2 DESC";
SQLQuery query = ssn.createSQLQuery(sql);
query.setMaxResults(count);
List tags = new ArrayList();
List results = query.list();
for(int i=0;results!=null && i
tags.add(((Object[])results.get(i))[0]);
}
return tags;
}
tags.add(((Object[])results.get(i))[0]); this code work fine in other database, but in
DB2 , it return the rownumber, i must change to get the second element of array then it
return the correct data.
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4705
days inactive
6393
days old
hibernate-issues@lists.jboss.org
12 comments
4 participants
participants (4)
-
Gail Badner (JIRA) -
Milosz Tylenda (JIRA)
-
Strong Liu (JIRA)
-
Winter Lau (JIRA)