i want to get remote database records one by one on client thorugh java RMI, Is there any example?

Question

i m using java RMI. I have done insertion, deletion, updation through client on remote database but when selecting records on there how can i show all records on client, should i creat large number of string arrays which is a bad idea at all...how?

Answer 1

To start with, I am assuming that you have an RMI client that connects to an RMI server, that in turn used JDBC to talk to a database.

The answer is to use a Swing TableModel implementation that retrieves each row of data on demand by fetching that row from the ResultSet held by the RMI server. As long as you don't bother keeping more than a small set of rows of data at any time (a small cache) within the TableModel, you should be able to handle nearly any amount of data.

See this discussion for more information: http://forum.java.sun.com/thread.jspa?threadID=382833&messageID=1811582