Overview
Provides the following two smart services that are database agnostic and supports dynamic queries.
Key Features & Functionality
Hi Corrado, we have used this plugin in our application. In light of the recent discovery of vulnerabilities with log4j2, we would like to know if this plugin uses the affected version Log4j2, and if yes, would you release an updated version of this plugin to counter the exploit of vulnerability?
Hi there,
This plugin works for me when I use a simple SQL statement: SELECT [] from [] where [] = []
However, I keep getting syntax errors when I try something more complex: SELECT [] from [] where [] = [] AND [] = []
What would be the correct way to format this string?
Thank you
Hi,
I am getting the same issue which you faced. Could you please look into the below attachments and suggest me any pointers to resolve this?
Database structure
Data getting stored in DB
PM Details
it worked !Thanks
I solved this by changing the structure of "base64str" in the database from "varchar(1000)" to "text" .. here below the sql statement:
CREATE TABLE book (base64str text,title varchar(100))
Hi everybody,
I tried to use this plugin in 19.4 Appian version.
I was able to configure the insert into db smart service but it provides me as output exactly the ID of the document instead of the base64 conversion.
Here below the configuration i have used:
input data:
*JNDI Name (text): "jdbc/BusinessData" --> found on the admin console / Data source
*Sql Statement (text): "INSERT INTO dbo.pkbbase64 VALUES (:documentid,:title)"
*documentid (number-integer): document id present in appian
*title (text): "test string"
what I get in the table is:
*base64 (varchar(4000)) --> exactly the documentID (not converted)
*title (varchar(255)) --> "test string"
This situation happens both for pdf and txt file.
Can anyone support me please?
Thanks
Hello Team,Im getting the following error : Error in executeUpdate, String or binary data would be truncated.Can you help resolve this
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