File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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: 210

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: 3610
    
  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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How can I start a Oracle dbms with my application?