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 Throw Custom Error Message on Stored Procedure or UDF Exception Java Class Reference Introduction DhSQLException DhSQLException.getDiagnostics DhSQLException.getMessageText DhSQLException.getSqlState 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