clob variable: java.lang.NullPointerException

[Romeo Ranjan]

Dear Ranchers,

I get java.lang.NullPointerException at

clob.putString(1, name);

of my code snippet. I really dont understand because name is not null and I tried printing out. Doing some google I found this "Have you closed the result set, statement, or db connection? Don't close and then call next(), premature closing will get you that exception" The answer is "no" I am not closing any statement before the next statement. The weird thing is I used the same code for uploading another table it just worked fine. I am not sure what could be wrong..can someone please help me.

  
 ResultSet rs = null;
        try{
               _up = _conn.prepareStatement( "sql");        

             String id=(String)map.get("ID");              
            System.out.println("id "+ id);
           
            if(rs.next()){

                String name=(String)map.get("NAME");             

                DelegatingResultSet drs = (DelegatingResultSet)rs;

                OracleResultSet ors = (OracleResultSet)drs.getDelegate();
                CLOB clob = ors.getCLOB(1);
             
                
                System.out.println("name "+name);                                          
                clob.putString(1, name);                              
                                        
                _up.setClob(1, clob);        
                _up.setString(2, id);

                                              
                 _up.executeUpdate();
            }
         }catch(SQLException e) {

             throw new SQLException(e.toString());
         }finally{
             try{
                 if(rs != null)
                     rs.close();

             }catch(SQLException e){
                              }
         }
        
    }

[Fatih Keles]

Hi Romeo,

I recall String operations for larger than 32k string in clob fails for some drivers. You can try streams for clob.