Hi experts, I'm trying to move my application to Hibernate. Until now, I was using JDBC to persists my POJOs to the database.
I made a couple of test and everything just worked fine.
But I've got this little problem.
Let me explain it.

private PreparedStatement selectAll(Connection aCon) throws SQLException{
StringBuffer text = new StringBuffer();
text.append("Select * from " + this.getSchema() + "jkEmpresa");
text.append(" where activo = 1");
PreparedStatement qSelect = this.getPreparedStatement(aCon, text.toString());
return qSelect;
}

This is a very common select I use in all the table, just a select * from the table.
If you can see, I use a method, "this.getSchema()", which resolves me the database I'm using.
As my application saves data from the front end, in different databases occording to the user configuration, I use that method to solve that for me.
Eg: If i'm in database 1, it'll make:

select * from database1.dbo.jkempresa or
select * from database2.dbo.jkempresa...

Now, the only way see to make Hibernate do this for me, is using different datasources, each one pointing to different databases... am I wrong?? do you have any ideas???
Thanks in advance!

You should create different SessionFactory's.

From the Advanced FAQ in http://www.hibernate.org/117.html:



Regards,

Jos

or take a J2EE Server
or take http://c-jdbc.objectweb.org/

HTH
Ernst