Hi Stevo, I checked many times, the users are different in context.xml
Thanks ________________________________ From: Stevo Slavić <ssla...@gmail.com> To: Tomcat Users List <users@tomcat.apache.org>; Steven Xiong <xcste...@yahoo.com> Sent: Thursday, March 15, 2012 9:21:58 AM Subject: Re: Datasources in Spring-JPA-Tomcat 6.0.29 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 >