You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@commons.apache.org by "Henri Yandell (JIRA)" <ji...@apache.org> on 2009/02/25 11:07:02 UTC
[jira] Closed: (DBUTILS-41) Inserting/updating null in a timestamp
field with PostgreSQL 8.x
[ https://issues.apache.org/jira/browse/DBUTILS-41?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Henri Yandell closed DBUTILS-41.
--------------------------------
Resolution: Fixed
svn ci -m "Merging in Dab Fabulich's work on https://svn.apache.org/repos/asf/commons/sandbox/dbutils/bugfixing from -r741987:747723. Resolving DBUTILS-34 - DBUTILS-37 - DBUTILS-29 - DBUTILS-14 - DBUTILS-31 - DBUTILS-39 - DBUTILS-41 - DBUTILS-44 - DBUTILS-33 - DBUTILS-42 - DBUTILS-40"
Sending pom.xml
Sending src/java/org/apache/commons/dbutils/BasicRowProcessor.java
Sending src/java/org/apache/commons/dbutils/BeanProcessor.java
Sending src/java/org/apache/commons/dbutils/QueryRunner.java
Adding src/java/org/apache/commons/dbutils/handlers/AbstractListHandler.java
Sending src/java/org/apache/commons/dbutils/handlers/ArrayListHandler.java
Sending src/java/org/apache/commons/dbutils/handlers/BeanListHandler.java
Sending src/java/org/apache/commons/dbutils/handlers/ColumnListHandler.java
Deleting src/java/org/apache/commons/dbutils/handlers/GenericListHandler.java
Sending src/java/org/apache/commons/dbutils/handlers/MapListHandler.java
Sending src/test/org/apache/commons/dbutils/BaseTestCase.java
Adding src/test/org/apache/commons/dbutils/QueryRunnerTest.java
Transmitting file data .........
Committed revision 747724.
> Inserting/updating null in a timestamp field with PostgreSQL 8.x
> ----------------------------------------------------------------
>
> Key: DBUTILS-41
> URL: https://issues.apache.org/jira/browse/DBUTILS-41
> Project: Commons DbUtils
> Issue Type: Bug
> Affects Versions: 1.1
> Environment: Linux CentOS 2.6.18-8.1.4.el5, PostgreSQL 8.2.4, Java 1.6.0_01
> Reporter: Malcolm McLean
> Priority: Minor
>
> When inserting or updating a value to null on timestamp (date) field in a PostgreSQL database, the following error is returned:
> column "foo" is of type timestamp without time zone but expression is of type character varying
> Overriding the fillStatement method by doing something like:
> {code}
> QueryRunner run = new QueryRunner() {
> /* (non-Javadoc)
> * @see org.apache.commons.dbutils.QueryRunner#fillStatement(java.sql.PreparedStatement, java.lang.Object[])
> */
> @Override
> protected void fillStatement(PreparedStatement stmt, Object[] params) throws SQLException {
> if (params == null) {
> return;
> }
> for (int i = 0; i < params.length; i++) {
> if (params[i] != null) {
> stmt.setObject(i + 1, params[i]);
> } else {
> // VARCHAR works with many drivers regardless
> // of the actual column type (Maybe not with Postgres 8.x). Oddly, NULL and
> // OTHER don't work with Oracle's drivers.
> stmt.setNull(i + 1, Types.NULL);
> }
> }
> }
> };
> {code}
> work, but it will have a problem if other databases are used instead of PostgreSQL.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.