tomcat ms access database connection problem
Hi all,
I'm having trouble with the following: I am trying to have a JSP file call a bunch of Java classes sitting inside tomcat which in turn call an ms access database. I specifically need to be able to call Java classes that reside within the classes directory under WEB-INF and I do not want to call the database directly from the JSP. One of my Java classes already has code in it to connect to the database which works outside of Tomcat but when I put it under WEB-INF/classes and call it from my JSP (which imports the class) it stops working. I even pulled the Java code out of the JSP and ran it with all my other java files and it worked but only outside of Tomcat. I tried using JNDI according to this tutorial: http://www.ericsson.com/mobilityworld/sub/open/technologies/open_development_tips/docs/odt_tomcat_db_connection
but it still does not work. Can someone please help me?
p.s. I need to keep the database outside of tomcat (I'm using version 5.5) and I would like to have my java classes do all the connecting to the database and not the jsp.
