dcsimg
Why am I getting ORA- 17090
0 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   srinivas_gopalan
Posted On:   Monday, June 14, 2004 11:43 PM

hi all, when i am creating the Statement object with the two parameters, resultSetType and resultSetConcurrency and executing the query, i am getting an SQLException saying operation not allowed on the highlighted line below. If I remove the parameters while creating connection, or if I remove the order by statement in the sql-query, it is working fine. My code look like this: String qry= Connection con=ds.getConnection(); Statement st=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); rs=st.executeQuery(qry); rs.last(); // i am getting exception in this line int ct=rs.getRow()   More>>

hi all,

when i am creating the Statement object with the two parameters,
resultSetType and resultSetConcurrency and executing the query,

i am getting an SQLException saying operation not allowed on the highlighted line below.

If I remove the parameters while creating connection, or if I remove the order by statement in the sql-query,
it is working fine.
My code look like this:

String qry=
Connection con=ds.getConnection();

Statement st=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);

rs=st.executeQuery(qry);



rs.last(); // i am getting exception in this line



int ct=rs.getRow();//finding the no of rows

rs.beforeFirst();



while(rs.next())

{

System.out.println("Code.."+rs.getString(1)+" "+"Name.."+rs.getString(2));

}


Can anybody tell me why is it so.


thanks in advance

srinivas

   <<Less
About | Sitemap | Contact