0

HI to all! I am facing some exceptions in my database connectivity programs. I am using jdk7, window7 and Ms Access 2007. I am giving code of programs and exeption.

import java.sql.*;


public class ResultSetEx
{
    public static void main(String[] args)
     {

             try
           {

         Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

        String url = "jdbc:odbc:personDSN";

        Connection con = DriverManager.getConnection(url);

        // creating prepare statement by passing
        // sql and ResultSet's constants so that the 
        //ResultSet that will produce as a result of executing 
        // query will be scrollable and updatable

          String sql = "SELECT *FROM persons";

          PreparedStatement pStmt = con.prepareStatement(sql,ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); 




           // execute query

          ResultSet rs = pStmt.executeQuery();


          // moving cursor forward i.e first row

           rs.next();

         // printing column "name" value of current row(first)

           System.out.println("moving cursor forward");

            String name  = rs.getString("name");
            System.out.println(name);

            // moving cursor forward i.e on to second row

             rs.next();

             // moving cursor backward i.e to first row

             rs.previous();

            // printing column "name" value for of current row(first)

           System.out.println("moving cursor backward");

            name = rs.getString("name");

            System.out.println(name);

          // close the connection

            con.close();

         }

   catch(Exception sqlEx)
        {
          System.out.println(sqlEx);
         }

      }// end main

  }// end class

Following exception is occuring in above program:
java.lang.StringIndexOutOfBoundsException: String index out of range: -1

program2:

import java.sql.*;

public class ResultSetEx2
{
    public static void main(String[] args)
     {

             try
           {

         Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

        String url = "jdbc:odbc:personDSN";

        Connection con = DriverManager.getConnection(url);

        // creating prepare statement by passing
        // sql and ResultSet's constants so that the 
        //ResultSet that will produce as a result of executing 
        // query will be scrollable and updatable

          String sql = "SELECT *FROM persons";

          PreparedStatement pStmt = con.prepareStatement(sql,ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); 




           // execute query

          ResultSet rs = pStmt.executeQuery();


           // moving cursor  to second row

             rs.absolute(2);

             // update address column of 2 row in rs

             rs.updateString("address", "model town");

           // update the row in database

            rs.updateRow();


          // close the connection

            con.close();

         }

   catch(Exception sqlEx)
        {
          System.out.println(sqlEx);
         }

      }// end main

  }// end class

Following exception is occuring;
java.lang.StringIndexOutOfBoundsException: String index out of range: -1

2
Contributors
1
Reply
5
Views
2 Years
Discussion Span
Last Post by JamesCherrill
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.