Hi there,

We are looking to layer an java API on top of our existing documents database containing around 100,000 document (including translations) records. Hibernate looks like a good way for us to put a custom document management API on this system. I am about to try Hibernate now but in the meantime I have one immediate question from looking over the docs.

Is it possible to join into a file system? Some databases such as Oracle and Sybase let you bring files on a filesystem in as a column in a table. It would be useful for us to define filesystem (or url) mappings to documents in the hibernate mapping file.

Of course we can join at a higher level or as a two step process but thought I would ask anyway.

Damon.

You could probably load a file document as a class property by using a custom UserType. They are not very dynamic however, take a look if it fits your needs.