aspose file tools*
The moose likes Oracle/OAS and the fly likes How can I start a Oracle dbms with my application? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "How can I start a Oracle dbms with my application?" Watch "How can I start a Oracle dbms with my application?" New topic
Author

How can I start a Oracle dbms with my application?

Rd Dari
Ranch Hand

Joined: Feb 22, 2010
Posts: 211

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

Joined: Aug 22, 2010
Posts: 3611
    
  60

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.
 
Consider Paul's rocket mass heater.
 
subject: How can I start a Oracle dbms with my application?