Re: Problem with special characters with JDBC/Oracle

More info about the problem:

I'm using Oracle JDBC Drivers release 8.1.6 for JDK 1.2.x

Here is a code snippet:

PreparedStatement pstmt = con.prepareStatement("SELECT id, name FROM cities WHERE name = 'A CORUŅA'",

   ResultSet.TYPE_SCROLL_INSENSITIVE,
   ResultSet.CONCUR_READ_ONLY);
pstmt.clearParameters();
ResultSet rset = pstmt.executeQuery();
while (rset.next()) {

   System.out.println(rset.getString(1));    System.out.println(rset.getString(2)); }

If I don't use the last two parameters of prepareStatement() (ResultSet.TYPE_SCROLL_INSENSITIVE and ResultSet.CONCUR_READ_ONLY), then it works, but I want these parameters because I want to use the ResultSet.absolute() (and it seems these parameters are the only way to make it work).

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Feb 24 2000 - 16:28:42 CST