We are developing a new application running against a legacy Sybase 12.5.3 database. We have a requirement/nice-to-have for this new application that it utilize JPA exclusively for application data access.

This database instance has numerous occasions where the same table structure is repeated across multiple schemas (i.e. Sybase databases).

We are able, using vanilla Hibernate to map a single class that maps to different, yet structurally identical tables using the 'entity-name' attribute to the <class> mapping.

However, we cannot find a way to solve this issue other than mapping native SQL queries; we'd prefer to not do that for obvious reasons.

Since this is a new project, we're open to working with any version of Entity Manager &/or Hibernate.