Oracle Probelm

[Jacob Michaels]

I am running a Tomcat server. I designed a servlet that opens a database and displays the information in a html table. Everything works like a charm when I assing the dbUrl to Microsoft access driver. When I try to use the Oracle driver, it does not work. Is there something I have to install to use Oracle? and where is the oracle_jdbc_driver.jar located?
[ July 04, 2003: Message edited by: Jacob Michaels ]

[Byron Estes]

Jacob,
Where it resides will be specific to your machine, but the jar file is not named what you listed in your post. The name of the archive file that you'll be looking for is classes12.zip. I personally think Oracle did a poor job naming it, but they didn't consult me .
I don't recall what the default install directory is (...or even it there was one) for the Oracle "thin" jdbc driver, but you can at least do a search for it and then if it's not there just go to the Oracle home site and download it.
Regards,
[ July 07, 2003: Message edited by: Byron Estes ]

[Avi Abrami]

Byron,
If you're gonna help the guy, at least give him some helpful information. No wonder Oracle didn't consult you about naming their JDBC driver file.
Jacob,
The JDBC driver file should be part of the Oracle distribution. If you're trying to connect to Oracle, then I assume you have access to a server with Oracle installed on it. Therefore, you should have access to the JDBC driver. On our Oracle 8.1.7.4 database, installed on a SUN [sparc] computer, the driver is located in the "jdbc/lib" subdirectory -- under the directory defined by the ORACLE_HOME environment variable. So, for us, the full path is:
/u/app/oracle/product/8.1.7/jdbc/lib/classes12.zip
Different Oracle versions use different JDBC drivers. All of the available drivers can be downloaded from here:
http://technet.oracle.com/software/tech/java/sqlj_jdbc/content.html
Hope this helps you.
Good Luck,
Avi.

[Byron Estes]

Avi,
I believe I was being helpful, the information I provided was generally more applicable than yours. You didn't add much except to...
A) Tell Jacob where it is if installed to a unix box, when he didn't indicate his platform.
FYI: I ussually copy all my JDBC drivers to a different directory so they are easier to locate.
2) Tell him to go to Oracle to get any additional drivers he needs. I assumed he and everyone else knows that Oracle has a website and that he can use a search engine.
He asked a specific question and I gave as specific an answer as possible given the information at hand. The key, I felt, was that he was looking for a archive file of the wrong name and incorrect extenstion. Given the info I provided all he has to do is run a search by filename. If he finds it, he can use it. If not, then he can go obtain the correct driver.

As far as the naming convention for the driver goes, if you think that it is aptly named in a descriptive fashion, then...well...no comment.
Jacob - Feel free to email me directly if you need more assistance.
Cheers,
[ July 08, 2003: Message edited by: Byron Estes ]
[ July 10, 2003: Message edited by: Byron Estes ]

[Jacob Michaels]

Thanks for the great relpies. I do not have a server running Oracle.
Do I have to purchase software in order to use Oracle, or can I just download the driver for it.
I am using a Microsoft 2000 Advanced Server and I have Tomcat under the hood. Thanks again for the replies.
They are VERY helpful!

[Robert Willems]

You can download all the Oracle software for free on http://technet.oracle.com. If i recall correctly you can use it on your development machine for free, but if you want to use it for a production environment you have pay for it.
Regards,
Robert
[ July 11, 2003: Message edited by: Robert Willems ]

[Byron Estes]

Jacob,
What database are you running? I get the feeling based upon re-reading your posts that you may be tring to access a database of one type with the driver of another type.
Database specific drivers, like the Oracle thin JDBC driver, will only work on an Oracle database, nothing else...
The JDBC-ODBC bridge can connect to to most JDBC / ODBC compliant databases (i.e. Oracle, SQL Server, Sybase, Access, etc.)(...there are however serious issues with it for more advanced users).
Regards,