Problem accessing Database from JSP

[Gaurav Pawar]

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 = "jdbcdbc:" + 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

[Bear Bibeault]

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 ]

[Paul Clapham]

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.)

[Bear Bibeault]

So what error are you getting that leads you to believe that you have a driver issue?

[Gaurav Pawar]

Hi,
Well my code for accessing the database is in a java class called Starter.java which has a function

    
public class Starter
{
Vector<ArrayList> vect = new Vector<ArrayList>()
public void InitializeMap()
{
                State_D reader1 = new State_D();
vect  = reader1.getData();
ArrayList<String> arrSt =new ArrayList<String>();
ArrayList<Integer> arrA =new ArrayList<Integer>();
 
if(vect!=null)
{
arrSt=vect.get(0);
arrA=vect.get(1);
}
 
}
 
}

and this is what getData() does.

public class State_D
{
public Vector getData()
{
 try 
  {
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);//"select * from...." 
rs = s.getResultSet();
ArrayList<String> arr = new ArrayList<String>();
ArrayList<Integer> arrNo = new ArrayList<Integer>();
if(rs!=null)
while(rs.next())
{
arr.add(rs.getString(1));
arrNo.add(rs.getInt(2));
}
v.add(arr);
v.add(arrNo);
s.close(); 
con.close();
}
catch (Exception err) 
    {
    System.out.println("ERROR: " + err);
    }
return v;
}
 
 
}
 

This class is in webapps/MyApp/WEB-INF/classes/core

In my JSP i have the following code.

<%@page import="core.Starter"%>
<%

Starter StMap = new Starter();
StMap.InitializeMap();

%>

The Error: org.apache.jasper.JasperException: Array index out of range: 0


The problem is this works fine as a standalone application.. but after deployment

I have put the database in webapps/MyApp

When i run this in my browser as http://localhost:8080/MyApp/Map.jsp
it gives the error


org.apache.jasper.JasperException: Array index out of range: 0
[ March 18, 2007: Message edited by: Gaurav Pawar ]

[Bear Bibeault]

When posting code to the forums, please use UBB code tags. Read this for more information.

It's just too hard to read unformatted code.

[Bear Bibeault]

You can go back and add them to previous posts by clicking the icon. Hint, hint.

[Gaurav Pawar]

Hi,

I got the solution to this one. I had declared the 'Data Source Name' as User DSN. I then tried declaring it as a System DSN and it worked.

Thanks,
Gaurav