Cezar,
Thank you very .... very much. Problem solved.
It just don't like twice resultset.getString(1) on the same url string,
need to replace both with a String variable.
Thank you again, you are very helpful.
Weigen
-----Original Message-----
From: Cezar Totth [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 26, 1999 2:32 PM
To: [EMAIL PROTECTED]
Subject: Re: encodeUrl problem with parameter
Hi,
Not sure I'm right but some JDBC drivers become angry if you call
twice resultset.getString(1) on the same row. Try to save the result
on first getString(1) in a String variable and print that variable within
html..
Yup, even java.sql.ResultSet apidoc tells that..
Cezar
On Fri, 26 Mar 1999, Weigen Jin wrote:
> Cezar,
>
> You are right. I have getOutputStream() in the exception handling
> section.
>
> However, the problem still remains.
>
> If I am using rs.getString(1),
> it goes to exception handling,
> now saying there is no data found.
>
> If I used a value such as 719 instead of rs.getString(1),
> it works and displays all the rows in a table.
>
> Anybody who did this successfully, please let me know.
>
> Weigen
>
>
============================================================================
> =================
> The code is as follws:
>
> ... connect to db ... get resultset ...
>
> try {
> boolean more = rs.next ();
> while (more) {
> out.println("<tr>");
> out.println("<td Align=\"Left\"><a href=\"" +
> response.encodeUrl("/servlets/admin.AccountEdit?bankcode="
+
> rs.getString(1)) +
> //
> response.encodeUrl("/servlets/admin.AccountEdit?bankcode=771") +
> "\">" + rs.getString(1) + "</a></td>");
> out.println("<td Align=\"Left\">" + rs.getString(2).trim()
+
> "</td>");
> out.println("<td Align=\"Left\">" + rs.getString(3).trim()
+
> "</td>");
> out.println("<td Align=\"Left\">" + rs.getString(4).trim()
+
> "</td>");
> out.println("</tr>");
> more = rs.next ();
> }
> }
> catch(Exception e)
> {
> out.println ( "<html><body>" );
> out.println ( "Error occured in database: <b>" + e.getMessage() +
> "</b>");
> out.println ( "</body></html>" );
> }
>
>
>
>
>
> -----Original Message-----
> From: Cezar Totth [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 26, 1999 10:14 AM
> To: [EMAIL PROTECTED]
> Subject: Re: encodeUrl problem with parameter
>
>
> Hi,
>
> You probably call both getOutputStream() and getWriter() on the same
> request. The javax.servlet.ServletResponse API states that an
> IllegalStateException should be thrown if you try to use them both
> during the same request.
>
> Cezar
>
> On Thu, 25 Mar 1999, Weigen Jin wrote:
>
> > Hi,
> >
> > It seems such a simple one line, but I just can not get it works
> > (internal error).
> > ( rs.getString(1) is pulled out of from a SQL db )
> >
> > out.println("<td Align=\"Left\"><a href=\"" +
> >
response.encodeUrl("/servlets/admin.AccountMgmt?bankcode="
> +
> > rs.getString(1)) +
> > "\">" + rs.getString(1) + "</a></td>");
> >
> > if I replace rs.getString(1) with a value like 719 as follows
> >
> >
> > response.encodeUrl("/servlets/admin.AccountEdit?bankcode=719") +
> >
> > it works and displays the values in the table.
> >
> > Look at log file, it says
> >
> > [25/03/1999 17:31:04:219 EST] java.lang.IllegalStateException:
> > Already called getWriter
> > at java.lang.Throwable.<init>(Compiled Code)
> > at org.apache.jserv.JServConnection.getOutputStream(Compiled
Code)
> > at admin.AccountMgmt.service(Compiled Code)
> > at javax.servlet.http.HttpServlet.service(Compiled Code)
> > at org.apache.jserv.JServConnection.run(Compiled Code)
> > at java.lang.Thread.run(Compiled Code)
> >
> >
> > Any ideas ?
> >
> > (I am using Apache / Jserv).
> >
> > Thanks.
> >
> > Weigen
> >
> >
>
___________________________________________________________________________
> > 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
> >
>
>
> Cezar Totth email: [EMAIL PROTECTED]
> Fax: (401) 220 33 95
> Genesys Software Romania Phone: (401) 638 49 44
> Stefan Furtuna 169, sect.6
> cod 77171, Bucharest
> Romania
>
>
___________________________________________________________________________
> 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
>
>
___________________________________________________________________________
> 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
>
Cezar Totth email: [EMAIL PROTECTED]
Fax: (401) 220 33 95
Genesys Software Romania Phone: (401) 638 49 44
Stefan Furtuna 169, sect.6
cod 77171, Bucharest
Romania
___________________________________________________________________________
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
___________________________________________________________________________
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
