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