Hi all, I have a sample Java Program that manipulates a MS Access Database. I have now written JSP code to perform the same functions (insert/ delete.) on the database.
I have my class files under WEB-INF/classes and the database in webapps/MyApp/myDB.mdb
Could you please help me with the following. 1. Is the database placed in the right path. 2. Do i have to place the driver in the WEB-INF/lib? if so which drivers. I did search a lot but could not find a good reference
It is inappropriate to do DB access from a JSP. You should be using the very non-UI classes that you've already set up in a reusable manner. But yes, once you find out what the correct drivers are, they will go in WEB-INF/lib. [ March 17, 2007: Message edited by: Bear Bibeault ]
If the driver you plan to use is "sun.jdbc.odbc.JdbcOdbcDriver" then you don't have to put it anywhere. It is already part of the JRE. (Unless you are using a JRE not written by Sun, in which case you will not be able to use it at all.)