He might still need the nlscharset classes to support his character encoding, those are the really big classes, the base jdbc classes are pretty small.
And why isn't this guy posting to the list directly? --mikej -=----- mike jackson [EMAIL PROTECTED] > -----Original Message----- > From: Durham David Cntr 805CSS/SCBE [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 08, 2002 2:41 PM > To: Tomcat Users List > Subject: RE: Trying to work with JDBC > > > 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]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
