Topic
No replies
TheCaptain
TheCaptain
3 Posts
ACCEPTED ANSWER

Pinned topic Problem Deploying a Java Stored Procedure

‏2013-10-18T23:09:38Z |

Hi,

I was developing a Java stored procedure that accessed Java packages within my RAD project and across RAD projects. All was working well. I then attempted to deploy it to a remote database server but it failed. Now, whenever I attempt to deploy any stored procedure, it fails attempting to find any other class. It can not find classes even in the same directory as the stored procedure java file.

I am using RAD V8.0.4. I have tried accessing a new DB2 database and creating a new RAD repository.

I have created a class called "Another" that has a single static method called run that does nothing.

public classAnother {

   public static void run() {

   }

}

I call it from the sample RAD system table data fetch SP program.

Another.run();

LOG of Failed Deployment attempt.

AMS.TEST_SP1 - Deploy started.
AMS.TEST_SP1 - Created temporary working directory C:\Data\RAD_Test_Workspace\.metadata\.plugins\com.ibm.datatools.db2.routines.deploy.ui\bld1382137225658.
C:\Program Files\IBM\SDP\jdk\bin\javac -classpath ".;C:\Program Files (x86)\IBM\SDPShared\plugins\com.ibm.datatools.sqlj.translator_2.1.0.v20100715_2051\sqlj.zip;C:\Program Files (x86)\IBM\SDPShared\plugins\com.ibm.datatools.db2_2.1.102.v20100715_2051\driver\db2jcc4.jar;C:\Program Files (x86)\IBM\SDPShared\plugins\com.ibm.datatools.db2_2.1.102.v20100715_2051\driver\db2jcc4_license_cisuz.jar" -source 1.5 -target 1.5 com\ibm\research\ams\TEST_SP1.java
com\ibm\research\ams\TEST_SP1.java:16: cannot find symbol
symbol  : variable Another
location: class com.ibm.research.ams.TEST_SP1
  Another.run();
  ^
1 error
AMS.TEST_SP1 - Removed temporary working directory C:\Data\RAD_Test_Workspace\.metadata\.plugins\com.ibm.datatools.db2.routines.deploy.ui\bld1382137225658.
AMS.TEST_SP1 - Deploy failed.
AMS.TEST_SP1 - Roll back completed successfully.