> Error messages, please.
> Paul
Dear Paul,
Thanks for your consideration,
please find attached the text file that is used to generate the jsp I am
having problems with. It is saved as updateTREES.jsp in the tomcat4
/examples/jsp directory of machine with jdk1.4/Apache2/Tomcat4.04
The problem seems to be with line 35 namely:-
Enumeration parameters = request.getParameterNames();
When trying to execute the jsp from http://host/examples/jsp/updateTREES.jsp
The error reported in Konqueror and Mozilla browser is as folows:
/opt/tomcat4/work/Standalone/localhost/examples/jsp/updateTrees$.jsp.java:62
Class org.apache.jsp.Enumeration not fount
Enumeration parameters = request.getParameterNames();
^
1 error, 1 warning
If you could provide some help it would be appreciated.
regards
sibu
On Saturday 10 August 2002 02:47, Paul Yunusov wrote:
> On Friday 09 August 2002 10:59 pm, sibusiso xolo wrote:
> > Greetings,
> >
> > I am using tomcat4.04 on SuSE8/postgresql7.2.1 with source compiled
> > jdbc driver.
> >
> > I am able to do SELECTS and other queries on database tables (with jsp
> > and servlets) but unable to do data UPDATES and INSERTS.. .
> >
> > Help would be appreciated.
> >
> > regards
> > sibu
>
> Error messages, please.
> Paul
// to be saved as updateTrees.jsp with html tag
<HTML>
<HEAD><TITLE>Using a jsp to Update a pgsql database table</TITLE></HEAD>
<BODY>
(P>Updata Database Table Content
<FORM ACTION="updateTrees.jsp" method = "Post">
Tree_Name: <INPUT TYPE = TEXT NAME =tree_nameParam><BR>
Average_Height_metres: <INPUT TYPE = TEXT NAME =av_height_mParam><BR>
Average_Diameter_cm: <INPUT TYPE = TEXT NAME =av_diameter_cmParam><BR>
Average_Lifespan_years: <INPUT TYPE = TEXT NAME =av_lifespan_yrsParam><BR>
Found_in: <INPUT TYPE = TEXT NAME =found_inParam><BR>
</FORM>
<HR>
<P> The TREES table contents:
<Table Border = 1 Cellpadding=0 CELLSPACING=0>
<TR><TD>TreeName</TD>
<TD>Average_Height_metres</TD>
<TD>Average_Diameter_cm</TD>
<TD>Average_Lifespan_yrs</TD>
<TD>Found_in</TD></TR>
<%
Class.forName("org.postgresql.Driver");
java.sql.Connection connection =
java.sql.DriverManager.getConnection("jdbc:postgresql://limpopo.b-lux.balls:5432/database","user","password");
java.sql.Statement statement = connection.createStatement();
Enumeration parameters = request.getParameterNames();
if(parameters.hasMoreElements())
{
String Tree_NameValue = request.getParameter("tree_nameParam");
String Average_Height_metresValue = request.getParameter("av_height_mParam");
String Average_diameter_cmValue = request.getParameter("av_diameter_cmParam");
String Average_Lifespan_yrsValue = request.getParameter("av_lifespan_yrsParam");
String Found_inValue = request.getParameter("found_inParam");
statement.executeUpdate("INSERT INTO TREES(Tree_Name, Average_Height_metres,
Average_Diameter_cm, Average_Lifespan_yrs, Found_in ) VALUES (Tree_NameValue,
Average_Height_metresValue, Average_diameter_cmValue, Average_Lifespan_yrsValue,
Found_inValue )" );
}
java.sql.ResultSet columns = statement.executeQuery( "SELECT * from TREES");
while (columns.next())
{
String Tree_Name = columns.getString("tree_name");
String Average_Height_metres = columns.getString("av_height_m");
String Average_Diameter_cm = columns.getString("av_diameter_cm");
String Average_Lifespan_yrs = columns.getString("av_lifespan_yrs");
String Found_in = columns.getString("found_in");
%>
<TR> <TD> <%= Tree_Name %> </TD>
<TD> <%= Average_Height_metres %> </TD>
<TD> <%= Average_Diameter_cm %> </TD>
<TD> <%= Average_Lifespan_yrs %> </TD>
<TD> <%= Found_in %> </TD>
</TR>
<% } %>
</TABLE>
</BODY>
</HTML>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
