How can I start a Oracle dbms with my application?

[Rd Dari]

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 Vashko]

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.