lesteryu / log4jdbc

Automatically exported from code.google.com/p/log4jdbc
0 stars 0 forks source link

Informix SQL is not correct #8

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
Log any insert statement with Dates.

What is the expected output? What do you see instead?
it looks like this:
insert into table (columns,...) values (1, 'string', 2222-02-22 22:22:22.0,
2009-06-10 15:02:05.0, 2009-06-10 15:02:05.0, 1) 
and there are two problems to put this into informix sql client
a) dates are not in the apostrophes ''
b) dates have additional characters .0 which are not parsed correctly by
informix

What version of the product are you using? On what operating system?
log4jdbc3-1.2alpha2.jar

Please provide any additional information below.
Maybe adding a DateTimeFormat and 'apostrophe required' options to
configuration would be a solution for that?

Original issue reported on code.google.com by kretesen...@gmail.com on 10 Jun 2009 at 1:35

GoogleCodeExporter commented 9 years ago
Fixed on SVN rev. 64

Original comment by arthur.b...@gmail.com on 1 Dec 2009 at 11:14