Hello Steven, Just a wild guess, you're probably using same credentials/account in context.xml for both data sources, while you're using different credentials/account in each Spring datasource bean.
Kind regards, Stevo. On Thu, Mar 15, 2012 at 2:12 PM, Steven Xiong <xcste...@yahoo.com> wrote: > I have a Spring/JPA application running on Tomcat 6.0.29 accessing two > schemas of a single Oracle database. Each schema is configured as a > seperate datasource. If we config the datasources as spring beans of > "com.mchange.v2.c3p0.ComboPooledDataSource" type, the app works correctly. > However if we use two JNDI datasources configured in META-INF/context.xml, > the both autowired datasources point to only ONE same schema. > > Any thoughts? > Thanks > > Steven >