You’re up late troubleshooting an issue on a database connected Java application and desperately need to run a SQL query to help diagnose the problem. You don’t have a SQL client available and for reasons of privilege or environment can’t install one. The process for getting one installed will require navigating a Byzantine bureaucracy of feuding lords and angry serfs, none of whom are available after 5:00 p.m. In the end, you may get what you need with an ETA ranging from too late to never.
The SimpleSQLClient (tada!) could be the answer. SimpleSQLClient is a command line JDBC SQL client that builds from a single Java source file. The only external runtime dependencies are a JVM, JDBC driver and an ASCII configuration file. Copy / paste / build the source or upload the SimpleSQLClient.class file on a machine that can satisfy the dependencies and you’re good to go. If the misbehaving application just happens to be Alfresco, you’ll be able to run using the Alfresco install’s JDBC driver and alfresco-global.properties.
I hope you’ll find it as useful as I have. For instructions on how to download the source, enter your email below.