Examples of java.sql.CallableStatement.wasNull()

java.sql.CallableStatement.wasNull()
Retrieves whether the last OUT parameter read had the value of SQL NULL. Note that this method should be called only after calling a getter method; otherwise, there is no value to use in determining whether it is null or not. @return true if the last parameter read was SQLNULL; false otherwise @exception SQLException if a database access error occurs orthis method is called on a closed CallableStatement


        sField = oCall.getObject(15);
        if (!oCall.wasNull()) put(DB.tx_email_from, sField.toString().trim());


        sField = oCall.getObject(16);
        if (!oCall.wasNull()) put(DB.tx_email_reply, sField.toString().trim());


        sField = oCall.getObject(17);
        if (!oCall.wasNull()) put(DB.nm_from, sField.toString().trim());


        sField = oCall.getObject(18);

View Full Code Here


        sField = oCall.getObject(16);
        if (!oCall.wasNull()) put(DB.tx_email_reply, sField.toString().trim());


        sField = oCall.getObject(17);
        if (!oCall.wasNull()) put(DB.nm_from, sField.toString().trim());


        sField = oCall.getObject(18);
        if (!oCall.wasNull()) put(DB.tx_subject, sField.toString().trim());
      } // fi (bRetVal)

View Full Code Here


        sField = oCall.getObject(17);
        if (!oCall.wasNull()) put(DB.nm_from, sField.toString().trim());


        sField = oCall.getObject(18);
        if (!oCall.wasNull()) put(DB.tx_subject, sField.toString().trim());
      } // fi (bRetVal)


      oCall.close();
    }
    else {

View Full Code Here

        stmt.registerOutParameter(5, Types.DATE);


        stmt.executeUpdate();


        assertEquals(1, stmt.getInt(1));
        assertFalse(stmt.wasNull());
        assertEquals("1", stmt.getString(3));
        assertFalse(stmt.wasNull());
        assertNull(stmt.getDate(5));
        assertTrue(stmt.wasNull());
    }

View Full Code Here

        stmt.executeUpdate();


        assertEquals(1, stmt.getInt(1));
        assertFalse(stmt.wasNull());
        assertEquals("1", stmt.getString(3));
        assertFalse(stmt.wasNull());
        assertNull(stmt.getDate(5));
        assertTrue(stmt.wasNull());
    }
}

View Full Code Here

        assertEquals(1, stmt.getInt(1));
        assertFalse(stmt.wasNull());
        assertEquals("1", stmt.getString(3));
        assertFalse(stmt.wasNull());
        assertNull(stmt.getDate(5));
        assertTrue(stmt.wasNull());
    }
}

View Full Code Here

        try
        {
            ret = call.getBigDecimal(3);
        }catch(NullPointerException ex)
        {
            assertTrue("This should be null",call.wasNull());
        }
    
        
        
    }

View Full Code Here

            cstmt.executeUpdate();
            
            assertTrue( cstmt.getBoolean(1) == true );
            assertTrue( cstmt.getBoolean(2) == false );
            cstmt.getBoolean(3);
            assertTrue(cstmt.wasNull());
        }
        
        finally
        {
            try

View Full Code Here

            
            val = (Double)cstmt.getObject(2);
            assertTrue( val.doubleValue() == doubleValues[1]);
            
            val = (Double)cstmt.getObject(3);            
            assertTrue( cstmt.wasNull() );
        }
        catch ( Exception ex )
        {
            fail(ex.getMessage());
        }

View Full Code Here

            cstmt.registerOutParameter(3,java.sql.Types.DOUBLE);
            cstmt.executeUpdate();
            assertTrue( cstmt.getDouble(1) == 1.0E125 );
            assertTrue( cstmt.getDouble(2) == 1.0E-130);
            cstmt.getDouble(3);
            assertTrue( cstmt.wasNull() );
        }
        catch ( Exception ex )
        {
            fail(ex.getMessage());
        }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.