Hi,
I'm running into a weird problem. My DataDeploy works fine when I insert/update records. It even works fine for deletes when some of the replicant fields are deleted from the DCR. But when the whole DCR is deleted, it fails. The log shows that the "Date" string from the DCR could not be converted into Oracle's "Date" type.
Snippets of the log:
The Error:
DBD: SelectCurrentRows
ELECT TO_CHAR(end_date,'yyyy-MM-dd') AS end_date,URI,station_code,TO_CHAR(begin_date,'yyyy-MM-dd') AS b
egin_date,TO_CHAR(open_date,'yyyy-MM-dd') AS open_date FROM Flight_Schedule WHERE station_code IN (? ) AND begin_date IN (? )
AND open_date IN (? ) ORDER BY station_code,begin_date,open_date
DBD: Index: 1, value: MCI
DBD: Index: 2, value: 2010-06-20 00:00:00.0
DBD: Index: 3, value: 2010-06-15 00:00:00.0
DBD: SelectCurrentRows: 1 rows selected.
DBD: DELETE: DELETE FROM Flight_Schedule WHERE station_code IN ( ?) AND begin_date IN ( ?) AND open_date IN ( ?)
DBD: DoDelete: pIndex = 0, value = MCI
DBD: DoDelete: pIndex = 1, value = 2010-06-20
DBD: DoDelete: pIndex = 2, value = 2010-06-15
DBD:
DBD: *******************************************************
DBD: SQLException occured in TDbSchemaGroupInfoNode
DBD: Exception Message: ORA-01861: literal does not match format string
DBD: Vendor Error Code: 1861
DBD: SQL state: 22008
DBD: *******************************************************
DBD:
DBD: *******STACK TRACE*************
DBD: ERROR:
java.sql.SQLException: ORA-01861: literal does not match format string
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
End the Error:
Same log file showing successful deletion when DCR is left alone but replicant fields deleted:
DBD: TTableSchemaHelper object for [Flight_Schedule] found in cache.
DBD: SelectCurrentRows
ELECT TO_CHAR(end_date,'yyyy-MM-dd') AS end_date,URI,station_code,TO_CHAR(begin_date,'yyyy-MM-dd') AS b
egin_date,TO_CHAR(open_date,'yyyy-MM-dd') AS open_date FROM Flight_Schedule WHERE station_code IN (?,? ) AND begin_date IN (?
) AND open_date IN (? ) ORDER BY station_code,begin_date,open_date
DBD: Index: 1, value: MCI
DBD: Index: 2, value: MCO
DBD: Index: 3, value: 2010-06-20 00:00:00.0
DBD: Index: 4, value: 2010-06-15 00:00:00.0
DBD: SelectCurrentRows: 2 rows selected.
DBD: DoesRowExist
ELECT COUNT(*) FROM Flight_Schedule WHERE station_code = ? AND begin_date = ? AND open_date = ? AND end_d
ate = ? AND URI = ?
DBD: Column: station_code, field: pdf_schedule/0/station/0/station_code/0, Index: 1,Converting 'MCI' to VARCHAR
DBD: Column: begin_date, field: pdf_schedule/0/begin_date/0, Index: 2,Converting '2010-06-20' to TIMESTAMP
DBD: Column: open_date, field: pdf_schedule/0/open_date/0, Index: 3,Converting '2010-06-15' to TIMESTAMP
DBD: Column: end_date, field: pdf_schedule/0/end_date/0, Index: 4,Converting '2010-06-26' to TIMESTAMP
DBD: Column: URI, field: pdf_schedule/0/station/0/uri/0, Index: 5,Converting 'assets/pdfs/20100523_20100519/mci.pdf' to VARCHA
R
DBD: UpdateOneRow: Row already exists...Leave alone.
DBD: DELETE FROM Flight_Schedule WHERE station_code = ? AND begin_date = ? AND open_date = ? AND end_date = ? AND URI = ?
DBD: Column: station_code, field: null, Index: 1,Converting 'MCO' to VARCHAR
DBD: Column: begin_date, field: null, Index: 2,Converting '2010-06-20' to TIMESTAMP
DBD: Column: open_date, field: null, Index: 3,Converting '2010-06-15' to TIMESTAMP
DBD: Column: end_date, field: null, Index: 4,Converting '2010-06-26' to TIMESTAMP
DBD: Column: URI, field: null, Index: 5,Converting 'assets/pdfs/20100523_20100519/mco.pdf' to VARCHAR
End of successful deletion
The DB scema file:
value-from-field="pdf_schedule/0/begin_date/0"
data-format="yyyy-MM-dd" allows-null="no"
db-datetime-format="yyyy-MM-dd"/>
value-from-field="pdf_schedule/0/end_date/0"
data-format="yyyy-MM-dd" allows-null="no"
db-datetime-format="yyyy-MM-dd"/>
value-from-field="pdf_schedule/0/open_date/0"
data-format="yyyy-MM-dd" allows-null="no"
db-datetime-format="yyyy-MM-dd"/>
value-from-field="pdf_schedule/0/station/[0-5]/station_code/0"
is-replicant="yes"/>
value-from-field="pdf_schedule/0/station/[0-5]/uri/0"
is-replicant="yes"/>
End DB Schema file
DCR:
2010-06-20
2010-06-26
2010-06-15
MCI
assets/pdfs/20100523_20100519/mci.pdf
MCO
assets/pdfs/20100523_20100519/mco.pdf
End DCR
