jdbcsql is a small command-line tool written in JAVA and can be used on all platforms, for which JRE 8 is available. To connect to a specific DBMS the tool uses its JDBC driver. The current version supports the following DBMS: mysql, oracle and postgresql. Other systems can easily be added by the user. The result of the executed ‘select’ query is displayed in CSV format (by default complying to rfc4180, but other standards are supported too). When there is an error the tool stops with exit code 1 and the error message is output on stderr. jdbcsql is created with a main purpose to be used in shell-scripts.
Relatively easy to configurate, this tool is suitable for queries ‘select’, ‘update’ and ‘delete’. I think that is not suitable for a large number of requests, like ‘insert’.
If you are like the rest of our user community, your IT team is busy. With pressure to deliver on-time projects, you don’t have a lot of time to spend making your management tools work. You need network monitoring tools that work for you. You want tools that makes it easy to find performance issues before your users do and resolve them before they impact the business. That’s why tens of thousands of customers around the world love WhatsUp Gold.