Examples of org.postgresql.largeobject.LargeObjectManager

org.postgresql.largeobject.LargeObjectManager
This class implements the large object interface to org.postgresql.
It provides methods that allow client code to create, open and delete large objects from the database. When opening an object, an instance of org.postgresql.largeobject.LargeObject is returned, and its methods then allow access to the object.
This class can only be created by org.postgresql.Connection
To get access to this class, use the following segment of code:
```
 import org.postgresql.largeobject.*; Connection  conn; LargeObjectManager lobj; ... code that opens a connection ... lobj = ((org.postgresql.PGConnection)myconn).getLargeObjectAPI(); 
```
Normally, client code would use the getAsciiStream, getBinaryStream, or getUnicodeStream methods in ResultSet, or setAsciiStream, setBinaryStream, or setUnicodeStream methods in PreparedStatement to access Large Objects.
However, sometimes lower level access to Large Objects are required, that are not supported by the JDBC specification.
Refer to org.postgresql.largeobject.LargeObject on how to manipulate the contents of a Large Object. @see java.sql.ResultSet#getAsciiStream @see java.sql.ResultSet#getBinaryStream @see java.sql.ResultSet#getUnicodeStream @see java.sql.PreparedStatement#setAsciiStream @see java.sql.PreparedStatement#setBinaryStream @see java.sql.PreparedStatement#setUnicodeStream

            int oid = res.getInt(1);
            if (oid != -1) {
                conn.setAutoCommit(false);
                PGConnection pgconn = (PGConnection)conn
                    .getInnermostDelegate();
                LargeObjectManager lom = pgconn.getLargeObjectAPI();
                if (ob != null) {
                    LargeObject lo = lom.open(oid, LargeObjectManager.WRITE);
                    OutputStream os = lo.getOutputStream();
                    copy((InputStream)ob, os);
                    lo.close();
                } else {
                    lom.delete(oid);
                    row.setInt(col, -1);
                }
            } else {
                if (ob != null) {
                    conn.setAutoCommit(false);
                    PGConnection pgconn = (PGConnection)conn
                        .getInnermostDelegate();
                    LargeObjectManager lom = pgconn.getLargeObjectAPI();
                    oid = lom.create();
                    LargeObject lo = lom.open(oid, LargeObjectManager.WRITE);
                    OutputStream os = lo.getOutputStream();
                    copy((InputStream)ob, os);
                    lo.close();
                    row.setInt(col, oid);
                }

View Full Code Here

            int oid = res.getInt(1);
            if (oid != -1) {
                conn.setAutoCommit(false);
                PGConnection pgconn = (PGConnection)conn
                    .getInnermostDelegate();
                LargeObjectManager lom = pgconn.getLargeObjectAPI();
                lom.delete(oid);
            }
        } finally {
            if (res != null)
                try { res.close (); } catch (SQLException e) {}
            if (stmnt != null)

View Full Code Here

     * @exception SQLException by LargeObject when initialising for first time
     */
    public LargeObjectManager getLargeObjectAPI() throws SQLException
    {
        if (largeobject == null)
            largeobject = new LargeObjectManager(this);
        return largeobject;
    }

View Full Code Here

    private ArrayList subLOs;


    public AbstractJdbc2BlobClob(BaseConnection conn, long oid) throws SQLException
    {
        this.conn = conn;
        LargeObjectManager lom = conn.getLargeObjectAPI();
        this.lo = lom.open(oid);
        subLOs = new ArrayList();
    }

View Full Code Here

     */
    public LargeObjectManager getLargeObjectAPI() throws SQLException
    {
        checkClosed();
        if (largeobject == null)
            largeobject = new LargeObjectManager(this);
        return largeobject;
    }

View Full Code Here

0 1 2 3 4

TOP

Related Classes of org.postgresql.largeobject.LargeObjectManager

com.alexkasko.springjdbc.blob.PostgresBlobTool

org.apache.openjpa.jdbc.sql.PostgresDictionary

org.postgresql.fastpath.FastpathArg

org.postgresql.jdbc2.AbstractJdbc2BlobClob

org.postgresql.jdbc2.AbstractJdbc2Connection

java.sql.Statement

java.sql.ResultSet

org.postgresql.util.PSQLException

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.