Rank: 245950 based on 0 downloads (last 30 days) and 0 file submitted
photo

Agustin

E-mail

Personal Profile:
Professional Interests:

 

Watch this Author's files

 

Comments and Ratings by Agustin View all
Updated File Comments Rating
19 Jul 2012 queryMySQL Platform independent MySQL database solution with blob support. Author: Jonathan Karr

Hi Jonathan,

Finally, I have fixed the issue. I's was my fault.

I was doing the import of the java class in each iteration. And the java memory in Matlab was running out.

Now, It's running fine.

Many thanks. It's a great job.

Regards.

18 Jul 2012 queryMySQL Platform independent MySQL database solution with blob support. Author: Jonathan Karr

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

17 Jul 2012 queryMySQL Platform independent MySQL database solution with blob support. Author: Jonathan Karr

17 Jul 2012 queryMySQL Platform independent MySQL database solution with blob support. Author: Jonathan Karr

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!

08 May 2012 queryMySQL Platform independent MySQL database solution with blob support. Author: Jonathan Karr

Hi Jonathan,

I had a problem trying to import data from a table. The data is type number with a single character. The problem is with the method getTiny for com.mysql.jdbc.JDBC4ResultSet

Contact us