Overview
Provides the following two smart services that are database agnostic and supports dynamic queries.
Key Features & Functionality
What should be the JNDI name for connected system. I am using a different schema and have created connected system for Maria DB
Hi Dharmendra Godhani, I am also facing the same issue. Changed the varchar to text, still facing the issue. have you solved your issue? if so, can you please share the solution?
Thanks
Were you able to resolve this issue?
Is this still an issue? This should indeed error gracefully. What is the error in tomcat stdout log?
Dear Community,
The Plug-In works well for us, we are using 'Get Base64 Document from Database' Smart Service.
The documents are downloaded and stored as expected only when there is a data in the database record.
However when the field is empty (we are missing document for certain record), the Process is paused with error. I was rather expecting it will get completed and pass the information to me with output variables 'isSuccess' and 'errorMessage', but for this specific use case it is just crashing.
I am looking for a smart workaround. I can think of using the Query Database node before to check if there is a value in the database and depending on it: end the process or move forward. However that seems not very efficient for me as i will query database twice with this process.
Do you see any other solution ?
Thank you in advance for all suggestions,Best Regards,Maciej
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))