Don't know how to connect to Oracle database

Posted on 2005-03-08
Medium Priority
Last Modified: 2011-10-03
First time to build the JSP page using DreamWeaver

When I try to add a record set and define the Oracle database connection. I have entered the info


with its Oracle login user and its password

BUT when i click on the Test button for testing database connection

I got the following error message.


Would anyone give me some hints so I can connect the database, thanks?

Question by:LeanMoreTryMore
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
  • 3
  • 3
  • 2
  • +4
LVL 53

Expert Comment

by:Ryan Chong
ID: 13492774
Try install Oracle Client on that machine 1st?

And what i usually did to connect my Oracle database via JSP is via a ConnectionPool Class, here is a good one:


try look and download for DbConnectionBroker


Author Comment

ID: 13492883
i have already installed the Oracle client on my machine.

Author Comment

ID: 13492929
Hi ryancys,

I have just downloaded the DBConnectionBroker.class
What I need to do next, please advise
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

LVL 53

Expert Comment

by:Ryan Chong
ID: 13493000
Have you saw the examples available in that DbConnectionBroker1.0.13.tar you downloaded?

For your info, the DBConnectionBroker.class is the compiled java file, you may need to decompile it if you want to see what's the codes written inside, and amend it accordingly.

For Java Decompiler, you can try:

hmm... a bit complicated? hope this is not confusing you... :/


Author Comment

ID: 13493306
My initial question is how do i connect the database via DreamWeaver.
The example is the java program to connect database. I know what to do.
LVL 53

Accepted Solution

Ryan Chong earned 1200 total points
ID: 13493412

Expert Comment

ID: 13712956
1.  Do you mean jdbc:oracle:thin: (coz if it is typo error, then ignore it)
otherwise it should look like this  jdbc:oracle:thin:@ (you are missing @ symbol in your url)

2.  Regarding the 2nd error, classes12.zip / classes12.jar is not in your classpath.  Either include classes12.zip/classes12.jar in your classpath or include that in /WEB-INF/lib folder.

Hope this helps!!

Expert Comment

ID: 13712958
Forgot to mention:  Class OracleDriver is included in classes12.zip file under the package oracle/jdbc/driver

Expert Comment

ID: 13714804
Hi, maybe I'm wrong, but I think if you wanna to connect to oracle, you must have a valid entry for target machine in tnsnames.ora
I hope I'm not out of topic - I connected to oracle database from windows machine, from C#.

Expert Comment

ID: 13715244
Hi, be aware that not all web containers automatically load .zip files from /WEB-INF/lib. You might have better luck if you rename the classes12.zip to classes12.jar.


Expert Comment

ID: 13716346
check you driver classname , it should be oracle.jdbc.driver.OracleDriver . By the looks of thing you've got it set to oracle.jdbc.driver.oracleDrive.

regarding tnsnames entry / oracle client , these are not required for the thin driver.


Expert Comment

ID: 13718199
Hi!  I did define an Oracle database connection in Dreamweaver MX 2004 and got it to work.  I am new to Dreamweaver also.   Anyway you probably know all this already, but here is what I did for an Oracle Thin Driver connection:
Connection Name:  as03
Driver:  oracle.jdbc.driver.OracleDriver
URL:  jdbc:oracle:thin:@<IP address of server>:1521:<sid_name>
User Name:  <some user name on db>
Password:    <password>
selected  Using Driver On This Machine and then clicked Advanced button and entered a schema in Caps in the Schema input field.  
Clicked on Test.  It said that it was successful.   Clicked on the plus sign beside the connection name in the Databases tab and then clicked on the plus beside tables.  The list of tables appeared from that schema.  
I figured out the connection but do not understand how to get the jsp file to run in Dreamweaver.  I do have the Oracle 9i database software installed on my computer, not just the client.  But I would think the client should work.   Maybe you got this resolved by now?  Hope so!


Featured Post

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

For those who don't know, Adobe Dreamweaver is a popular commercial web editor that enables you to design, build and manage complex websites. The editor is a WYSIWYG (What You See Is What You Get) web editor, which means that you can create your web…
Adobe Dreamweaver CS5 is a WYSIWYG web page editor that has advanced HTML, CSS, and Javascript rendering functionality and is probably the most well-known HTML editor available. Much of Dreamweaver's appeal centers around the Design View interfac…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses
Course of the Month9 days, 13 hours left to enroll

762 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