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.
Thursday, September 9, 2010
Creating DB Connection in Jdeveloper
Subscribe to:
Post Comments (Atom)
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
ReplyDeleteIf 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.
ReplyDeletenice post... helpful in successfully creating the connection!
ReplyDeleteI 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?
ReplyDelete20170303shizhong
ReplyDeletepandora uk
red bottoms shoes
true religion jeans
adidas uk
beats headphones
louboutin uk
pandora charms
hermes handbags
christian louboutin
nike factory store
red bottoms
I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Oracle JDeveloper 11g Fusion, kindly contact us http://www.maxmunus.com/contact
ReplyDeleteMaxMunus Offer World Class Virtual Instructor led training on Oracle JDeveloper 11g Fusion. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
For Demo Contact us.
Nitesh Kumar
MaxMunus
E-mail: nitesh@maxmunus.com
Skype id: nitesh_maxmunus
Ph:(+91) 8553912023
http://www.maxmunus.com/
I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Oracle 11g Fusion Java Programming, kindly contact us http://www.maxmunus.com/contact
ReplyDeleteMaxMunus Offer World Class Virtual Instructor led training on Oracle 11g Fusion Java Programming. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
For Demo Contact us.
Nitesh Kumar
MaxMunus
E-mail: nitesh@maxmunus.com
Skype id: nitesh_maxmunus
Ph:(+91) 8553912023
http://www.maxmunus.com/
hermes outlet online
ReplyDeletenike outlet store
adidas yeezy boost 350
adidas nmd r1
oakley sunglasses outlet
birkenstock outlet
yeezy boost
michael kors outlet online
coach factory outlet
tommy hilfiger windbreaker
170511yueqin
off white shoes
ReplyDeletesupreme new york
air jordan
off white shoes
supreme hoodie
steph curry shoes
off white hoodie
stephen curry shoes
air jordan
retro jordans