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 -
Method Summary
Modifier and TypeMethodDescriptionstatic String
static String
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 #1556static void
static int
static int
static int
transferPeopleWithSalary
(int salary)
-
Constructor Details
-
SPIActions
public SPIActions()
-
-
Method Details
-
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
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
- Throws:
SQLException
-