Performace of Updatable resultset

[manvendra singh]

Hi All,
I had a requirement to morph CreditCard information present in a legacy Database for last 14 years.

I tried to do it in java and have written following code for that.
based upon updatable resultset.
But its performance is very poor.

private static void performDBOperations(String qry, Object[] objs,int numberOfFieldsToProcess) throws Exception {
	log.info("performDBOperations() called.");
	Connection con = DBAccess.getConnection();
	PreparedStatement stmt = DBAccess.getUpdatableStatement(con, qry);
	DBAccess.setParameters(stmt, objs);
	ResultSet rs = stmt.executeQuery();
	
                 System.out.println(rs.getType());
	System.out.println(rs.getConcurrency());
	
                 handleResultSet(rs,numberOfFieldsToProcess);

	rs.close();
	stmt.close();
	con.close();

	log.info("performDBOperations() returning.");
}

	private static void handleResultSet(ResultSet rs, int numberOfFieldsToProcess) throws Exception {
		log.info("handleResultSet() called.");
		
		//for testing performance
                                 int totalRecords = 0;Date startTime = new Date ();

		String txt = null;
		if (rs != null) {
			while (rs.next()) {
				int i = 1;
				while (i <= numberOfFieldsToProcess) {
					txt = rs.getString(i);
					
// Following is the morphing logic...But even after commenting it performance is poor...
//					if (txt != null && txt.trim().length() != 0) {
//						txt = Morpher.morphCardInString(txt);
//						
//						if (Morpher.isTextChanged) {
//							rs.updateString(i, txt);
//						}
					}
					i++;
				}
			}
		}
		Date endTime = new Date ();
		log.info("handleResultSet() returning. record processed " + totalRecords + " time taken " + (endTime.getTime()-startTime.getTime()));
	}

Class DB Access looks like

public class DBAccess {
	private final static Log	log	= LogFactory.getLog(DBAccess.class);

	public static PreparedStatement getUpdatableStatement(Connection con, String qry) throws SQLException {
		return con.prepareStatement(qry, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_UPDATABLE);
	}

	public static Connection getConnection() {
		
		Connection con = null;
		try {
			Class.forName(ApplicationConstants.DB_DRIVER_CLASS);
		} catch (ClassNotFoundException e) {
			log.error("Can not load SQL Driver: " + ApplicationConstants.DB_DRIVER_CLASS);
			System.exit(0);
		}
		try {
			con = DriverManager.getConnection(ApplicationConstants.DB_URL, ApplicationConstants.DB_USER,
					ApplicationConstants.DB_PWD);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return con;
	}

	public static void setParameters(PreparedStatement ps, Object[] args) throws SQLException {
		if (args != null) {
			for (int i = 0; i < args.length; i++) {
				Object arg = args[i];
				if (arg instanceof Integer) {
					ps.setInt(i+1, ((Integer) arg).intValue());
				} else if (arg instanceof Long) {
					ps.setLong(i+1, ((Long) arg).longValue());
				} else if (arg instanceof String) {
					ps.setString(i+1, (String) arg);
				} else if (arg instanceof Date) {
					ps.setDate(i+1, new java.sql.Date(((Date) arg).getTime()));
				}
			}
		}
	}

}

Can somebody please tell some optimization in it without writing a stored procedure.......

And even above rs.updateString() method throws an obvious exception Internal (Error: Unable to construct a Datum from the specified input) when operating with clob.
So can anyone please tell that how to create a clob object to pass to rs.updateClob(1,txtClob)....