Hello,
Although it appears that the Java action is not returning anything visually, it internally returns a list of objects.
Hi Ulaganathan,
Thanks for your response. Point 1 I am not sure about, because I have got it working now and it visually returns a list again. So, I think if you set it up correctly it will show in the UI too. I kind of did what you mentioned in point 2.
I did the following:
1. You have to use the option 'Connection string' like so: jdbc:sqlserver://hostname:portnumber;databaseName=databasename;integratedSecurity=True;trustServerCertificate=true
Beware to escape characters like \ in JSON. Username and Password you can fill in anything, this does not matter.
2. In the marketplace module change the dependencies in settings.Change com.microsoft.sqlserver to 12.2.0.jre11.
3. Go to App -> Synchronize Dependencies
4. Go to App -> Clean Deployment Directory (was needed in my case and it can't hurt)
5. Run your app and test your connection
Kind regards,
Bas