SQLException 'general error' when using the JDBC-ODBC bridge

Hi folks,

There's a guy in my department who's trying to get to grips with JSPs and JDBC. He's written a test JSP accessing an Access database via the JDBC-ODBC bridge, but when he tries to run it, he gets an SQLException with the not very helpful error "general error".

The basic code is below:

<%

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection con = DriverManager.getConnection("jdbc:odbc:Conference");

Statement stmt = con.createStatement();

String familyName = request.getParameter("required_familyname");

String firstName = request.getParameter("required_firstname");

String organization = request.getParameter("organisation");

String position = request.getParameter("position");

String email = request.getParameter("required_email");

String queryUpdatePerson="insert into Person values ('ITIL2002', '" + email +"','foo','" + familyName +"','" + firstName +"','" + organization +"','" + position +"' )";

int rowsAffectedPerson = stmt.executeUpdate(queryUpdatePerson);

if (rowsAffectedPerson == 1)

{

%>

<h1>Thank youfor expressing interest</h1>

<%}

else

{

%>

<h1>Sorry,addition has failed.Please,try later</h1>

<%

}

stmt.close();

con.close();

%>

The exception gets thrown on the executeUpdate() line, but the query is definitely correct. We've copied the line and tried executing it directly on Access as a query and it works fine.

The database definitely exists as an ODBC data source (a simple JSP to print out the contents of a table proved that).

We're running Tomcat 3.1 on Windows NT 4 Server with SP6a applied. I've tried posting on the JavaServer Pages forum without any joy, can anyone help?

Thanks very much in advance,

Raj.

[2560 byte] By [rajbhaskar] at [2007-9-26 3:18:14]