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.
New feature: The application server includes enhanced
SQLJ support for applications that use container-managed persistence
(CMP). The new features 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.
newfeat