Solved

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

Posted on 2008-10-05
8
363 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
exp/imp 25 101
form builder not starting 3 72
How to Comment Out Lines of Code in a Pass Through Query In MS Access 2016 19 84
error in my cursor 5 51
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

730 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