Database Connection in datasource

[rpatibandla]

Is there a way I can specify the connection settings in each and every datasources rather than in server.properties.We have 2 databases and some of the datasources should connect DB1 and rest to DB2.How do we achieve this?

Regards
Rajesh Patibandla

[bbruyn]

User server.properties like you always did:

sql.WHATEVERNAMEYOUWANT.driver.serverName: yourdbserver.fqdn
sql.WHATEVERNAMEYOUWANT.driver.databaseName: yourdbName

and add a dbName attribute to your datasource definition

<DataSource xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  ID="YourDataSourceId"
  dbName="WHATEVERNAMEYOUWANT"
  ...
  >