[ http://jira.jboss.com/jira/browse/JBSEAM-2179?page=comments#action_12384873 ] Pete Muir commented on JBSEAM-2179: ----------------------------------- What are you talking about? -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://jira.jboss.com/jira/browse/JBSEAM-2179?page=all ] Pete Muir updated JBSEAM-2179: ------------------------------ Summary: Seam-gen created pages show non-assigned ids (was: Seam-gen ) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://jira.jboss.com/jira/browse/JBSEAM-2179?page=all ] Pete Muir updated JBSEAM-2179: ------------------------------ Summary: Seam-gen (was: Seam-gen doesn't recognize identifier properties properly) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://jira.jboss.com/jira/browse/JBSEAM-2179?page=comments#action_12385026 ] Viorel Andronic commented on JBSEAM-2179: ----------------------------------------- All code trimmed for readability. @Entity @Table(name = "group", schema = "security") public class Group implements java.io.Serializable { @Id @Column(name = "id", unique = true, nullable = false) @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "gen_group") @SequenceGenerator(name = "gen_group", sequenceName = "security.group_id_seq", allocationSize = 1) public int getId() { return this.id; } } I have a PostgreSQL database. I don't know if the DDL is usefull because you cannot replicate this on MySQL and this is the only way you can autoincrement an identifier when using PostgreSQL(this is actualy generated by PostgreSQL when declaring id as serial): CREATE TABLE "security"."group" ( id integer NOT NULL DEFAULT nextval('"security".group_id_seq'::regclass), CONSTRAINT group_pkey PRIMARY KEY (id) ) As seam-gen, or hibernate-tools doesn't know how to recognize(at least from what I know of) the DDL above and because I didn't manage to dig deep enough into hibernate-tools ftls, I added to seam-gen/pojo/GetPropertyAnnotation.ftl the following lines: <#-- To be used for "id" named columns defined as serial in PostgreSQL --> <#if property.equals(pojo.identifierProperty) && property.name.equals("id")> @${pojo.importType("javax.persistence.GeneratedValue")}(strategy=${pojo.importType("javax.persistence.GenerationType")}.SEQUENCE, generator="gen_${clazz.table.name}") @${pojo.importType("javax.persistence.SequenceGenerator")}(name="gen_${clazz.table.name}", sequenceName="${clazz.table.schema}.${clazz.table.name}_id_seq", allocationSize=1) </#if> and now my entities know how to map correctly these types of DDLs(but only if the identifier column is named id). So the generation of the entity above is done somehow artificially. What I believe now is the following: seam-gen uses the same information when building xhtml pages as when building entities and isn't aware of the two lines: @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "gen_group") @SequenceGenerator(name = "gen_group", sequenceName = "security.group_id_seq", allocationSize = 1) that specify that id is assigned. I don't know if this makes any sense ... but what i'm trying to say is that: ! Seam-gen should now how to recognize " id integer NOT NULL DEFAULT nextval('"security".group_id_seq'::regclass) " as an autoincrement column in PostgreSQL, or the generation of vieproperty, ediproperty or list should be done according to entities not table information ! This is a major drawback in PostgreSQL because identifiers are not recognized properly. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://jira.jboss.com/jira/browse/JBSEAM-2179?page=all ] Pete Muir updated JBSEAM-2179: ------------------------------ Fix Version/s: (was: 2.0.0.GA) Assignee: Max Andersen (was: Pete Muir) Reopening and assigning to Max as this looks like a problem in hibernatetools, not seam-gen (hibernate tools is recognising this as an assigned id and so seam-gen is as well). -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://jira.jboss.com/jira/browse/JBSEAM-2179?page=comments#action_12385035 ] Viorel Andronic commented on JBSEAM-2179: ----------------------------------------- Hi Max, This is a SQL template that tells you when a column has a default value given by a sequence: select column_default from information_schema.columns where table_catalog='postgres' and table_schema='security' and table_name='group' the result is: "nextval('"security".group_id_seq'::regclass)" you can process this string and identify the keyword: 'nextval' that tells you: BINGO! I hope this is helpful -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://jira.jboss.com/jira/browse/JBSEAM-2179?page=all ] Pete Muir closed JBSEAM-2179. ----------------------------- Resolution: Won't Fix Viorel, please open an issue Hibernate Tools JIRA (it's not in the same JIRA instance as this, so we can't just move the issue). -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira