Jakob Braeuchi wrote:
hi tim,please provide the sql generated by ojb. jakob
Pasted below. I've been searching the postgresql jdbc email archives.
Although I haven't found anything conclusive, this error points to
a problem with the jdbc driver not handling comparing floats in a
way compatible with sql. I've seen a similar problem with timestamps
between toplink and oracle.
Any ideas/thoughts?
-tim
Here is the last few entries in spy.log:
1037470421168|29|0|statement|SELECT count(*) FROM foo A0 WHERE (A0.LFOO = ? ) AND A0.FFOO = ? |SELECT count(*) FROM foo A0 WHERE (A0.LFOO = '100' ) AND A0.FFOO = '3.14'
1037470421184|2|0|statement|SELECT A0.LASTMODIFIED,A0.LFOO,A0.TIMECREATED,A0.FFOO,A0.SFOO,A0.DFOO,A0.DATEFOO,A0.IFOO,A0.ID FROM foo A0 WHERE (A0.LFOO = ? ) AND A0.FFOO = ? |SELECT A0.LASTMODIFIED,A0.LFOO,A0.TIMECREATED,A0.FFOO,A0.SFOO,A0.DFOO,A0.DATEFOO,A0.IFOO,A0.ID FROM foo A0 WHERE (A0.LFOO = '100' ) AND A0.FFOO = '3.14'
1037470421200|1|0|statement|SELECT count(*) FROM foo A0 WHERE (A0.LFOO = ? ) AND A0.FFOO = ? |SELECT count(*) FROM foo A0 WHERE (A0.LFOO = '100' ) AND A0.FFOO = '3.14'
here is the result when pasted into psql:
ojb=# SELECT A0.LASTMODIFIED,A0.LFOO,A0.TIMECREATED,A0.FFOO,A0.SFOO,A0.DFOO,A0.DATEFOO,A0.IFOO,A0.ID FROM foo A0 WHERE (A0.LFOO = '100' ) AND A0.FFOO = '3.14';
lastmodified | lfoo | timecreated | ffoo | sfoo | dfoo | datefoo | ifoo | id
----------------------------+------+----------------------------+------+--------+-----------+------------+------+------
2002-11-14 23:18:46.96-05 | 100 | 2002-11-14 23:18:46.96-05 | 3.14 | sample | 1234.5678 | 2000-12-31 | 1 | 881
2002-11-15 14:33:31.57-05 | 100 | 2002-11-15 14:33:31.57-05 | 3.14 | sample | 1234.5678 | 2000-12-31 | 1 | 941
2002-11-15 15:13:17.159-05 | 100 | 2002-11-15 15:13:17.159-05 | 3.14 | sample | 1234.5678 | 2000-12-31 | 1 | 961
2002-11-15 15:14:47.517-05 | 100 | 2002-11-15 15:14:47.517-05 | 3.14 | sample | 1234.5678 | 2000-12-31 | 1 | 981
2002-11-16 13:13:41.008-05 | 100 | 2002-11-16 13:13:41.008-05 | 3.14 | sample | 1234.5678 | 2000-12-31 | 1 | 1021
(5 rows)
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
