Solved

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

Posted on 2008-10-05
8
362 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
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.

 

Author Comment

by:mawingho
ID: 22647615
is it because my PATH problems?? or anything else???
0
 
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
Query Records that don't match 8 50
Deleting Rows from an Oracle Database - Performance 19 53
Problem with duplicate records in Oracle query 16 40
Creation date for a PDB 5 39
Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

839 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