Thursday, September 9, 2010

Creating DB Connection in Jdeveloper

The basic requirement in Jdeveloper is to connect to database and execute queries in Jdeveloper. We'll see how to do it in below steps.

1. Check if 'Database Navigator' palette is open in Jdeveloper. If now, cick on 'View' and select 'Database Navigator'.

2. In the 'Database Navigator', Right click 'IDE Connections' and select 'New Connection'.

3. In the 'Create Database Connection' window, give Name for the connection, select the type of DB you want to connect.

4. Give the connection details for the DB. You can give database connection URL by checking 'Enter Custom JDBC URL'. Test your connection and click 'OK'.

5. Now, you can see the newly created DB under 'IDE Connections'. Select it and Right Click and select 'Connect'.

6. It'll open SQL editor window where you can type and execute your queries (It is same as Oracle SQL Developer).

7. Alternatively, you can also connect to DB by clicking on the 'SQL' icon and selecting the appropriate DB connection.

5 comments:

  1. Iv tried to connect to the Database in Jdeveloper using the name specified in the tns entries but continue recieving the message Network Adapter could not find the connection

    ReplyDelete
  2. If you are able to connect to DB using SQL Plus, you should be able to connect in Jdeveloper too. Please make sure you gave correct host name, SID, username and password.

    ReplyDelete
  3. nice post... helpful in successfully creating the connection!

    ReplyDelete
  4. I have connect the DB successfully,but i encouter a problem when a try to new BC from tables:ORA-04063: view "SYS.ALL_QUEUE_TABLES" has errors,can u help me please?

    ReplyDelete

Related Posts with Thumbnails