String query1 = "select substr(to_char(max_data),1,4) as year, " + "substr(to_char(max_data),5,6) as month, max_data " + "from dss_fin_user.acq_dashboard_src_load_success " + "where source = 'CHQ PeopleSoft FS'"; String query2 = "....."; String sql = "insert into domo_queries (clob_column) values (?)"; PreparedStatement pstmt = con.prepareStatement(sql); StringReader reader = new StringReader(query1); pstmt.setCharacterStream(1, reader, query1.length()); pstmt.addBatch(); reader = new StringReader(query2); pstmt.setCharacterStream(1, reader, query2.length()); pstmt.addBatch(); pstmt.executeBatch(); con.commit();
@Override public final void setCharacterStream(final int parameterIndex, final Reader x, final int length) throws SQLException { getTargetPreparedStatement().setCharacterStream(parameterIndex, x, length); }
@Override public final void setCharacterStream(final int parameterIndex, final Reader x, final long length) throws SQLException { getTargetPreparedStatement().setCharacterStream(parameterIndex, x, length); }
ps.setCharacterStream(paramIndex, characterStream, contentLength); ps.setCharacterStream(paramIndex, characterStream);
@Override public final void setCharacterStream(final int parameterIndex, final Reader x) throws SQLException { getTargetPreparedStatement().setCharacterStream(parameterIndex, x); }
@Override public void setCharacterStream(int parameterIndex, Reader reader, int length) throws SQLException { setParamByIndex(parameterIndex, reader); targetStatement.setCharacterStream(parameterIndex, reader, length); }
@Override public void setCharacterStream(int parameterIndex, Reader reader, long length) throws SQLException { setParamByIndex(parameterIndex, reader); targetStatement.setCharacterStream(parameterIndex, reader, length); }
@Override public void setCharacterStream(int parameterIndex, Reader reader) throws SQLException { setParamByIndex(parameterIndex, reader); targetStatement.setCharacterStream(parameterIndex, reader); }
@Override public void setCharacterStream(int parameterIndex, Reader reader) throws SQLException { checkOpen(); try { stmt.setCharacterStream(parameterIndex, reader); } catch (Throwable t) { throw checkException(t); } }
@Override public void setCharacterStream(int parameterIndex, Reader reader, int length) throws SQLException { checkOpen(); try { stmt.setCharacterStream(parameterIndex, reader, length); } catch (Throwable t) { throw checkException(t); } }
@Override public void setCharacterStream(int parameterIndex, Reader reader, long length) throws SQLException { checkOpen(); try { stmt.setCharacterStream(parameterIndex, reader, length); } catch (Throwable t) { throw checkException(t); } }
@Override public void preparedStatement_setCharacterStream(PreparedStatementProxy statement, int parameterIndex, java.io.Reader reader) throws SQLException { if (this.pos < filterSize) { nextFilter().preparedStatement_setCharacterStream(this, statement, parameterIndex, reader); return; } statement.getRawObject().setCharacterStream(parameterIndex, reader); }
@Override public void preparedStatement_setCharacterStream(PreparedStatementProxy statement, int parameterIndex, java.io.Reader reader, int length) throws SQLException { if (this.pos < filterSize) { nextFilter().preparedStatement_setCharacterStream(this, statement, parameterIndex, reader, length); return; } statement.getRawObject().setCharacterStream(parameterIndex, reader, length); }
@Override public void preparedStatement_setCharacterStream(PreparedStatementProxy statement, int parameterIndex, java.io.Reader reader, long length) throws SQLException { if (this.pos < filterSize) { nextFilter().preparedStatement_setCharacterStream(this, statement, parameterIndex, reader, length); return; } statement.getRawObject().setCharacterStream(parameterIndex, reader, length); }
@Override public void set(PreparedStatement prep, int parameterIndex) throws SQLException { long p = getPrecision(); if (p > Integer.MAX_VALUE || p <= 0) { p = -1; } if (type == Value.BLOB) { prep.setBinaryStream(parameterIndex, getInputStream(), (int) p); } else { prep.setCharacterStream(parameterIndex, getReader(), (int) p); } }
@Override public void set(PreparedStatement prep, int parameterIndex) throws SQLException { long p = getPrecision(); if (p > Integer.MAX_VALUE || p <= 0) { p = -1; } if (type == Value.BLOB) { prep.setBinaryStream(parameterIndex, getInputStream(), (int) p); } else { prep.setCharacterStream(parameterIndex, getReader(), (int) p); } }
public Q setCharacterStream(final int index, final Reader reader, final int length) { initPrepared(); try { preparedStatement.setCharacterStream(index, reader, length); } catch (SQLException sex) { throwSetParamError(index, sex); } return _this(); }
@Test public void testSetClobAsCharacterStreamWithoutLength() throws SQLException, IOException { Reader str = new StringReader("testContent"); lobCreator.setClobAsCharacterStream(ps, 1, str, -1); verify(ps).setCharacterStream(1, str); }
@Test public void testSetClobAsCharacterStream() throws SQLException, IOException { Reader str = new StringReader("testContent"); lobCreator.setClobAsCharacterStream(ps, 1, str, 11); verify(ps).setCharacterStream(1, str, 11); }
public Q setCharacterStream(final String param, final Reader reader, final int length) { initPrepared(); final int[] positions = query.getNamedParameterIndices(param); try { for (final int position : positions) { preparedStatement.setCharacterStream(position, reader, length); } } catch (SQLException sex) { throwSetParamError(param, sex); } return _this(); }