Tuesday, July 1, 2014

How to Connect Oracle Database XE with NetBeans IDE using JDBC Thin driver

In this tutorial we shall learn how to connect oracle database XE with NetBeans IDE for database administration & development using NetBeans IDE and connection for developing database oriented Java EE web application project and Java Desktop project. Basically NetBeans IDE has already built in support for oracle database as support to MySQL server. In this tutorial we shall establish a connection of local installed oracle database XE with Netbeans IDE. Both softwares are installed on same computer.

Software required for this tutorials are NetBeans IDE & Oracle Database XE which should already installed at your computer and Oracle JDBC Thin Driver.



Oracle JDBC Thin driver is platform independent because it is based on Java language. It is standalone driver which does not require other Oracle libraries for connection with Oracle database, it allows a direct connection with Database. Oracle JDBC Thin driver file " ojdbc7.jar can save before the connection established process or during the process. We will download file during connection process.

Lets start, Open the NetBeans IDE, open the Services tab as showing in below picture. Right click on Database node and click on New Connection

How to Connect & register Oracle Database XE with NetBeans IDE, oracle database 11g, database learning, Netbeans IDE tutorial, register netbeans IDE with Oracle database 11g, database learning, database learning education, java web action, java web development, database administration, oracle database development with Netbeans IDE, oracle database education, database training

A window has opened, where Drive options are given to select for connection with your desired database server. We shall select Oracle Thin for Oracle Database XE as showing in below picture. Click next for further step

How to Connect & register Oracle Database XE with NetBeans IDE, oracle database 11g, database learning, Netbeans IDE tutorial, register netbeans IDE with Oracle database 11g, database learning, database learning education, java web action, java web development, database administration, oracle database development with Netbeans IDE, oracle database education, database training

In new opened window, Oracle thin is already selected in driver option but there is no file showing in Driver Files. If we have already download ojdbc.jar file at our computer, we can provide path to file by clicking add button. As we have already not download driver file ojdbc.jar, a downloading link is showing below to download the driver file. click on downloading link to download it

How to Connect & register Oracle Database XE with NetBeans IDE, oracle database 11g, database learning, Netbeans IDE tutorial, register netbeans IDE with Oracle database 11g, database learning, database learning education, java web action, java web development, database administration, oracle database development with Netbeans IDE, oracle database education, database training

Oracle website page for JDBC Drivers downloads has been opened, here different JDBC Drivers version are showing. Our required driver version is ojdbc7.jar, click on it to download it. Save the file at your computer disk, where you want

How to Connect & register Oracle Database XE with NetBeans IDE, oracle database 11g, database learning, Netbeans IDE tutorial, register netbeans IDE with Oracle database 11g, database learning, database learning education, java web action, java web development, database administration, oracle database development with Netbeans IDE, oracle database education, database training

Put the saved ojdbc.jar file in Folder where your Netbeans IDE is installed like 
Netbeans 7.4 -> ide -> modules->ext
This file can be put any where in your computer, we have just put it in external library folder of  Netbeans IDE for easy to manage.

How to Connect & register Oracle Database XE with NetBeans IDE, oracle database 11g, database learning, Netbeans IDE tutorial, register netbeans IDE with Oracle database 11g, database learning, database learning education, java web action, java web development, database administration, oracle database development with Netbeans IDE, oracle database education, database training

Now click on add button to add downloaded ojdbc.jar file. Give path to file where we have save it Netbeans 7.4 -> ide -> modules->ext

How to Connect & register Oracle Database XE with NetBeans IDE, oracle database 11g, database learning, Netbeans IDE tutorial, register netbeans IDE with Oracle database 11g, database learning, database learning education, java web action, java web development, database administration, oracle database development with Netbeans IDE, oracle database education, database training

Driver File path has been added as showing in below picture. Click next for next step

How to Connect & register Oracle Database XE with NetBeans IDE, oracle database 11g, database learning, Netbeans IDE tutorial, register netbeans IDE with Oracle database 11g, database learning, database learning education, java web action, java web development, database administration, oracle database development with Netbeans IDE, oracle database education, database training

In this Customize connection step, we shall provide database connection necessary parameters to connect with database. Below are the parameters for oracle Database XE connection

Driver Name              Oracle Thin (with Service ID (SID))
Host             localhost

If your database is installed on an other computer, provide that computer IP address or resolvable hostname.

Port                        1521 (default)
Service ID (SID) XE (default SID for Oracle Database XE).

Service ID can be different for different database instance, in this case ask the database administrator to provide desired database SID.

For our tutorial, enter system as username (default database administrator account) and password that you  used during database installation like abc@123.

Username         Enter the username.
Password Enter the password for the selected username.

Click on Test connection button, if database is running and connection parameters are OK, connection status will be successful other wise it will show failed.

Click on Finish Button, to complete the process. 

How to Connect & register Oracle Database XE with NetBeans IDE, oracle database 11g, database learning, Netbeans IDE tutorial, register netbeans IDE with Oracle database 11g, database learning, database learning education, java web action, java web development, database administration, oracle database development with Netbeans IDE, oracle database education, database training

Congratulation, Netbeans IDE has been connected with Oracle Database XE as showing below, OracleDB node has added in database connection list as connected. Here all the Databases tables are showing with their tables. Here we can manage our databases accounts and tables. Here we can add, delete, modify and views required database tables. Now we can use Oracle database with our developing Java EE web application project, Java Desktop application project and PHP web application project etc.

How to Connect & register Oracle Database XE with NetBeans IDE, oracle database 11g, database learning, Netbeans IDE tutorial, register netbeans IDE with Oracle database 11g, database learning, database learning education, java web action, java web development, database administration, oracle database development with Netbeans IDE, oracle database education, database training


Related Topics:

How to register Oracle Database XE with Oracle JDeveloper and Edit, unblock the users






42 comments:

  1. Bạn có muốn sống trong một căn hộ chung cư tiện nghi, hiện đại bậc nhất Sài Gòn hiện nay không. Đừng bỏ qua cơ hội này nhé, click ngay để xem thông tin chi tiết căn hộ chung cư Him Lam Chợ Lớn quận 6 hoặc Can ho chung cu Him Lam Cho Lon quan 6

    ReplyDelete
  2. Các bạn còn chần chờ gì nữa hãy tới đây để có cơ hội thưởng thức hương vị thơm ngon của bánh Kiitkat trà xanh Shop bánh kitkat trà xanh nhật giá rẻ sỉ lẻ ở TPHCM và toàn quốc hoặc Shop banh kitkat tra xanh nhat gia re si le o TPHCM va toan quoc

    ReplyDelete
  3. Acetech Information, a leading software development company of India offers Software Development,Custom Software Development ,Website Design, website development , search engine optimization, e commerce and website maintenance services for its customers around the globe.

    ReplyDelete
  4. Bạn nào muốn mua nhà thì vào đây tìm hiểu nhé, căn hộ chung cư cao cấp giá rẽ phải nói là tuyệt đẹp luôn, vừa được mở bán, không xem sẽ thấy tiếc đó Căn hộ chung cư Him Lam Chợ Lớn quận 6 hoặc Can ho chung cu Him Lam Cho Lon quan 6

    ReplyDelete
  5. Nhiều người đang rất hài lòng khi sở hữu được căn hộ chung cư cao cấp tuyệt đẹp và tiện nghi này ở quận 6,còn bạn thì sao hãy vào đây xem ngay nhé Căn hộ chung cư giá rẻ An Gia Star quận Bình Tân hoặc Can ho chung cu gia re An Gia Star quan Binh Tan

    ReplyDelete
  6. Nhà đẹp, nhà đẹp đây, mua đi, mua đi. Vào xem ngay căn hộ chung cư An Gia Star để có mức giá tốt nhất nhé, khu căn hộ chung cư tuyệt vời với giao thong thuận tiện và an ninh nhất sài gòn miễn chê luôn. Chi tiết xem Căn hộ An Gia Star quận Bình Tân hoặc Can ho An Gia Star quan Binh Tan

    ReplyDelete
  7. Thank you for information about the how to connect oracle database XE with NetBeans Ideas using.

    Nashville Graphic Design

    ReplyDelete
  8. You’ve written nice post, I am gonna bookmark this page, thanks for info. I actually appreciate your own position and I will be sure to come back here.
    Signature:
    download descargar facebook and download free descargar facebook apk and baixar whatsapp , descargar whatsapp

    ReplyDelete

  9. Wow!!! Honestly speaking you are really a great writer. What I required I got it. Thank you so much...
    PHP Services in Leicester
    Website Development Company in Leicester

    ReplyDelete
  10. This blog post is very useful. This is my first time I visit here. I have found so much interesting stuff in your blog especially its discussion. Really it is a great article. Keep it up. psd to css

    ReplyDelete
  11. Nice blog, Thanks for sharing such a useful and informative post.
    Blaster Waves Technologies

    ReplyDelete
  12. Great Information about Php Website Developer. Find best PHP Web Development Company in Napgur. Visit AceZed.Com Today!

    ReplyDelete
  13. This was really an interesting topic and I kinda agree with what you have mentioned here! search engine optimization new york

    ReplyDelete
  14. Hi! I have 1.5 years experience. I search in Google so Many Websites & Blog but you’re blog and post really is too good its title, description, images your content style is really good and I feel glad when post read Custom Software Application Development

    ReplyDelete
  15. World wide web coder than would be that helps make active software. World wide web coder has liitle bit of designing info however much better in generating software.Phone System

    ReplyDelete

  16. I read your post and need to thank you for sharing such pleasant lines. Be that as it may, I likewise need to instruct you to share more data as I had needed to peruse all the more yet didn't get acceptable substance from anyplace.
    Website Development Company Bangalore

    ReplyDelete
  17. http://mkniit.blogspot.in

    ReplyDelete
  18. Great information thanks for sharing this with us. Web Development In fact in all posts of this blog their is something to learn . your work is very good and i appreciate your work and hopping for some more informative posts .
    Apps Development

    ReplyDelete
  19. The first one is such an incredible picture. I love how it is just black, white and red, it leaves such an amazing effect.
    application development

    ReplyDelete
  20. I have read all your post. Each and every post is amazing. Always look forward for new updates.

    web design calgary

    ReplyDelete
  21. The blog was absolutely fantastic! Lot of great information which can be helpful in some or the other way. Keep updating the blog, looking forward for more contents...Great job, keep it up..
    Web Design Company Bangalore | Web Developers Bangalore

    ReplyDelete
  22. There is lot of articles on the web about java development. But I like yours more, although i found one that’s more descriptive.

    website development company in United States

    ReplyDelete
  23. Your Article looks like it's very good i truly assemble wide range of info in the Article. Cheers for expressing this specific awesome Article
    Web Development Company

    ReplyDelete
  24. Nice Post... Web design is significant in making the best website. Hiring professional web designer would be the best decision to ensure high quality website.

    web design austin
    web developer austin

    ReplyDelete
  25. Thank you so much for this! Immortal Technologies Website Development company in Delhi the best site plan and change in World.

    ReplyDelete

Please enter relevant question and information.