I am developing a solution. This solution is based on Sybase. In this solution i have table which is storing all the .wav file into media fileds. This table has few sample data. When i am importing this solution in other servoy mechine which is configured with Mysql. Solution is importing sucessfully, but when it importing sample data giving error. After error it is not importing data for reset of the tables.
Sample data import failed for table table_wavrecords, exception
com.servoy.j2db.persistence.RepositoryException : java.sql.SQLException: must rollback
Sample data import failed
com.servoy.j2db.persistence.RepositoryException :
com.servoy.j2db.persistence.RepositoryException : No transaction active for id= No transaction active for id=
This my first time with Servoy with Mysql.
Is Sybase treated Blob differently from Mysql?
Worth checking the MySQL setting for “max_allowed_packet” size - if this is smaller than the largest blob/media field you are importing then the import process will fail.
It is possible to edit the .ini files with a text editor but suggest you download MySQL Administrator program (free) - http://www.mysql.com/products/tools/administrator/ - then after setting up the connection go to “Options” and select “Advanced Networking” from the drop down menu.
Another great MySQL tool for importing/exporting and copying MySQL databases is Navicat - http://www.navicat.com/ - not free but well worth looking at.