Problem in ResultSet

[jaya repaka]

Hi,
I am getting error Invalid operation for read only resultset
when I executed this program.Please tell me what wrong I did

import com.uhc.basics.dao.*;
//import com.uhc.basics.ods.dao.*;
 
 
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.PreparedStatement;
 
public class TestDAO extends GenericDAO{

public TestDAO()
{

}

void initVariables()
{
m_driverClassname = "oracle.jdbc.driver.OracleDriver";
m_jdbcURL = "jdbc  :-o	  racle:thin:bods04/[e-mail]:1525:bodsddb";
}

void testConnection()
{
System.out.println("Connection =  " +m_connection);
}

void executeStmt()
{
try{
Connection con = getConnection();

String query = "SELECT * FROM BODS04.GL_ACCOUNT";

Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
System.out.println("Statement = "+stmt); 

ResultSet rs = stmt.executeQuery(query);
System.out.println("rs = "+rs);

int concur = rs.getConcurrency();
// I am getting problem here:
if (concur == ResultSet.CONCUR_UPDATABLE)
System.out.println("ResultSet.CONCUR_UPDATABLE");
else if(concur == ResultSet.CONCUR_READ_ONLY)
System.out.println("ResultSet.CONCUR_READ_ONLY");

/*going to the first row */
System.out.println("First row = "+rs.next());

/*Value of first row */
System.out.println("Value of first row");
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));

/*Going to next row */
rs.next();
System.out.println("Value of next row");
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));

rs.moveToInsertRow(); 

rs.updateString("gl_acct_typ_cd","3");
//rs.updateRow();
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));

//rs.updateRow();
rs.insertRow();
            rs.moveToCurrentRow();
 
/*
System.out.println("before update");
int count = stmt.executeUpdate("UPDATE BODS04.GL_ACCOUNT SET GL_ACCT_TYP_CD = '3' WHERE GL_ACCT_NBR='2'");
System.out.println("after update count "+count);
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
*/
}catch(Exception e)
{
System.out.println("exception = "+e.toString());
}

}

 
}

Thanks in advance
Vani

[edited by Jeanne to add code tags]
[ June 10, 2004: Message edited by: Jeanne Boyarsky ]

[Stefan Wagner]

Perhaps you may edit your post to make it readable by [ code] -tags -[ /code] (there is button for it too).

Then you should give us the concrete errormessage and mark the line, it belongs too.