<database>

The data source is the result of a query against a database. The query is expressed in the <query> sub-element.

driver

Required: JDBC driver class name. For example:

Oracle 9.2.0—oracle.jdbc.driver.OracleDriver
SQL Server 2000—com.microsoft.jdbc.sqlserver.SQLServerDriver

The jar file containing the driver must be present in <install-root>/lib.

url

Required: URL to connect to the database. For example:

Oracle 9.2.0—jdbc:oracle:thin:@hostname:1521:dbname
SQL Server 2000—jdbc:microsoft:sqlserver://hostname:1433;DatabaseName=dbname;SelectMethod=cursor
where hostname is the name of the database server host, and dbname is the name of the database.

user

Required: User to log on to the database.

password

Required:. Password for the specified database user. Passwords beginning with “{3DES}” are assumed to be encrypted with the <install-root>/bin/encrypt utility.

connection

Name of the server’s internal connection pool from which database connections are obtained. (Mutually exclusive with driver, url, user and password.)

Note:

Starting with Release 2.5.1, you can omit all of the above attributes to signify that the database is the same one used by the Integrated Operational Planning Server.