MySQL - community version - driver settings

Hello,

I hvae installed MySQL in the community version and load data from ChEMBL and commercial sets.

Since it is not the commercial version of MySQL the ODBC driver in PP doesn't work (I get an error when I set up the connection).

I downloaded the jdbc driver from oracle, and loaded it.

I can create the connection and actually connect to the data.

However if I want to pull out lots of data from the database, by default MySQL stores the data in memeory and then sents it, and I run out of memory.

I found some solution online:

http://benjchristensen.com/2008/05/27/mysql-jdbc-memory-usage-on-large-resultset/

and

http://stackoverflow.com/questions/2447324/streaming-large-result-sets-with-mysql

The main point seems to add those lines at the beggining of the connection:

stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY,              java.sql.ResultSet.CONCUR_READ_ONLY);stmt.setFetchSize(Integer.MIN_VALUE);

So the records are streamed to the application instead of being stored.

However I have no idea at all how I can change it on PP server so it actually works.

Does someone have this problem before, and managed to solve it? Or knows how to change the settings for the driver connection?

Thank you

Jérémy