Hello, I just started using Hibernate for persistence in a Tapestry project. I am stuck with using Filemaker 7 database. I know that it's not oficially supported by Hibernate (and it is very far from my 5-th choice of a database) however it does have ok JDBC driver support.

I am actually able to persist objects from my Tapestry application but the database (from what I understand) hides the primary key column away from the users. Furthermore, the only way that the primary key can be displayed is in a read-only column. I had to create an additional column in the table to be used with the <id> element.

My question is, can I use a readonly column in which a primary key is auto-generated by the database as my <id> element column and if so what generator should I use or how should I go about this.

Thanks in advance.

Sincerely,

Leo

Maybe

works straight a way.

HTH
Ernst

Thanks for the suggestion. I'm using a generic dialect since I really can't locate what dialect Filemaker 7 supports and 'identity' is not supported with generic dialect.

Any suggestions?

Thanks.

I'd have a look at the source of other dialects which do support the identity generator (MySql). Find out how they do the insert ant how they retrieve the id.
Once you know that you can extend the generic dialect to support Filemaker 7.

HTH
Ernst