Embed Structured Query Language in Java (SQLJ)
statements in your applications to maximize the efficiency of transactions
with your databases. Before your applications can take advantage of
SQLJ, you must deploy the application and customize the SQLJ profiles
that are created. The application server provides functionality to
use SQLJ as the persistence mechanism for enterprise beans that use
container-managed persistence. Deploy the CMP beans in the application
server to enable SQLJ support.
Before you begin
You need an application that uses SQLJ and container-managed
persistence. Develop this application in Rational® Application
Developer or another development tool.
About this task
Deploy SQLJ applications in the application server to simplify
the process of SQLJ translation and bean deployment. The application
server includes these new features for SQLJ support:
- 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.
You can also deploy the SQLJ application using the ejbdeploytool.
Read the topic on deploying SQLJ applications that use container-managed
persistence (CMP) with the ejbdeploy tool for more information.
Procedure
- Create a top-down mapping to a DB2® database.
- From your DB2 installation, copy the sqlj.zip file
to a directory on your workstation.
- Deploy the EAR file in the administrative console.
- Click .
- Select Local file system or Remote
file system, and browse to the EAR file.
- Select Detailed - Show all installation options
and parameters. Click Next.
- In Step 1: Select installation options,
select Deploy enterprise beans. Configure any
other options, and click Next.
- In Step 3: Provide options to perform the
EJB deploy, select SQLJ for Deploy
EJB option - Database access type.
- Enter the location of the sqlj.zip file
in the SQLj class path field.
- Complete the installation process for the application.
What to do next
After the enterprise application is deployed, customize the
SQLJ profiles using the administrative console, scripting, or the
db2sqljcustomize tool:
- For administrative console support, read the topic on customizing
and binding profiles for Structured Query Language in Java (SQLJ) applications.
- For scripting support, read the topic on the application management
command group for the AdminTask object.
- For use of the db2sqljcustomize tool, read the topic on customizing
and binding SQLJ profiles with the db2sqljcustomize tool.