Requirements for deploying EJB applications using SQLJ

Make sure you have the following requirements in place before you try to deploy your EJB applications using SQLJ:

• The database

  To run SQLJ enterprise beans on WebSphere Application Server, you need DB2 installed on the machine where you generate the deployment code, as well as on the machine containing the databases. Structured Query Language in Java (SQLJ) for EJB persistence requires DB2 Version 8 fix pack 1.

  On the machine where you generate the deployment code, you need: DB2 UDB Application Development Client Version 8 fix pack 1.

  On the machine that contains the database for running the scenario, you need: DB2 UDB Server:

  • 

    Version 8 fix pack 1

  • 

    Version 6 or Version 7

• Version of the enterprise beans

  SQLJ support requires Version 2.x CMP enterprise Java beans. If you mix EJB 1.1 and 2.x beans in an EJB 2.x module, then only the EJB 2.x beans are deployed to use SQLJ. The EJB 1.1 beans continue using JDBC for data access.

 

Parent topic

Deploying EJB applications using SQLJ for data access
Next topic: Configuring EJB applications to use SQLJ instead of JDBC for enterprise bean persistence (workbench only)

Related reference
The ejbdeploy command