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

2001-09-23 Thread 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')"; Appare

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

2001-09-23 Thread BlyonsJ2EE
Right now, I have tried Microsofts own example of the SQL statement which does not differ much from my original statement it is in the form INSERT INTO Employees (FirstName,LastName, Title) VALUES ('Harry', 'Washington', 'Trainee'); However, I do not have a SQL client at home to test directly.

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

2001-09-22 Thread BlyonsJ2EE
Hi dim, Still having no success. I think it might be that access has a problem with prepared statements. I'll keep trying to insert successfully and will test it at work with Oracle. I will let you know what happens. Thanks, Brian

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

2001-09-22 Thread BlyonsJ2EE
Hello All, I am trying to insert two values into a access database from a Servlet. The values are form variables consisting of a URL and a name. I'm getting the following error: SQL Exception Caught: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. If anyo

How to Instaniate Bean from Servlet?

2001-09-22 Thread BlyonsJ2EE
Hello, Please note: This email was submitted twice because of an error in the SQL statement in the first email. I am having a problem instaniating a Javabean from a Servlet. When compiling the Servlet the following error occurs: 'cannot resolve symbol: Linkbean linkbean = new LinkBean();'

How to Instaniate Bean from Servlet?

2001-09-22 Thread BlyonsJ2EE
Hello, I am having a problem instaniating a Javabean from a Servlet. When compiling the Servlet the following error occurs: 'cannot resolve symbol: Linkbean linkbean = new LinkBean();' I have run this servlet before instaniating the bean in the same manner with Weblogic. Any help as to wher

Re: Upcoming Tomcat 4.0 Final Release

2001-09-05 Thread BlyonsJ2EE
Craig, Something interesting happening over here with Tomcat Beta 7 that might interest you, or perhaps you can provide a solution for the problem I am experiencing. After installing Tomcat 4, I built a very simple servlet for testing purposes. This particular servlet compiled and executed w