Professional Web Applications Themes

ResultSet is not updatable. - IBM DB2

Removed by Administrator...

  1. Moderated Post

    Default Re: ResultSet is not updatable.

    Removed by Administrator
    xixi Guest
    Moderated Post

  2. Moderated Post

    Default Re: ResultSet is not updatable.

    Removed by Administrator
    sharpe@us.ibm.com Guest
    Moderated Post

  3. Moderated Post

    Default Re: ResultSet is not updatable.

    Removed by Administrator
    sharpe@us.ibm.com Guest
    Moderated Post

  4. Moderated Post

    Default Re: ResultSet is not updatable.

    Removed by Administrator
    xixi Guest
    Moderated Post

  5. Moderated Post

    Default Re: ResultSet is not updatable.

    Removed by Administrator
    sharpe@us.ibm.com Guest
    Moderated Post

  6. Moderated Post

    Default Re: ResultSet is not updatable.

    Removed by Administrator
    sharpe@us.ibm.com Guest
    Moderated Post

  7. #7

    Default Re: ResultSet is not updatable.

    Hi xixi,
    I don't think it does, you need the fixpak2 for that.

    xixi wrote:
    >hello,
    >
    >i do put the db2jcc_license_cisuz.jar in the classpath, but still not
    >work, i just want to know whether db2jcc.jar from fixpack1 support
    >positioned update (or delete) ? (updateObject() method, updateRow()
    >method)
    >
    sharpe@us.ibm.com Guest

  8. #8

    Default Re: ResultSet is not updatable.

    hello, I was able to use db2jcc.jar fixpack2 to run the program now,
    but still interfere with errors.

    What I do is use a select query to position the cursor, then do a
    resultset.updateObject(), so far no problem, then I do a
    resultset.updateRow(), I got error code 798, I don't know why.

    The sql is select id, brnum, ITMNUM, DESC from DDAI.NOINDEX_TABLE
    where id = 8

    id is identity column, but my updateobject() doesn't update id field,
    but desc field. Please see the log. thanks
    DriverManager.getConnection("jdbc:db2://172.16.4.10:50000/hd1100pd:traceFile=c:/foobar.txt;traceLevel=550;")
    trying driver[className=com.ibm.as400.access.AS400JDBCDriver,AS/400
    Toolbox for Java JDBC Driver]
    trying driver[className=com.ibm.db2.jcc.DB2Driver,com.ibm.db2.jc c.DB2Driver1db7df8]
    [ibm][db2][jcc] BEGIN TRACE_CONNECTS
    [ibm][db2][jcc] Attempting connection to 172.16.4.10:50000/hd1100pd
    [ibm][db2][jcc] Using properties: { traceLevel=550,
    traceFile=c:/foobar.txt, user=ddai, password=<escaped> }
    [ibm][db2][jcc] END TRACE_CONNECTS
    [ibm][db2][jcc][Connectionadb1d4] BEGIN TRACE_CONNECTS
    [ibm][db2][jcc][Connectionadb1d4] Successfully connected to server
    jdbc:db2://172.16.4.10:50000/hd1100pd
    [ibm][db2][jcc][Connectionadb1d4] User: ddai
    [ibm][db2][jcc][Connectionadb1d4] Database product name: DB2/NT
    [ibm][db2][jcc][Connectionadb1d4] Database product version: SQL08012
    [ibm][db2][jcc][Connectionadb1d4] Driver name: IBM DB2 JDBC Universal
    Driver Architecture
    [ibm][db2][jcc][Connectionadb1d4] Driver version: 1.2.117
    [ibm][db2][jcc][Connectionadb1d4] DB2 Correlator:
    AC100436.GE38.00F6675277DF
    [ibm][db2][jcc][Connectionadb1d4] END TRACE_CONNECTS
    [ibm][db2][jcc][t4] DRDA manager levels: { SQLAM=7, AGENT=7,
    CMNTCPIP=5, RDB=7, SECMGR=6 }
    getConnection returning
    driver[className=com.ibm.db2.jcc.DB2Driver,com.ibm.db2.jc c.DB2Driver1db7df8]
    [ibm][db2][jcc][Thread:main][Statement1b60280] executeQuery (select
    NAME from sysibm.sysschemata where name = 'DDAI') called
    [ibm][db2][jcc][Thread:main][Statement1b60280] executeQuery ()
    returned ResultSet1d0fafc
    [ibm][db2][jcc][Thread:main][ResultSet1d0fafc] next () called
    [ibm][db2][jcc][Thread:main][ResultSet1d0fafc] next () returned true
    [ibm][db2][jcc][Thread:main][PreparedStatementf6438d] setString (1,
    NOINDEX_TABLE) called
    [ibm][db2][jcc][Thread:main][PreparedStatementf6438d] executeQuery ()
    called
    [ibm][db2][jcc][Thread:main][PreparedStatementf6438d] executeQuery ()
    returned ResultSet1eb2c1b
    [ibm][db2][jcc][Thread:main][ResultSet1eb2c1b] next () called
    [ibm][db2][jcc][Thread:main][ResultSet1eb2c1b] next () returned true
    [ibm][db2][jcc][Thread:main][ResultSet1eb2c1b] getString (DBKFLD)
    called
    [ibm][db2][jcc][Thread:main][ResultSet1eb2c1b] getString (2) called
    [ibm][db2][jcc][Thread:main][ResultSet1eb2c1b] getString () returned
    BRNUM
    [ibm][db2][jcc][Thread:main][ResultSet1eb2c1b] getString (DBKORD)
    called
    [ibm][db2][jcc][Thread:main][ResultSet1eb2c1b] getString (3) called
    [ibm][db2][jcc][Thread:main][ResultSet1eb2c1b] getString () returned
    A
    [ibm][db2][jcc][Thread:main][ResultSet1eb2c1b] next () called
    [ibm][db2][jcc][Thread:main][ResultSet1eb2c1b] next () returned false
    [ibm][db2][jcc][Thread:main][PreparedStatement1632847] setString (1,
    DDAI) called
    [ibm][db2][jcc][Thread:main][PreparedStatement1632847] setString (2,
    NOINDEX_TABLE) called
    [ibm][db2][jcc][Thread:main][PreparedStatement1632847] executeQuery
    () called
    [ibm][db2][jcc][Thread:main][PreparedStatement1632847] executeQuery
    () returned ResultSete95a56
    [ibm][db2][jcc][Thread:main][ResultSete95a56] next () called
    [ibm][db2][jcc][Thread:main][ResultSete95a56] next () returned true
    [ibm][db2][jcc][Thread:main][ResultSete95a56] getString (COLTYPE)
    called
    [ibm][db2][jcc][Thread:main][ResultSete95a56] getString (2) called
    [ibm][db2][jcc][Thread:main][ResultSete95a56] getString () returned
    INTEGER
    [ibm][db2][jcc][Thread:main][ResultSete95a56] getInt (LENGTH) called
    [ibm][db2][jcc][Thread:main][ResultSete95a56] getInt (4) called
    [ibm][db2][jcc][Thread:main][ResultSete95a56] getInt () returned 4
    [ibm][db2][jcc][Thread:main][ResultSete95a56] getString (NAME) called
    [ibm][db2][jcc][Thread:main][ResultSete95a56] getString (1) called
    [ibm][db2][jcc][Thread:main][ResultSete95a56] getString () returned
    BRNUM
    [ibm][db2][jcc][Thread:main][ResultSete95a56] next () called
    [ibm][db2][jcc][Thread:main][ResultSete95a56] next () returned true
    [ibm][db2][jcc][Thread:main][ResultSete95a56] getString (COLTYPE)
    called
    [ibm][db2][jcc][Thread:main][ResultSete95a56] getString (2) called
    [ibm][db2][jcc][Thread:main][ResultSete95a56] getString () returned
    INTEGER
    [ibm][db2][jcc][Thread:main][ResultSete95a56] getInt (LENGTH) called
    [ibm][db2][jcc][Thread:main][ResultSete95a56] getInt (4) called
    [ibm][db2][jcc][Thread:main][ResultSete95a56] getInt () returned 4
    [ibm][db2][jcc][Thread:main][ResultSete95a56] getString (NAME) called
    [ibm][db2][jcc][Thread:main][ResultSete95a56] getString (1) called
    [ibm][db2][jcc][Thread:main][ResultSete95a56] getString () returned
    ITMNUM
    [ibm][db2][jcc][Thread:main][ResultSete95a56] next () called
    [ibm][db2][jcc][Thread:main][ResultSete95a56] next () returned true
    [ibm][db2][jcc][Thread:main][ResultSete95a56] getString (COLTYPE)
    called
    [ibm][db2][jcc][Thread:main][ResultSete95a56] getString (2) called
    [ibm][db2][jcc][Thread:main][ResultSete95a56] getString () returned
    VARCHAR
    [ibm][db2][jcc][Thread:main][ResultSete95a56] getInt (LENGTH) called
    [ibm][db2][jcc][Thread:main][ResultSete95a56] getInt (4) called
    [ibm][db2][jcc][Thread:main][ResultSete95a56] getInt () returned 20
    [ibm][db2][jcc][Thread:main][ResultSete95a56] getString (NAME) called
    [ibm][db2][jcc][Thread:main][ResultSete95a56] getString (1) called
    [ibm][db2][jcc][Thread:main][ResultSete95a56] getString () returned
    DESC
    [ibm][db2][jcc][Thread:main][ResultSete95a56] next () called
    [ibm][db2][jcc][Thread:main][ResultSete95a56] next () returned false
    [ibm][db2][jcc][Thread:main][Statement1b60280] close () called
    [ibm][db2][jcc][Thread:main][ResultSete95a56] close () called
    [ibm][db2][jcc][Thread:main][PreparedStatement1632847] close ()
    called
    [ibm][db2][jcc][Thread:main][Statement1ffc686] executeQuery (select
    id, brnum, ITMNUM, DESC from DDAI.NOINDEX_TABLE WHERE brnum=4 ORDER
    BY brnum ASC) called
    [ibm][db2][jcc][Thread:main][Statement1ffc686] executeQuery ()
    returned ResultSet961dff
    [ibm][db2][jcc][Thread:main][ResultSet961dff] isBeforeFirst () called
    [ibm][db2][jcc][Thread:main][ResultSet961dff] isBeforeFirst ()
    returned true
    [ibm][db2][jcc][Thread:main][ResultSet961dff] next () called
    [ibm][db2][jcc][Thread:main][ResultSet961dff] isAfterLast () called
    [ibm][db2][jcc][Thread:main][ResultSet961dff] isAfterLast () returned
    false
    [ibm][db2][jcc][Thread:main][ResultSet961dff] next () returned true
    [ibm][db2][jcc][Thread:main][ResultSet961dff] getObject (brnum)
    called
    [ibm][db2][jcc][Thread:main][ResultSet961dff] getObject (2) called
    [ibm][db2][jcc][Thread:main][ResultSet961dff] getObject () returned 4
    [ibm][db2][jcc][Thread:main][ResultSet961dff] getObject (ITMNUM)
    called
    [ibm][db2][jcc][Thread:main][ResultSet961dff] getObject (3) called
    [ibm][db2][jcc][Thread:main][ResultSet961dff] getObject () returned 5
    [ibm][db2][jcc][Thread:main][ResultSet961dff] getObject (DESC) called
    [ibm][db2][jcc][Thread:main][ResultSet961dff] getObject (4) called
    [ibm][db2][jcc][Thread:main][ResultSet961dff] getObject () returned
    5th Item
    [ibm][db2][jcc][Thread:main][ResultSet961dff] getObject (id) called
    [ibm][db2][jcc][Thread:main][ResultSet961dff] getObject (1) called
    [ibm][db2][jcc][Thread:main][ResultSet961dff] getObject () returned 8
    [ibm][db2][jcc][Thread:main][Statement1aaf0b3] executeQuery (select
    id, brnum, ITMNUM, DESC from DDAI.NOINDEX_TABLE where id = 8) called
    [ibm][db2][jcc][Thread:main][Statement1aaf0b3] executeQuery ()
    returned ResultSet1a082e2
    [ibm][db2][jcc][Thread:main][ResultSet1a082e2] getConcurrency ()
    returned 1008
    [ibm][db2][jcc][Thread:main][ResultSet1a082e2] next () called
    [ibm][db2][jcc][Thread:main][ResultSet1a082e2] isAfterLast () called
    [ibm][db2][jcc][Thread:main][ResultSet1a082e2] isAfterLast ()
    returned false
    [ibm][db2][jcc][Thread:main][ResultSet1a082e2] next () returned true
    [ibm][db2][jcc][Thread:main][ResultSet961dff] getConcurrency ()
    returned 1007
    [ibm][db2][jcc][Thread:main][ResultSet961dff] updateObject (desc,
    Fifth Item) called
    [ibm][db2][jcc][Thread:main][ResultSet961dff] updateObject (4, Fifth
    Item) called
    SQLException: SQLState(null) vendor code(-99999)
    com.ibm.db2.jcc.c.SqlException: ResultSet is not updatable.
    at com.ibm.db2.jcc.c.cc.i(cc.java:3000)
    at com.ibm.db2.jcc.c.cc.updateObject(cc.java:2078)
    at com.ibm.db2.jcc.c.cc.updateObject(cc.java:2204)
    at com.mincron.framework.translated.file.db.AS400Curs or.updateObject(AS400Cursor.java:156)
    at com.mincron.framework.translated.file.db.DB2DbFile .resultSetUpdate(DB2DbFile.java:2669)
    at com.mincron.framework.translated.file.db.DB2DbFile .updat(DB2DbFile.java:2494)
    at com.mincron.framework.translated.file.db.Db2DbFile Tester1.chain_Test(Db2DbFileTester1.java:179)
    at com.mincron.framework.translated.file.db.Db2DbFile Tester1.main(Db2DbFileTester1.java:34)
    [ibm][db2][jcc] BEGIN TRACE_DIAGNOSTICS
    [ibm][db2][jcc][SQLException210b5b] java.sql.SQLException
    [ibm][db2][jcc][SQLException210b5b] SQL state = null
    [ibm][db2][jcc][SQLException210b5b] Error code = -99999
    [ibm][db2][jcc][SQLException210b5b] Message = ResultSet is not
    updatable.
    [ibm][db2][jcc][SQLException210b5b] Stack trace follows
    com.ibm.db2.jcc.c.SqlException: ResultSet is not updatable.
    at com.ibm.db2.jcc.c.cc.i(cc.java:3000)
    at com.ibm.db2.jcc.c.cc.updateObject(cc.java:2078)
    at com.ibm.db2.jcc.c.cc.updateObject(cc.java:2204)
    at com.mincron.framework.translated.file.db.AS400Curs or.updateObject(AS400Cursor.java:156)
    at com.mincron.framework.translated.file.db.DB2DbFile .resultSetUpdate(DB2DbFile.java:2669)
    at com.mincron.framework.translated.file.db.DB2DbFile .updat(DB2DbFile.java:2494)
    at com.mincron.framework.translated.file.db.Db2DbFile Tester1.chain_Test(Db2DbFileTester1.java:179)
    at com.mincron.framework.translated.file.db.Db2DbFile Tester1.main(Db2DbFileTester1.java:34)
    [ibm][db2][jcc] END TRACE_DIAGNOSTICS
    xixi Guest

Similar Threads

  1. DW CS3, Templates and Updatable Navigation
    By Demon Design in forum Macromedia Contribute General Discussion
    Replies: 5
    Last Post: December 12th, 02:01 PM
  2. Updatable Datagrid with Multipage
    By Black in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: August 2nd, 12:31 PM
  3. Updatable calendar diary
    By Philippio webforumsuser@macromedia.com in forum Macromedia Dreamweaver
    Replies: 0
    Last Post: July 28th, 03:22 PM
  4. Recordset is not updatable
    By Trent Argante in forum Microsoft Access
    Replies: 1
    Last Post: July 18th, 04:48 PM
  5. updatable recordset?
    By RP in forum ASP
    Replies: 1
    Last Post: July 3rd, 12:47 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139