Re: problem in resultset relative method - Mailing list pgsql-jdbc

Arun,

The problem must have been with the previous code, because this is doing
what it should be doing.

Here are the results of my run

Row 1Value -->1
Row 2Value -->3
Row 3Value -->6
Row 4Value -->10
Row 5Value -->10
Row 6Value -->10
Row 7Value -->10
Row 8Value -->10
Row 9Value -->10
Row 10Value -->10


the first one get's row 1 and increments kk to 2 which moves relative to
the third row, and then increments kk to 3 which moves relative to row
3, and then increments kk to 4 which moves relative to row 10

Dave

On Fri, 2002-05-03 at 03:49, arun vc wrote:
> hello
>
> i have found some problem in using the relative()
> method of ResultSet
>
> the problem occured when i upgrade my old
> postgres.jar driver with the new one posted on ur site
> http://jdbc.postgresql.org/download/pgjdbc2.jar
>
> try exicte this program using both drivers
> and u will find the difference
>
> import java.sql.*;
>
> public class sqlDriverTest
> {
>     String Driver = "org.postgresql.Driver";
>     String Bridge="jdbc:postgresql://localhost/database";
>     String LoginName="postgres";
>     String Password="postgres";
>
>      try
>      {
>
>            Class.forName(Driver);
>            Connection con=
> DriverManager.getConnection(Bridge,LoginName,Password);
>         System.out.println("Connection made: " + con);
>
>         PreparedStatement pm=con.prepareStatement("SELECT *
> FROM admin");
>         ResultSet rs=pm.executeQuery();
>
>         rs.last();
>         int tot=rs.getRow();    //my tot returned 10 records
>
>         rs.beforeFirst();
>
>         int kk=1;
>
>         while(kk<=tot)        //the program stoped after reading 3
> records and rest of the 7 records are shown wrongly
>         {
>             rs.relative(kk);
>             System.out.println(rsProj.getString(1));
>             kk=kk+1;
>         }
>
>
>        }
>      catch(Exception e)
>      {
>          System.out.println("Error "+e.getMessage());
>      }
>
>     }
>
>         //the program stoped after reading first 3 records
> and rest of the 7 records are shown wrongly
>         //why iam getting error in using relative() method
> this problem was not in the previous postgres.jar
> driver
>
>         please look in to this problem
>
> =====
> The Future belongs to those who believe in the beauty of their dreams...............................................
> Arun VC, E Team India Web Solutions,
> Serene,Anupama Nagar,Pongummoodu,Trivandrum
> Phone: +91 471 558089. Fax   : +91 471 551807.
> http://www.e-teamindia.com
> http://www.geocities.com/vcarun
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Health - your guide to health and wellness
> http://health.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
>