-
1. Re: error in your SQL syntax near 'FROM product WHERE ' at l
aragorn94 Mar 7, 2003 4:11 AM (in response to wqhhust)Three changes in your XDolclets tags (options i use with Eclipse & Lomboz):
- Replace (should not be the problem)
* generate="false" => * generate="true"
- add this tag before your setter methods (are they really generated ?)
* @ejb:interface-method
- Replace the tag in getId method
*@ejb:pk-field
by
* primkey-field = "id"
in * @ejb:bean tag
I read somewhere it's better and i use second (but i don't think this has many impact)
Please reply if all is OK. (I will check with my code this afternoon) -
2. Re: error in your SQL syntax near 'FROM product WHERE ' at l
aragorn94 Mar 7, 2003 3:27 PM (in response to wqhhust)Correction :
i don't use generate attribute in @ejb:pjk tag (but true is the default)
but i use
primkey-field = "id" generate = "true"
in the @ejb:bean tag
here's a complete XDoclet tags i use for a bean (no *@ejb:pk-field at method level) :
/**
*
*
* @ejb:bean name="User"
* jndi-name="jndi/UserBean"
* primkey-field = "email" generate = "true" schema = "UserBeanSch" view-type = "local"
* type="CMP"
* cmp-version="2.x"
*
* @ejb:pk class = "java.lang.String"
*
* @ejb:finder
* signature="Collection findAll()"
* query="select Object(o) from UserBeanSch as o"
* result-type-mapping="Local"
*
* @jboss:table-name table-name = "user"
*
* @jboss:create-table "true"
*
**/ -
3. Re: error in your SQL syntax near 'FROM product WHERE ' at l
aragorn94 Mar 7, 2003 3:42 PM (in response to wqhhust)Correction :
i don't use generate attribute in @ejb:pjk tag (but true is the default)
but i use (i think i had some problem like yours before settings this XDoclet attributes, not sure) :
primkey-field = "id" generate = "true"
in the @ejb:bean tag
here's a complete XDoclet tags i use for a bean (no *@ejb:pk-field at method level) :
/**
*
*
* @ejb:bean name="User"
* jndi-name="jndi/UserBean"
* primkey-field = "email" generate = "true" schema = "UserBeanSch" view-type = "local"
* type="CMP"
* cmp-version="2.x"
*
* @ejb:pk class = "java.lang.String"
*
* @ejb:finder
* signature="Collection findAll()"
* query="select Object(o) from UserBeanSch as o"
* result-type-mapping="Local"
*
* @jboss:table-name table-name = "user"
*
* @jboss:create-table "true"
*
**/ -
4. Re: error in your SQL syntax near 'FROM product WHERE ' at l
aragorn94 Mar 7, 2003 3:45 PM (in response to wqhhust)Correction :
i don't use generate attribute in @ejb:pjk tag (but true is the default)
but i use (i think i had some problem like yours before settings this XDoclet attributes, not sure) :
primkey-field = "id" generate = "true"
in the @ejb:bean tag
here's a complete XDoclet tags i use for a bean (no *@ejb:pk-field at method level) :
/**
*
*
* @ejb:bean name="User"
* jndi-name="jndi/UserBean"
* primkey-field = "email" generate = "true" schema = "UserBeanSch" view-type = "local"
* type="CMP"
* cmp-version="2.x"
*
* @ejb:pk class = "java.lang.String"
*
* @ejb:finder
* signature="Collection findAll()"
* query="select Object(o) from UserBeanSch as o"
* result-type-mapping="Local"
*
* @jboss:table-name table-name = "user"
*
* @jboss:create-table "true"
*
**/ -
5. Re: error in your SQL syntax near 'FROM product WHERE ' at l
aragorn94 Mar 7, 2003 3:46 PM (in response to wqhhust)Correction :
i don't use generate attribute in @ejb:pjk tag (but true is the default)
but i use (i think i had some problem like yours before settings this XDoclet attributes, not sure) :
primkey-field = "id" generate = "true"
in the @ejb:bean tag
here's a complete XDoclet tags i use for a bean (no *@ejb:pk-field at method level) :
/**
*
*
* @ejb:bean name="User"
* jndi-name="jndi/UserBean"
* primkey-field = "email" generate = "true" schema = "UserBeanSch" view-type = "local"
* type="CMP"
* cmp-version="2.x"
*
* @ejb:pk class = "java.lang.String"
*
* @ejb:finder
* signature="Collection findAll()"
* query="select Object(o) from UserBeanSch as o"
* result-type-mapping="Local"
*
* @jboss:table-name table-name = "user"
*
* @jboss:create-table "true"
*
**/