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
