Bug #11798 Calling to setObject(i, bValue, Types.BOOLEAN) throws an exception

Submitted:	7 Jul 2005 20:19	Modified:	17 Oct 2005 19:42
Reporter:	Adrián Romero Corchado	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / J	Severity:	S3 (Non-critical)
Version:	mysql-connector-java-3.1.10	OS:	Windows (Windows XP)
Assigned to:	Mark Matthews	CPU Architecture:	Any

Description:
I have a Prepared statement "m_ps"

this call works: m_ps.setBoolean(paramIndex, bValue.booleanValue());
but this other throws an exception: m_ps.setObject(paramIndex, bValue, Types.BOOLEAN);

How to repeat:
execute  m_ps.setObject(paramIndex, bValue, Types.BOOLEAN);

Suggested fix:
add to the method setObject the following lines

                case Types.BOOLEAN:

                    Number parameterAsNum;

                    if (parameterObj instanceof Boolean) {
                        parameterAsNum = ((Boolean) parameterObj).booleanValue()
                            ? new Integer(1) : new Integer(0);
                    } 

                    switch (targetSqlType) {
                    case Types.BIT:
                    case Types.TINYINT:
                    case Types.SMALLINT:
                    case Types.INTEGER:
                        setInt(parameterIndex, parameterAsNum.intValue());

                        break;

Could you please provide table definition and test case ?

This one doesn't need a testcase, it's obvious from inspection. Thanks.

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.