IBM Support

IZ52414: JDBC exception while using CachedRowset.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Error Message: N/A
.
Stack Trace: com.ibm.db2.jcc.c.SqlException: ITEMDESC;TE = ? ,
ITEMABC = ?;,
            at com.ibm.db2.jcc.c.qh.c(qh.java:1671)

            at com.ibm.db2.jcc.c.qh.d(qh.java:1659)

            at com.ibm.db2.jcc.c.qh.a(qh.java:1216)

            at com.ibm.db2.jcc.a.db.g(db.java:139)

            at com.ibm.db2.jcc.a.db.a(db.java:39)

            at com.ibm.db2.jcc.a.t.a(t.java:34)

            at com.ibm.db2.jcc.a.sb.f(sb.java:142)

            at com.ibm.db2.jcc.c.qh.m(qh.java:1187)

            at com.ibm.db2.jcc.c.rh.db(rh.java:1942)

            at com.ibm.db2.jcc.c.rh.ib(rh.java:2042)

            at com.ibm.db2.jcc.c.rh.setObject(rh.java:1208)

            at
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.
setObject(WSJdbcPreparedStatement.java:1397)

            at com.sun.rowset.internal.CachedRowSetWriter.

updateOriginalRow(CachedRowSetWriter.java:686)

            at
com.sun.rowset.internal.CachedRowSetWriter.writeData
(CachedRowSetWriter.java:340)

            at com.sun.rowset.CachedRowSetImpl.acceptChanges

(CachedRowSetImpl.java:855)

            at com.sun.rowset.CachedRowSetImpl.acceptChanges

(CachedRowSetImpl.java:914)

            at
com.ibm.testjdbc.TestJDBCPortlet.testCRS(TestJDBCPortlet.
java:125)
.

Local fix

  • 



Problem summary


    

  • Invalid SQL query generated by updateOriginalRow() function
in CachedRowSetWriter.java due to missing comma.

    



Problem conclusion


    

  • This defect will be fixed in:
5.0.0 SR11
.
The code to insert comma in the query was missing one condition
check.The problem was resolved by adding the proper check .
.
To obtain the fix:
Install build 20090614 or later

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IZ52414
    • 

  • Reported component name
    JAVA 5 CLASS LI
    • 

  • Reported component ID
    620500130
    • 

  • Reported release
    500
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2009-06-03
    • 

  • Closed date
    2009-07-13
    • 

  • Last modified date
    2009-07-13
    • 





    

  • APAR is sysrouted FROM one or more of the following:
    

    • 

  • APAR is sysrouted TO one or more of the following:
    

    • 



Fix information


    

  • Fixed component name
    JAVA 5 CLASS LI
    • 

  • Fixed component ID
    620500130
    • 



Applicable component levels


    

  • R500  PSN
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCVQ3Y","label":"Java Class Libraries"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.0","Edition":"","Line of Business":{"code":"","label":""}}]
              

                                                                    

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            13 July 2009
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback