[SQL (Join) from Oracle dont run in tOracleInput]

Hi i have a prob with the following SQL:

" SELECT D.cid, D.DLayAusgabe, D.SeitNr, dlayressort,  dlayresslang,farbplan, D.Durchlaufseite, R.destid, to_char(D.cgd,'dd.mm.yyyy hh24:mi:ss') cgd, To_Char(D.ced,'dd.mm.yyyy:mi:ss') ced
FROM refs R, Dlayout D
WHERE
(
 R.srcid(+) = D.cid
 and
 R.srcattr(+) = 'LayoutMaster'
)
AND
D.cid IN
(
SELECT destid FROM refs WHERE srcid in
(
SELECT
  cid
FROM
  ddruckprodukt
WHERE
cid IN
  (SELECT destid FROM refs WHERE srcid IN
    (SELECT cid FROM dspiegel WHERE pperscham <= To_Date ('01.04.2010', 'DD.MM.YYYY') and pperscham >= To_Date ('01.01.2009', 'DD.MM.YYYY')))
AND
  PPAusgabe LIKE '1%'
AND
  PPAusgabe NOT IN ('112','122','123','125','126','142')
AND
   PPProduktTyp = 'hp'
)
)
ORDER BY DLayAusgabe "

 

At the normal console the Script will run with out Prob's. And in the JasperETL it will give me the following result:

" [statistics] connecting to socket on port 4320
[statistics] connected
Exception in component tOracleInput_1
java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
    at java.sql.Timestamp.valueOf(Unknown Source)
    at oracle.jdbc.driver.CharCommonAccessor.getTimestamp(CharCommonAccessor.java:486)
    at oracle.jdbc.driver.T4CVarcharAccessor.getTimestamp(T4CVarcharAccessor.java:897)
    at oracle.jdbc.driver.OracleResultSetImpl.getTimestamp(OracleResultSetImpl.java:1060)
    at blattplannung.ngtst_dbextraktion_blattplanung_inhalt_0_1.NGTST_DBExtraktion_Blattplanung_Inhalt.tOracleInput_1Process(NGTST_DBExtraktion_Blattplanung_Inhalt.java:1084)
    at blattplannung.ngtst_dbextraktion_blattplanung_inhalt_0_1.NGTST_DBExtraktion_Blattplanung_Inhalt.runJobInTOS(NGTST_DBExtraktion_Blattplanung_Inhalt.java:1894)
    at blattplannung.ngtst_dbextraktion_blattplanung_inhalt_0_1.NGTST_DBExtraktion_Blattplanung_Inhalt.main(NGTST_DBExtraktion_Blattplanung_Inhalt.java:1787)
[statistics] disconnected "

What is the Problem? The Join or the ...... ????

Many thanks for any idea's

regars Wolfgang