I'm trying to use the Microsoft JDBC Driver. This driver has the problem that we can not read the columns table in a diferent order than the one that was specified in the SELECT statement (Currentrly I'm using the JSQLConnect driver that don't have such problem).
The solution that I found is to use :
con.prepareStatement(sql, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY)
but it is not working in Jboss 3.0.0. Anyone knows what is happening ?
Thanks.