public void insertClobForStreamingLoad(Row row, Column col, Object ob) throws SQLException { if (ob == null) { col.setType(Types.OTHER); row.setNull(col); } else { row.setClob(col, getEmptyClob()); } }
public void insertClobForStreamingLoad(Row row, Column col, Object ob) throws SQLException { if (ob == null) { col.setType(Types.OTHER); row.setNull(col); } else { row.setClob(col, getEmptyClob()); } }
public void insertClobForStreamingLoad(Row row, Column col, Object ob) throws SQLException { if (ob == null) { col.setType(Types.OTHER); row.setNull(col); } else { row.setClob(col, getEmptyClob()); } }
public void insertClobForStreamingLoad(Row row, Column col, Object ob) throws SQLException { if (ob == null) { col.setType(Types.OTHER); row.setNull(col); } else { row.setClob(col, getEmptyClob()); } }
stmnt.setClob(idx, getEmptyClob()); else { super.setClobString(stmnt, idx, val, col);
stmnt.setClob(idx, getEmptyClob()); else { super.setClobString(stmnt, idx, val, col);
stmnt.setClob(idx, getEmptyClob()); else { super.setClobString(stmnt, idx, val, col);
stmnt.setClob(idx, getEmptyClob()); else { super.setClobString(stmnt, idx, val, col);
public void setNull(PreparedStatement stmnt, int idx, int colType, Column col) throws SQLException { if (colType == Types.BLOB && _driverBehavior == BEHAVE_ORACLE) stmnt.setBlob(idx, getEmptyBlob()); else if (colType == Types.CLOB && _driverBehavior == BEHAVE_ORACLE && !col.isXML()) stmnt.setClob(idx, getEmptyClob()); else if ((colType == Types.STRUCT || colType == Types.OTHER) && col != null && col.getTypeName() != null) stmnt.setNull(idx, Types.STRUCT, col.getTypeName()); // some versions of the Oracle JDBC driver will fail if calling // setNull with DATE; see bug #1171 else if (colType == Types.DATE) super.setNull(stmnt, idx, Types.TIMESTAMP, col); // the Oracle driver does not support Types.OTHER with setNull else if (colType == Types.OTHER || col.isXML()) super.setNull(stmnt, idx, Types.NULL, col); else super.setNull(stmnt, idx, colType, col); }
@Override public void setNull(PreparedStatement stmnt, int idx, int colType, Column col) throws SQLException { if ((colType == Types.CLOB || colType == Types.BLOB) && col.isNotNull()) throw new UserException(_loc.get("null-blob-in-not-nullable", toDBName(col .getFullDBIdentifier()))); if (colType == Types.BLOB && _driverBehavior == BEHAVE_ORACLE) stmnt.setBlob(idx, getEmptyBlob()); else if (colType == Types.CLOB && _driverBehavior == BEHAVE_ORACLE && !col.isXML()) stmnt.setClob(idx, getEmptyClob()); else if ((colType == Types.STRUCT || colType == Types.OTHER) && col != null && !DBIdentifier.isNull(col.getTypeIdentifier())) stmnt.setNull(idx, Types.STRUCT, col.getTypeIdentifier().getName()); // some versions of the Oracle JDBC driver will fail if calling // setNull with DATE; see bug #1171 else if (colType == Types.DATE) super.setNull(stmnt, idx, Types.TIMESTAMP, col); // the Oracle driver does not support Types.OTHER with setNull else if (colType == Types.OTHER || col.isXML()) super.setNull(stmnt, idx, Types.NULL, col); else super.setNull(stmnt, idx, colType, col); }
@Override public void setNull(PreparedStatement stmnt, int idx, int colType, Column col) throws SQLException { if ((colType == Types.CLOB || colType == Types.BLOB) && col.isNotNull()) throw new UserException(_loc.get("null-blob-in-not-nullable", toDBName(col .getFullDBIdentifier()))); if (colType == Types.BLOB && _driverBehavior == BEHAVE_ORACLE) stmnt.setBlob(idx, getEmptyBlob()); else if (colType == Types.CLOB && _driverBehavior == BEHAVE_ORACLE && !col.isXML()) stmnt.setClob(idx, getEmptyClob()); else if ((colType == Types.STRUCT || colType == Types.OTHER) && col != null && !DBIdentifier.isNull(col.getTypeIdentifier())) stmnt.setNull(idx, Types.STRUCT, col.getTypeIdentifier().getName()); // some versions of the Oracle JDBC driver will fail if calling // setNull with DATE; see bug #1171 else if (colType == Types.DATE) super.setNull(stmnt, idx, Types.TIMESTAMP, col); // the Oracle driver does not support Types.OTHER with setNull else if (colType == Types.OTHER || col.isXML()) super.setNull(stmnt, idx, Types.NULL, col); else super.setNull(stmnt, idx, colType, col); }
@Override public void setNull(PreparedStatement stmnt, int idx, int colType, Column col) throws SQLException { if ((colType == Types.CLOB || colType == Types.BLOB) && col.isNotNull()) throw new UserException(_loc.get("null-blob-in-not-nullable", toDBName(col .getFullDBIdentifier()))); if (colType == Types.BLOB && _driverBehavior == BEHAVE_ORACLE) stmnt.setBlob(idx, getEmptyBlob()); else if (colType == Types.CLOB && _driverBehavior == BEHAVE_ORACLE && !col.isXML()) stmnt.setClob(idx, getEmptyClob()); else if ((colType == Types.STRUCT || colType == Types.OTHER) && col != null && !DBIdentifier.isNull(col.getTypeIdentifier())) stmnt.setNull(idx, Types.STRUCT, col.getTypeIdentifier().getName()); // some versions of the Oracle JDBC driver will fail if calling // setNull with DATE; see bug #1171 else if (colType == Types.DATE) super.setNull(stmnt, idx, Types.TIMESTAMP, col); // the Oracle driver does not support Types.OTHER with setNull else if (colType == Types.OTHER || col.isXML()) super.setNull(stmnt, idx, Types.NULL, col); else super.setNull(stmnt, idx, colType, col); }
@Override public void setNull(PreparedStatement stmnt, int idx, int colType, Column col) throws SQLException { if ((colType == Types.CLOB || colType == Types.BLOB) && col.isNotNull()) throw new UserException(_loc.get("null-blob-in-not-nullable", toDBName(col .getFullDBIdentifier()))); if (colType == Types.BLOB && _driverBehavior == BEHAVE_ORACLE) stmnt.setBlob(idx, getEmptyBlob()); else if (colType == Types.CLOB && _driverBehavior == BEHAVE_ORACLE && !col.isXML()) stmnt.setClob(idx, getEmptyClob()); else if ((colType == Types.STRUCT || colType == Types.OTHER) && col != null && !DBIdentifier.isNull(col.getTypeIdentifier())) stmnt.setNull(idx, Types.STRUCT, col.getTypeIdentifier().getName()); // some versions of the Oracle JDBC driver will fail if calling // setNull with DATE; see bug #1171 else if (colType == Types.DATE) super.setNull(stmnt, idx, Types.TIMESTAMP, col); // the Oracle driver does not support Types.OTHER with setNull else if (colType == Types.OTHER || col.isXML()) super.setNull(stmnt, idx, Types.NULL, col); else super.setNull(stmnt, idx, colType, col); }