Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

SQL syntaxt error in CMP in JBoss 4.0  RSS feed

 
magic zha
Greenhorn
Posts: 24
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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!
 
Srikanth Garnepudi
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi .. Can you add your query. You said you are inserting and the error is showing a select query?
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!