0 Replies Latest reply on Oct 10, 2002 5:04 PM by Joao Machado

    Problem with TYPE_SCROLL_INSENSITIVE

    Joao Machado Newbie

      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.