Home

Stored Procedure Proxy

To call a stored procedure you need to do two things:

1. create an interface that represents the stored procedures
2. create and instance of the interface

Deriving Names

We have to derive database names from Java names we differentiate between

• objects: procedures, packages, schemas
• parameters

If the Java names do not match the database names then there are different options how we can derive them.

Objects

Parameters

Connection Pooling

We assume the DataSource you provide is a connection pooling DataSource.

Transactions

We don't do transactions. You'll have to do transactions around the stored procedure calls either directly or indirectly through JTA or through Spring or a similar way..

Supported Types

All types that your JDBC driver supports through #getObject and #setObject are supported, we just delegate to the driver. Primitive types are supported and we automatically box and unbox them for you.