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.