Problem of connecting to and extracting data from an Oracle database in Eclipse 3.4.1
In my Eclipse 3.4.1 ( with Tomcat 6.0 ) set up, I am having problems connecting to and extracting data from an Oracle (8.1.7) database. I am using "classe12.jar" in Tomcat's lib directory which is also in my CLASSPATH.
Despite using what I consider as the correct Driver template for that classes12.jar file, appropriate context.xml and web.xml files my test jsp file is not able to output any results from the database.
Any of the forum members who worked with Oracle with their Eclipse could help, may be by providing instructions on setting up the driver correctly along with the proper xml files to work with my database ?.
Any help will be very much appreciated. I can send my versions of those files for any one to look at.
Re: Connecting to Oracle from within Eclipse
Welcome to the Java Programming Forums.
It would be an advantage to post the code that you are using. This way our members can look it over to try to diagnose any problems.
I personally have never used Java to connect to an Oracle database but I do have experience with Sybase.
Take a look and see if any of these links will help you:
Connect to an Oracle database with JDBC - Real's Java How-to
Oracle JDbc Frequently Asked Questions
Oracle JDBCDatabase SQL JDBCJava