Solved

Am I need to install Oracle server on my local machine before I can use JDBC?

Posted on 2008-10-05
8
360 Views
Last Modified: 2013-12-19
Am I need to install Oracle server on my local machine before I can use JDBC?
0
Comment
Question by:mawingho
8 Comments
 
LVL 2

Accepted Solution

by:
maggc earned 175 total points
ID: 22647528
No, that is normally not necessary. I think you will only need the oracle client drivers.

look here:

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html
0
 
LVL 5

Assisted Solution

by:Didier Vally
Didier Vally earned 175 total points
ID: 22647590
Oracle server components can be installed either on your own development machine, or on another machine reachable on the network.

Oracle client components need to be installed on your development machine, and Oracle JDBC drivers must also be installed on the development machine, because it will be needed by your Java Code to access the local or remote Oracle database.
0
 

Author Comment

by:mawingho
ID: 22647597
I have followed the instruction to download the JDBC driver, but still doesn't work....
0
 

Author Comment

by:mawingho
ID: 22647615
is it because my PATH problems?? or anything else???
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 1

Assisted Solution

by:MrMarshall
MrMarshall earned 150 total points
ID: 22649489
You need to point to a Database somewhere it can be  local or on a remote host. You do need to oracle JDBC drivers availble to build your project. It doesn't work doesn't really gives us alot to go on to help you. What specific errors are you getting?
0
 
LVL 5

Assisted Solution

by:Didier Vally
Didier Vally earned 175 total points
ID: 22657206
Can you give more details on your problem please.
0
 

Author Comment

by:mawingho
ID: 22665415
When I run my java program, it return an error......It cannot find the JDBC driver even I set the Path in the System.
0
 
LVL 5

Expert Comment

by:Didier Vally
ID: 22684573
Have you copied the Oracle JDBC Driver in WEB-INF\LIB ?
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
statspack purge automate 7 51
Migrate database to ASM disks. 1 39
Difference in number of minutes between 2 timestamps 16 39
Oracle and DateTime math 6 25
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now