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 was non streaming.
-----Original Message----- From: Leonardo Francalanci To: 'Mysql ' Sent: 6/22/04 7:55 AM Subject: R: connectorJ & huge table problem > Are you using a streaming connection? ehm... how do I know? My conn string is jdbc:mysql://192.168.0.253:3000/LETSPARTY1?autoReconnect=yes where 192.168.0.253 is a machine on my LAN... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]