IntroductionIf you have setup your Mondrian's sample database in MySQL and want to check whether it is setup correctly in your Tomcat's installation, here I have a sample JSP file you can use for that purpose.
InstallationDownload my sample JSP attached at the end of the article (showtables.jsp). Copy the file into your Mondrian's web app folder.
ConfigurationOpen this file in your favorite editor and change the following line to meet your MySQL's configuration :
In this sample, I have local MySQL setup (localhost) pointing to foodmart database, and a user root with no password.
Open your browser and navigate to the url of the copied file (eg: http://localhost/mondrian/showtables.jsp), and you should get a listing of tables in your foodmart database setup.