Try OpenEdge Now
skip to main content
Managed Adapters Guide
Database Managed Adapter : Updating Database properties and server files
 

Updating Database properties and server files

When you create an application having one or more Database Adapters, it stores that database adapter's connection properties in the WORKSPACE\.com.savvion.studio\adapters\DBAdapters\db.properties file.
When you publish such an application on the server, you must update the OEBPM_HOME\server\adapters\db\conf\db.properties file on Business Process server and the OEBPM_HOME\jboss\server\ejbServer\deploy\bmjdbc\sbmcommondb-ds.xml file with the database properties and the data sources details.
To update database properties file on the server:
1. Copy the configurations of your Database Adapter from the db.properties file in the WORKSPACE\.com.savvion.studio\adapters\DBAdapters\ location to the db.properties file on the server in the OEBPM_HOME\server\adapters\db\conf\ location.
2. After copying the contents from the workspace location to the server location, ensure that you remove all the instances of “\” (backward slashes) from the db.properties file in the server location.
For instance, if you have added a Database adapter to your Business Web Flow and your db.properties file in your workspace has the following entry:
db1.name= DataDirect CloudNew
db1.type= DDCloud
db1.user=asmishra
db1.pass= encrypted password
db1.jndi= jdbc/DDCloudJNDI
db1.driver=com.ddtek.jdbc.ddcloud.DDCloudDriver
db1.url= jdbc:datadirect:ddcloud://das.ddcloud.progress.com;databasename=[DATASET_NAME];

db1.additional=
Update the db.properties file in the server, which might have other database properties in it, as follows:
db.count=2
db0.name=MYORACLEDB
db0.type=oracle
db0.user=ora_user
db0.pass=r9lLxM5ut6A=
db0.jndi=jdbc/MyOracleDB
db0.driver=oracle.jdbc.driver.OracleDriver
db0.url=jdbc:oracle:thin:@server1:1521:orcl
db0.additional=
db1.name= DataDirect CloudNew
db1.type= DDCloud
db1.user=asmishra
db1.pass= encrypted password
db1.jndi= jdbc/DDCloudJNDI
db1.driver=com.ddtek.jdbc.ddcloud.DDCloudDriver
db1.url= jdbc:datadirect:ddcloud://das.ddcloud.progress.com;databasename=[DATASET_NAME];

db1.additional=
Note: The server file may have existing database adapters, do not overwrite any existing properties, append the new one and give it the next higher number (db1 in the above example).
3. Increase the db.count by one whenever you add a new database property detail in the db.properties file, and then append to the end of the file, the new database’s properties.
4. Update the OEBPM_HOME\jboss\server\ejbServer\deploy\bmjdbc\sbmcommondb-ds.xml file with the newly added DDCloud driver Data Source information.
The following shows a sample entry of a DataDirect Cloud driver Data Source in the sbmcommondb-ds.xml:
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>jdbc/DDCloudJNDI</jndi-name>
<!- Change to DB specific connection-url and driver-class->
<connection-url>jdbc:datadirect:ddcloud://das-qa-int.palette-test.progress.com;databasename=MyDataSet</connection-url>
<driver-class>com.ddtek.jdbc.ddcloud.DDCloudDriver</driver-class>
<use-java-context>false</use-java-context>
<user-name>asmishra</user-name>
<password>password</password>
<min-pool-size>5</min-pool-size>
<max-pool-size>40</max-pool-size>
<idle-timeout-minutes>5</idle-timeout-minutes>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<prepared-statement-cache-size>50</prepared-statement-cache-size>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolatio n>
</local-tx-datasource>
</datasources>
5. Restart the servers from First Steps Console (Start > All Programs > Progress > OpenEdge 11.X > BP Server > First Steps Console) for the changes to take effect.