Help with Hibernate configuration


I need help to configure a Hibernate.

We have several users/companies that access the application using there own url, for exampel "[url removed, login to view]".

However, each company has their owb database/schema and we want Hibernate to be configured to select a correct Database/Schema based on which url is used in the web page request.

## Deliverables

We are using hibernate-spring-wicket in a webapp deployed in Tomcat.

MySQL is used as database. Currently each customer run a single

instance of our application in a dedicated tomcat, using one dedicated

physical database each.

We want to consolidate our servers by moving several customers from

their own separate tomcats into a single shared tomcat backed by a

single mysql server using separate logical databases/schemas for each

customer. The idea is to simply select the correct database/schema

based on which frontend-adress the customer requests. e.g. if the customer requests the webpage "[url removed, login to view]" the application should use the database schema "company1" for all

requests, while simultaneously selecting different schemas for other users (company2, company3 etc).

Currently we configure hibernate using various properties-files but these are by their nature application-wide and we dont want that, as explained above we want dynamic selection of database/schema for each session.

How do we do this in hibernate? The delivery should either be instructions for us to this and we verify by actually doing this or you setting up hibernate for us or setting up a test environment with hibernate and a MySQl database and provide means for us to see that it works as we wanted.

Habilidades: PHP, Arquitectura de software, Verificación de software, Web Hosting, Gestión de páginas web, Verificación de páginas web

Ver más: spring for php, application server configuration, moving up in a company, spring/hibernate, spring hibernate, Hibernate , spring hibernate wicket, webapp spring, access database help wanted, dynamic php mysql application, php mysql webapp, php webapp, company help wanted, schemas, access help wanted, using php wicket, mysql web frontend, php mysql dynamic selection, dynamic webpage php, requests simultaneously

Información del empleador:
( 143 comentarios ) Kungens Kurva, Sweden

Nº del proyecto: #3617852

Adjudicado a:


See private message.

$118 USD en 30 días
(11 comentarios)

2 freelancers están ofertando el promedio de $99 para este trabajo


See private message.

$80.75 USD en 30 días
(105 comentarios)