# Adding Connections to the `connections.properties` File

If your application uses any connections, you must add these to the `connections.properties` file. If you are using JDeveloper, it is strongly recommended that you use JDeveloper to edit connection information. If you do not have access to JDeveloper, you can edit the file in a text editor.

To manually add a connection to the `connections.properties` file:

1. Edit the line (or create one) that sets the property CM_NumConnections. The syntax is
   CM_NumConnections=<number>
   where <number> is the total number of connections that will be in the file.
2. After the line that sets the property `CM_NumConnections`, add a line for the connection. The syntax is
   `CM_Connection<number>=<property_list>`
   where `<number>` is a unique number for each connection, starting at 1. For example, if this is the third connection you've added to this file, the line should start `CM_Connection3=`.
   `<property_list>` is a list of property/value pairs. The pairs are separated from one another by
   `\r,`
   including the comma. Each property is separated from its corresponding value by
   `\=`
   All connections have the property/value combinations:

   Property name | Value
   `ConnectionType` | `IIOP` or `JDBC`
   `ConnectionName` | the name of the connection
   `user` | the user ID of the connection
   `DeployPassword` | `true` if you want to include the password here, `false` if you want the user to enter it when connecting
   `password` | the user's password--do not include this pair if you set `DeployPassword` to `false`
   URL | for IIOP connections, a string with the syntax `sess_iiop\\\://<hostname>\\\:<port>\\\:<SID>` for JDBC connections, a string with the syntax `jdbc\\\:oracle\\\:<driver>\\\:@<hostname>\\\:<port>\\\:<SID>` where `<driver>` is `thin`, `oci7`, or `oci8`
   Role | `Normal`, `SYSDBA`, or `SYSOPER`

   In addition, JDBC connections have the following property/value combinations:

   Property name | Value
   `remarksReporting` | `false`
   `JdbcDriver` | `oracle.jdbc.driver.OracleDriver`
   `defaultBatchValue` | Oracle JDBC drivers allow you to accumulate inserts and updates of prepared statements and send them to the server in batches once it reaches a specified batch value. This feature reduces round trips to the server. Use the value `1` if you don't want to use this feature.
   `defaultRowPrefetch` | Oracle JDBC drivers allow you to set the number of rows to prefetch from the server while the result set is being populated during a query. Prefetching row data into the client reduces the number of round trips to the server. A typical value for this property is `10`.

   An example IIOP connection could be specified by
   `CM_Connection1=ConnectionType\=IIOP\r,user\=scott\r,
   ConnectionName\=MyIIOP\r,DeployPassword\=false\r,
   URL\=sess_iiop\\\://myhost\\\:2481\\\:ORCL\r,Role\=Normal`
   An example JDBC connection could be specified by
   `CM_Connection2=ConnectionType\=JDBC\r,user\=scott\r,
   ` `password\=tiger\r,ConnectionName\=MYUSER\r,DeployPassword\=true\r,
   URL\=jdbc\\\:oracle\\\:thin\\\:@myhost\\\:1521\\\:ORCL\r,
   remarksReporting\=false\r,defaultBatchValue\=1\r,
   JdbcDriver\=oracle.jdbc.driver.OracleDriver\r,
   defaultRowPrefetch\=10\r,Role\=Normal`
   Note: For clarity, we've split these examples onto multiple lines. Do not split your actual connection specifications onto multiple lines.