| [birt-dev] CheckIN:Fix bugzilla bug 175749 Incorrect query result -- date parameters getting truncated? |
|
Summary: CheckIN:Fix bugzilla bug 175749 Incorrect query result --
date parameters getting truncated? Bugzilla Entry(ies) Resolved: [175749] Incorrect query result -- date parameters getting
truncated? Description: The bug is caused by odaconsumer.PreparedStatement’s
setParameterValue() method’s truncating time part of a java.util.Date
type object to made a java.sql.Date type object. However the rule that BIRT
follow to convert BIRT type to SQL type after introduction of Date/Time data
types is that BIRT java.util.Date à SQL
java.sql.TimeStamp. So instead of convert a parameter of java.util.Date type to
java.sql.Date type, we should convert it to java.sql.Timestamp type. Tests Description: Manual Test. Notes to Build Team: None. Notes to Developers: None. Notes to QA: None. Notes to Documentation: None. Files Edited: "/org.eclipse.birt.data/src/org/eclipse/birt/data/engine/odaconsumer/PreparedStatement.java" Files Added: Files Deleted:
|