I try to use a CMP without PK in JBoss 3.2.5, but have the following exception from the finder method: anonymous wrote : | 2005-02-10 18:27:32,540 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.Transaction#findAll] Executing SQL: SELECT FROM MYTABLE t0_t | 2005-02-10 18:27:32,590 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.Transaction#findAll] Find failed | java.sql.SQLException: Syntax error or access violation message from server: "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 'FROM MYTABLE t0_t' at line 1" | at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997) | at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167) | at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278) | ...... | The executed SQL statement looks messed up. Is there any XDoclet tag that I need to specify? Thanks in advance.
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3866168#3866168 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3866168 ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
