|
(Converting slowly from https://intranet.urbancode.com/support/process-for-hooking-up-ahp-to-customer-databases)
|
(→ASSEMBLE CONNECTION)
|
| Line 12: | |||
| ## One method for finding this is analyzing the DB_VERSION table in the database. | ## One method for finding this is analyzing the DB_VERSION table in the database. | ||
| ## Use '''derby''' as the installation database; we will change this afterwards | ## Use '''derby''' as the installation database; we will change this afterwards | ||
| - | Install an agent that matches that version of the server (if necessary). | + | # Install an agent that matches that version of the server (if necessary). |
| - | Download/obtain the driver for the database type that was being used and copy it to the %SERVER_HOME%\lib\ext directory | + | # Download/obtain the driver for the database type that was being used and copy it to the '''%SERVER_HOME%\lib\ext''' directory |
| - | For example, if using Oracle, you could be using http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-111060-084321.html (ojdbc5.jar) | + | ## For example, if using Oracle, you could be using http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-111060-084321.html (ojdbc5.jar) |
| - | Modify the %SERVER_HOME%\conf\server\installed.properties file with the following values: | + | # Modify the '''%SERVER_HOME%\conf\server\installed.properties''' file with the following values: |
| - | install.db.schema=null | + | ## ''install.db.schema''= <font face="monospace">null</font> |
| - | install.db.url=[[database's url connection string]] | + | ## ''install.db.url''= <font face="monospace">database's url connection string</font> |
| - | install.db.password=[[database user's password]] | + | ## ''install.db.password''= <font face="monospace">database user's password</font> |
| - | install.db.driver=[[database driver's terminology name]] | + | ## ''install.db.driver''= <font face="monospace">database driver's terminology name</font> |
| - | Example for oracle: oracle.jdbc.driver.OracleDriver | + | ### Example for oracle: <font face="monospace">'''oracle.jdbc.driver.OracleDriver'''</font> |
| - | install.db.user=[[database user's username]] | + | ## ''install.db.user''= <font face="monospace">database user's username</font> |
| - | install.db.type=[[type of database installed]] | + | ## ''install.db.type''= <font face="monospace">type of database installed</font> |
| - | Example for oracle: oracle | + | ### Example for oracle: '''<font face="monospace">oracle</font>''' |
| - | Modify %SERVER_HOME%\conf\spring-server\base.xml file and change any occurrences of: | + | # Modify '''%SERVER_HOME%\conf\spring-server\base.xml''' file and change any occurrences of: |
| - | url to [[database's url connection string]] | + | ## url to <font face="monospace">database's url connection string</font> |
| - | username to [[database user's username]] | + | ## username to <font face="monospace">database user's username</font> |
| - | password to [[database user's password]] | + | ## password to <font face="monospace">database user's password</font> |
| Modify %SERVER_HOME%\conf\server\spy.properties file by changing line 42: | Modify %SERVER_HOME%\conf\server\spy.properties file by changing line 42: | ||
| realdriver=[[database driver's terminology name]] | realdriver=[[database driver's terminology name]] | ||
