anonymous wrote : From what i know, Hibernate allows the schema to be set through one of its APIs. Yes hibernate allows it. But I need to create seperate sessionfactiories for each database. Since number of database is more , this may not be good solution . And if somebody gets the connection from hibernate session and use that connection for JDBC query , it will use the default catalog which is set in the ds.xml View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4151908#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...