Home.... | log in.... | Pub my question! | Sign-up....
Java-index >> Database Connectivity >> Java Database Connectivity (JDBC)

Problem with populating ROWSET

Hi ,

I have a problem with ROWSET.

I have a table with 6 columns and approximately more than 200 records.

I reterive them in a ResultSet and resultset gets populated.

But I populate Rowset with that ResultSet then it hangs for atleast 1 minuate and then it comes back to its original state.

Can anyone have thge idea why it happens....?

Is therer any issue with the Rowset ?

Why it takes too much time to populate the rowset..?

Thanks

Tariq

[509 byte] By [Java_persona] at [2007-11-27 11:32:12]
«« java heap space problem...
»» NavigatableSetExample:Error with the code
# 1

Isn't there JDBC GURU on this forum who can solve my problem?

Java_persona at 2007-7-29 16:44:10 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2

> Isn't there JDBC GURU on this forum who can solve my

> problem?

then post your SSCCE so that we can tell which part of your code has problem.

http://mindprod.com/jgloss/sscce.html

Yannixa at 2007-7-29 16:44:10 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 3

Here it is....

CachedRowSetImpl crs = new CachedRowSetImpl();

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

ResultSet result = stmt.executeQuery(sql); // Here we have 250 records in ResultSet

crs.populate(result); // This is the problem. This line takes atleast 1min to execute

Any solution u gurus have ....

Java_persona at 2007-7-29 16:44:10 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 4

Hello guys......

Nobody have the solution of my problem......

Where are so called GURUS....

Java_persona at 2007-7-29 16:44:10 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 5

> Where are so called GURUS....

Right here.

**** off.

cotton.ma at 2007-7-29 16:44:10 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 6

any solution mr.GuRu

Java_persona at 2007-7-29 16:44:10 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 7

> any solution mr.GuRu

Yes

cotton.ma at 2007-7-29 16:44:10 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 8

I think u r one of the DUMP person of this FORUM.

Java_persona at 2007-7-29 16:44:10 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 9

> I think u r one of the DUMP person of this FORUM.

I think you don't know how to spell the word dumb.

cotton.ma at 2007-7-29 16:44:10 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
Database Connectivity
Java Database Connectivity (JDBC)

Database Connectivity Hot Topic

Database Connectivity

All Classified