Deploying Java stored procedures

Use the Deploy Routines wizard to deploy Java™ stored procedures to a database.

Before you begin

If you selected the Deploy option in the Create Stored Procedure wizard, the Java stored procedure was deployed after it was created.

When you deploy a Java stored procedure, all of the class files within the Java project where you created the stored procedure are deployed inside the stored procedure JAR file

Restriction: If the pureQuery runtime (pdq.jar file) is present in the Java project that contains the stored procedure you are deploying, you have the option of also deploying the pureQuery runtime. The pureQuery runtime is licensed only for development use. The pureQuery runtime should be present in a development database only once. You must coordinate the deployment and use of the pureQuery runtime among all of the stored procedures in the database.

About this task

To deploy a Java stored procedure to a database:

Procedure

  1. If you did not select the Deploy check box in the Create Stored Procedure wizard, open the Deploy Routine wizard.
    1. In the Package Explorer, double-click the Java stored procedure that you want to deploy. The stored procedure opens in the Routine editor.
    2. In the Routine editor, select Deploy. The Deploy command is available on the Configuration page in the Deployment and Execution section. The command also is available on the Source page of the editor. After you right-click in the page, the command is displayed on the pop-up menu
  2. Complete the steps of the wizard. Some of the fields in the wizard are populated based on the default settings that are specified in the Deploy options preferences pages and some of the fields are populated with the values from the routines you want to deploy. If you select to deploy to a different server, you can select an existing database connection or create a new connection. Connections to supported database servers are the only connections that are available in the list of existing connections.
  3. Click Finish.

Results

The deploy process begins, and you can view the progress and messages in the SQL Results view. After the stored procedure is deployed, you can refresh the Stored Procedures folder under the database connection in the Data Source Explorer view to verify that the stored procedure was added to the server.

Feedback