aspose file tools*
The moose likes JDBC and the fly likes .NET dataset in java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark ".NET dataset in java" Watch ".NET dataset in java" New topic
Author

.NET dataset in java

liana lim
Greenhorn

Joined: Oct 12, 2008
Posts: 8
i want to know if there is a tool like .NET dataset but in java

i need to perform like this :
// BIG PROCESS begin
process a begin
get data from database
process
save result to database
end process a

process b begin
get data from database(which is process a result)
process
save result to database
end process b

next process ....
///BIG PROCESS end

i want to cut database access, because it make the application work slower.
thanks
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

A ResultSet is probably what you are looking for.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
liana lim
Greenhorn

Joined: Oct 12, 2008
Posts: 8
i already try resultset, i can't update resultset without update the database
i use 2 commands to update resultset
resultset.updateString(index,string) and resultset.updateRow()
with those command both of resultset and database get updated.

// BIG PROCESS begin
process a begin
get data from database
process
save result to resultset
end process a

process b begin
get data from resultset(which is process a result)
process
save result to resultset
end process b

next process ....
///BIG PROCESS end
save data to database

can i do like that with resultset. if i can, how?
thanks
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Cache your results in a Collection of some sort.
stefano bitossi
Greenhorn

Joined: Oct 06, 2010
Posts: 5
you could search for some library implementing the cachedrowset interface (http://download.oracle.com/javase/1.5.0/docs/api/javax/sql/rowset/CachedRowSet.html , http://download.oracle.com/docs/cd/E17824_01/dsc_docs/docs/jscreator/apis/rowset/com/sun/rowset/CachedRowSetImpl.html ) , otherwise you'll have to make it by yourself. A dataset is a collection of Table objects (a bean in java) which holds a list of rows , and a set of Adapters , objects which manages the connections and the queries between db and your application using tables
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: .NET dataset in java