File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How can I start a Oracle dbms with my application?

 
Rd Dari
Ranch Hand
Posts: 212
Java Netbeans IDE
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all Ranchers,

I am new in Oracle DBMS so I want to start a web application in Netbeans IDE 6.9 with Oracle DBMS.

I don't have Oracle on my PC , First of all what url is from where I can download it and make a connection pool.

Please share your knowledge with me to start it by a first step.

Thanks!!
 
Martin Vajsar
Sheriff
Pie
Posts: 3747
62
Chrome Netbeans IDE Oracle
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You need to set up Oracle on your PC first. I'd suggest starting with the free edition of Oracle - Oracle XE (see our Oracle FAQ for links).

Oracle XE comes preconfigured, you should be able to connect to it using the connection string "jdbc:oracle:thin:@//localhost:1521:xe" (I don't use XE myself, so I hope this is right).

You should create your own users in the database, it is not a good idea to let your application connect using the system account which has all the privileges. I believe there are some XE guides or tutorials which should help you get these things done.

Creating a connection pool is an independent task. You'll need the connection string I've mentioned before. Other details depend on the connection pool you'll want to use.
 
Don't get me started about those stupid light bulbs.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic