I am getting following exception while executing merge query in mysql 3.2. I am using embedded java library called mysql-je. Its an open source project (http://mysql-je.sourceforge.net/).
EXCEPTION IN RESULTSET WRAPPER WHILE EXECUTING QUERY: java.sql.SQLException: All tables in the MERGE table are not identically definedjava.sql.SQLException: All tables in the MERGE table are not identically defined
at com.mysql.embedded.api.api.mysql_real_query(Native Method)
David O'Meara wrote:the error message is pretty informative. have you looked at that?
Yes I did search for that but I found no solution. They all were talking about incompatible engine type and datatype. But I've all tables created with MyISAM.
Alright, thanks for the info. I read that but it was working fine with the original mysql daemon. I've just copied the whole database from another location. Do you have anything in mind that can be solve this problem.