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
- If you did not select the Deploy check box
in the Create Stored Procedure wizard, open the Deploy
Routine wizard.
- In the Package Explorer, double-click the Java stored
procedure that you want to deploy. The stored procedure opens
in the Routine editor.
- 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
- 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.
- 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.