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
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String dataSourceName = strDSN;
String dbURL = "jdbc:odbc:" + dataSourceName;
Connection con = DriverManager.getConnection(dbURL, "","");
Statement s = con.createStatement();
s.execute(strQuery);
This is how the code in my java class looks like. This class is called from the JSP.
Can anyone please give me guidelines/ sample example on a JSP accessing a (ms acess) database deployed in
Tomcat?
Thanks.
Gaurav