hi, everyone, I am writing a CMP bean. And it is very simple, and now I need to insert a row with create(). However, when I invoke create(), I get such exceptions:
Executing SQL: SELECT COUNT(*) FROM users WHERE 2006-05-23 15:36:22,328 ERROR [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.User] Error checking if entity exists java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
I think I did right in all the files, could you tell what is the possible problem? Thanks a lot!
posted 11 years ago
Hi .. Can you add your query. You said you are inserting and the error is showing a select query?