How do I access specific schemas in hibernate spring?

Question

I use Hibernate-Spring and I am trying to access a specific schema in a db but don't know how. The name of the table is not doing the trick. I was hoping that annotation would help be but it hasn't so far. Note: I am not trying to create a schema, I just want to access it. I use Spring 2.5.

Answer 1

Set schema in your mappings:

@Table(name="myentity", schema="some")

<class name="MyEntity" table="myentity" schema="some">

or use default:

hibernate.default_schema="some"