Use Structured Query Language in Java (SQLJ)
to develop data access applications that connect to DB2® databases.
SQLJ is a set of programming extensions that enable you to use the Java programming language to embed statements
that provide SQL (Structured Query Language) database requests.
About this task
The advantages of developing applications with SQLJ include
improved performance and a shorter, more efficient development cycle.
You can achieve the following with SQL:
- Improve performance by using static SQL statements.
- Reduce the development cycle:
- Write less code with the simpler SQLJ syntax, which reduces the
number of lines of code that is required to execute statements, set
parameters, and retrieve parameters.
- Detect programming errors earlier in the development phase with
the online check function, which performs data type validation and
schema validation. See the DB2 documentation for a complete
list of customization options.
Consider using SQLJ in situations where dynamic SQL is not needed,
and where applications use DB2 as the database server.
The
application server includes enhanced SQLJ support for applications
that use container-managed persistence (CMP). The enhanced support
includes the following items: include:
- Deploying CMP beans during the application installation in the
application server.
- Customizing and binding SQLJ profiles with the administrative
console or scripting.
- Customizing and binding SQLJ applications again without needing
to reinstall the application.
These enhancements reduce the complexity of installing, deploying,
and customizing SQLJ applications for both container-managed and bean-managed
persistence.