Package org.postgresql.pljava.jdbc
PL/Java's specialized JDBC implementation that interacts directly with the
backend over SPI.
Some classes and methods here have departures from strict JDBC behavior that should be covered in their javadoc, or resolved; for now, comments in the code may be helpful in case of any question.
- Author:
- Thomas Hallgren
-
Interface Summary Interface Description SPIReadOnlyControl An extended interface onStatement
(accessible withunwrap()
) allowing control of theread_only
flag that PostgreSQL SPI will see when the statement is next executed. -
Class Summary Class Description AbstractResultSet TheAbstractResultSet
serves as a base class for implementations of theResultSet
interface.AbstractResultSetMetaData Implementation of ResultSetMetaData for SyntheticResultSetBlobValue Implementation ofBlob
for the SPI connection.BuiltinFunctions PostgreSQL builtin functionsClobValue Implementation ofClob
for the SPI connection.Invocation One invocation, from PostgreSQL, of functionality implemented using PL/Java.ObjectResultSet Implements most getters in terms ofObjectResultSet.getValue(int, java.lang.Class<T>)
,ObjectResultSet.getNumber(int, java.lang.Class)
, or a few otherResultSet
getters that are so implemented, trackswasNull
, and providesObjectResultSet.getObjectValue(int)
as the chief method for subclasses to implement; turns most updaters intoResultSet.updateObject(int,Object)
.PgNodeTreeAsXML An adapter presenting PostgreSQL'spg_node_tree
type (a serialized representation of a tree data structure) through the XML API (in, currently, an ad-hoc, schemaless rendering, but one with which some practical use might be made of the information, after a little study).ReadOnlyResultSet Implements all methods that change the ResultSet in any way as methods that yield anUnsupportedFeatureException
.ResultSetBase Provides methods that are common both for a SyntheticResultSet (which is not associated with a statement) and SPIResultSet.ResultSetField Representation of a field to be presented in aSyntheticResultSet
.SingleRowReader A single row, read-only ResultSet, specially made for functions and procedures that takes complex types as arguments (PostgreSQL 7.5 and later).SingleRowResultSet A single row ResultSetSingleRowWriter A single row, updateable ResultSet, specially made for functions and procedures that returns complex types or sets.SPIConnection Provides access to the current connection (session) the Java stored procedure is running in.SPIDatabaseMetaData Implementation ofDatabaseMetaData
for the SPI connection.SPIDriver Implementation ofDriver
for the SPI connection.SPIParameterMetaData Implementation ofParameterMetaData
for the SPI connection.SPIPreparedStatement Implementation ofPreparedStatement
for the SPI connection.SPIResultSet A Read-only ResultSet that provides direct access to aPortal
.SPIResultSetMetaData Implementation of ResultSetMetaData for SPIResultSetSPIStatement Implementation ofStatement
for the SPI connection.SQLInputFromChunk The SQLInputToChunk uses JNI to read from memory that has been allocated by the PostgreSQL backend.SQLInputFromTuple Implements theSQLInput
interface for a user-defined type (UDT) implemented in Java, for the case where a composite type in PostgreSQL is used as the UDT's representation, so it can be accessed as a PG tuple.SQLOutputToChunk The SQLOutputToChunk uses JNI to build a PostgreSQL StringInfo buffer in memory.SQLOutputToTuple Implementation ofSQLOutput
for the case of a composite data type.SQLUtils Helpful utility commands when dealing with JDBCSQLXMLImpl<V extends VarlenaWrapper> Implementation ofSQLXML
for the SPI connection.SyntheticResultSet A Synthetic ResultSet that provides direct access to data stored in aArrayList
; chiefly used to return tabular information from...MetaData
objects.SyntheticResultSetMetaData Implementation of ResultSetMetaData for SyntheticResultSetTriggerResultSet A single row, updateable ResultSet specially made for triggers.TypeBridge<S> Encapsulate some information about Java object classes and their possible mappings to PostgreSQL types.TypeOid Provides constants for well-known backend OIDs for the types we commonly use. -
Exception Summary Exception Description StatementClosedException AnSQLException
specific to the case of attempted use of aStatement
that has been closed.UnsupportedFeatureException AnSQLException
specific to the case of attempted use of an unsupported feature.