Alfredo Rico <alfredorico@gmail.com> writes:
> //for each row that I want to insert
> for(int i=1 ; i<= this.columnNumbers ; i ++)
> {
> this.insertColumn( columnNames[i] , columnValues[i] , i );
> }
> //For each row that I want to insert:
> public void insertColumn(String columnName, Object X , int i )
> {
>
> this.rs.updateObject(columnName , X );
>
> I would not like to use a bulk of if setences for various data types
> according to obtained by using ResultSetMetaData.
Why not? You have to do this only once per ResultSet type.
I wrote something similar here:
https://forge.continuent.org/plugins/scmcvs/cvsweb.php/sequoia/src/org/continuent/sequoia/common/protocol/?cvsroot=sequoia
in SQLDataSerialization#getSerializer()
The idea is that you, compute, store and then call back some abstract
"setters", one per column.
The advantage of typing earlier is that you catch input errors
earlier: in the driver instead of inside the engine.