[#EHO-67] Not compatible with MySQL 5.1 connector - eHour JIRA

5.1 connector gives a
Caused by: java.sql.SQLException: Column 'ENTRY_DATE' not found.

Ascending order - Click to sort in descending order

Hide

Permalink

Thies Edeling added a comment - 18/Jan/08 10:05 PM

Show

Thies Edeling added a comment - 18/Jan/08 10:05 PM related to http://issues.apache.org/bugzilla/show_bug.cgi?id=43831

Hide

Permalink

Thies Edeling added a comment - 14/Dec/09 4:32 PM

upgrade from etch to lenny (ie libmysql-java 5.04 to 5.1.6)
ehour was failing the detailed reports ([2009.12.01.14:52:17] 12-01@14:52:17 INFO org.hibernate.type.DateType - could not read column value from result set: ENTRY_DATE; Column 'ENTRY_DATE' not found.)
upgraded from ehour 8.1 to 8.4, the problem was still here.
http://www.ehour.nl/forum/index.php/topic,203.0.html

I'm with tomcat 5.5, debian lenny, java 6, and i had to downgrade to an old libmysql-java to make it work. (5.0.4)

the weird thing is that the bug (http://dev.ehour.nl/jira/browse/EHO-67
https://issues.apache.org/bugzilla/show_bug.cgi?id=43831
http://bugs.mysql.com/bug.php?id=31406
http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html)

is resolved, on the mysql/apache side. (2007.12 AFAIK)

there could be a need to change the java ehour code to set useOldAliasMetadataBehavior to true when connecting.
maybe the ~~EHO-67~~ is still valid.

Show

Thies Edeling added a comment - 14/Dec/09 4:32 PM upgrade from etch to lenny (ie libmysql-java 5.04 to 5.1.6) ehour was failing the detailed reports ([2009.12.01.14:52:17] 12-01@14:52:17 INFO org.hibernate.type.DateType - could not read column value from result set: ENTRY_DATE; Column 'ENTRY_DATE' not found.) upgraded from ehour 8.1 to 8.4, the problem was still here. http://www.ehour.nl/forum/index.php/topic,203.0.html I'm with tomcat 5.5, debian lenny, java 6, and i had to downgrade to an old libmysql-java to make it work. (5.0.4) the weird thing is that the bug (http://dev.ehour.nl/jira/browse/EHO-67 https://issues.apache.org/bugzilla/show_bug.cgi?id=43831 http://bugs.mysql.com/bug.php?id=31406 http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html) is resolved, on the mysql/apache side. (2007.12 AFAIK) there could be a need to change the java ehour code to set useOldAliasMetadataBehavior to true when connecting. maybe the ~~EHO-67~~ is still valid.

Vote (0)

Watch (0)