In that function, i was attempting something like:

ResultSetMetaData md = rsCols.getMetaData(); md.getPrecision(1); md.getScale(1);

but it just returns 0 all the time =/

hmm.. im just thinking now, this may be because this function - rsCols is the column information and not the actual data. Still you (or I would) think it would work it out.

beyond that, my idea was then do:

if(dbmd.getDatabaseProductName().equalsIgnoreCase("Oracle")) {                //todo: doubles (re assign to INTEGER if no decimals.)            }