db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Fox (JIRA)" <j...@apache.org>
Subject [jira] [Created] (TORQUE-330) Postgresql fails for some prepared statement replacement types (short, double ...)
Date Fri, 26 Sep 2014 01:00:36 GMT
Thomas Fox created TORQUE-330:

             Summary: Postgresql fails for some prepared statement replacement types (short,
double ...)
                 Key: TORQUE-330
                 URL: https://issues.apache.org/jira/browse/TORQUE-330
             Project: Torque
          Issue Type: Bug
          Components: Runtime
    Affects Versions: 4.0
         Environment: postgresql
            Reporter: Thomas Fox
            Assignee: Thomas Fox
             Fix For: 4.1

When executing a SQL statement with some prepared statement replacement types (short, double
...), postgresql fails with an error, e.g. ERROR: operator does not exist: smallint = character

This error is caught by the test org.apache.torque.generated.peer.RetrieveByPkTest.testRetrieveByNonExistingPkMultiplePKs()
in the test project.

The reason is that in org.apache.torque.util.BasePeerImpl.setPreparedStatementReplacements(PreparedStatement,
List<Object>, int) in the runtime, not all of these arguments are considered, and for
unknown arguments, java.sql.PreparedStatement.setString(int, String) is used.

The setPreparedStatementReplacements method should be changed such that also the specific
setters for short, byte, float and double are used.

This message was sent by Atlassian JIRA

To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org

View raw message