We have an Spring + hibernate java application on jboss app server. Currently we are taking db schema name from the hibernate properties mentioned in application Context XML.

HIbernate Default Schema in hibernate properties. ( Current )

We have a requirement to take the SB Schema name from one of the database table.

I am bit confused, Where to insert this logic in spring + Hibernate configuration.

Please help.

Please help on this question.

Try to not configure the hibernate.default_schema property, i.e. remove it from your properties file. Hibernate will then automatically use the schema that is the default for the defined database user.