Hello,
when I use the function ‘getDataSetByQuery()’ I have the problem that datetime-values will not be assigned correctly/completely.
The call in the method is:
vTermine = databaseManager.getDataSetByQuery(controller.getServerName(), vQuery, new Array(abfrage_start, abfrage_ende), 1000);
The variable ‘abfrage_start’ is of type date and contains: ‘Mon Feb 7 2005 8:00:00 GMT+0100 (CET)’,
the variable ‘abfrage_ende’ is of the same type and contains: ‘Sun Feb 13 2005 19:00:00 GMT+0100 (CET)’
The problem is that the time will not be assigned in the query.
The log file shows:
Got connection, thread=AWT-EventQueue-0used sql
SELECT [...]
WHERE (kontakte_benutzer.datum_von >= ? AND kontakte_benutzer.datum_von <= ?)
ascquestiondata[0]= 2005-02-07 ,type: java.sql.Datequestiondata[1]= 2005-02-13 ,type: java.sql.Datequestiondata
Closed connection, thread=AWT-EventQueue-0spotlight: