Announcement Announcement Module
No announcement yet.
default_schema using JDBCTemplate Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • default_schema using JDBCTemplate

    How can I define a default_schema for my DAO's that extend JdbcDaoSupport versus HibernateDaoSupport? For my Hibernate DAO's the tables will be prefixed with the hibernate.default_schema property definition, although I don't know how to do this for my JDBC DAO's?

  • #2
    Check this thread

    It has something to do with setting schema on a Connection. It works for Hibernate, your own JDBC DAO's etc.

    But a drawback is that it executes as SQL call each time you get a connection from the pool.

    I was looking into optimizing this but couldn't figure out how to do it properly if you have 2 or more schema's to swtich between as I do. (5 in total).

    Anyone with a good solution would be appreciated.
    Last edited by robyn; May 14th, 2006, 12:30 PM.