[ http://opensource.atlassian.com/projects/hibernate/browse/ANN-701?page=co... ] Emmanuel Bernard updated ANN-701: --------------------------------- Fix Version/s: 3.3.1 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/ANN-701?page=co... ] Tim Evers commented on ANN-701: ------------------------------- OK, I've managed to get the building of the table working. But, the @CollectionId annotation is ignored. In that the n_key_contact column is not created by the automatic schema generation. Should I raise this as a new issue? -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/ANN-701?page=co... ] Tim Evers commented on ANN-701: ------------------------------- Ok, I've uploaded the Entity and the Embeddable classes to show the problem I'm having. I have been trying to get this working and I have used 2 different databases and I'm getting the same issue on both databases. So I'm pretty sure this is not an Ingres issue here. And I have been able to reproduce this using MySQL. This is the SQL being generated for the creation of the schema. 08:56:53.176 [main] gekko-pool [] create table pr_tenure (n_key_tenure bigint not null, d_created date, d_updated date, f_active bit not null, d_expiry date, t_file_ref varchar(255), d_commencement_date date not null, t_customer_ref varchar(255), n_deposit numeric(19,2), d_expiry_date date, d_final_payment_cert_date date, t_elvas_case_id varchar(255), t_final_payment_cert_number varchar(255), n_purchase_price numeric(19,2), f_residential bit, t_service_addressee varchar(255) not null, c_account_type varchar(255) not null, c_rent_type varchar(255), t_source varchar(250), c_tenure_status varchar(255), t_subdivision varchar(255), c_lease_purpose varchar(255), t_tenure_ref_no varchar(255), c_tenure_type varchar(255), t_title_ref varchar(255), n_key_tenure_customer bigint, n_key_financial_group bigint not null, n_key_service_address bigint not null, n_key_ligislative_group bigint not null, n_key_user_created bigint, n_key_land bigint, n_key_proposal bigint, n_key_user_updated bigint, primary key (n_key_tenure)); (16 milliseconds) 08:56:53.192 [main] gekko-pool [] create table pr_tenure_account (n_key_tenure bigint not null, d_commencement_date date not null, t_customer_ref varchar(255), n_deposit numeric(19,2), d_expiry_date date, date date, finalPaymentCertElvasCaseId varchar(255), finalPaymentCertNumber varchar(255), n_key_financial_group bigint not null, n_key_ligislative_group bigint not null, n_purchase_price numeric(19,2), f_residential bit, n_key_service_address bigint not null, t_service_addressee varchar(255) not null, c_account_type varchar(255) not null, n_index_order integer not null, primary key (n_key_tenure, n_index_order)); (16 milliseconds) As you can see it is not sending the @CollectionId column information in the SQL. Could you please advise what else I can try? A couple of things I'd like to know are: What is the SQL being generated by your tests? and What database are you using? -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/ANN-701?page=co... ] Emmanuel Bernard commented on ANN-701: -------------------------------------- Hibernate Annotations raises a meaningful exception now. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira