All Classes

Class	Description
Aggregates	A class demonstrating several aggregate functions.
AnyTest	Provides example methods to illustrate the polymorphic types any, anyarray, and anyelement.
BinaryColumnTest	Example using ResultSetProvider to return 100 rows of two bytea columns each, which should be equal in each row, one being set by updateBinaryStream and the other by updateBytes.
ComplexScalar	Complex (re and im parts are doubles) implemented in Java as a scalar UDT.
ComplexTuple	Complex (re and im parts are doubles) implemented in Java as a mapped UDT.
ConditionalDDR	Test of a very simple form of conditional execution in the deployment descriptor using only the <implementor name> specified for an <implementor block>.
Enumeration	Confirms the mapping of PG enum and Java String, and arrays of each, as parameter and return types.
Holdability	Demonstrate holdability of ResultSets (test for issue 168).
HugeResultSet	Example implementing ResultSetProvider to provide a function that generates and returns a lot of rows (caller passes the desired row count) each containing the row number, a random integer, and a timestamp.
IntWithMod	An integer-like data type accepting a type modifier: IntWithMod(even) or IntWithMod(odd).
JDBC42_21	Exercise new mappings between date/time types and java.time classes (JDBC 4.2 change 21).
LoggerTest	Provides a function to log, at the specified level, a specified message.
MetaDataBooleans	Example returning (varchar,boolean) rows, one for each boolean-valued attribute in the JDBC DatabaseMetaData.
MetaDataInts	Example returning (varchar,int) rows, one for each int-valued attribute in the JDBC DatabaseMetaData.
MetaDataStrings	Example returning (varchar,varchar) rows, one for each String-valued attribute in the JDBC DatabaseMetaData.
MetaDataTest	Provides a callMetaData function taking a string that supplies the name of, and arguments to, any ResultSet-returning DatabaseMetaData method, and returns a single-column varchar result, the first row a header, then one for each ResultSet row, semicolons delimiting the original columns.
OnInterface	Illustrates PL/Java functions on an interface instead of a class.
OnInterface.A
OnInterface.B
OnInterface.B.C
Parameters	Some methods used for testing parameter and return value coersion and resolution of overloaded methods.
PassXML	Class illustrating use of SQLXML to operate on XML data.
PassXML.SQLXMLMock	Class that will mock an SQLXML instance, returning only binary or character stream data from a byte array or string supplied at construction.
PassXML.SQLXMLProxy	Class that will proxy methods to another SQLXML class.
PGF1010962	A gnarly test of TupleDesc reference management, crafted by Johann Oskarsson for bug report 1010962 on pgFoundry.
Point	Example of a "mirrored UDT": a user-defined type that exposes to Java the internal representation of an existing (but not SQL-standard) PostgreSQL type.
PreJSR310	Some tests of pre-JSR 310 date/time/timestamp conversions.
RandomInts	Provides a function producing as many rows as requested, each with a random int.
RecordParameterDefaults	Example demonstrating the use of a RECORD parameter as a way to supply an arbitrary sequence of named, typed parameters to a PL/Java function.
ResultSetTest	Provides a function that takes any SQL SELECT query as a string, executes it, and returns the ResultSet produced as a single string column, the first row being a header, then one per row of the ResultSet, semicolons delimiting the original columns.
ReturnComposite	Demonstrates @Function(out={...}) for a function that returns a non-predeclared composite type.
S9	Class illustrating use of XQuery with Saxon as the implementation, using its native "s9api".
Security	Provides a createTempFile function, expected to fail if it is declared with the trusted java language.
SetOfRecordTest	Example implementing the ResultSetHandle interface, to return the ResultSet from any SQL SELECT query passed as a string to the executeSelect function.
SPIActions	Some methods used for testing the SPI JDBC driver.
Threads	This class contains thread related methods.
ThreadTest	Test control of access to 1-thread backend by n-thread JVM.
Triggers	Example creating a couple of tables, and a function to be called when triggered by insertion into either table.
Triggers	This class contains some triggers that I found written in C under the contrib/spi directory of the postgres source distribution.
TupleReturn	Illustrates various methods of returning composite values.
TypeRoundTripper	A class to simplify testing of PL/Java's mappings between PostgreSQL and Java/JDBC types.
UDTScalarIOTest	A special user-defined type simply to exercise the I/O routines.
UnicodeRoundTripTest	Test that strings containing characters from all Unicode planes are passed between PG and Java without alteration (issue 21).
Users	Uses the ResultSetHandle interface to implement two functions, listNonSupers and listSupers, returning the corresponding subsets of rows from pg_user.
UsingProperties	An example that retrieves a Properties resource, and returns (key,value) rows from it by implementing the ResultSetProvider interface.
UsingProperties	Illustrates use of the ResultSetProvider interface to return (key,value) rows from the example.properties file, also making use of PL/Java's ObjectPool facility.
UsingPropertiesAsResultSet	This implementation uses another function that returns a set of a complex type and returns the ResultSet produced by a query.
UsingPropertiesAsScalarSet	This implementation uses another function that returns a set of a complex type, concatenates the name and value of that type and returns this as a set of a scalar type.
UsingPropertiesAsScalarSet	This implementation uses another function that returns a set of a complex type, concatenates the name and value of that type and returns this as a set of a scalar type.
Variadic	Provides example methods to illustrate variadic functions.
VarlenaUDTTest	A User Defined Type with varlena storage, testing github issue 52.
XMLRenderedTypes	Class illustrating use of SQLXML to operate on non-XML data types for which PL/Java provides an XML rendering.