the vanishing table ...

bearbear · **Joined:** Mon Mar 12, 2012 7:07 am **Posts:** 9

My java class :

Code:

@Entity
public class DeploymentDescriptor  implements Serializable {
    @Id
    @GeneratedValue
    private long id;

    @NaturalId
    private String key ;

   //+getter + setters
}

the trace of the validation

Code:

  create table DeploymentDescriptor (
        id bigint not null auto_increment,
        key varchar(255),
        primary key (id),
        unique (key)
    )

and the result of execution :

Code:

org.hibernate.exception.SQLGrammarException: Table 'config1.deploymentdescriptor' doesn't exist

while all other tables that have a reference to 'deploymentdescriptor' are generated, this table disappears ...
all other tables in the same package with equivalent definition are ok, some reference this one .... except it is never really created!
baffling...
any suggestion? (edit: oops: using mySQL)

bearbear · **Joined:** Mon Mar 12, 2012 7:07 am **Posts:** 9

C'mon boys this is stupid: I have a field with the name 'key'!!!!
there is a collision with SQL keyword 'key' in mySQL ..... no error message is popping out!
and I spent hours trying to understand why the table does not appear!
May I file a bug report somewhere? to whom?

bearbear · **Joined:** Mon Mar 12, 2012 7:07 am **Posts:** 9

bearbear wrote:

C'mon boys this is stupid: I have a field with the name 'key'!!!!
there is a collision with SQL keyword 'key' in mySQL ..... no error message is popping out!
and I spent hours trying to understand why the table does not appear!
May I file a bug report somewhere? to whom?

I tried to file a bug report but JIRA pretends I do not exist (though I used the "can't access your account" link).
if bug report is a complex task volunteers just give up...

sanne.grinovero · **Posted:** Thu Mar 15, 2012 5:55 pm

Hi bearbear,
I'm sorry for all your trouble, indeed that looks very annoying.
I can try looking what's wrong with your JIRA account, what is your JIRA username?

bearbear · **Joined:** Mon Mar 12, 2012 7:07 am **Posts:** 9

sanne.grinovero wrote:

Hi bearbear,
I'm sorry for all your trouble, indeed that looks very annoying.
I can try looking what's wrong with your JIRA account, what is your JIRA username?

OOps sorry was not aware that JIRA name was different from Hibernate user name.
so is there a specific name for Jira for Hibernate and one for Hibernate forums ???

sanne.grinovero · **Posted:** Fri Mar 16, 2012 9:01 am

yes it's two independent services. You should create an account on JIRA if you don't have one.