Martin and Wendy thank you very much for getting back to me.
I replaced the '?' with ? alone, and I'm now getting this error:
SEVERE: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE emailAddress = 'firstname.lastname@example.org'' at line 1
Hey Jeanne – thanks for suggesting a solution. I removed the coma after the last field as you suggested and it is not throwing any errors anymore. However, the issue that I have right now is that the database is not storing the information. Checked the database after storing the values and nothing is being stored. Do you have any suggestion why this is happening?
The Insert command doesn't work at all. No records are being added to the database. I don't have any stack trace the when I run the application the only things shown in Glassfish output log is the confirmation that the application is running and how long it took for it to be deployed.
The information to be added to the database is being passed from a html form.
This is the servlet of registration form for which the database should store the entered information: