Which version run on jdk1.4 and oracle 8i

[jiechu]

Hi

I have a question for the version of oracle 8i. If I create a new report in IReport and oracle 8i, such as with the sql is "select
(case when $P{InputDate}=to_date('01/01/1970', 'mm/dd/yyyy')  then X.birthday else $P{InputDate} end) as trueBirthday
from (select birthday from A) X".

It will display "ORA-00932: inconsistent datatypes" and "at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)... " 

The enviroment is iReport 2.0.2, oracle client 10.2.0. In oracle, the column is Date type and in iReport the field is java.util.Date.

If the oracle is 9i or 10g, it works fine.

Does anybody know why it cannot work on oracle 8i and how to resolve it?

Many thanks.

[ggalang]

its probably the version of the jdbc driver your using, oracle 8 should be shipped with a classes12.jar try that and remove the ojdbc.jar from your classpath.

[jiechu]

I have resolved it.

in oracle , add trunc function for each $P{java.util.Date} if you only want Date not timestamp.

 

Code:

trunc($P{java.util.Date}).