Skip to main content
Known Participant
Aug 5, 2024 2:53 PM UTC
Question

Query Database smart service to connect to an external database.

I'm using the Query Database smart service to connect to an external database. I've set up the connected system correctly, but when I run the process model, it doesn't work as expected and doesn't show any errors. However, when I use the Execute Stored Procedure smart service with the same connected system, it works fine. Can you help me understand why the Query Database smart service isn't working?

4 replies

stefanhelzle0001
Brainy
Aug 5, 2024 2:56 PM UTC

Did you check the tomcat stdout log file for details?

Known Participant
Aug 5, 2024 3:10 PM UTC

I don't have access to check it.

stefanhelzle0001
Brainy
Aug 5, 2024 5:13 PM UTC

Well, without any additional details, this becomes pretty difficult.

davidj137213
Brainy
Aug 6, 2024 7:32 AM UTC

It's complicated without more information.... 

Try executing the query from a DDBB Client, like Toad , DB Visualizer, using the same driver , connection string and query that you are actually using in your PM. Did it work?