Agustin

Hi Jonathan,

It's no problem of machine memory. We have enough.

I have a database with data from hundreds of users and I do 27 queries on each of them. All the queries are 'Select'.

For each user, I open and close the connection to the database.

When I am in the 25th user, I get this error and Matlab crashes. My Matlab version is 7.11 (R2010b).

Do you have any idea?

Thanks

Hi Jonathan

Thanks for your help. The problem with the tinyint issue is fixed.

But, now, there is a problem of lack of memory.

After several queries I get the following error:

"Error using ==> MySQLDatabase>SQLDatabase.open at...
Java exception occurred:
java.sql.SQLException: java.lang.OutOfMemoryError: PermGen space..."

This is an example of the queries:

"st3= strcat('SELECT * FROM',' `',tablesq_sm(14),'`');
db.prepareStatement(char(st3(1)));
fieldsqacc = db.query();
assert(~isequal(-1, fieldsqacc));
"

Every time that I change the subject, I close and reopen the database.

"db = MySQLDatabase(...
db.close();"

Do you know where is the problem?

Thanks in advance!