Skip to end of metadata
Go to start of metadata

PL-J JDBC Driver

A Java stored procedure uses simple JDBC calls to perform database operations. PL-J has two JDBC Drivers:

  • PostgreSQL Driver, this is derived from the original PostgreSQL JDBC Project.
  • Scratch driver. This is a research driver with many configuration options, prepared statement pool and other features.

In general, the properties of the PL-J JDBC drivers:

  • Does not open connection to the RDBMS, the RDBMS did already open it (inverse behavior)
  • More JDBC connection will operate on the same connection
  • No frontend-backend protocol, it uses the Channel architecture
  • Highly configurable
  • Provides plan pool to reuse already prepared statements
  • Metainformations use the configuration object.
  • Does not use any RDBMS specific code
  • Type mapping using the typemapper architecture
  • Transactions: not supported, will support embeded transactions.
  • And the best: you dont have to know all this, only JDBC programming (and keep an aya on the unimplemented features list)

O/R mapping:

  • In the very far future O/R mapping tools can be integrated to PL-J runtime. Basically when running PL-J triggers, you handle objects.

You dont need to load the classes for the drivers implivitly, the Drivers are pre-registered. An example of stored procedure:

Because of the statement plan pool embeded in the JDBC driver, prepared statements will have better performance than dynamic sql.

~grammar, typos~

Labels
  • None