matjaz cof

I am new in JBuilder and my english isn't very good so let me appologize
for all of my stupid mistakes.

I spend 4 hours to connect jBuilder with MySQL. I sucessfully connect
with Component under DataExpres (Database and QueryDataSet). It works fine.

But my trouble is when i try to execute select query on table that has
200 000 rows. Than my application froze.

LoadOptions in queryDataSet under query property doesn't work fine. I
try all of four options: Load all rows, Load rows Asynchronously, Load
as needed, Load 1 row at time, but my applet has frozen again.
And yes i write an applet, my tables and mysql aren't on localhost.

So what have i doing wrong?

Which components i must use, to get rows in my tables with 200 000 rows
count. I don't want to Load all rows, but only that that i needed.

john moore

Are you looking at the Java Console to see if an error is being generated..

My guess is that you are trying to load data from a server that is
different from the "web server".. If that is the case you are comming up
against the "sandbox" security of the applet..

You need to re think how you are transporting the data back and forth..

Suggestions: XML or DataSetData component via RMI

John..

--
=============================================
TeamB are volunteer helpers. Please DO NOT REPLY VIA EMAIL!
Post all questions and replies to this newsgroup ONLY
For papers on DataExpress, Applets, JSP, and Web Development go to:
http://www.microps.com/mps/paperFAQ.html
================================================== ==

matjaz cof

I think a lot at the weekend and i get the next idea. On server i pack
data(table) to an txt file, get this file zipped and then send to the
client. Client will data unzip, and read from an txt file.

I don't know if this is the fastest solution, but it is better then read
data directly across the internet and a MySQL base.

So, your suggestion is to send data(table) to the client not to read
table from server. I think this is much better.

Could you tell me 3 more statements about "DataSetData component via RMI".

thanks