How to use
addFunctions
method
in
org.postgresql.fastpath.Fastpath

Best Java code snippets using org.postgresql.fastpath.Fastpath.addFunctions (Showing top 4 results out of 315)

Common ways to obtain Fastpath

private void myMethod () {
 Fastpath f =BaseConnection baseConnection;baseConnection.getFastpathAPI()
AbstractJdbc2Connection abstractJdbc2Connection;new Fastpath(abstractJdbc2Connection)
Smart code suggestions by Codota
}

fp.addFunctions(res);
res.close();
stmt.close();

  throw new PSQLException(GT.tr("Failed to initialize LargeObject API"), PSQLState.SYSTEM_ERROR);
fp.addFunctions(res);
res.close();

  throw new PSQLException(GT.tr("Failed to initialize LargeObject API"), PSQLState.SYSTEM_ERROR);
fp.addFunctions(res);
res.close();

  throw new PSQLException(GT.tr("Failed to initialize LargeObject API"), PSQLState.SYSTEM_ERROR);
fp.addFunctions(res);
res.close();

Javadoc

This takes a ResultSet containing two columns. Column 1 contains the function name, Column 2 the oid.

It reads the entire ResultSet, loading the values into the function table.

REMEMBER to close() the resultset after calling this!!

Implementation note about function name lookups:

PostgreSQL stores the function id's and their corresponding names in the pg_proc table. To speed things up locally, instead of querying each function from that table when required, a Hashtable is used. Also, only the function's required are entered into this table, keeping connection times as fast as possible.

The org.postgresql.largeobject.LargeObject class performs a query upon it's startup, and passes the returned ResultSet to the addFunctions() method here.

Once this has been done, the LargeObject api refers to the functions by name.

Dont think that manually converting them to the oid's will work. Ok, they will for now, but they can change during development (there was some discussion about this for V7.0), so this is implemented to prevent any unwarranted headaches in the future.

Popular methods of Fastpath

<init>
Initialises the fastpath system
createOIDArg
Creates a FastpathArg with an oid parameter. This is here instead of a constructor of FastpathArg be
fastpath
Send a function call to the PostgreSQL backend by name. Note: the mapping for the procedure name to
getData
This convenience method assumes that the return value is not an Integer
getID
This returns the function id associated by its name.If addFunction() or addFunctions() have not been
getInteger
This convenience method assumes that the return value is an Integer
getOID
This convenience method assumes that the return value is an oid.
getLong
This convenience method assumes that the return value is a long (bigint).

Popular in Java

Start an intent from android
runOnUiThread (Activity)
orElseThrow (Optional)
Return the contained value, if present, otherwise throw an exception to be created by the provided s
startActivity (Activity)
GridBagLayout (java.awt)
The GridBagLayout class is a flexible layout manager that aligns components vertically and horizonta
Collections (java.util)
This class consists exclusively of static methods that operate on or return collections. It contains
LinkedList (java.util)
Doubly-linked list implementation of the List and Dequeinterfaces. Implements all optional list oper
TreeMap (java.util)
A Red-Black tree based NavigableMap implementation. The map is sorted according to the Comparable of
Base64 (org.apache.commons.codec.binary)
Provides Base64 encoding and decoding as defined by RFC 2045.This class implements section 6.8. Base
FileUtils (org.apache.commons.io)
General file manipulation utilities. Facilities are provided in the following areas: * writing to a

How to use addFunctionsmethodin org.postgresql.fastpath.Fastpath

Best Java code snippets using org.postgresql.fastpath.Fastpath.addFunctions (Showing top 4 results out of 315)

How to use
addFunctions
method
in
org.postgresql.fastpath.Fastpath