dynamobi/dynamobi — Issue #342: [FRG-424] Fix sqldeploymentdescriptor.sql test with netbeans
Author: dynamobi-build
Created: 2011-12-30 02:33:31+00:00
State: open
Labels: FRG, Test

[reporter="ksecretan", created="Fri, 24 Jun 2011 20:09:00 -0500 (GMT-05:00)"]
Follow up from FRG-420, this test breaks in a build with netbeans.

The deployment descriptor isn't being run properly. The test jar is supposed to create three functions but never runs the last for some reason. (It runs fine in sqlineEngine.) An extension to the test: select invocation_name from sys_boot.mgmt.dba_routines_internal2 where schema_name = 'SS';

The failing line: call sqlj.remove_jar('test_jar', 1);

translates to drop jar test_jar OPTIONS(1) RESTRICT;

The '1' marks that it should be undeployed first (the REMOVE portion of the deployment descriptors run), so that a CASCADE is not necessary, but this does not appear to happen with netbeans. The deploy.txt file being used may be malformed syntax; e.g. it doesn't have semicolons at the end of all sql statements as it should. That seems to be intentional, though, due to whatever syntax the inner-implementor[sic] blocks want.