Java & .NET Stored Procedures Guide

 
Copyright Notice
FairCom Typographical Conventions
Introduction to Stored Procedures, Triggers, and User Defined Functions
Overview
Advantages of Stored Procedures
Java Stored Procedures, Triggers, and UDFs
Creating Stored Procedures
Calling Stored Procedures
Java Stored Procedure and Triggers require JDK V1.7 or newer
Java Quick Tour
Introductory Tutorial
Init
Define
Manage
Done
Additional Resources
Record/Row Locking
Init
Define
Manage
Done
Additional Resources
Transaction Processing
Init
Define
Manage
Done
Additional Resources
NetBeans Plugin for Java
Setting up the Connection to the Server
Installing the NetBeans Plugin
Editing Stored Procedures
Enabling Debugging
Using Java Stored Procedures
Introduction
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
Calling Stored Procedures from ODBC
Calling Stored Procedures from JDBC
Calling Stored Procedures from .NET
Calling Stored Procedures from ISQL
Modifying and Deleting Stored Procedures
Debugging Stored Procedures
Transactions and Stored Procedures
Stored Procedure Security
Restrictions on Calling Java Methods in Stored Procedures
Using c-treeACE 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: the RESULT Clause and DhSQLResultSet
Handling Null Values
Setting SQL Statement Input Params & Procedure Result SetFields to Null
Assigning Null Values from SQL Result Sets:SQLCursor.wasNULL Method
Handling Errors
Calling Stored Procedures from 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
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
Java Class Reference
Introduction
DhSQLException
DhSQLException.getDiagnostics
DhSQLResultSet
DhSQLResultSet.insert
DhSQLResultSet.makeNULL
DhSQLResultSet.set
SQLCursor
SQLCursor.close
SQLCursor.fetch
SQLCursor.found
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
.NET Support
Visual Studio .NET Development
.NET Tutorials
Mapping Between SQL Types and .NET Types
Writing .NET Stored Procedures
Writing a New SP, UDF, or Trigger
Deploying the SP, UDF, or Trigger
Testing the SP, UDF, or Trigger
Debugging the SP, UDF, or Trigger
Altering the SP, UDF, or Trigger
Writing the Code
Returning a Result Set from a Stored Procedure
Returning a UDF Result
Accessing Old and New Rows in Triggers
The .NET Ctree.SqlSP Assembly
SqlSpBase
SqlStoredProc
SqlUdf
SqlTrigger
SqlSpRow
SqlSpColumn
SqlSpCommand
SqlException
Glossary
Document History
Index