-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Leonardo Francalanci wrote:
> I have a large table (64,000,000 rows).
> Everything was fine when the table was 16,000,000 rows,
> now connectorJ crashes:
>
> java.sql.SQLException: java.lang.ArrayIndexOutOfBoundsException: 6
> at
>
com.mysql.jdb
A non-streaming connection will place the resultset in memory. With large
tables you can run out of memory and the application will stop. A streaming
resultset does not place the entire dataset in memory and therefore you can
retrieve `large` data sets. In order versions of connectorJ the default w
Dude. I wouldn't post your server ip here. ouch.
God Bless
Paul C. McNeil
Developer in Java, MS-SQL, MySQL, and web technologies.
GOD BLESS AMERICA!
To God Be The Glory!
-Original Message-
From: Leonardo Francalanci [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 22, 2004
Are you using a streaming connection?
-Original Message-
From: Leonardo Francalanci
To: Mysql
Sent: 6/22/04 7:43 AM
Subject: connectorJ & huge table problem
I have a large table (64,000,000 rows).
Everything was fine when the table was 16,000,000 rows,
now connectorJ crashes:
java.sql.S
