Raymond: Your Oracle distribution should come with the JDBC drivers you need, classes111.zip or classes12.zip. They should be in your $ORACLE_HOME/jdbc/lib directory.
Put them in your classpath, and you can write the JDBC code to access them in a servlet. I guess you can put the code to do so in a JSP directly for playing around with it. But you really want to put DB stuff in a server side process of some sort, as that will keep the connections around for pooling, less initial page rendering performance hit, better architecture, etc.... Browse the Professional Java Server Programming book published by WROX. It is pretty good with the JSP, servlets, and JDBC stuff. jchuang ----- Original Message ----- From: "Raymond Reid" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 27, 2001 7:46 AM Subject: Configuring Tomcat 3.2.3 to access Oracle 8i backend > Hello, > I currently have Apache 1.3.2 configured together with Tomcat 3.2.3 > running on windows NT 4.0 Service pack 5, and when I remotely access > html pages that > execute simple JSP's (hello world looping 10 times etc...) everything > works fine. On a second computer I have Oracle 8i running on Linux Red > Hat 6.2, and have > been successful accessing the database from NT using sqlplus. > > My question is what modifications do I have to make to Apache/Tomcat to > obtain access to the Oracle database via JSP, and what drivers do I > need? > > I've searched the Web, and referenced several books, but I just can't > find the information that I need. > > Thank you, > Raymond Reid > > > -- > To unsubscribe: <mailto:[EMAIL PROTECTED]> > For additional commands: <mailto:[EMAIL PROTECTED]> > Troubles with the list: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
