Re: ResultSet.updateString against DB2 giving "Column not updatable"


adamcrume@xxxxxxxxx wrote:
If that's what's happening, the driver's not only being silent but
devious. I tested the result set after it was created:

System.out.println("Type correct: "+
(rs.getType()==ResultSet.TYPE_FORWARD_ONLY));
System.out.println("Concurrency correct: "+
(rs.getConcurrency()==ResultSet.CONCUR_UPDATABLE));

These printed out true and true.

I'm curious how you arrived at your conclusion. Are you aware of a
DB2-specific issue? If so, could you reference any documentation?

Hi. I just based my conclusion on the obvious driver response
to the initial code. I would suggest making a small standalone
program that makes a JDBC connection, creates a table, inserts
a row, and then tries your code to update it via a result set.
Joe


Joe Weinstein wrote:
Hi. There's nothing wrong with your JDBC. It seems the
driver is silently downgrading your ResultSet to a
non updateable one. Check the driver documents about this.
Joe Weinstein at BEA Systems

.

Relevant Pages

  • Re: Java vs SQL Server float datatype limits
    ... However Java double has a much wider range: ... Joe Weinstein at BEA Systems ... So I would have imagined that an SQL Server driver either handle the ... The JDBC specification says something about the driver being expected to coerce the Java data type into the correct data type for the server the driver is representing. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: JDBC and JVM question
    ... > public SybDriver() ... > change of regime in DriverManager from one perfectly good driver instance ... > Joe Weinstein at BEA ... There would be no need for the registerWithDriverManager() routine. ...
    (comp.lang.java.databases)
  • Re: executeBatch()
    ... Joe Weinstein wrote: ... >> Is this a limitation of the database or of the driver? ... > all together in one network packet, ... If it doesn't, it's because the driver ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: JDBC and JVM question
    ... >> I just checked the very latest 5.5 EBF driver. ... >> public class SybDriver ... >> Joe Weinstein at BEA ... >There would be no need for the registerWithDriverManager() routine. ...
    (comp.lang.java.databases)