Hi,

I’m trying to write a java service which does all the Db operations in a generic way.
I have written a code which checks for the connection and can perform the passed query as well. But I willing to know how can I capture the output after executing the query. Is it possible that way? If so can you please let me know how can I achieve this?

Many Thanks,
Abhiram.

Hi Abhiram,

can you provide a more detailed outline what you have achieved so far, please?
Can you explain your use case why you want to have such a service?

You should be very careful with such things to avoid some security leakages like SQL Injection etc.

Regards,
Holger

There is JDBC adapter that will give you flexibility to do all the database DML operations that you want and with all the facilities/framework at your disposal to perform database operations. I think it might not be a good idea to re-invent the wheel again by writing java service and utilize JDK jdbc service to establish the connection and then manipulate the data.

If you want to look for example on Java JDBC service, feel free to google and I’m sure there are so many example out there.