[DBUTILS-84] BeanProcessor method processColumn should take SQLXML in consideration

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.4
• Fix Version/s: 1.5
• Labels: SQLXML sqlserver

Environment

Windows 7 + IBM J9 VM (build 2.4, JRE 1.6.0 IBM J9 2.4 Windows 7 x86-32 jvmwi3260sr9-20110216_75791 (JIT enabled, AOT enabled)

• Assignee: Bill Speirs
• Reporter: Tiago Cavaleiro
• Created: 11/Nov/11 15:04
• Updated: 20/Jul/12 19:34
• Resolved: 06/Jul/12 18:46

Description

I was experimenting DbUtils and discovered that if the result set contains a SQLXML column using the BeanProcessor the returned type will be a String and not a java.sql.SQLXML.

Part of the problem is related with the fact the SQL Server driver returns a String.
The call to ResultSet.getObject([SQLXML index]) is returning a String instead of the java.sql.SQLXML, but if we call the ResultSet.getSQLXML([SQLXML index]) it works as expected.

The correction I've made on the DbUtils was to add the following code:

BeanProcess.java

    protected Object processColumn(ResultSet rs, int index, Class<?> propType)
        throws SQLException {

        (...)
        
        } else if (propType.equals(SQLXML.class)) {
        	return rs.getSQLXML(index);
            
        } else {
            return rs.getObject(index);
        }