If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Servlet Help

I want to create a Registration Servlet allowing a user to type in their details and save it to a mySQL database. Below are all the classes i have used. the Registration Servelt is throwing an SQlException shown below.
} catch (SQLException se) {
out.println("<p>There has been a problem creating your account. Please contact the site administrator via email to <a href=\"mailto:admin@sfikjfdk.com\">this address</a></p>");
out.println("<p>SQL Error executing query='"+query+"'");
}

My question is how can I fix it to make my servlet work, ive tried everything i could think of.

/*
* User.java
*
* Created on 2 September 2005, 20:33
*
* To change this template, choose Tools | Options and locate the template under
* the Source Creation and Management node. Right-click the template and choose
* Open. You can then make changes to the template in the Source Editor.
*/

/*
* DataManager.java
*
* Created on 28 August 2005, 18:30
*
* To change this template, choose Tools | Options and locate the template under
* the Source Creation and Management node. Right-click the template and choose
* Open. You can then make changes to the template in the Source Editor.
*/

currently I am only getting what is printed in the catch block which is
There has been a problem creating your account. Please contact the site administrator via email this address
SQL Error executing query="trixma","123","Bob","brown","apple@gmail.com")'

So my query is throwing an SQLException and i want to stop this. The query is meant to store the results into mySQL and currently it is not but throwing an exception, I want help in fixing my code so it no longers throws the exception but stores the data into the database Users.

I did copy it, the message is exactly how i saw it in html view, i ran getMessage() and found that I needed to fix up some file permissions, and once i did this i fixed the problem. Thanks for your help Norm, its most appriciated