View Issue Details

IDProjectCategoryView StatusLast Update
0001279SymmetricDSBugpublic2013-06-14 09:45
ReporterSektatAssigned To 
Status newResolutionopen 
Product Version3.4.6 
Target VersionFixed in Version 
Summary0001279: Derby - clob - primary key (date)
DescriptionIf I want to replicate a (derby store transaction data table like this (removed non-important columns):

create table pos_journal_transaction (
  evt_day date not null,
  receipt_data clob(64K));

Primary key = EVT_DAY

I receive this error as soon as I insert data into the table

java.sql.SQLException: The syntax of the string representation of a datetime value is incorrect.

After logging all SQL statements I found this statement generated by the symetrics code:

select RECEIPT_DATA from pos_journal_transaction
where "EVT_DAY"={ts '2013-06-14'}

This seems to be the cause for the errormessage (reproducable), since evt_day is a date and therefore the jdbc escape syntax for date must be used, which is a "d".
Correct would be:
select RECEIPT_DATA from pos_journal_transaction
where "EVT_DAY"={d '2013-06-14'}

If I ignore the receipt_data column (sym_trigger.exclude_column='receipt_data'), everything works fine, as expected.
Steps To Reproducesee above.


There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2013-06-14 09:45 Sektat New Issue