Re: New To Java - Cant't get Database Insert to work

[BlyonsJ2EE]

Hi Dim,

Thanks for your help.  The problem is resolved.  The error was caused because 
I apparently used a reserved word as a colum name in the database.  In the 
original Servlet I was using the statement: 

"INSERT INTO LINKS (VALUE, NAVIGATION_TEXT) VALUES ('George', 'Washington')"; 
 

Apparently using 'VALUE' as a colum name in the database is mistake.  

The successfull insert statement is:

"INSERT INTO LINKS (NAV_VALUE, NAVIGATION_TEXT) VALUES ('George', 
'Washington')";

Thanks Again,

Brian