More than 1 Datasource/Connection Pool for the same Database

[Santhosh Kalisamy]

Hi,

I have been given to maintain an application.

JRE - Java 1.4.02 (I know, stone age application)
JBoss - 3.2.6 (Yes, it has been released before I born)

No of applications deployed on server : 1

and below is the datasource configuration.

<local-tx-datasource> <jndi-name>MyDataSource1</jndi-name> <connection-url>jdbc:oracle:thin:@DBXXXX:1521:DBXXXX</connection-url> <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> <user-name>UserName1</user-name> <password>XXXXXXXXXXXX</password> <max-pool-size>30</max-pool-size> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name> </local-tx-datasource> <local-tx-datasource> <jndi-name>MyDataSource2</jndi-name> <connection-url>jdbc:oracle:thin:@DBXXXX:1521:DBXXXX</connection-url> <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> <user-name>UserName1</user-name> <password>XXXXXXXXXXXX</password> <max-pool-size>30</max-pool-size> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name> </local-tx-datasource>

For some reason, they have created 2 datasources to the same database, same schema and same user account to access. I don't know, why? and No documentation there for it.

Now, my question:

Will this affect the performance (Speed) ? If so, will it increase speed or slow down?

[Siitesh Hind]

I have not seen much of a difference on the test environment that I am having.

Not deployed it on Production though to see what happens.

[Jaikiran Pai]

The mere fact that there are 2 datasources pointing to the same DB doesn't necessarily have to do anything with the performance. It's ultimately how those datasources are used and what kind of traffic/user activity and other technical details of the application, that decide the performance.