Hi, I'm wondering if you should have a space provided between the INSERT line and the VALUES line. If I were troubleshooting this, I would probably start with using hard-coded values in the SQL statement as well just to verify functionality at that level, and monitior the table results with Access. If it still doesn't work, keep watering it down until it does. There are some decent examples of JDBC at its simple best at http://java.sun.com/docs/books/tutorial/jdbc/basics/index.html <http://java. sun.com/docs/books/tutorial/jdbc/basics/index.html> . GL, -Steve -----Original Message----- From: yilmaz [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 26, 2001 4:16 AM To: [EMAIL PROTECTED] Subject: Another strange SQLException "string out of range" SQLException[JOB] Connection failed String index out of range: -19 "INSERT INTO chat (name, subject, message) " + "VALUES (?, ?, ?)"; This message may contain information which is private, privileged or confidential and is intended solely for the use of the individual or entity named in the message. If you are not the intended recipient of this message, please notify the sender thereof and destroy / delete the message. Neither the sender nor Sappi Limited (including its subsidiaries and associated companies) shall incur any liability resulting directly or indirectly from accessing any of the attached files which may contain a virus or the like. ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
