Anyone done this successfully? I have the December 2001 release of Struts (I think this is 1.0) and I am developing a webapp that has a need for two datasources. I modified the struts-config and, leaving the default data-source without a key, added the new data-source (same Oracle database - diff user/pwd).
... <data-source> <set-property property="key" value="loadFoo"/> <set-property property="autoCommit" value="false"/> <set-property property="description" value="Oracle" /> <set-property property="driverClass" value="oracle.jdbc.driver.OracleDriver" /> <set-property property="maxCount" value="50"/> <set-property property="minCount" value="1"/> <set-property property="url" value="jdbc:oracle:thin:@192.168.0.10:1521:dev" /> <set-property property="user" value="foo"/> <set-property property="password" value="bar"/> </data-source> ... The Application class calls: public void initDatabase() { // try to get a db handle DataSource ds = null; Connection dbConn = null; try { ds = super.findDataSource(null); dbConn = ds.getConnection(); } catch (Exception e) { return; } ..... I gen the .war file and deploy it. Tomcat starts and you see the first data-source load and: org.apache.struts.util.GenericDataSource properties are set to the default (null key). Then you see the second data-source load and the GenericDataSource properties are set to the second data-source. Now - when the inits run, he runs the queries against the second data-source even though I am using the null value for DATA_SOURCE_KEY. ARGGH! I stumbled through the Digester code and the format of data-source seems correct. Can anyone assist? I am pulling what little hair I have left out :o) Thanks in advance. Brian BTW - I also tried naming the default data-source with a key = "default" - no go. He loads, but the behavior is the same. -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>