8 Replies Latest reply on Nov 19, 2010 8:53 AM by Philani Dlamini

    EJB application with multiple database support

    Philani Dlamini Newbie

      Hi Everyone


      Will try and keep this very short and sweet


      Basically i need to write an EJB application that uses Hibernate Entity manager on JBOSS , this app needs to dynamically issues custom SQL queries at runtime. I undestand these queries will be optimized for Oracle & MySQL for now.


      Scenario: If my app is using an Oracle database, it will use an Oracle data source and will need to lookup the oracle specific SQL to use for the application from somewhere.


      Our aim to to let our customers choose the database they want and as programmers we need to cater for that from the EJB solution but we want to only "write once".


      Please help.