postgresql-jdbc.git / summary / log / commit / refs

commit    c6b8ae2cc87f320fcab7ee40ab1448a944b16849
Author:   Kris Jurka <books@ejurka.com>
Date:     Fri Jun 22 21:37:35 2007 +0000

    setObject fails to identify the correct type of java.lang.Byte.
    
    Boom Roos


org/postgresql/jdbc2/AbstractJdbc2Statement.java | 4 +++- org/postgresql/test/jdbc3/TypesTest.java | 16 +++++++++++++++- 2 files changed, 18 insertions(+), 2 deletions(-) diff --git a/org/postgresql/jdbc2/AbstractJdbc2Statement.java b/org/postgresql/jdbc2/AbstractJdbc2Statement.java index f29fd063..511ccc93 100644 --- a/org/postgresql/jdbc2/AbstractJdbc2Statement.java +++ b/org/postgresql/jdbc2/AbstractJdbc2Statement.java @@ -3,7 +3,7 @@ * Copyright (c) 2004-2005, PostgreSQL Global Development Group * * IDENTIFICATION -* $PostgreSQL: pgjdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java,v 1.99 2007/03/29 04:27:52 jurka Exp $ +* $PostgreSQL: pgjdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java,v 1.100 2007/05/07 13:10:34 davec Exp $ * *------------------------------------------------------------------------- */ @@ -1721,6 +1721,8 @@ public abstract class AbstractJdbc2Statement implements BaseStatement setTimestamp(parameterIndex, (Timestamp)x); else if (x instanceof Boolean) setBoolean(parameterIndex, ((Boolean)x).booleanValue()); + else if (x instanceof Byte) + setByte(parameterIndex, ((Byte)x).byteValue()); else if (x instanceof Blob) setBlob(parameterIndex, (Blob)x); else if (x instanceof Clob) diff --git a/org/postgresql/test/jdbc3/TypesTest.java b/org/postgresql/test/jdbc3/TypesTest.java index 477a2749..e5d73911 100644 --- a/org/postgresql/test/jdbc3/TypesTest.java +++ b/org/postgresql/test/jdbc3/TypesTest.java @@ -3,7 +3,7 @@ * Copyright (c) 2004-2005, PostgreSQL Global Development Group * * IDENTIFICATION -* $PostgreSQL: pgjdbc/org/postgresql/test/jdbc3/TypesTest.java,v 1.8 2005/11/24 02:31:44 oliver Exp $ +* $PostgreSQL: pgjdbc/org/postgresql/test/jdbc3/TypesTest.java,v 1.9 2006/05/15 09:35:57 jurka Exp $ * *------------------------------------------------------------------------- */ @@ -64,6 +64,20 @@ public class TypesTest extends TestCase { } } + public void testPreparedByte() throws SQLException { + PreparedStatement pstmt = _conn.prepareStatement("SELECT ?,?"); + pstmt.setByte(1, (byte)1); + pstmt.setObject(2, Byte.valueOf((byte)2)); + ResultSet rs = pstmt.executeQuery(); + assertTrue(rs.next()); + assertEquals((byte)1, rs.getByte(1)); + assertFalse(rs.wasNull()); + assertEquals((byte)2, rs.getByte(2)); + assertFalse(rs.wasNull()); + rs.close(); + pstmt.close(); + } + public void testCallableBoolean() throws SQLException { CallableStatement cs = _conn.prepareCall("{? = call return_bool(?)}"); cs.registerOutParameter(1, Types.BOOLEAN); [parent: d77895846efc]