7:27 a.m.
SELECT COUNT(*) fails on Linux but not on Windows XP
----------------------------------------------------
Key: HHH-2945
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2945
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.5
Environment: Windows XP/Redhat Linux
Reporter: Thom Hehl
While working with an Informix database hosting on Linux, I tested my web application
running on my windows XP workstation with the following query genereated by hibernate:
(From P6 spy)
select count(*) as col_0_0_ from POOL poolinfo0_ where poolinfo0_.DEF_DATE='2008-02-11
00:00:00.0' and poolinfo0_.DIVISION_CODE='3'
When I run this against my database, it returns the proper number every single time.
I moved my web application to our Redhat Linux environment (platform for client) and ran
the application and this same query against the same database returns 0 every single
time.
When I run the same query from SQuirreL on the Redhat Linux box using the same JDBC driver
as the webapp uses, it returns the proper values. To me, this points to hibernate as the
issue.
Here is the debugs:
64854 DEBUG org.hibernate.jdbc.AbstractBatcher | preparing statement
64856 DEBUG org.hibernate.type.CalendarType | binding '2008-02-11 00:00:00' to
parameter: 1
64856 DEBUG org.hibernate.type.StringType | binding '3' to parameter: 2
64899 DEBUG org.hibernate.jdbc.AbstractBatcher | about to open ResultSet (open ResultSets:
0, globally: 0)
64899 DEBUG org.hibernate.loader.Loader | processing result set
64899 DEBUG org.hibernate.loader.Loader | result set row: 0
64899 DEBUG org.hibernate.loader.Loader | result row:
64899 DEBUG org.hibernate.type.LongType | returning '0' as column: col_0_0_
64899 DEBUG org.hibernate.loader.Loader | done processing result set (1 rows)
64899 DEBUG org.hibernate.jdbc.AbstractBatcher | about to close ResultSet (open
ResultSets: 1, globally: 1)
64899 DEBUG org.hibernate.jdbc.AbstractBatcher | about to close PreparedStatement (open
PreparedStatements: 1, globally: 1)
Thanks.
--
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:43 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2945) SELECT COUNT(*) fails on Linux but not on Windows XP
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2945?page=c...
]
Max Rydahl Andersen commented on HHH-2945:
------------------------------------------
eh you show zero hibernate related code or test case in here...
SELECT COUNT(*) fails on Linux but not on Windows XP
----------------------------------------------------
Key: HHH-2945
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2945
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.5
Environment: Windows XP/Redhat Linux
Reporter: Thom Hehl
While working with an Informix database hosting on Linux, I tested my web application
running on my windows XP workstation with the following query genereated by hibernate:
(From P6 spy)
select count(*) as col_0_0_ from POOL poolinfo0_ where
poolinfo0_.DEF_DATE='2008-02-11 00:00:00.0' and
poolinfo0_.DIVISION_CODE='3'
When I run this against my database, it returns the proper number every single time.
I moved my web application to our Redhat Linux environment (platform for client) and ran
the application and this same query against the same database returns 0 every single
time.
When I run the same query from SQuirreL on the Redhat Linux box using the same JDBC
driver as the webapp uses, it returns the proper values. To me, this points to hibernate
as the issue.
Here is the debugs:
64854 DEBUG org.hibernate.jdbc.AbstractBatcher | preparing statement
64856 DEBUG org.hibernate.type.CalendarType | binding '2008-02-11 00:00:00' to
parameter: 1
64856 DEBUG org.hibernate.type.StringType | binding '3' to parameter: 2
64899 DEBUG org.hibernate.jdbc.AbstractBatcher | about to open ResultSet (open
ResultSets: 0, globally: 0)
64899 DEBUG org.hibernate.loader.Loader | processing result set
64899 DEBUG org.hibernate.loader.Loader | result set row: 0
64899 DEBUG org.hibernate.loader.Loader | result row:
64899 DEBUG org.hibernate.type.LongType | returning '0' as column: col_0_0_
64899 DEBUG org.hibernate.loader.Loader | done processing result set (1 rows)
64899 DEBUG org.hibernate.jdbc.AbstractBatcher | about to close ResultSet (open
ResultSets: 1, globally: 1)
64899 DEBUG org.hibernate.jdbc.AbstractBatcher | about to close PreparedStatement (open
PreparedStatements: 1, globally: 1)
Thanks.
--
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:41 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2945) SELECT COUNT(*) fails on Linux but not on Windows XP
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2945?page=c...
]
Thom Hehl commented on HHH-2945:
--------------------------------
Here is the source causing the issue. As you can see, I'm running this through the
Spring 2.0.7 templates.
public long countByDeferDateAndDivision(Calendar deferDate, String division) {
long result;
try {
Query query = getSession().createQuery(
"SELECT count(*) FROM PoolInfo p WHERE p.dateDeferred=? AND
p.divisionCode=?");
query.setCalendar(0, deferDate);
query.setString(1, division);
result = (Long)query.uniqueResult();
}
catch (HibernateException ex) {
throw convertHibernateAccessException(ex);
}
return result;
}
SELECT COUNT(*) fails on Linux but not on Windows XP
----------------------------------------------------
Key: HHH-2945
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2945
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.5
Environment: Windows XP/Redhat Linux
Reporter: Thom Hehl
While working with an Informix database hosting on Linux, I tested my web application
running on my windows XP workstation with the following query genereated by hibernate:
(From P6 spy)
select count(*) as col_0_0_ from POOL poolinfo0_ where
poolinfo0_.DEF_DATE='2008-02-11 00:00:00.0' and
poolinfo0_.DIVISION_CODE='3'
When I run this against my database, it returns the proper number every single time.
I moved my web application to our Redhat Linux environment (platform for client) and ran
the application and this same query against the same database returns 0 every single
time.
When I run the same query from SQuirreL on the Redhat Linux box using the same JDBC
driver as the webapp uses, it returns the proper values. To me, this points to hibernate
as the issue.
Here is the debugs:
64854 DEBUG org.hibernate.jdbc.AbstractBatcher | preparing statement
64856 DEBUG org.hibernate.type.CalendarType | binding '2008-02-11 00:00:00' to
parameter: 1
64856 DEBUG org.hibernate.type.StringType | binding '3' to parameter: 2
64899 DEBUG org.hibernate.jdbc.AbstractBatcher | about to open ResultSet (open
ResultSets: 0, globally: 0)
64899 DEBUG org.hibernate.loader.Loader | processing result set
64899 DEBUG org.hibernate.loader.Loader | result set row: 0
64899 DEBUG org.hibernate.loader.Loader | result row:
64899 DEBUG org.hibernate.type.LongType | returning '0' as column: col_0_0_
64899 DEBUG org.hibernate.loader.Loader | done processing result set (1 rows)
64899 DEBUG org.hibernate.jdbc.AbstractBatcher | about to close ResultSet (open
ResultSets: 1, globally: 1)
64899 DEBUG org.hibernate.jdbc.AbstractBatcher | about to close PreparedStatement (open
PreparedStatements: 1, globally: 1)
Thanks.
--
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
9:51 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2945) SELECT COUNT(*) fails on Linux but not on Windows XP
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2945?page=c...
]
Max Rydahl Andersen commented on HHH-2945:
------------------------------------------
your debug output shows that 1 row is processed and returned...so what is the issue again
?
I'm sorry - but you haven't shown anything that points to any hibernate issue
here.
SELECT COUNT(*) fails on Linux but not on Windows XP
----------------------------------------------------
Key: HHH-2945
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2945
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.5
Environment: Windows XP/Redhat Linux
Reporter: Thom Hehl
While working with an Informix database hosting on Linux, I tested my web application
running on my windows XP workstation with the following query genereated by hibernate:
(From P6 spy)
select count(*) as col_0_0_ from POOL poolinfo0_ where
poolinfo0_.DEF_DATE='2008-02-11 00:00:00.0' and
poolinfo0_.DIVISION_CODE='3'
When I run this against my database, it returns the proper number every single time.
I moved my web application to our Redhat Linux environment (platform for client) and ran
the application and this same query against the same database returns 0 every single
time.
When I run the same query from SQuirreL on the Redhat Linux box using the same JDBC
driver as the webapp uses, it returns the proper values. To me, this points to hibernate
as the issue.
Here is the debugs:
64854 DEBUG org.hibernate.jdbc.AbstractBatcher | preparing statement
64856 DEBUG org.hibernate.type.CalendarType | binding '2008-02-11 00:00:00' to
parameter: 1
64856 DEBUG org.hibernate.type.StringType | binding '3' to parameter: 2
64899 DEBUG org.hibernate.jdbc.AbstractBatcher | about to open ResultSet (open
ResultSets: 0, globally: 0)
64899 DEBUG org.hibernate.loader.Loader | processing result set
64899 DEBUG org.hibernate.loader.Loader | result set row: 0
64899 DEBUG org.hibernate.loader.Loader | result row:
64899 DEBUG org.hibernate.type.LongType | returning '0' as column: col_0_0_
64899 DEBUG org.hibernate.loader.Loader | done processing result set (1 rows)
64899 DEBUG org.hibernate.jdbc.AbstractBatcher | about to close ResultSet (open
ResultSets: 1, globally: 1)
64899 DEBUG org.hibernate.jdbc.AbstractBatcher | about to close PreparedStatement (open
PreparedStatements: 1, globally: 1)
Thanks.
--
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
10:21 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2945) SELECT COUNT(*) fails on Linux but not on Windows XP
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2945?page=c...
]
Thom Hehl commented on HHH-2945:
--------------------------------
Not just one row, it returns 0. The issue is that the same code on the same database
returns 15 when I run tomcat on Windows XP and 0 when I run tomcat on Redhat Linux. 15 is
the right answer and is returned by EVERYTHING I can think of.
BECAUSE hibernate appears to be getting the info back, but is reporting 0 instead of 15, I
believe it to be a hibernate issue.
SELECT COUNT(*) fails on Linux but not on Windows XP
----------------------------------------------------
Key: HHH-2945
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2945
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.5
Environment: Windows XP/Redhat Linux
Reporter: Thom Hehl
While working with an Informix database hosting on Linux, I tested my web application
running on my windows XP workstation with the following query genereated by hibernate:
(From P6 spy)
select count(*) as col_0_0_ from POOL poolinfo0_ where
poolinfo0_.DEF_DATE='2008-02-11 00:00:00.0' and
poolinfo0_.DIVISION_CODE='3'
When I run this against my database, it returns the proper number every single time.
I moved my web application to our Redhat Linux environment (platform for client) and ran
the application and this same query against the same database returns 0 every single
time.
When I run the same query from SQuirreL on the Redhat Linux box using the same JDBC
driver as the webapp uses, it returns the proper values. To me, this points to hibernate
as the issue.
Here is the debugs:
64854 DEBUG org.hibernate.jdbc.AbstractBatcher | preparing statement
64856 DEBUG org.hibernate.type.CalendarType | binding '2008-02-11 00:00:00' to
parameter: 1
64856 DEBUG org.hibernate.type.StringType | binding '3' to parameter: 2
64899 DEBUG org.hibernate.jdbc.AbstractBatcher | about to open ResultSet (open
ResultSets: 0, globally: 0)
64899 DEBUG org.hibernate.loader.Loader | processing result set
64899 DEBUG org.hibernate.loader.Loader | result set row: 0
64899 DEBUG org.hibernate.loader.Loader | result row:
64899 DEBUG org.hibernate.type.LongType | returning '0' as column: col_0_0_
64899 DEBUG org.hibernate.loader.Loader | done processing result set (1 rows)
64899 DEBUG org.hibernate.jdbc.AbstractBatcher | about to close ResultSet (open
ResultSets: 1, globally: 1)
64899 DEBUG org.hibernate.jdbc.AbstractBatcher | about to close PreparedStatement (open
PreparedStatements: 1, globally: 1)
Thanks.
--
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
10:45 a.m.
New subject: [Hibernate-JIRA] Resolved: (HHH-2945) SELECT COUNT(*) fails on Linux but not on Windows XP
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2945?page=c...
]
Max Rydahl Andersen resolved HHH-2945.
--------------------------------------
Resolution: Cannot Reproduce
..and you did not consider it to be a driver or db issue or something else more OS
specific ?
You haven't proved anything being wrong at the level of hibernate nor given a
reproducible test case - please come back when you can.
SELECT COUNT(*) fails on Linux but not on Windows XP
----------------------------------------------------
Key: HHH-2945
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2945
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.5
Environment: Windows XP/Redhat Linux
Reporter: Thom Hehl
While working with an Informix database hosting on Linux, I tested my web application
running on my windows XP workstation with the following query genereated by hibernate:
(From P6 spy)
select count(*) as col_0_0_ from POOL poolinfo0_ where
poolinfo0_.DEF_DATE='2008-02-11 00:00:00.0' and
poolinfo0_.DIVISION_CODE='3'
When I run this against my database, it returns the proper number every single time.
I moved my web application to our Redhat Linux environment (platform for client) and ran
the application and this same query against the same database returns 0 every single
time.
When I run the same query from SQuirreL on the Redhat Linux box using the same JDBC
driver as the webapp uses, it returns the proper values. To me, this points to hibernate
as the issue.
Here is the debugs:
64854 DEBUG org.hibernate.jdbc.AbstractBatcher | preparing statement
64856 DEBUG org.hibernate.type.CalendarType | binding '2008-02-11 00:00:00' to
parameter: 1
64856 DEBUG org.hibernate.type.StringType | binding '3' to parameter: 2
64899 DEBUG org.hibernate.jdbc.AbstractBatcher | about to open ResultSet (open
ResultSets: 0, globally: 0)
64899 DEBUG org.hibernate.loader.Loader | processing result set
64899 DEBUG org.hibernate.loader.Loader | result set row: 0
64899 DEBUG org.hibernate.loader.Loader | result row:
64899 DEBUG org.hibernate.type.LongType | returning '0' as column: col_0_0_
64899 DEBUG org.hibernate.loader.Loader | done processing result set (1 rows)
64899 DEBUG org.hibernate.jdbc.AbstractBatcher | about to close ResultSet (open
ResultSets: 1, globally: 1)
64899 DEBUG org.hibernate.jdbc.AbstractBatcher | about to close PreparedStatement (open
PreparedStatements: 1, globally: 1)
Thanks.
--
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
10:51 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2945) SELECT COUNT(*) fails on Linux but not on Windows XP
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2945?page=c...
]
Thom Hehl commented on HHH-2945:
--------------------------------
I did consider those. That is why I went to the Redhat Linux system and ran SQuirelL with
the same query, the same JDBC driver and the same JDBC connection string and the same java
runtime environment. This returned the correct results. To me, this, along with the way
the information is reported in the debug information, leads me to believe that this is a
hibernate issue.
I have provided source code. What do I need to give you to have a reproducible test case
seeing that you do not have my database?
SELECT COUNT(*) fails on Linux but not on Windows XP
----------------------------------------------------
Key: HHH-2945
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2945
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.5
Environment: Windows XP/Redhat Linux
Reporter: Thom Hehl
While working with an Informix database hosting on Linux, I tested my web application
running on my windows XP workstation with the following query genereated by hibernate:
(From P6 spy)
select count(*) as col_0_0_ from POOL poolinfo0_ where
poolinfo0_.DEF_DATE='2008-02-11 00:00:00.0' and
poolinfo0_.DIVISION_CODE='3'
When I run this against my database, it returns the proper number every single time.
I moved my web application to our Redhat Linux environment (platform for client) and ran
the application and this same query against the same database returns 0 every single
time.
When I run the same query from SQuirreL on the Redhat Linux box using the same JDBC
driver as the webapp uses, it returns the proper values. To me, this points to hibernate
as the issue.
Here is the debugs:
64854 DEBUG org.hibernate.jdbc.AbstractBatcher | preparing statement
64856 DEBUG org.hibernate.type.CalendarType | binding '2008-02-11 00:00:00' to
parameter: 1
64856 DEBUG org.hibernate.type.StringType | binding '3' to parameter: 2
64899 DEBUG org.hibernate.jdbc.AbstractBatcher | about to open ResultSet (open
ResultSets: 0, globally: 0)
64899 DEBUG org.hibernate.loader.Loader | processing result set
64899 DEBUG org.hibernate.loader.Loader | result set row: 0
64899 DEBUG org.hibernate.loader.Loader | result row:
64899 DEBUG org.hibernate.type.LongType | returning '0' as column: col_0_0_
64899 DEBUG org.hibernate.loader.Loader | done processing result set (1 rows)
64899 DEBUG org.hibernate.jdbc.AbstractBatcher | about to close ResultSet (open
ResultSets: 1, globally: 1)
64899 DEBUG org.hibernate.jdbc.AbstractBatcher | about to close PreparedStatement (open
PreparedStatements: 1, globally: 1)
Thanks.
--
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:44 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2945) SELECT COUNT(*) fails on Linux but not on Windows XP
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2945?page=c...
]
Max Rydahl Andersen commented on HHH-2945:
------------------------------------------
Running sql via squirell means (at least it did some time back) to run with non-prepared
statement and it thus dependent on the driver a very different result.
Your result shows it process 1 row and nothing else ... and you did not provide any test
case besides what is already executed in our unittests and these are not OS specific.
SELECT COUNT(*) fails on Linux but not on Windows XP
----------------------------------------------------
Key: HHH-2945
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2945
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.5
Environment: Windows XP/Redhat Linux
Reporter: Thom Hehl
While working with an Informix database hosting on Linux, I tested my web application
running on my windows XP workstation with the following query genereated by hibernate:
(From P6 spy)
select count(*) as col_0_0_ from POOL poolinfo0_ where
poolinfo0_.DEF_DATE='2008-02-11 00:00:00.0' and
poolinfo0_.DIVISION_CODE='3'
When I run this against my database, it returns the proper number every single time.
I moved my web application to our Redhat Linux environment (platform for client) and ran
the application and this same query against the same database returns 0 every single
time.
When I run the same query from SQuirreL on the Redhat Linux box using the same JDBC
driver as the webapp uses, it returns the proper values. To me, this points to hibernate
as the issue.
Here is the debugs:
64854 DEBUG org.hibernate.jdbc.AbstractBatcher | preparing statement
64856 DEBUG org.hibernate.type.CalendarType | binding '2008-02-11 00:00:00' to
parameter: 1
64856 DEBUG org.hibernate.type.StringType | binding '3' to parameter: 2
64899 DEBUG org.hibernate.jdbc.AbstractBatcher | about to open ResultSet (open
ResultSets: 0, globally: 0)
64899 DEBUG org.hibernate.loader.Loader | processing result set
64899 DEBUG org.hibernate.loader.Loader | result set row: 0
64899 DEBUG org.hibernate.loader.Loader | result row:
64899 DEBUG org.hibernate.type.LongType | returning '0' as column: col_0_0_
64899 DEBUG org.hibernate.loader.Loader | done processing result set (1 rows)
64899 DEBUG org.hibernate.jdbc.AbstractBatcher | about to close ResultSet (open
ResultSets: 1, globally: 1)
64899 DEBUG org.hibernate.jdbc.AbstractBatcher | about to close PreparedStatement (open
PreparedStatements: 1, globally: 1)
Thanks.
--
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:23 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2945) SELECT COUNT(*) fails on Linux but not on Windows XP
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2945?page=c...
]
Thom Hehl commented on HHH-2945:
--------------------------------
What would you like to see in the way of a test case to reproduce this issue.
SELECT COUNT(*) fails on Linux but not on Windows XP
----------------------------------------------------
Key: HHH-2945
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2945
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.5
Environment: Windows XP/Redhat Linux
Reporter: Thom Hehl
While working with an Informix database hosting on Linux, I tested my web application
running on my windows XP workstation with the following query genereated by hibernate:
(From P6 spy)
select count(*) as col_0_0_ from POOL poolinfo0_ where
poolinfo0_.DEF_DATE='2008-02-11 00:00:00.0' and
poolinfo0_.DIVISION_CODE='3'
When I run this against my database, it returns the proper number every single time.
I moved my web application to our Redhat Linux environment (platform for client) and ran
the application and this same query against the same database returns 0 every single
time.
When I run the same query from SQuirreL on the Redhat Linux box using the same JDBC
driver as the webapp uses, it returns the proper values. To me, this points to hibernate
as the issue.
Here is the debugs:
64854 DEBUG org.hibernate.jdbc.AbstractBatcher | preparing statement
64856 DEBUG org.hibernate.type.CalendarType | binding '2008-02-11 00:00:00' to
parameter: 1
64856 DEBUG org.hibernate.type.StringType | binding '3' to parameter: 2
64899 DEBUG org.hibernate.jdbc.AbstractBatcher | about to open ResultSet (open
ResultSets: 0, globally: 0)
64899 DEBUG org.hibernate.loader.Loader | processing result set
64899 DEBUG org.hibernate.loader.Loader | result set row: 0
64899 DEBUG org.hibernate.loader.Loader | result row:
64899 DEBUG org.hibernate.type.LongType | returning '0' as column: col_0_0_
64899 DEBUG org.hibernate.loader.Loader | done processing result set (1 rows)
64899 DEBUG org.hibernate.jdbc.AbstractBatcher | about to close ResultSet (open
ResultSets: 1, globally: 1)
64899 DEBUG org.hibernate.jdbc.AbstractBatcher | about to close PreparedStatement (open
PreparedStatements: 1, globally: 1)
Thanks.
--
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:30 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2945) SELECT COUNT(*) fails on Linux but not on Windows XP
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2945?page=c...
]
Max Rydahl Andersen commented on HHH-2945:
------------------------------------------
A standalone test that creates the data you can't retreive again.
SELECT COUNT(*) fails on Linux but not on Windows XP
----------------------------------------------------
Key: HHH-2945
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2945
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.5
Environment: Windows XP/Redhat Linux
Reporter: Thom Hehl
While working with an Informix database hosting on Linux, I tested my web application
running on my windows XP workstation with the following query genereated by hibernate:
(From P6 spy)
select count(*) as col_0_0_ from POOL poolinfo0_ where
poolinfo0_.DEF_DATE='2008-02-11 00:00:00.0' and
poolinfo0_.DIVISION_CODE='3'
When I run this against my database, it returns the proper number every single time.
I moved my web application to our Redhat Linux environment (platform for client) and ran
the application and this same query against the same database returns 0 every single
time.
When I run the same query from SQuirreL on the Redhat Linux box using the same JDBC
driver as the webapp uses, it returns the proper values. To me, this points to hibernate
as the issue.
Here is the debugs:
64854 DEBUG org.hibernate.jdbc.AbstractBatcher | preparing statement
64856 DEBUG org.hibernate.type.CalendarType | binding '2008-02-11 00:00:00' to
parameter: 1
64856 DEBUG org.hibernate.type.StringType | binding '3' to parameter: 2
64899 DEBUG org.hibernate.jdbc.AbstractBatcher | about to open ResultSet (open
ResultSets: 0, globally: 0)
64899 DEBUG org.hibernate.loader.Loader | processing result set
64899 DEBUG org.hibernate.loader.Loader | result set row: 0
64899 DEBUG org.hibernate.loader.Loader | result row:
64899 DEBUG org.hibernate.type.LongType | returning '0' as column: col_0_0_
64899 DEBUG org.hibernate.loader.Loader | done processing result set (1 rows)
64899 DEBUG org.hibernate.jdbc.AbstractBatcher | about to close ResultSet (open
ResultSets: 1, globally: 1)
64899 DEBUG org.hibernate.jdbc.AbstractBatcher | about to close PreparedStatement (open
PreparedStatements: 1, globally: 1)
Thanks.
--
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:32 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2945) SELECT COUNT(*) fails on Linux but not on Windows XP
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2945?page=c...
]
Max Rydahl Andersen commented on HHH-2945:
------------------------------------------
...but actually that probably won't let me reproduce it since i have no informix nor
drivers that could be used to test this with so you are actually best suited to trace
through it you self and provide the patch for the bug you belive there are in hibernate.
SELECT COUNT(*) fails on Linux but not on Windows XP
----------------------------------------------------
Key: HHH-2945
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2945
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.5
Environment: Windows XP/Redhat Linux
Reporter: Thom Hehl
While working with an Informix database hosting on Linux, I tested my web application
running on my windows XP workstation with the following query genereated by hibernate:
(From P6 spy)
select count(*) as col_0_0_ from POOL poolinfo0_ where
poolinfo0_.DEF_DATE='2008-02-11 00:00:00.0' and
poolinfo0_.DIVISION_CODE='3'
When I run this against my database, it returns the proper number every single time.
I moved my web application to our Redhat Linux environment (platform for client) and ran
the application and this same query against the same database returns 0 every single
time.
When I run the same query from SQuirreL on the Redhat Linux box using the same JDBC
driver as the webapp uses, it returns the proper values. To me, this points to hibernate
as the issue.
Here is the debugs:
64854 DEBUG org.hibernate.jdbc.AbstractBatcher | preparing statement
64856 DEBUG org.hibernate.type.CalendarType | binding '2008-02-11 00:00:00' to
parameter: 1
64856 DEBUG org.hibernate.type.StringType | binding '3' to parameter: 2
64899 DEBUG org.hibernate.jdbc.AbstractBatcher | about to open ResultSet (open
ResultSets: 0, globally: 0)
64899 DEBUG org.hibernate.loader.Loader | processing result set
64899 DEBUG org.hibernate.loader.Loader | result set row: 0
64899 DEBUG org.hibernate.loader.Loader | result row:
64899 DEBUG org.hibernate.type.LongType | returning '0' as column: col_0_0_
64899 DEBUG org.hibernate.loader.Loader | done processing result set (1 rows)
64899 DEBUG org.hibernate.jdbc.AbstractBatcher | about to close ResultSet (open
ResultSets: 1, globally: 1)
64899 DEBUG org.hibernate.jdbc.AbstractBatcher | about to close PreparedStatement (open
PreparedStatements: 1, globally: 1)
Thanks.
--
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
6253
days inactive
6254
days old
hibernate-issues@lists.jboss.org
10 comments
2 participants
participants (2)
-
Max Rydahl Andersen (JIRA) -
Thom Hehl (JIRA)