Java Answers Forum - Resultset TYPE_SCROLL

Articles |
News |
Weblogs |
Books |
Forums

Artima Forums | Articles | Weblogs | Java Answers | News

Sponsored Link •

Java Answers Forum
Resultset TYPE_SCROLL_INSENSITIVE

4 replies. Most recent reply: Apr 1, 2002 1:33 AM by Rajeshwari

Welcome Guest
Sign In

Back to Topic List

Reply to this Topic

Search Forum

Flat View


Previous Topic		Next Topic

Threaded View: This topic has 4 replies on 1 page

Rajeshwari

Posts: 4
Nickname: rrb
Registered: Mar, 2002

Resultset TYPE_SCROLL_INSENSITIVE

Posted: Mar 25, 2002 10:41 PM

I'm trying to set the resultset as TYPE_SCROLL_INSENSITIVE but the resultset i get is always a TYPE_FORWARD_ONLY...Do i need to change my oracle driver?

Re: Resultset TYPE_SCROLL_INSENSITIVE

Posted: Mar 25, 2002 11:15 PM

Posted by: Palani kumar Posts: 7 / Nickname: coolgossip / Registered: Mar, 2002

Have u imported the javax.sql.* package ?

Re: Resultset TYPE_SCROLL_INSENSITIVE

Posted: Mar 25, 2002 11:37 PM

Posted by: Rajeshwari Posts: 4 / Nickname: rrb / Registered: Mar, 2002

yes..tried importing javax.sql.* package...doesn't work....

Re: Resultset TYPE_SCROLL_INSENSITIVE

Posted: Mar 26, 2002 8:44 PM

Posted by: Palani kumar Posts: 7 / Nickname: coolgossip / Registered: Mar, 2002

Hai
hope you are using the correct jdbc api .for scrollable resultset support ,you have to use jdbc api 2.0 or more .then only the scrollable resultset will be supported .

Cheers

Palani kumar

Re: Resultset TYPE_SCROLL_INSENSITIVE

Posted: Apr 1, 2002 1:33 AM

Posted by: Rajeshwari Posts: 4 / Nickname: rrb / Registered: Mar, 2002

Thanx a lot ...i got the solution....i was using a PreparedStatement instead of Statement.
prepareStaement() doesn't work for scrollabale resultset whereas createStatement works fine. :)
Thanx again.

Previous Topic

Next Topic


	Web Artima.com