The examples that have been around the longest, and are deployed using hand-written SQL deployment code (see
src/main/resources/deployment), not having been reworked to use annotations yet.
- Thomas Hallgren
Class Summary Class Description BinaryColumnTest HugeResultSetExample implementing
ResultSetProviderto 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.
LoggerTestProvides a function to log, at the specified level, a specified message. MetaDataBooleansExample returning (varchar,boolean) rows, one for each boolean-valued attribute in the JDBC
MetaDataIntsExample returning (varchar,int) rows, one for each int-valued attribute in the JDBC
MetaDataStringsExample returning (varchar,varchar) rows, one for each String-valued attribute in the JDBC
MetaDataTest RandomIntsProvides a
functionproducing as many rows as requested, each with a random int.
functionthat takes any SQL
SELECTquery as a string, executes it, and returns the
ResultSetproduced as a single string column, the first row being a header, then one per row of the
ResultSet, semicolons delimiting the original columns.
createTempFilefunction, expected to fail if it is declared with the trusted
ThreadsThis class contains thread related methods. TriggersThis class contains some triggers that I found written in C under the contrib/spi directory of the postgres source distribution. TupleReturnIllustrates various methods of returning composite values. Users UsingPropertiesIllustrates use of the
ResultSetProviderinterface to return (key,value) rows from the
example.propertiesfile, also making use of PL/Java's
UsingPropertiesAsResultSetThis implementation uses another function that returns a set of a complex type and returns the ResultSet produced by a query. UsingPropertiesAsScalarSetThis 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.