DataBase Connection

How to prepare Database Connection in OA Framework Environment

Before Establishing Connection You have to make sure your DBC(Database Connection) file reside in the

Proper directory (jdeveloper/jdevbin/jdev/dbc_files/secure)

About DBC File

Database Connection file resides in the secure subfolder in the JDeveloper folder.

Basically it consists of your Data Base connection, port number

Ex:   severname: port number

         ibm5014.daytonoh.ncr.com:1533

Connection Management: You need to traverse in the connection navigator (Ctrl+Shift-O)  

                                              Right Click in the Database folder and Say New connection

                                              It will popup welcome screen ,say next

Now When you say next you have to provide the connection Name and Connection type

Be default name will be DBConnection1 and oracle(JDBC)

When you say Next you need to provide username and password and if you want just click on the deploy

Checkbox button

When you say next it will ask you connection details screen

Now last you need to test your connection