[BEANUTILS-142] RowSetDynaClass fails to copy ResultSet to DynaBean with Oracle 10g JDBC driver

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.7.0
• Fix Version/s: 1.8.0
• Component/s: DynaBean

Environment

Operating System: Windows XP
Platform: All

• Bugzilla Id: 39343
• Assignee: Henri Yandell
• Reporter: Li Zhang
• Created: 19/Apr/06 05:43
• Updated: 25/Mar/08 08:08
• Resolved: 14/Jul/07 06:38

Description

Beginning in Oracle 9.2, DATE is mapped to Date and TIMESTAMP is mapped to
Timestamp. However if you were relying on DATE values to contain time
information, there is a problem. When using Oracle 10g JDBC driver, the
ResultSetMetaData.getColumnClassName returns java.sql.Timestamp but
ResultSet.getObject(name).getClass() returns java.sql.Date. Obviously these two
do not match each other. When the RowSetDynaClass.copy function tries to set the
value to BasicDynaBean, it throws exception. Need a workaround.