Advanced JDBC Connector Functionality

The previous example created a graphical user interface that displayed a result set in a JTable. Now we will switch gears and show you some of the more advanced features of the Advanced Server JDBC Connector.

To avoid unnecessary clutter, the rest of the code samples in this document will use the console to interact with the user instead of creating a graphical use interface.

• Reducing Client-side Resource Requirements
  • Modifying the Batch Size of a Statement Object
• Using PreparedStatements to Send SQL Commands
• Executing Stored Procedures
  • Invoking Stored Procedures
    • Executing a Simple Stored Procedure
    • Executing Stored Procedures with IN parameters
    • Executing Stored Procedures with OUT parameters
    • Executing Stored Procedures with IN OUT parameters
• Using REF CURSORS with Java
  • Using a REF CURSOR to retrieve a ResultSet
• Using BYTEA Data with Java
  • Inserting BYTEA Data into an Advanced Server Database
  • Retrieving BYTEA Data from an Advanced Server Database
• Using Object Types and Collections with Java
  • Using an Object Type
  • Using a Collection
• Asynchronous Notification Handling with NoticeListener