Hi All,
I'm wondering if there could be a problem in the JDBC driver.
I'm calling:
preparedStatement.setObject(i, value);
where value is of type Boolean (with value false
below)and created the column associated with that
value as type BIT and I'm getting the following
exception when the prepar
I'm having a problem doing a select on an Order with a where clause below,
getting a preparedStatemtnt and calling
preparedStatement.setObject(timeStamp);
Its return nothing and I know there is a row with that orderDate.
SQL: select
OrderID,CustomerID,EmployeeID,OrderDate,RequiredDate,ShippedDat
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,ShipNam