He's not using oracle's jdbc drivers, although maybe that is something to try. I recommend getting the newest drivers from oracle because it has been reduced to a single jar file, is much smaller (I think the old drivers were like 8MBs the new ones are around 2MB), and there is support for the jdbc 2 optional packages which means that connection pooling is supported.
-Dave > -----Original Message----- > From: Mike Jackson [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 08, 2002 3:42 PM > To: Tomcat Users List > Subject: RE: Trying to work with JDBC > > > First and foremost, don't unjar the oracle classes. They're > fine in the jar > files as is. You'll just need to put them in the lib > directory under your > WEB-INF or in tomcat's lib directory. > > Also another thing to watch for is what jar's you're putting > out there. You > only need the classes12.jar and nlscharset12.jar generally. > If your jdk > isn't 1.2+ then you'll want the 11 series drivers. Don't put > both of the > versions in your classpath however, you can sometimes get > weird results that > way. > > Second, your driver is ok, but the jdbc url is all wrong. It > should be > something like the > following: > > "jdbc:oracle:thin:@server-name-or-ip-address:1521:ORCL" > > Third, I'm not sure what you're attempting to do with the > server.xml file, > unless you're attempting to use the jdbcrealm authentication > you don't need > to do anything with it (I don't do jdbcrealm, so you'll need > to ask someone > else). If you are attempting to use it (jdbcrealm) then > you'll need to put > the oracle jar files into the tomcat lib directory. If you > put them in the > webapp tomcat won't be able to see them and you'll not get anywhere. > > > As for your Java Beans and JSPs, you might have better luck > after you fix > the url that you're using to connect to the database. If you > don't post a > message and get some more help. > > --mikej > -=----- > mike jackson > [EMAIL PROTECTED] > > > -----Original Message----- > > From: Nagpal, Vikas [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, August 08, 2002 1:22 PM > > To: '[EMAIL PROTECTED]' > > Subject: Trying to work with JDBC > > > > > > Hi everybody, > > > > I was trying to connect to the ORACLE database thru the JDBC > > driver. I have > > downloaded the DRIVER TYPE 4 and unzip this driver. On > unzipping one of > > ORACLE.JAR driver i have got the hierarchy like > > com/ddtek/jdbc/oracle/OracleDriver.class. I have placed > this hierarchy in > > WEB-INF/classes directory. I have configured my CLASSPATH to > > point towards > > the tools.jar, servlet.jar, WEB-INF/classes, jdbc2_0-stdext.jar. > > Also in my > > JAVA code i have put myDriver > =com.ddtek.jdbc.oracle.OracleDriver and > > myURL=http://bioinfo.utmb.edu/cgi-bin/bsql_ProbeSet.cgi. I am not > > sure what > > exactly i need to do with the SERVER.XML file. Also i have > created the > > instance of my JAVABEAN class in the JSP file to retrieve > the requisite > > fields into my page. But even after this my code is not able to pull > > anything from the database. Can anyone help. > > > > Thanks, > > With regards, > > Vikas Nagpal. > > > > > > -- > > To unsubscribe, e-mail: > > <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: > > <mailto:[EMAIL PROTECTED]> > > > > > > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
