[Springframework-developer] Exposing LOB support to Jdbc Object layer

[Thomas R. <tho...@tr...>]

I've recently started to take a closer look at Juergen's LOB handler 
classes and they look very solid.  It would be a shame not exposing them 
to the Jdbc Object package - primarily SqlUpdate.  I have started to 
test a few ideas.  I added a constructor accepting a LobHandler to the 
SqlParameter class.  I also added a SqlLobValue class for holding the 
input stream and the length.  This is what the usage would look like:

        LobHandler lobHandler = new DefaultLobHandler();  // or 
OracleLobHandler
        String sql = "insert into docs (doc_id, description , added, 
document) values(?, ?, ?, ?)";
        SqlUpdate su = new SqlUpdate(ds, sql);
        su.declareParameter(new SqlParameter("id", Types.INTEGER));
        su.declareParameter(new SqlParameter("desc", Types.VARCHAR));
        su.declareParameter(new SqlParameter("added", Types.DATE));
        su.declareParameter(new SqlParameter("lob", Types.BLOB, 
lobHandler));
        su.compile();
        Object[] inval = new Object[4];
        inval[0] = new Integer(newId);
        inval[1] = "Doc One";
        inval[2] = new java.sql.Date(new Date().getTime());
        File in = new File("word.doc");
        int len = (int) in.length();
        FileInputStream is = new FileInputStream(in);
        inval[3] = new SqlLobValue(is, len);
        int count = su.update(inval);
        is.close();

A few tweaks to the PreparedStatementCreateorImpl class and this 
actually ran against both Oracle and PostgreSQL.

I think we could easily support all the different methods that 
LobHandler supports:
 byte[]
 BinaryStream
 String
 AsciiStream
 CharacterStream

Any thoughts or ideas?

Thomas