I am having trouble getting multiple datasources to work in my application. I have searched the archives and found inofrmation on how to do it but the solutions given are depricated. Can anyone help me?
<data-sources> <data-source> <set-property property="key" value="MRA"/> <set-property property="driverClass" value ="oracle.jdbc.driver.OracleDriver"/> <set-property property="url" value="jdbc:oracle:thin: @147.101.104.63:1524:common"/> <set-property property="user" value="MRA"/> <set-property property="password" value="mralog"/> </data-source> <data-source> <set-property property="key" value="PHONE_DB"/> <set-property property="driverClass" value ="oracle.jdbc.driver.OracleDriver"/> <set-property property="url" value="jdbc:oracle:thin: @oid:1521:infoprd"/> <set-property property="user" value="info_user"/> <set-property property="password" value="info_user"/> </data-source> </data-sources> try { ServletContext context = servlet.getServletContext(); DataSource dataSource = (DataSource) context.getAttribute(Action.DATA_SOURCE_KEY); conn = dataSource.getConnection(); stmt = conn.createStatement(); rs = stmt.executeQuery(sql); Thank you for your help Tim Bachta Information Technology MC 48 -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>