Try OpenEdge Now
skip to main content
SQL Development
Stored Procedures and Triggers : Basics of Java stored procedures : How OpenEdge SQL interacts with Java
 

How OpenEdge SQL interacts with Java

OpenEdge SQL stored procedures allow the use of standard Java programming constructs along with standard SQL statements. To do this, the OpenEdge SQL Engine interacts with Java in the following ways:
*When you create a stored procedure, the SQL engine processes the Java code, submits it to the Java compiler, receives the compiled result, and stores the result in the database.
*When an application calls a stored procedure, the SQL engine interacts with the Java Virtual Machine (JVM) to execute the stored procedure and receive any result.
* Creating stored procedures
* Calling stored procedures
* Using stored procedures