Package org.postgresql.pljava.example.annotation

package org.postgresql.pljava.example.annotation
The first examples that were converted to test the annotation-driven SQL generator instead of using hand-written SQL deployment code.
Author:
Thomas Hallgren, Chapman Flack
  • Class
    Description
    Aggregates
    A class demonstrating several aggregate functions.
    AnyTest
    Provides example methods to illustrate the polymorphic types any, anyarray, and anyelement.
    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).
    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).
    Modules
    Example code to support querying for the modules in Java's boot layer.
    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.
    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.
    ReturnComposite
    Demonstrates @Function(out={...}) for a function that returns a non-predeclared composite type.
    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.
    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.
    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).
    UsingProperties
    An example that retrieves a Properties resource, and returns (key,value) rows from it by implementing the ResultSetProvider interface.
    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.