[GENERAL] JDBC org.postresql.Driver

2001-01-11 Thread Ian deSouza
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

[GENERAL] Problem when calling setObject on Timestamp column with JDBC driver

2001-02-06 Thread Ian deSouza
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

[GENERAL] Date types in where clause of PreparedStatement

2001-02-22 Thread Ian deSouza
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