Yes I did a manual SELECT query using the mySql command line and successfully got all 4 records in the DB.
Following Bear's advice I also added a few System.out.println statements. Adding System.out.println(rs.getString("FirstName")); in the UserDB class I was able to see a print out of the DB records in the console. When restarting the application I noticed the following error in the
Tomcat log. Does this suggest my application is corrupted (seeing as I opened this project in Netbeans didn't build it from scratch)?
java.lang.IllegalArgumentException: Document base C:\murach\extract\servlet_jsp\netbeans\ex_starts\ch07email\build\web does not exist or is not a readable directory
at org.apache.naming.resources.FileDirContext.setDocBase(FileDirContext.java:138)
at org.apache.catalina.core.StandardContext.resourcesStart(StandardContext.java:5002)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5182)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:656)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1635)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:722)
Any ideas if this error is a corruption of Netbeans, Tomcat or my JDK? I'd like to be on the safe side and re-install all but would appreciate any suggestions if anybody has come across this error before. I searched through the forum but didn't really find anything definitive on this error.
I also followed Bear's advice and added log4j, which doesn't output any errors so it looks like the database objects are working fine??