We have a project using TopLink 10.1.3 with WAS 6.0 and Oracle 9i. The project is experiencing the following exception. Could someone provide an insight on what could cause the error? We greatly appreciate your help.
[7/20/07 10:00:32:718 EDT] 00000023 SystemOut O [TopLink Finer]: 2007.07.20 10:00:32.718--ServerSession(120755866)--client acquired
[7/20/07 10:00:32:718 EDT] 00000023 SystemOut O [TopLink Finest]: 2007.07.20 10:00:32.718--ClientSession(1697994439)--Execute query ReadAllQuery(com.ford.gpd.plm.fos.bo.RepSolvedRules)
[7/20/07 10:00:32:718 EDT] 00000023 SystemOut O [TopLink Finest]: 2007.07.20 10:00:32.718--ServerSession(120755866)--reconnecting to external connection pool
[7/20/07 10:00:32:718 EDT] 00000023 SystemOut O [TopLink Fine]: 2007.07.20 10:00:32.718--ServerSession(120755866)--Connection(2023118535)--select a.fos005_ftr_C, a.fos007_rule_d, a.fos011_column_d, a.fos001_option_c, a.fos009_report_k, a.FOS002_PROD_TYPE_C, a.FOS002_VEH_LINE_C, a.FOS002_MODEL_YEAR_R
from FFOSV01_REP_OPT_SOLVE_RULE_VW a, FFOS020_REP_SOLVE_QUALIFIER b
where a.fos009_report_k = 3
and a.fos011_column_d in (3, 4, 5, 8, 9, 14)
and UPPER(b.fos005_qualifier_ftr_c) like UPPER('a3%')
and a.fos009_report_k = b.fos009_report_k
and a.fos013_group_d = b.fos013_group_d
and a.fos011_column_d = b.fos011_column_d
and a.fos007_rule_d = b.fos007_rule_d
--and a.fos013_report_date_s = b.fos013_report_date_s
order by a.fos005_ftr_C, a.fos011_column_d, DECODE(a.fos001_option_c, 'S', 1, 'L', 2, 'M', 3, 'O', 4, 'P', 5, 'I', 6, 'A', 7)
[7/20/07 10:00:32:749 EDT] 00000023 SystemOut O [TopLink Warning]: 2007.07.20 10:00:32.749--ClientSession(1697994439)--java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss.fffffffff
at java.sql.Timestamp.valueOf(Timestamp.java:304)
at oracle.jdbc.driver.OracleStatement.getTimestampValue(OracleStatement.java(Compiled Code))
at oracle.jdbc.driver.OracleResultSetImpl.getTimestamp(OracleResultSetImpl.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.getTimestamp(WSJdbcResultSet.java(Compiled Code))
at oracle.toplink.oraclespecific.Oracle9Platform.getObjectFromResultSet(Oracle9Platform.java(Compiled Code))
at oracle.toplink.internal.databaseaccess.DatabaseAccessor.getObject(DatabaseAccessor.java(Compiled Code))
at oracle.toplink.internal.databaseaccess.DatabaseAccessor.fetchRow(DatabaseAccessor.java(Compiled Code))
at oracle.toplink.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java(Compiled Code))
at oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:442)
at oracle.toplink.threetier.ServerSession.executeCall(ServerSession.java:453)
at oracle.toplink.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:117)
at oracle.toplink.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:103)
at oracle.toplink.internal.queryframework.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:174)
at oracle.toplink.internal.queryframework.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:481)
at oracle.toplink.queryframework.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:458)
at oracle.toplink.queryframework.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:800)
at oracle.toplink.queryframework.DatabaseQuery.execute(DatabaseQuery.java:603)
at oracle.toplink.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:768)
at oracle.toplink.queryframework.ReadAllQuery.execute(ReadAllQuery.java:436)
at oracle.toplink.publicinterface.Session.internalExecuteQuery(Session.java:2062)
at oracle.toplink.publicinterface.Session.executeQuery(Session.java:981)
at oracle.toplink.publicinterface.Session.executeQuery(Session.java:953)
at com.ford.it.persistence.impl.toplink.AbstractQueryStrategy.execute(AbstractQueryStrategy.java:324)
at com.ford.it.persistence.impl.toplink.QueryImpl.execute(QueryImpl.java:138)
FFOSV01_REP_OPT_SOLVE_RULE_VW is a VIEW and the reference b FFOS020_REP_SOLVE_QUALIFIER is a table with a to b as one-to-many mapping. View has a reportDate filed as DATE and the same with the b table. Java side descriptors are using the java.sql.Timestamp.
The problem is when joining the View with the Table(like in the above SQL), the Exception occurs. If we run a select from the View then we don't see this exception.
-- Haiwei