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 on 1 page. 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

Threaded View


Previous Topic		Next Topic

Flat 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?

Palani kumar

Posts: 7
Nickname: coolgossip
Registered: Mar, 2002

Re: Resultset TYPE_SCROLL_INSENSITIVE

Posted: Mar 25, 2002 11:15 PM

Have u imported the javax.sql.* package ?

Rajeshwari

Posts: 4
Nickname: rrb
Registered: Mar, 2002

Re: Resultset TYPE_SCROLL_INSENSITIVE

Posted: Mar 25, 2002 11:37 PM

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

Palani kumar

Posts: 7
Nickname: coolgossip
Registered: Mar, 2002

Re: Resultset TYPE_SCROLL_INSENSITIVE

Posted: Mar 26, 2002 8:44 PM

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

Rajeshwari

Posts: 4
Nickname: rrb
Registered: Mar, 2002

Re: Resultset TYPE_SCROLL_INSENSITIVE

Posted: Apr 1, 2002 1:33 AM

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.

Flat View: This topic has 4 replies on 1 page

Previous Topic

Next Topic


	Web Artima.com