Shaheen Hussain wrote:
>
> I think my original email may have been somewhat vague, as the solutions
> being presented are not for the problem i'm experiencing. For this i
> appologise.
>
> ok, the problem is not with retrieving the results from the resultset, the
> problem is with replacing the place holders in the query with other values,
> so if i had (taking Chris' example):
>
> String value;
> ResultSet res;
> PreparedStatement stm = con.prepareStatement("select value from table where
> number=?");
> for(int i = 0;i < 5;i++) {
> stm.setInt(1,i);
> res = stm.executeQuery(); //the error is occuring here, on
> second itereation
> while(res.next()) {
> value = res.getString(1);
> }
> }
>
> This only happens with jdk1.2, 1.1 works fine.
Sounds like you've been bitten by bug #4101823, see
http://developer.java.sun.com/developer/bugParade/bugs/4101823.html
The current status is "Closed, not reproducable" but I have seen the
same thing with JDK 1.2 and so has many others. There are a few work-arounds
that you may try. You may also like to try with the latest JDK 1.2 dot
release (1.2.2 ?).
--
Hans Bergsten [EMAIL PROTECTED]
Gefion Software http://www.gefionsoftware.com
___________________________________________________________________________
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
