Wondering how people are running MySQL stored procedures from Appian for validat

davidw754 over 8 years ago

Wondering how people are running MySQL stored procedures from Appian for validation services in forms?

I found some examples of using Java and JPA/Hibernate bindings to do this e.g. - examples.javacodegeeks.com/.../

I'm thinking this could be run via a RESTful API and the http SmartService for inputs / outputs - or is there a way to create a CDT that maps to the JPA/Hibernate directives and work it that way?

Discussion posts and replies are publicly visible

Parents

0 Matthew Kornfield
Appian Employee
over 8 years ago

David, one way to run Stored Procedures using OOTB functionality would be the deprecated Query Database Smart Service:

forum.appian.com/.../Query_Database_Smart_Service.html

I have attached a screenshot of how this could be configured to run a test procedure in MYSQL that already has a JDBC set up. You can also use a set of connection information through this method as well by choosing "Set up a custom data source" if no predefined source exists.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Matthew Kornfield
Appian Employee
over 8 years ago

David, one way to run Stored Procedures using OOTB functionality would be the deprecated Query Database Smart Service:

forum.appian.com/.../Query_Database_Smart_Service.html

I have attached a screenshot of how this could be configured to run a test procedure in MYSQL that already has a JDBC set up. You can also use a set of connection information through this method as well by choosing "Set up a custom data source" if no predefined source exists.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data