Package org.postgresql.pljava.example.annotation

Class SPIActions

java.lang.Object

org.postgresql.pljava.example.annotation.SPIActions

@SQLAction(provides="employees tables",install={"CREATE TABLE javatest.employees1 ( id     int PRIMARY KEY, name   varchar(200), salary int )","CREATE TABLE javatest.employees2 ( id\t\tint PRIMARY KEY, name\tvarchar(200), salary\tint, transferDay date, transferTime time )"},remove={"DROP TABLE javatest.employees2","DROP TABLE javatest.employees1"}) @SQLAction(requires="issue228",install="SELECT javatest.issue228()")
public class SPIActions
extends Object

Some methods used for testing the SPI JDBC driver.

Author:

Thomas Hallgren

Constructor Summary

Constructors

Constructor	Description
SPIActions()

Method Summary

Modifier and Type	Method	Description
static String	getDateAsString()
static String	getTimeAsString()
static void	issue228()	Confirm JDBC behavior of Savepoint, in particular that a Savepoint rolled back to still exists and can be rolled back to again or released.
static int	maxFromSetReturnExample(int base, int increment)
static void	nestedStatements(int innerCount)	Test of bug #1556
static void	registerTransactionListener()
static int	testSavepointSanity()
static int	testTransactionRecovery()
static int	transferPeopleWithSalary(int salary)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SPIActions

public SPIActions()

Method Detail

getDateAsString

@Function(schema="javatest",
          effects=STABLE)
public static String getDateAsString()
                              throws SQLException

Throws:

SQLException

getTimeAsString

@Function(schema="javatest",
          effects=STABLE)
public static String getTimeAsString()
                              throws SQLException

Throws:

SQLException

maxFromSetReturnExample

@Function(schema="javatest",
          effects=IMMUTABLE)
public static int maxFromSetReturnExample(int base,
                                          int increment)
                                   throws SQLException

Throws:

SQLException

nestedStatements

@Function(schema="javatest")
public static void nestedStatements(int innerCount)
                             throws SQLException

Test of bug #1556

Throws:

SQLException

testSavepointSanity

@Function(schema="javatest",
          effects=IMMUTABLE)
public static int testSavepointSanity()
                               throws SQLException

Throws:

SQLException

issue228

@Function(schema="javatest",
          provides="issue228")
public static void issue228()
                     throws SQLException

Confirm JDBC behavior of Savepoint, in particular that a Savepoint rolled back to still exists and can be rolled back to again or released.

Throws:

SQLException

testTransactionRecovery

@Function(schema="javatest",
          effects=IMMUTABLE)
public static int testTransactionRecovery()
                                   throws SQLException

Throws:

SQLException

transferPeopleWithSalary

@Function(schema="javatest",
          name="transferPeople")
public static int transferPeopleWithSalary(int salary)
                                    throws SQLException

Throws:

SQLException

registerTransactionListener

public static void registerTransactionListener()
                                        throws SQLException

Throws:

SQLException