Database.oracle-database-prod.jdbc_driver=oracle.jdbc.driver.OracleDriver
Database.oracle-database-prod.connection_string=jdbc:oracle:thin:@host:port:oracle_instance
Database.oracle-database-prod.userid=user
Database.oracle-database-prod.password=passwd
Database.accessDB-test.jdbc_driver=sun.jdbc.odbc.JdbcOdbcDriver
Database.accessDB-test.connection_string =jdbc:odbc:ptr.mdb
Database.accessDB-test.userid=access_user
Database.accessDB-test.password=access_password
Database.mysql-database-dev.jdbc_driver=org.gjt.mm.mysql.Driver
Database.mysql-database-dev.connection_string=jdbc:mysql://11.11.11.11/CountryClub
Database.mysql-database-dev.userid=demo
Database.mysql-database-dev.password=demo
database.alias.app1-database=mysql-database-dev
database.alias.app2-database=oracle-database-prod
database.alias.app3-database=accessDB-test
Databases aliases are used for changing your databases with out changing the rest of the code.
request.getEmployees.classname=com.ai.db.DBRequestExecuor2
request.getEmployees.db=app2-database
request.getEmployees.stmt=your-select-statement-goes-here
See how the app2-database alias could be pointing to any of the above databases. Changing this indirection will not impact the select query called "getEmployees". One can use this mechanism especially to move between development, testing, and production with out extensively changing code.
Currently there is no concept of a default database. This means with every select statement you have to use a database alias. You can not skip and assume a default one.
1. Aspire data access over view
2. Using aspire for relational data access. This article also goes into the number of ways one can use Aspire for queries, updates, and transactions. This artcile also talks about a tool for testing data access and validating your connection strings.