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

      cStmt.setInt(3, 1);
      cStmt.setInt(4, 1);


      assertFalse(cStmt.execute());
      assertEquals(0f, cStmt.getInt(1), .001);
      assertEquals(true, cStmt.wasNull());
      assertEquals(null, cStmt.getObject(1));
      assertEquals(true, cStmt.wasNull());


      assertEquals(-1, cStmt.executeUpdate());
      assertEquals(0f, cStmt.getInt(1), .001);

View Full Code Here


      assertFalse(cStmt.execute());
      assertEquals(0f, cStmt.getInt(1), .001);
      assertEquals(true, cStmt.wasNull());
      assertEquals(null, cStmt.getObject(1));
      assertEquals(true, cStmt.wasNull());


      assertEquals(-1, cStmt.executeUpdate());
      assertEquals(0f, cStmt.getInt(1), .001);
      assertEquals(true, cStmt.wasNull());
      assertEquals(null, cStmt.getObject(1));

View Full Code Here

      assertEquals(null, cStmt.getObject(1));
      assertEquals(true, cStmt.wasNull());


      assertEquals(-1, cStmt.executeUpdate());
      assertEquals(0f, cStmt.getInt(1), .001);
      assertEquals(true, cStmt.wasNull());
      assertEquals(null, cStmt.getObject(1));
      assertEquals(true, cStmt.wasNull());


      // Check with literals, not all parameters filled!
      cStmt = this.conn.prepareCall("{? = CALL testBug10310(4,5,?)}");

View Full Code Here


      assertEquals(-1, cStmt.executeUpdate());
      assertEquals(0f, cStmt.getInt(1), .001);
      assertEquals(true, cStmt.wasNull());
      assertEquals(null, cStmt.getObject(1));
      assertEquals(true, cStmt.wasNull());


      // Check with literals, not all parameters filled!
      cStmt = this.conn.prepareCall("{? = CALL testBug10310(4,5,?)}");
      cStmt.registerOutParameter(1, Types.INTEGER);
      cStmt.setInt(2, 1);

View Full Code Here

        cStmt.setInt(3, 1);
        cStmt.setInt(4, 1);
        
        assertFalse(cStmt.execute());
        assertEquals(0f, cStmt.getInt(1), .001);
        assertEquals(true, cStmt.wasNull());
        assertEquals(null, cStmt.getObject(1));
        assertEquals(true, cStmt.wasNull());


        assertEquals(-1, cStmt.executeUpdate());
        assertEquals(0f, cStmt.getInt(1), .001);

View Full Code Here

        
        assertFalse(cStmt.execute());
        assertEquals(0f, cStmt.getInt(1), .001);
        assertEquals(true, cStmt.wasNull());
        assertEquals(null, cStmt.getObject(1));
        assertEquals(true, cStmt.wasNull());


        assertEquals(-1, cStmt.executeUpdate());
        assertEquals(0f, cStmt.getInt(1), .001);
        assertEquals(true, cStmt.wasNull());
        assertEquals(null, cStmt.getObject(1));

View Full Code Here

        assertEquals(null, cStmt.getObject(1));
        assertEquals(true, cStmt.wasNull());


        assertEquals(-1, cStmt.executeUpdate());
        assertEquals(0f, cStmt.getInt(1), .001);
        assertEquals(true, cStmt.wasNull());
        assertEquals(null, cStmt.getObject(1));
        assertEquals(true, cStmt.wasNull());


        cStmt = this.conn.prepareCall("{? = CALL testBug10310(4,5,?)}");
        cStmt.registerOutParameter(1, Types.INTEGER);

View Full Code Here


        assertEquals(-1, cStmt.executeUpdate());
        assertEquals(0f, cStmt.getInt(1), .001);
        assertEquals(true, cStmt.wasNull());
        assertEquals(null, cStmt.getObject(1));
        assertEquals(true, cStmt.wasNull());


        cStmt = this.conn.prepareCall("{? = CALL testBug10310(4,5,?)}");
        cStmt.registerOutParameter(1, Types.INTEGER);
        cStmt.setInt(2, 1);

View Full Code Here

    cstmt.setNString(7, "tagPairs");
    cstmt.setLong(8, 9999L);
    cstmt.registerOutParameter(9, java.sql.Types.BIGINT);
    expect(cstmt.execute()).andReturn(true);
    expect(cstmt.getLong(9)).andReturn(99L);
    expect(cstmt.wasNull()).andReturn(false);


    // replay
    replay(configuration, connection, cstmt);


    SqlServerSink sink = new SqlServerSink();

View Full Code Here

    cstmt.setNString(7, "tagPairs");
    cstmt.setLong(8, 9999L);
    cstmt.registerOutParameter(9, java.sql.Types.BIGINT);
    expect(cstmt.execute()).andReturn(true);
    expect(cstmt.getLong(9)).andReturn(99L);
    expect(cstmt.wasNull()).andReturn(true);


    // replay
    replay(configuration, connection, cstmt);


    SqlServerSink sink = new SqlServerSink();

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.