Examples with Ref java.sql.Ref used on opensource projects

Example 1 with Ref

use of java.sql.Ref in project robovm by robovm.

the class OldPreparedStatementTest method testSetRef.

public void testSetRef() {
    ResultSet res = null;
    PreparedStatement ps = null;
    Ref mock = new MockRef();
    try {
        String neverExecutedQuery = "select TBlob from type;";
        ps = conn.prepareStatement(neverExecutedQuery);
        ps.setRef(1, mock);
        fail("Exception expected not supported");
    } catch (SQLException e) {
    //ok
    }
}

Example 2 with Ref

use of java.sql.Ref in project jdk8u_jdk by JetBrains.

the class CommonCachedRowSetTests method createDataTypesRows.

/*
     * Add rows to DATAYPES table
     */
protected void createDataTypesRows(RowSet crs) throws SQLException {
    Integer aInteger = 100;
    String aChar = "Oswald Cobblepot";
    Long aLong = Long.MAX_VALUE;
    Short aShort = Short.MAX_VALUE;
    Double aDouble = Double.MAX_VALUE;
    BigDecimal aBigDecimal = BigDecimal.ONE;
    Boolean aBoolean = false;
    Float aFloat = Float.MAX_VALUE;
    Byte aByte = Byte.MAX_VALUE;
    Date aDate = Date.valueOf(LocalDate.now());
    Time aTime = Time.valueOf(LocalTime.now());
    Timestamp aTimeStamp = Timestamp.valueOf(LocalDateTime.now());
    Array aArray = new StubArray("INTEGER", new Object[1]);
    Ref aRef = new SerialRef(new StubRef("INTEGER", query));
    byte[] bytes = new byte[10];
    crs.moveToInsertRow();
    crs.updateInt(1, aInteger);
    crs.updateString(2, aChar);
    crs.updateString(3, aChar);
    crs.updateLong(4, aLong);
    crs.updateBoolean(5, aBoolean);
    crs.updateShort(6, aShort);
    crs.updateDouble(7, aDouble);
    crs.updateBigDecimal(8, aBigDecimal);
    crs.updateFloat(9, aFloat);
    crs.updateByte(10, aByte);
    crs.updateDate(11, aDate);
    crs.updateTime(12, aTime);
    crs.updateTimestamp(13, aTimeStamp);
    crs.updateBytes(14, bytes);
    crs.updateArray(15, aArray);
    crs.updateRef(16, aRef);
    crs.updateDouble(17, aDouble);
    crs.insertRow();
    crs.moveToCurrentRow();
}

Example 3 with Ref

use of java.sql.Ref in project jdk8u_jdk by JetBrains.

the class BaseRowSetTests method testAdvancedParameters.

/*
     * DataProvider used to set advanced parameters for types that are supported
     */
@DataProvider(name = "testAdvancedParameters")
private Object[][] testAdvancedParameters() throws SQLException {
    byte[] bytes = new byte[10];
    Ref aRef = new SerialRef(new StubRef("INTEGER", query));
    Array aArray = new SerialArray(new StubArray("INTEGER", new Object[1]));
    Blob aBlob = new SerialBlob(new StubBlob());
    Clob aClob = new SerialClob(new StubClob());
    Reader rdr = new StringReader(query);
    InputStream is = new StringBufferInputStream(query);
    ;
    brs = new StubBaseRowSet();
    brs.setBytes(1, bytes);
    brs.setAsciiStream(2, is, query.length());
    brs.setRef(3, aRef);
    brs.setArray(4, aArray);
    brs.setBlob(5, aBlob);
    brs.setClob(6, aClob);
    brs.setBinaryStream(7, is, query.length());
    brs.setUnicodeStream(8, is, query.length());
    brs.setCharacterStream(9, rdr, query.length());
    return new Object[][] { { 1, bytes }, { 2, is }, { 3, aRef }, { 4, aArray }, { 5, aBlob }, { 6, aClob }, { 7, is }, { 8, is }, { 9, rdr } };
}

Example 4 with Ref

use of java.sql.Ref in project jdk8u_jdk by JetBrains.

the class SQLInputImplTests method test09.

/*
     * Validate a Ref can be read
     */
@Test(enabled = true)
public void test09() throws Exception {
    Ref ref = new StubRef(sqlType, hero);
    Object[] values = { ref };
    SQLInputImpl sqli = new SQLInputImpl(values, map);
    Ref ref2 = sqli.readRef();
    assertTrue(ref.getObject().equals(ref2.getObject()));
    assertTrue(ref.getBaseTypeName().equals(ref2.getBaseTypeName()));
}

Example 5 with Ref

use of java.sql.Ref in project jdk8u_jdk by JetBrains.

the class SQLOutputImplTests method test07.

/*
     * Validate a Ref can be written and returned
     */
@Test(enabled = true)
public void test07() throws Exception {
    Ref ref = new StubRef(sqlType, hero);
    outImpl.writeRef(ref);
    SerialRef sr = (SerialRef) results.get(0);
    assertTrue(hero.equals(sr.getObject()));
}