Probably also need to put quotes around varchar datatype.
stmt.executeUpdate("INSERT INTO JSP_TESTS VALUES ( " + employee_id + ",'" +
name + "')");
-----Original Message-----
From: Joe Milora [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 19, 2000 9:09 AM
To: [EMAIL PROTECTED]
Subject: Re: Error inserting in DataBase
try
stmt.executeUpdate("INSERT INTO JSP_TESTS VALUES ( " + employee_id + "," +
name + ")");
-----Original Message-----
From: Jose Castro [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 19, 2000 8:39 AM
To: [EMAIL PROTECTED]
Subject: Error inserting in DataBase
Hi,
I'm new with JSP's, and right now I'm testing JSP with WebLogic Server and
with two databases (Oracle and CloudScape).
The following code is used to insert some data in the database, but it
returns an error that I don't know how to fix.
ERROR:
E:\weblogic\myserver\classfiles\examples\jsp\_dbtest\_Personal_95_form_95_v4
_95_2.java:77: '}' expected.
probably occurred due to an error in dbtest\Personal_form_v4_2.jsp line 20:
" %>
E:\weblogic\myserver\classfiles\examples\jsp\_dbtest\_Personal_95_form_95_v4
_95_2.java:78: Statement expected.
probably occurred due to an error in dbtest\Personal_form_v4_2.jsp line 21:
E:\weblogic\myserver\classfiles\examples\jsp\_dbtest\_Personal_95_form_95_v4
_95_2.java:85: Type expected.
(No more information available, probably caused by another error)
CODE (with line numbers):
16. <%@ page import="
17. weblogic.db.jdbc.*,
18. java.sql.*,
19. weblogic.common.*
20. " %>
23. <%
24. Connection conn = null;
25. public Connection getCon()
26. {
27. Class.forName("weblogic.jdbc.pool.Driver").newInstance();
28. conn = DriverManager.getConnection("jdbc:weblogic:pool:oraclePool");
29. return conn;
30. }
31. %>
32.
33. <%
34. conn = getCon();
35. if (conn != null)
36. {
37. String employee_id = (String) request.getParameter("employee_id");
38. String name = (String) request.getParameter("name");
39.
40. Statement stmt = conn.createStatement();
41. stmt.executeUpdate("INSERT INTO JSP_TESTS VALUES (employee_id, name)");
42. ResultSet ds = stmt.getResultSet();
43. ds.close();
44. }
45. %>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
