/** * <p>This creates a large object, returning its OID.</p> * * <p>It defaults to READWRITE for the new object's attributes.</p> * * @return oid of new object * @throws SQLException if something wrong happens */ public long createLO() throws SQLException { return createLO(READWRITE); }
/** * This creates a large object, returning its OID. * * <p>It defaults to READWRITE for the new object's attributes. * * @return oid of new object */ public long createLO() throws SQLException { return createLO(READWRITE); }
/** * This creates a large object, returning its OID * * @param mode a bitmask describing different attributes of the new object * @return oid of new object * @exception SQLException on error * @deprecated As of 8.3, replaced by {@link #createLO(int)} */ public int create(int mode) throws SQLException { long oid = createLO(mode); return (int)oid; }
/** * This creates a large object, returning its OID. * * @param mode a bitmask describing different attributes of the new object * @return oid of new object * @throws SQLException on error * @deprecated As of 8.3, replaced by {@link #createLO(int)} */ @Deprecated public int create(int mode) throws SQLException { long oid = createLO(mode); return (int) oid; }
protected long createBlob(int i, InputStream inputStream, long length) throws SQLException { LargeObjectManager lom = connection.getLargeObjectAPI(); long oid = lom.createLO(); LargeObject lob = lom.open(oid); OutputStream outputStream = lob.getOutputStream();
long oid = lom.createLO(); LargeObject lob = lom.open(oid); OutputStream los = lob.getOutputStream();
int l_length = (int) x.length(); LargeObjectManager lom = connection.getLargeObjectAPI(); long oid = lom.createLO(); LargeObject lob = lom.open(oid); Charset connectionCharset = Charset.forName(connection.getEncoding().name());
int l_length = (int) x.length(); LargeObjectManager lom = connection.getLargeObjectAPI(); long oid = lom.createLO(); LargeObject lob = lom.open(oid); OutputStream los = lob.getOutputStream();
long oid = lom.createLO(); LargeObject lob = lom.open(oid); OutputStream los = lob.getOutputStream();
long oid = lom.createLO(); LargeObject lob = lom.open(oid); OutputStream los = lob.getOutputStream();
public void setBytes(int parameterIndex, byte[] x) throws SQLException { checkClosed(); if (null == x) { setNull(parameterIndex, Types.VARBINARY); return ; } if (connection.haveMinimumCompatibleVersion("7.2")) { //Version 7.2 supports the bytea datatype for byte arrays byte[] copy = new byte[x.length]; System.arraycopy(x, 0, copy, 0, x.length); preparedParameters.setBytea( parameterIndex, copy, 0, x.length); } else { //Version 7.1 and earlier support done as LargeObjects LargeObjectManager lom = connection.getLargeObjectAPI(); long oid = lom.createLO(); LargeObject lob = lom.open(oid); lob.write(x); lob.close(); setLong(parameterIndex, oid); } }
/** * This creates a large object, returning its OID. * * <p>It defaults to READWRITE for the new object's attributes. * * @return oid of new object */ public long createLO() throws SQLException { return createLO(READWRITE); }
/** * This creates a large object, returning its OID * * @param mode a bitmask describing different attributes of the new object * @return oid of new object * @exception SQLException on error * @deprecated As of 8.3, replaced by {@link #createLO(int)} */ public int create(int mode) throws SQLException { long oid = createLO(mode); return (int)oid; }
/** * This creates a large object, returning its OID. * * <p>It defaults to READWRITE for the new object's attributes. * * @return oid of new object */ public long createLO() throws SQLException { return createLO(READWRITE); }
/** * This creates a large object, returning its OID * * @param mode a bitmask describing different attributes of the new object * @return oid of new object * @exception SQLException on error * @deprecated As of 8.3, replaced by {@link #createLO(int)} */ public int create(int mode) throws SQLException { long oid = createLO(mode); return (int)oid; }
LargeObjectManager largeObjectManager = null; LargeObject largeObject = null; Long largeObjectRef = null; largeObjectManager = ((org.postgresql.PGConnection) connection).getLargeObjectAPI(); largeObjectRef = largeObjectManager.createLO(LargeObjectManager.READ | LargeObjectManager.WRITE); largeObject = largeObjectManager.open(largeObjectRef, LargeObjectManager.WRITE); largeObject.write("string/file content to write into oid column".getBytes()); largeObject.close();
private void doWritePostgres(Handle h, String path, InputStream file) { doDelete(h, path); try { LargeObjectManager lobj = getPostgresConnection(h.getConnection()).getLargeObjectAPI(); long oid = lobj.createLO(); LargeObject obj = lobj.open(oid, LargeObjectManager.WRITE); try (OutputStream lob = obj.getOutputStream()) { IOUtils.copy(file, lob); } h.insert("INSERT INTO filestore(path, data) values (?,?)", path, oid); } catch (IOException | SQLException ex) { throw DaoException.launderThrowable(ex); } }
private void doWritePostgres(Handle h, String path, InputStream file) { doDelete(h, path); try { LargeObjectManager lobj = getPostgresConnection(h.getConnection()).getLargeObjectAPI(); long oid = lobj.createLO(); LargeObject obj = lobj.open(oid, LargeObjectManager.WRITE); try (OutputStream lob = obj.getOutputStream()) { IOUtils.copy(file, lob); } h.insert("INSERT INTO filestore(path, data) values (?,?)", path, oid); } catch (IOException | SQLException ex) { throw ExtensionDataAccessException.launderThrowable(ex); } }
private void doWritePostgres(Handle h, String id, InputStream file) { doDelete(h, id); try { LargeObjectManager lobj = getPostgresConnection(h.getConnection()).getLargeObjectAPI(); long oid = lobj.createLO(); LargeObject obj = lobj.open(oid, LargeObjectManager.WRITE); try (OutputStream lob = obj.getOutputStream()) { IOUtils.copy(file, lob); } h.insert("INSERT INTO icon_filestore(id, data) values (?,?)", id, oid); } catch (IOException | SQLException ex) { throw IconDataAccessException.launderThrowable(ex); } }
private void doWritePostgres(Handle h, String path, InputStream file) { doDelete(h, path); try { LargeObjectManager lobj = getPostgresConnection(h.getConnection()).getLargeObjectAPI(); long oid = lobj.createLO(); LargeObject obj = lobj.open(oid, LargeObjectManager.WRITE); try (OutputStream lob = obj.getOutputStream()) { IOUtils.copy(file, lob); } h.insert("INSERT INTO filestore(path, data) values (?,?)", path, oid); } catch (IOException | SQLException ex) { throw DaoException.launderThrowable(ex); } }