Stefan Evans wrote:>SEVERE: java.sql.SQLDataException: A truncation error was encountered trying to shrink VARCHAR 'firstname.lastname@example.org' to length 10.
This error seems obvious enough.
The database field you are storing the email address to allows only 10 characters.
So take a look at the App.ApplyJob table and see that you are inserting into the correct column, and that column is large enough to store values in.
- Java code belongs in servlets, not in JSPs.
- Use prepared statements rather than constructing SQL strings. You are opening yourself up to SQL Injection attacks.
- Use a JNDI Datasource to obtain database connections rather than making a database connection yourself.