Hello,

My team is running a java app with an oracle server. We are using hibernate with annotations for object relational mapping.

The challenge which we are faced with, is that we want to set up a sandbox for each developer for testing. However, using an oracle backend makes it infeasible for each user to have their own database.

The solution we came up with, is to assign a new schema for each developer.

First of all, is this the best way to do this?
Secondly, is there a way to dynamically create hibernate bindings at run time?

Any help is mutch appreciated.

Dave

>>First of all, is this the best way to do this?

I think what you have is a strategy that works, and that's the most important thing. As far as dynamic binding, well, it depends on how dynamic you want it to be?

Thanks for the reply.

I guess you're right in that above all else, it is more important for a solution that works.

The brings us to the second question. When speaking about dynamic binding, I am wondering if there is away to condition the schema for hibernate bindings based on a user's identity?

Meaning, after starting a junit test, can we set our hibernate bindings based on different conditions?

For instance, in our junit setup, can we do something like:

public setUp() {
if (env != "prod")
bind hibernate model to "dev_" user
else
bind hibernate model to "prod_" user
}

I'm unsure whether hibernate allows runtime bindings...