Media data and MySQL

Classic Servoy
1

Hi Guys, do any of you have any experience with Media data and MySQL

I am trying to integrate Julian Salerno’s MediaStream plugin with a MySQL solution. The Demo is currently set up in Servoy and works so I know the plugin is working, however transfering the data source to MySQL results in an importing error.

This seems to be an issue with the Media field where the import of the solution to MySQL gives the following error:

“The server version of the column ‘media’ of table ‘media’ in server ‘mediamanager’ has length -2147483639 while in the import version the column has length 2147483647.”

Any ideas regarding what the issue is or better still a solution would be gratefully received. Sybase is not really an option as a/ cost is an issue and b/ I have a lasso/flash/mysql soltuion already built as a web front for this project. Converting to Sybase is definatly a last resort, and potentially a non starter.

I understand that media fields in MySQL are set small by default is this the case and how do you change the setting ? I assume a MySQL media field is effectively the same as a Sybase equivalent and therefore 1.5mb audio file should not be an issue ?

Platform: Mac OSX104
MySQL: v4
Servoy R2.2 build 328
Mediamanager Plugin R1.02

I would like to stress that Julian’s plugin is working and is not the issue provided you are using Sybase and not MySQL (in fact its excellent!!)

Many thanks in advance
Gordon

2

Did you upgrade your jdbc mysql driver to the latest and greatest from mysql’s website?

3

Thanks Jan, I will do that too!! The fix was sorted by Lee McNeil, apparently the blob size is fixed to 1mb in the config (my.cnf), we have re set it and hey presto its all working !!

many thanks

Gordon