Can anybody show any reason why the code using a prepared statement with a
where clause using a date won't find any records on PostgreSQL but WILL work
using Access and the jdbc-odbc bridge?
ie.
SQL: select
OrderID,CustomerID,EmployeeID,OrderDate,RequiredDate,ShippedDate,ShipVia,Fre
ight,ShipName,ShipAddress,ShipCity,ShipRegion,ShipPostalCode,ShipCountry
from Orders where OrderDate = ?
Setting value: OrderDate 1996-07-05 00:00:00.0
It does not cause an exception, but fails to retrieve anything with
PostgreSQL yet works and retrieves the right record with Access.
I further verified that a record does exist with the PostreSQL database.