MySQL Connector: mYm

I am trying to compile for Win64, any luck anyone?

I was getting this "out of sync" error as well. I think that it is related to autocommit and using InnoDB tables. It happens in other languages (eg PHP and Python), so it may not be a bug of mYm. Actually the cpp source code is very neat!

To use my InnoDB table, I first send the following:

            mym('SET autocommit = 1');

Then everything seems to work fine.

I also noticed that sending multiple SQL commands in one go, e.g.

mym('begin; insert ...; end;')

will not work well. It may execute, but if there is an error in the query, it won't be returned to you. Rather use
mym('begin');
mym('insert ...');
mym('end');

I have been able to compile this on mac 10.6.2 with the following command line:

/Applications/MATLAB_R2009b.app/bin/mex -v -maci64 -I../mysql-connector-c-6.0.2-osx10.5-x86-64bit/include/ -I/Applications/MATLAB_R2009b.app/extern/include/ -L/Applications/MATLAB_R2009b.app/bin/maci64/ -L../mysql-connector-c-6.0.2-osx10.5-x86-64bit/lib/ -lz -lmysqlclient_r -lSystemStubs -lpthread mym.cpp

Unfortuntely, upon running mym from matlab I get:

>> mym
??? Invalid MEX-file '/Users/cp/Downloads/mym_src_v1.0.9/mym.mexmaci64': dlopen(/Users/cp/Downloads/mym_src_v1.0.9/mym.mexmaci64, 1):
Library not loaded: libmysql.16.dylib
  Referenced from: /Users/cp/Downloads/mym_src_v1.0.9/mym.mexmaci64
  Reason: image not found.

I think this is due to the whole @loader mechanism in OS X. I think this could be solved by linking the libraries statically. How do I do that with mex?

Thanks
CRP