We are currently building JDBC Provisioning rule. Last friday, we were able to create and save the rule. However, when we tried to modify it, it’s getting an error. The error is pointing to line where the “import java.sql.PreparedStatement” is located.
So we tried to remove all the new lines in the code and revert it to the original and tried to save it again. However, the error still appearing and pointing to “import java.sql.PreparedStatement”.
Is anyone experiencing this behavior? even with our existing working JDBC Provisioning Rule, we tried saving it in visual studio even though no changes, it still showing same error.
Hello Rainiel. Since even your unchanged, previously working JDBC rules now fail to save, I would first isolate whether this is a validation or a save issue. import java.sql.PreparedStatement; is valid and appears in SailPoint’s own JDBC Provision rule example, so I would not remove it just because the error points to that line.
Capture the full error from the extension’s Output panel in VS Code, including the HTTP status and any tracking ID.
Retrieve the deployed rule with GET /connector-rules/v1/{id}, then validate its stored sourceCode (version and script) through POST /connector-rules/v1/validate with an ORG_ADMIN token, and check the returned state (OK or ERROR) and details. This tests the exact stored script, not the editor copy.
If validation returns OK but saving still fails, inspect the save/update API response to tell an extension issue from a platform-side failure, since a clean validation does not guarantee the update itself succeeds. If validation returns ERROR on a rule you did not change, review the details and raise a SailPoint Support case.
If the problem isolates to the community VS Code extension, it is not supported by SailPoint, so I would report it to the maintainer there.
Could you share the exact error and your VS Code extension version?
It is blocking HttpURLConnection and PreparedStatement classes, and—much like Lucas—it doesn’t even allow for updating rules that have already been committed.
I have the same problem with my JDBC Provision Rule.
I already had a working connector rule on the tenant and only wanted to make some changes, but I am now getting the following errors:
Could you try a quick test in a non-production tenant? Create a separate JDBCProvision rule with only this code and try saving it without attaching it to a source:
import java.sql.PreparedStatement;
import sailpoint.object.ProvisioningResult;
return new ProvisioningResult();
Then try saving the same test rule again after removing only the PreparedStatement import.
If both versions save, you could add sections of the original rule back until the error returns. If only the version with the import fails, you’ll have a small example to share with SailPoint Support. If both fail, the issue may not be specific to that import.
Also, if the error includes inline evaluation of, the import may just be showing the beginning of the script. The actual error or line number could appear later in the message.
I’m in the same situation here, i can’t even save a rule that’s already in the tenant with preparedStatement. Also tried changing by api and it doesn’t work.
I have raised a support ticket with SailPoint regarding this issue. They confirmed that a recent update on their end has caused the issue and that their team is already working on a resolution.