OverviewThis simple webapp is intended to be used in a J2EE/Java EE container, in order to test DataSource objects available in a JNDI context.

It allows one to type a JNDI name and a SQL SELECT query and outputs the result in a tabular form.

InstallationSimply deploy the WAR archive (available in the downloads section) to your J2EE container / application server. It should work out of the box.

For example, on JBoss, you just need to copy the DataSourceTester-0.0.1-SNAPSHOT.war file to $JBOSS_HOME/server/default/deploy/ and the application will become available on http://yourserveraddress.example.com/DataSourceTester-0.0.1-SNAPSHOT/

UsageAfter opening the main web page, you'll see a web form with two text fields labeled DataSource JNDI name and Test query text. After you fill them in, press the Test DataSource button. If the query succeeds, its results will be shown below in tabular form.

Deinstallation / undeploymentDepends on the kind of application server. On JBoss, you just have to delete the DataSourceTester-0.0.1-SNAPSHOT.war file from the $JBOSS_HOME/server/default/deploy/ directory.

DisclaimerWARNING: Deploy this application on your server only after you have understood all its security implications!

This application does not authenticate the user in any way and allows to send arbitraty queries to any DataSource available through public JNDI contexts. Don't deploy it on a publically available server, and undeploy it immediately after use. Alternatively, you can employ container provided authentication and authorization mechanisms (e.g. JAAS and J2EE role based security) but you have to do this on your own and the authors of DataSourceTester provide no support for this since most of this is container specific (e.g. for JBoss you can use similar approach as for securing the JMX and Web console).

The author gives no guarantees for the proper functioning nor take any responsibility for damages resulting from the use of this application. For details, see the LICENSE file.

You have been warned.