Dear Francis,
I just created the Jira entry, but I don't have much time now. I
also prepared my code to simulate the operation while logging, but it is
not ready yet and I am not sure I will have time soon to work on it.
It looks indeed like a simple toString, and the code I use is the one I
already posted:
GregorianCalendar today = new GregorianCalendar();
Date todayDate = today.getTime();
MiscTools.insertSearchTerm(..., todayDate, ...);
Then the insertSearchTerm is setting the todayDate in the DBRecord
without changing it. For me, it looks like the column type is unknown
when the method getValueString is called in DBDatabaseDriverOracle, so
we get the toString, even if I have no idea how that could happen. I am
just subclassing the class to be able to log that, aside of the test
suggested by Rainer in getSQLDateTimeString.
I am actually expecting to find that I am simply doing something very
very stupid :). We will see...
//Alain
On 05/03/2013 09:09, Francis De Brabandere wrote:
Alain,
One more question, is "Thu Feb 21 10:27:45 CET 2013" the toString() of
a date on your machine? I wonder if there is a code path that just
uses the toString for adding a value.
Could you also post us the query for a correct call. Does it look like this?
INSERT INTO DATA( SEARCH_TERMS, IS_LOCAL, AT_TIME, FROM_IP) VALUES (
'test', 1, TO_DATE('2013-03-04 23:23:22', 'YYYY-MM-DD HH24:MI:SS'),
'0.0.0.0')
F
