Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2008-10-05
8
Medium Priority
?
368 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 700 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 700 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
Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

 

Author Comment

by:mawingho
ID: 22647615
is it because my PATH problems?? or anything else???
0
 
LVL 1

Assisted Solution

by:MrMarshall
MrMarshall earned 600 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 700 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

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Question has a verified solution.

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

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Suggested Courses
Course of the Month15 days, 12 hours left to enroll

580 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