Commons DbUtils
  1. Commons DbUtils
  2. DBUTILS-49

QueryRunner - fillStatement method does not work for PostgreSQL database drivers

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 1.1
    • Fix Version/s: None
    • Labels:
      None
    • Environment:

      Windows XP, Centos (Linux)

      Description

      QueryRunner - fillStatement method does not work for PostgreSQL database drivers. PostgreSQL database drivers need to the java.sql.Type to be specified on the PreparedStatement.setObject method (as the 3rd parameter). But the QueryRunner - fillStatement does not you to specify the java.sql.Type as the third parameter on the PreparedStatement.setObject method. See the particular line I'm referred to in the method below.

      stmt.setObject(i + 1, params[i]);

        Activity

        Hide
        Dan Fabulich added a comment -

        Removing "Fix Version: 1.2" since this is really a dupe; it clutters the release notes.

        Show
        Dan Fabulich added a comment - Removing "Fix Version: 1.2" since this is really a dupe; it clutters the release notes.
        Show
        Henri Yandell added a comment - Akin to DBUTILS-44 and friends. Should be fixed in trunk after the following was merged in: http://svn.apache.org/viewvc/commons/sandbox/dbutils/bugfixing/src/java/org/apache/commons/dbutils/QueryRunner.java?p2=%2Fcommons%2Fsandbox%2Fdbutils%2Fbugfixing%2Fsrc%2Fjava%2Forg%2Fapache%2Fcommons%2Fdbutils%2FQueryRunner.java&p1=%2Fcommons%2Fsandbox%2Fdbutils%2Fbugfixing%2Fsrc%2Fjava%2Forg%2Fapache%2Fcommons%2Fdbutils%2FQueryRunner.java&r1=742865&r2=742864&view=diff&pathrev=742865

          People

          • Assignee:
            Unassigned
            Reporter:
            Cullen Kehoe
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development