At a guess, I'd say it's not really an XDoclet problem nor even an EJB problem, at least not exactly. It looks to me more like a SQL problem - "desc" is a reserved word (as in "SELECT foo FROM bar ORDER BY bub DESC"), so I reckon your database is objecting to the SQL that JBoss' CMP engine has generated for the create method. Try renaming your field/column to "description" rather than "desc" and see if that works any better.
I changed the column to descriptions but now get.
java.sql.SQLException: Column not found: DESCRIPTION in statement [INSERT INTO ROLES (name, description, comments) VALUES ('Kevin', 'All', 'Everyone')]
I'm trying to keep it simple so I am just using the DefaultDS with typemapping of Hybernat SQL.
I believe it is creating the table dynamicaly?
this is my setting from my build.xml
<jboss
version="3.0"
xmlencoding="UTF-8"
destdir="${ejb.dd.dir}"
validatexml="false"
typemapping="Hypersonic SQL"
/>
_________________________________________________________________
Instant message during games with MSN Messenger 6.0. Download it now FREE! http://msnmessenger-download.com
------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ xdoclet-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/xdoclet-user
