FairCom Java & .NET Stored Procedures

 
FairCom Java and .NET Stored Procedures, Triggers, and User Defined Functions
Overview of Stored Procedures
Advantages of Stored Procedures
Java Stored Procedures, Triggers, and UDFs
Creating Stored Procedures
Calling Stored Procedures
LVARCHAR Fields Allowed in Stored Procedure Code
Java Stored Procedures and Triggers Require JDK V1.7 or Newer
SQL Stored Procedures - Close cursors that were left open
Java Quick Tour
NetBeans Plugin for Java
Setting up the Connection to the Server
Installing the NetBeans Plugin
Editing Stored Procedures
Enabling Debugging
Throw Custom Error Message on Stored Procedure or UDF Exception
Java Class Reference
Introduction
DhSQLException
DhSQLException.getDiagnostics
DhSQLResultSet
DhSQLResultSet.set
DhSQLResultSet.makeNULL
DhSQLResultSet.insert
SQLCursor
SQLCursor.close
SQLCursor.fetch
SQLCursor.found
SQLCursor.getLongValue
SQLCursor.getParam
SQLCursor.getValue
SQLCursor.makeNULL
SQLCursor.open
SQLCursor.registerOutParam
SQLCursor.rowCount
SQLCursor.setParam
SQLCursor.wasNULL
SQLIStatement
SQLIStatement.execute
SQLIStatement.getParam
SQLIStatement.makeNULL
SQLIStatement.registerOutParam
SQLIStatement.rowCount
SQLIStatement.setParam
SQLPStatement
SQLPStatement.execute
SQLPStatement.getParam
SQLPStatement.makeNULL
SQLPStatement.registerOutParam
SQLPStatement.rowCount
SQLPStatement.setParam
Using FairCom DB SQL Java Classes
Passing Values to SQL Statements
The setParam Method: Pass Input Values to SQL Statements
The getValue Method: Pass Values from SQL Result Sets to Variables
Passing Values to and From Stored Procedures: Input and Output Parameters
Implicit Data Type Conversion Between SQL and Java Types
Executing an SQL Statement
Immediate Execution
Prepared Execution
Retrieving Data: the SQLCursor Class
registerOutParam Method: registering the Type of OUT and INOUT Variables
Returning a Procedure Result Set with SQLResultSet
Handling Null Values
Setting SQL Statement Input Params & Procedure Result SetFields to Null
Assigning Null Values from Result Sets:SQLCursor.wasNULL Method
Handling Errors
Calling Stored Procedures from Stored Procedures
Debugging Java Stored Procedures
Enabling Java Debugging Tools
JSWAT Example
Using Java Stored Procedures
Stored Procedure Basics
What Is a Java Snippet?
Structure of Stored Procedures
Setting Up Your Environment to Write Stored Procedures
Writing Stored Procedures
Invoking Stored Procedures
Modifying and Deleting Stored Procedures
Debugging Stored Procedures
Transactions and Stored Procedures
Stored Procedure Security
Restrictions on Calling Java Methods in Stored Procedures
Using Triggers
Trigger Basics
Triggers vs. Stored Procedures vs. Constraints
Typical Uses for Triggers
Restrictions on Creating Triggers
Structure of Triggers
Create Trigger
OLDROW and NEWROW Objects: Passing Values to Triggers
Dynamically Disable Triggers
Using User-Defined Scalar Functions
Introduction
Structure of User-Defined Functions
Create Function
Drop Function
Invoking User-Defined Scalar Functions
With Constants
With Constants and Column References
With parameter reference (ODBC/JDBC)
User-Defined Scalar Function Security
Calling Scalar Functions from a User Defined Scalar Function
.NET Support
Visual Studio .NET Development
.NET Tutorials
Mapping Between SQL Types and .NET Types
The .NET Ctree.SqlSP Assembly
SqlSpBase
SqlStoredProc
SqlUdf
SqlTrigger
SqlSpRow
SqlSpColumn
SqlSpCommand
SqlException
Glossary
FairCom Typographical Conventions
Copyright Notice
Index