I have the following declaration but when I run my application I keep getting However, looking back at the log is seems that the mapping knows about the PostgreSQL schema I can't see anything else obviously wrong. Does anyone have any ideas on what else I can check for?

Cheers, Eric

Why do you add a quote inside the table name ?



Shouldn't you write ?

The internal quotes are necessary to preserve the mixed-case of the table name, otherwise everything is converted to lower case.

Cheers, Eric

OK, so if I take the schema strings out of the annotations in source code, and add the following to my hibernate.cfg.xml file then everything works fine. However, if instead I try to set the schema on the URL string then it doesn't work. The bottom line is I cannot seem to get my code to work just by specifying the schema in the annotations. I suspect there may be a bug somewhere, maybe in the provider, because I can get some code working by specifying the schema in the annotations, but I cannot get all the code working just using annotations.

I would rather not have to specify the schema in the cfg file as it limits the entire session to just that schema.

Does anyone else have any more clues?

Cheers, Eric

OK, I reported it as a bug. I have a workaround to useCheers, Eric