Does JBoss support CMP without primary key?

bluezero000 Feb 10, 2005 7:00 PM

I try to use a CMP without PK in JBoss 3.2.5, but have the following exception from the finder method:

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.