situation as follows.
We have a date field in database and we want to insert dd.MM.yyyy hh:mm:ss.
In adapter i see following:
COLUMN - ‘name’
Column Type - DATE
JDBC Type - DATE
Input Field - ‘name’
Input Field Type - ‘java.util.Date’
It is not working for us. But I have adapter that works fine. All same as above but.
JDBC Type - TIMESTAMP
Input Field Type - ‘java.sql.TimeStamp’
Problem is that I cannot pick java.sql.TimeStamp from the list of Input Field Type and I cannot change JDBC Type to TIMESTAMP.
Any thoughts how can i do one of these things?