Deploying Java Stored Procedure   

I'm having trouble deploying a Java Stored Procedure. I'm running Data Studio V2.2, using IBM DB2.

It deploys just fine to my local DB from within Data Studio, and seems to Export just fine. It creates what appears to be a complete set of directories and jar files, but when I run:

> ant -buildfile MyStoredProc.xml

I get this result:

builddeploySps:
createsp Debug options:
createsp file:/MyExportArea/Deployment/.options loaded

BUILD FAILED
D:\MyExportArea\Deployment\MyStoredProc.xml:97: org.eclipse.emf.ecore.resource.impl.ResourceSetImpl$1DiagnosticWrappedException: org.e
clipse.emf.ecore.xmi.PackageNotFoundException: Package with uri 'http:///com/ibm/db/models/db2/routine/extensions.ecore' not found. (file:/D:/MyExportArea/Deployment/MyStoredProc.spxmi, 391, 26)

I've looked around to try to find out where the missing extensions.ecore package might be, and I found: com.ibm.db.models.db2.routine.extensions.jar, which contains this:

> jar tf jar\com.ibm.db.models.db2.routine.extensions.jar
META-INF/
META-INF/MANIFEST.MF
com/
com/ibm/
com/ibm/db/
com/ibm/db/models/
com/ibm/db/models/db2/
com/ibm/db/models/db2/routine/
com/ibm/db/models/db2/routine/extensions/
com/ibm/db/models/db2/routine/extensions/impl/
com/ibm/db/models/db2/routine/extensions/util/
model/
com/ibm/db/models/db2/routine/extensions/DB2RoutineDeployRecord.class
com/ibm/db/models/db2/routine/extensions/DB2RoutineExecution.class
com/ibm/db/models/db2/routine/extensions/DB2RoutineExtensionsFactory.class
com/ibm/db/models/db2/routine/extensions/DB2RoutineExtensionsPackage$Literals.class
com/ibm/db/models/db2/routine/extensions/DB2RoutineExtensionsPackage.class
com/ibm/db/models/db2/routine/extensions/DB2RoutineParmValue.class
com/ibm/db/models/db2/routine/extensions/DB2RoutineRun.class
com/ibm/db/models/db2/routine/extensions/DB2zSeriesRoutineRun.class
com/ibm/db/models/db2/routine/extensions/ExtensionsPlugin.class
com/ibm/db/models/db2/routine/extensions/impl/DB2RoutineDeployRecordImpl.class
com/ibm/db/models/db2/routine/extensions/impl/DB2RoutineExecutionImpl.class
com/ibm/db/models/db2/routine/extensions/impl/DB2RoutineExtensionsFactoryImpl.class
com/ibm/db/models/db2/routine/extensions/impl/DB2RoutineExtensionsPackageImpl.class
com/ibm/db/models/db2/routine/extensions/impl/DB2RoutineParmValueImpl.class
com/ibm/db/models/db2/routine/extensions/impl/DB2RoutineRunImpl.class
com/ibm/db/models/db2/routine/extensions/impl/DB2zSeriesRoutineRunImpl.class
com/ibm/db/models/db2/routine/extensions/util/DB2RoutineExtensionsAdapterFactory$1.class
com/ibm/db/models/db2/routine/extensions/util/DB2RoutineExtensionsAdapterFactory.class
com/ibm/db/models/db2/routine/extensions/util/DB2RoutineExtensionsSwitch.class
model/DB2RoutineExtensions.cat
=> model/DB2RoutineExtensions.ecore
model/DB2RoutineExtensions.genmodel
model/DB2RoutineExtensions.mdl
plugin.properties
plugin.xml

can anyone tell me how to resolve this problem?

Thanks....

Well, mostly....

One of my colleagues discovered that I could remove one of the definition statements at the beginning of the spxmi file (xmlns:DB2RoutineExtensions="http:///com/ibm/db/models/db2/routine/extensions.ecore"), and make a couple of other adjustments, and that fixed that particular problem.

I was then left with a "missing jar file" error for sqltools.parser.sql.

So, I indirectly took your advice and copied the missing jar file ("org.eclipse.datatools.sqltools.parser.sql.jar") to the jar directory, which fixed the immediate problem, though it leaves me wondering why it misses the file in the first place.

I also found that removing the ResultSet parameter from the CREATE PROCEDURE statement (since I am, indeed, not returning any results) resulted in the removal of the DB2RoutineExtensions definition statement from the spxmi file, so I no longer have to remove it manually.

All in all, not an easy experience, though I greatly appreciate your help.

Regards......