test/jdbc/network/Statement/TestScript10.java

   1
   2 //Irrespective of number set in setFetchSize(), getFetchSize() should return 1
   3
   4 import java.sql.*;
   5 /**
   6  *
   7  * @author bijaya
   8  */
   9 public class TestScript10 {
  10  public static void main(String[] args)
  11     {
  12        try
  13        {
  14            Class.forName("csql.jdbc.JdbcSqlDriver");
  15             Connection con = DriverManager.getConnection("jdbc:csql://localhost:5678", "root", "manager");
  16                Statement cStmt = con.createStatement();
  17            cStmt.execute("CREATE TABLE T1 (f1 integer, f2 smallint, f3 tinyint, f4 bigint, f5 float, f6 char(10), f7 date, f8 time, f9 timestamp);");
  18                con.commit();
  19                PreparedStatement stmt = null, selStmt= null;
  20            stmt = con.prepareStatement("INSERT INTO T1 VALUES (?,?,?,?,?,?,?,?,?);");
  21            stmt.setInt(1, 1);
  22            stmt.setShort(2,(short)2);
  23                    stmt.setByte(3,(byte)3);
  24                    stmt.setLong(4,(long)4);
  25                    stmt.setFloat(5,(float)5);
  26            stmt.setString(6, String.valueOf(5));
  27                    stmt.setDate(7,Date.valueOf("2008-03-21"));
  28                    stmt.setTime(8,Time.valueOf("18:00:00"));
  29                    stmt.setTimestamp(9,Timestamp.valueOf("2008-03-21 18:00:00"));
  30            stmt.executeUpdate();
  31            stmt.close();
  32            con.commit();
  33
  34            cStmt = con.createStatement();
  35            cStmt.execute("SELECT * from T1;");
  36            ResultSet rs=cStmt.getResultSet();
  37            int retval=cStmt.getFetchSize();
  38            System.out.println("Default Fetch Size "+retval);
  39            cStmt.setFetchSize(3);
  40            retval=cStmt.getFetchSize();
  41            System.out.println("Default Fetch Size "+retval);
  42            while (rs.next())
  43            {
  44                  System.out.println("Tuple value is " + rs.getInt(1) + " "+
  45                                                         rs.getShort(2) + " "+
  46                                                         rs.getByte(3) + " "+
  47                                                         rs.getLong(4) + " "+
  48                                                         rs.getFloat(5) + " "+
  49                                                         rs.getString(6) + " "+
  50                                                         rs.getDate(7) + " "+
  51                                                         rs.getTime(8) + " "+
  52                                                         rs.getTimestamp(9) + " "
  53                                                         );
  54            }
  55            rs.close();
  56            cStmt.close();
  57
  58            cStmt.execute("DROP TABLE T1 ;");
  59            con.close();
  60         }catch(Exception e) {
  61              System.out.println("Exception in Test: "+e);
  62              e.printStackTrace();
  63              System.exit(0);
  64         }
  65     }
  66 }