Overview
Provides the following two smart services that are database agnostic and supports dynamic queries.
Key Features & Functionality
The download package has been updated to include this documentation
The documentation for this was accidentally excluded from the latest release.It's attached below. This should answer many questions as to how to operate the plugin successfully.PDF
Hi Jorge, can you please share all the values you set as input? Do you also have something logged in the stdOut when you tested it and got that error? That error is a generic one and most of the times indicates that the inputs of the SS have been wrongly mapped.
Still persists "An error occurred in executing an Activity Class."... What can I do?
JNDI is the datasource name (Example: jdbc/AppianBusinessDS) - You can find the datasource name under admin console>>Datasources or in the datastore object , you can find the datasource name
What is JNDI name??
In the end I got this working too. Thought I'd post and perhaps save someone else a little frustration. This really is a good plugin, would benefit from a few examples.
The node inputs on the Get Base64 Document from Database
Afraid I'm not using the counterpart smart service to create a document from the base64 entry. Sorry - my use case is for one way only. Have you checked the STDOUT log file to see if anything is being trapped there ?
Paul,
Finally... this worked perfectly. I was struggling with how the sql married with the inputs and how to pass it the document.
If you have a similar example for retrieving the base64 and saving as a file that will complete the round trip. Right now I'm fetching and though it all looks good and I'm getting no errors... no file is being written.
Many Thanks, Dave