What Oracle is best?
Just wondering what kind of oracle programs do I need to get Tomcat to
access an SQL database. I have servlets already written that work on
another Sun OS machine that I still have access to. Is there a way I can
query the OS to find out what versions of oracle are installed? The RPM
command obviously doesn't work (since it is a Sun OS), and I don't have
root permissions of course.
If I can't query the Sun OS what versions of Oracle do you recommend.
I tried browsing the oracle homepage and google searches but that just
made me more confused from the vast number of choices. Also do I need
sqlplus or JDBC if I have j2sdk, tomcat, and MySQL?
This is whats already installed:
---
tomcat4-webapps-4.1.24-full.2jpp
tomcat4-4.1.24-full.2jpp
tomcat4-admin-webapps-4.1.24-full.2jpp
j2re1.4.1_02
j2sdkee1.4
j2sdk1.4.1_02
redhat 8
standard MySQL that comes with Redhat 8 Linux
Sample Servlet code that works on another computer
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
public class MultiServlet extends HttpServlet {
/**
* Initialize global variables
*/
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
/**
* Process the HTTP Post request
*/
public void doPost(HttpServletRequest request, HttpServletResponse
response)
throws ServletException, IOException {
String category = request.getParameter(category);
response.setContentType(text/html);
PrintWriter out = new PrintWriter (response.getOutputStream());
out.println(html);
out.println(headtitleAdvanced Search/title/head);
out.println(bodytable border=1 cellpadding = 5 cellspacing = 0);
try
{
System.out.println (\n before registering driver \n);
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
System.out.println ( before GET Connection \n);
Connection conn = DriverManager.getConnection
(jdbc:oracle:thin:@dbserv.uits.indiana.edu:1521:OED1,s3jm013,s3jm013);
System.out.println ( before STatement \n);
Statement stmt = conn.createStatement();
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: faulty fix for (javax.servlet does not exist)
This website http://www.sitepoint.com/article/509/3 says all I have to do is put servlet.jar in my classpath to solve my problems. Unfortunitally, it doesn't seem to work. This is my error - $ javac MultiServlet.java MultiServlet.java:1: package javax.servlet does not exist import javax.servlet.*; ^ MultiServlet.java:2: package javax.servlet.http does not exist import javax.servlet.http.*; ^ --- THis is my path $ echo $CLASSPATH /var/tomcat4/common/lib/commons-dbcp.jar:/var/tomcat4/common/lib/naming-resources.jar:/var/tomcat4/common/lib/jdbc2_0-stdext.jar:/var/tomcat4/ common/lib/commons-collections.jar:/var/tomcat4/common/lib/naming-factory.jar:/var/tomcat4/common/lib/jasper-runtime.jar:/var/tomcat4/common/l ib/ant.jar:/var/tomcat4/common/lib/naming-common.jar:/var/tomcat4/common/lib/jasper-compiler.jar:/var/tomcat4/common/lib/activation.jar:/var/t omcat4/common/lib/jndi.jar:/var/tomcat4/common/lib/servlet.jar:/var/tomcat4/common/lib/commons-logging-api.jar:/var/tomcat4/common/lib/jta.jar :/var/tomcat4/common/lib/commons-pool.jar:/var/tomcat4/common/lib/mailapi.jar:/var/tomcat4/server/lib/servlets-common.jar:/var/tomcat4/server/ lib/commons-fileupload.jar:/var/tomcat4/server/lib/tomcat-http11.jar:/var/tomcat4/server/lib/servlets-cgi.renametojar:/var/tomcat4/server/lib/ commons-digester.jar:/var/tomcat4/server/lib/tomcat-coyote.jar:/var/tomcat4/server/lib/mx4j.license:/var/tomcat4/server/lib/commons-beanutils. jar:/var/tomcat4/server/lib/servlets-webdav.jar:/var/tomcat4/server/lib/mx4j-jmx.jar:/var/tomcat4/server/lib/catalina.jar:/var/tomcat4/server/ lib/servlets-ssi.renametojar:/var/tomcat4/server/lib/jakarta-regexp-1.2.jar:/var/tomcat4/server/lib/catalina-ant.jar:/var/tomcat4/server/lib/t omcat-jk2.jar:/var/tomcat4/server/lib/commons-logging.jar:/var/tomcat4/server/lib/commons-modeler.jar:/var/tomcat4/server/lib/jaas.jar:/var/to mcat4/server/lib/servlets-default.jar:/var/tomcat4/server/lib/servlets-invoker.jar:/var/tomcat4/server/lib/servlets-manager.jar:/var/tomcat4/s erver/lib/tomcat-jk.jar:/var/tomcat4/server/lib/tomcat-util.jar:/var/tomcat4/server/lib/tomcat-warp.jar:/usr/java/j2sdk1.4.1_02/lib/dt.jar:/us r/java/j2sdk1.4.1_02/lib/j2ee.jar:/usr/java/j2sdk1.4.1_02/lib/j2eetools.jar:/usr/java/j2sdk1.4.1_02/lib/tools.jar:/usr/java/j2sdk1.4.1_02/lib/ htmlconverter.jar:/usr/java/j2sdk1.4.1_02/lib/j2ee-ri-svc.jar:/usr/java/j2sdk1.4.1_02/lib/jhall.jar:/usr/java/j2sdkee1.4/lib/j2ee.jar:/usr/jav a/j2sdkee1.4/lib/j2ee-ri-svc.jar:/usr/java/j2sdkee1.4/lib/j2eetools.jar:/usr/java/j2sdkee1.4/lib/jhall.jar The actual code is CLASSPATH=/var/tomcat4/common/lib/commons-dbcp.jar:/var/tomcat4/common/lib/naming-resources.jar:/va r/tomcat4/common/lib/jdbc2_0-stdext.jar:/var/tomcat4/common/lib/commons-collections.jar:/var/tomcat 4/common/lib/naming-factory.jar:/var/tomcat4/common/lib/jasper-runtime.jar:/var/tomcat4/common/lib/ ant.jar:/var/tomcat4/common/lib/naming-common.jar:/var/tomcat4/common/lib/jasper-compiler.jar:/var/ tomcat4/common/lib/activation.jar:/var/tomcat4/common/lib/jndi.jar:/var/tomcat4/common/lib/servlet. jar:/var/tomcat4/common/lib/commons-logging-api.jar:/var/tomcat4/common/lib/jta.jar:/var/tomcat4/co mmon/lib/commons-pool.jar:/var/tomcat4/common/lib/mailapi.jar:/var/tomcat4/server/lib/servlets-comm on.jar:/var/tomcat4/server/lib/commons-fileupload.jar:/var/tomcat4/server/lib/tomcat-http11.jar:/va r/tomcat4/server/lib/servlets-cgi.renametojar:/var/tomcat4/server/lib/commons-digester.jar:/var/tom cat4/server/lib/tomcat-coyote.jar:/var/tomcat4/server/lib/mx4j.license:/var/tomcat4/server/lib/comm ons-beanutils.jar:/var/tomcat4/server/lib/servlets-webdav.jar:/var/tomcat4/server/lib/mx4j-jmx.jar: /var/tomcat4/server/lib/catalina.jar:/var/tomcat4/server/lib/servlets-ssi.renametojar:/var/tomcat4/ server/lib/jakarta-regexp-1.2.jar:/var/tomcat4/server/lib/catalina-ant.jar:/var/tomcat4/server/lib/ tomcat-jk2.jar:/var/tomcat4/server/lib/commons-logging.jar:/var/tomcat4/server/lib/commons-modeler. jar:/var/tomcat4/server/lib/jaas.jar:/var/tomcat4/server/lib/servlets-default.jar:/var/tomcat4/serv er/lib/servlets-invoker.jar:/var/tomcat4/server/lib/servlets-manager.jar:/var/tomcat4/server/lib/to mcat-jk.jar:/var/tomcat4/server/lib/tomcat-util.jar:/var/tomcat4/server/lib/tomcat-warp.jar:/usr/ja va/j2sdk1.4.1_02/lib/dt.jar:/usr/java/j2sdk1.4.1_02/lib/j2ee.jar:/usr/java/j2sdk1.4.1_02/lib/j2eeto ols.jar:/usr/java/j2sdk1.4.1_02/lib/tools.jar:/usr/java/j2sdk1.4.1_02/lib/htmlconverter.jar:/usr/ja va/j2sdk1.4.1_02/lib/j2ee-ri-svc.jar:/usr/java/j2sdk1.4.1_02/lib/jhall.jar:/usr/java/j2sdkee1.4/lib /j2ee.jar:/usr/java/j2sdkee1.4/lib/j2ee-ri-svc.jar:/usr/java/j2sdkee1.4/lib/j2eetools.jar:/usr/java /j2sdkee1.4/lib/jhall.jar which is very long so, in short it contains: All the J2sdk 1.4 jar files All the J2sdk Enterprise edition Jar files
Re: faulty fix for (javax.servlet does not exist)
I'm compiling with root, $ javac -cp /var/tomcat4/common/lib/servlet.jar MultiServlet.java javac: invalid flag: -cp Usage: javac options source files and if I change my classpath to: $ echo $CLASSPATH /var/tomcat4/common/lib/servlet.jar I still get the same error $ javac MultiServlet.java MultiServlet.java:1: package javax.servlet does not exist import javax.servlet.*; ^ MultiServlet.java:2: package javax.servlet.http does not exist import javax.servlet.http.*; ^ Weird isn't it. On Mon, 2 Jun 2003, Jason Bainbridge wrote: Simplify things... Firstly that extensive CLASSPATH you have created could be causing more problems than it is solving, so try removing it. Then just try: javac -cp /var/tomcat4/common/lib/servlet.jar MultiServlet.java Does that work? If not does the user you are compiling with have rights to access /var/tomcat4/common/lib/servlet.jar ? Regards, Jason On Mon, 2 Jun 2003 00:00, Jonathan Michael Nowacki wrote: This website http://www.sitepoint.com/article/509/3 says all I have to do is put servlet.jar in my classpath to solve my problems. Unfortunitally, it doesn't seem to work. This is my error -- --- $ javac MultiServlet.java MultiServlet.java:1: package javax.servlet does not exist import javax.servlet.*; ^ MultiServlet.java:2: package javax.servlet.http does not exist import javax.servlet.http.*; ^ -- - THis is my path $ echo $CLASSPATH /var/tomcat4/common/lib/commons-dbcp.jar:/var/tomcat4/common/lib/naming-res ources.jar:/var/tomcat4/common/lib/jdbc2_0-stdext.jar:/var/tomcat4/ common/lib/commons-collections.jar:/var/tomcat4/common/lib/naming-factory.j ar:/var/tomcat4/common/lib/jasper-runtime.jar:/var/tomcat4/common/l ib/ant.jar:/var/tomcat4/common/lib/naming-common.jar:/var/tomcat4/common/li b/jasper-compiler.jar:/var/tomcat4/common/lib/activation.jar:/var/t omcat4/common/lib/jndi.jar:/var/tomcat4/common/lib/servlet.jar:/var/tomcat4 /common/lib/commons-logging-api.jar:/var/tomcat4/common/lib/jta.jar :/var/tomcat4/common/lib/commons-pool.jar:/var/tomcat4/common/lib/mailapi.j :ar:/var/tomcat4/server/lib/servlets-common.jar:/var/tomcat4/server/ lib/commons-fileupload.jar:/var/tomcat4/server/lib/tomcat-http11.jar:/var/t omcat4/server/lib/servlets-cgi.renametojar:/var/tomcat4/server/lib/ commons-digester.jar:/var/tomcat4/server/lib/tomcat-coyote.jar:/var/tomcat4 /server/lib/mx4j.license:/var/tomcat4/server/lib/commons-beanutils. jar:/var/tomcat4/server/lib/servlets-webdav.jar:/var/tomcat4/server/lib/mx4 j-jmx.jar:/var/tomcat4/server/lib/catalina.jar:/var/tomcat4/server/ lib/servlets-ssi.renametojar:/var/tomcat4/server/lib/jakarta-regexp-1.2.jar :/var/tomcat4/server/lib/catalina-ant.jar:/var/tomcat4/server/lib/t omcat-jk2.jar:/var/tomcat4/server/lib/commons-logging.jar:/var/tomcat4/serv er/lib/commons-modeler.jar:/var/tomcat4/server/lib/jaas.jar:/var/to mcat4/server/lib/servlets-default.jar:/var/tomcat4/server/lib/servlets-invo ker.jar:/var/tomcat4/server/lib/servlets-manager.jar:/var/tomcat4/s erver/lib/tomcat-jk.jar:/var/tomcat4/server/lib/tomcat-util.jar:/var/tomcat 4/server/lib/tomcat-warp.jar:/usr/java/j2sdk1.4.1_02/lib/dt.jar:/us r/java/j2sdk1.4.1_02/lib/j2ee.jar:/usr/java/j2sdk1.4.1_02/lib/j2eetools.jar :/usr/java/j2sdk1.4.1_02/lib/tools.jar:/usr/java/j2sdk1.4.1_02/lib/ htmlconverter.jar:/usr/java/j2sdk1.4.1_02/lib/j2ee-ri-svc.jar:/usr/java/j2s dk1.4.1_02/lib/jhall.jar:/usr/java/j2sdkee1.4/lib/j2ee.jar:/usr/jav a/j2sdkee1.4/lib/j2ee-ri-svc.jar:/usr/java/j2sdkee1.4/lib/j2eetools.jar:/us r/java/j2sdkee1.4/lib/jhall.jar The actual code is CLASSPATH=/var/tomcat4/common/lib/commons-dbcp.jar:/var/tomcat4/common/lib/ naming-resources.jar:/va r/tomcat4/common/lib/jdbc2_0-stdext.jar:/var/tomcat4/common/lib/commons-col lections.jar:/var/tomcat 4/common/lib/naming-factory.jar:/var/tomcat4/common/lib/jasper-runtime.jar: /var/tomcat4/common/lib/ ant.jar:/var/tomcat4/common/lib/naming-common.jar:/var/tomcat4/common/lib/j asper-compiler.jar:/var/ tomcat4/common/lib/activation.jar:/var/tomcat4/common/lib/jndi.jar:/var/tom cat4/common/lib/servlet. jar:/var/tomcat4/common/lib/commons-logging-api.jar:/var/tomcat4/common/lib /jta.jar:/var/tomcat4/co mmon/lib/commons-pool.jar:/var/tomcat4/common/lib/mailapi.jar:/var/tomcat4/ server/lib/servlets-comm on.jar:/var/tomcat4/server/lib/commons-fileupload.jar:/var/tomcat4/server/l ib/tomcat-http11.jar:/va r/tomcat4/server/lib/servlets-cgi.renametojar:/var/tomcat4/server/lib/commo ns-digester.jar:/var/tom cat4/server/lib/tomcat-coyote.jar:/var/tomcat4/server/lib/mx4j.license:/var /tomcat4/server/lib/comm ons-beanutils.jar:/var/tomcat4/server/lib/servlets-webdav.jar:/var/tomcat4/ server/lib/mx4j-jmx.jar: /var
Re: faulty fix for (javax.servlet does not exist)
Holy cow!!! It worked. Thank you very much Kwok Peng Tuck It's still puzzles me why javac -classpath /var/tomcat4/common/lib/servlet.jar MultiServlet.java works yet javac doesn't when I set my class path variable. $ echo $CLASSPATH /var/tomcat4/common/lib/servlet.jar $ javac MultiServlet.java MultiServlet.java:1: package javax.servlet does not exist import javax.servlet.*; ^ MultiServlet.java:2: package javax.servlet.http does not exist import javax.servlet.http.*; ^ the $CLASSPATH variable is the same as whats after -classpath, why does one work and the other doesn't. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
faulty fix for (javax.servlet does not exist)
This website http://www.sitepoint.com/article/509/3 says all I have to do is put servlet.jar in my classpath to solve my problems. Unfortunitally, it doesn't seem to work. This is my path -- $ echo $CLASSPATH /usr/java/j2sdkee1.4/lib/*.jar:/usr/java/j2sdk1.4.1_02/lib/*.jar:/var/tomcat4/server/lib/*.jar:/var/tomcat4/common/lib/*.jar The classpath is set in the .bashrc, but that should effect the javac command right?!? I've also done the classpath without the *.jar by explicitly naming each of the jar files talk about a pain. This is my error - $ javac MultiServlet.java MultiServlet.java:1: package javax.servlet does not exist import javax.servlet.*; ^ MultiServlet.java:2: package javax.servlet.http does not exist import javax.servlet.http.*; ^ --- these are installed: - tomcat4-webapps-4.1.24-full.2jpp tomcat4-4.1.24-full.2jpp tomcat4-admin-webapps-4.1.24-full.2jpp j2re1.4.1_02 j2sdk1.4.1_02 j2sdkee1.4 The tomcat lib jar files -- classes $ ls /var/tomcat4/common/lib/ activation.jar commons-dbcp.jar jasper-compiler.jar jndi.jar naming-common.jar servlet.jar ant.jar commons-logging-api.jar jasper-runtime.jar jta.jar naming-factory.jar commons-collections.jar commons-pool.jar jdbc2_0-stdext.jar mailapi.jar naming-resources.jar classes $ ls /var/tomcat4/server/lib/ catalina-ant.jarcommons-logging.jar mx4j.license servlets-manager.jar tomcat-jk2.jar catalina.jarcommons-modeler.jar servlets-cgi.renametojar servlets-ssi.renametojar tomcat-jk.jar commons-beanutils.jar jaas.jarservlets-common.jar servlets-webdav.jar tomcat-util.jar commons-digester.jarjakarta-regexp-1.2.jar servlets-default.jar tomcat-coyote.jar tomcat-warp.jar commons-fileupload.jar mx4j-jmx.jarservlets-invoker.jar tomcat-http11.jar - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Compilation errors of Servlet.
When trying to compile a servlet that works on another installation of
tomcat I get this error.
javac MultiServlet.java
MultiServlet.java:1: package javax.servlet does not exist
import javax.servlet.*;
^
MultiServlet.java:2: package javax.servlet.http does not exist
import javax.servlet.http.*;
^
MultiServlet.java:7: cannot resolve symbol
symbol : class HttpServlet
location: class MultiServlet
public class MultiServlet extends HttpServlet {
^
MultiServlet.java:12: cannot resolve symbol
symbol : class ServletConfig
location: class MultiServlet
public void init(ServletConfig config) throws ServletException {
^
MultiServlet.java:12: cannot resolve symbol
symbol : class ServletException
location: class MultiServlet
public void init(ServletConfig config) throws ServletException {
^
MultiServlet.java:23: cannot resolve symbol
symbol : class HttpServletRequest
location: class MultiServlet
public void doPost(HttpServletRequest request, HttpServletResponse
response)
The servlet is good, so it can't be the code itself. Somebody told me I
need some jar files that are in the enterprise edition of java SDK.
so when I try to install it i get:
$ ./j2sdkee-1_4-beta-linux.sh
Using /var/tmp as temporary directory...
Searching for Java(TM) 2 Platform, Standard Edition...
Initializing InstallShield Wizard...
ERROR: could not initialize interface awt - exception:
java.lang.InternalError: Can't connect to X11 window server using ':0.0'
as the value of the DISPLAY variable.
What's the deal, and do I really need the enterprise edition?
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: Compilation errors of Servlet.
I have the full version of tomcat tomcat4-webapps-4.1.24-full.2jpp tomcat4-4.1.24-full.2jpp tomcat4-admin-webapps-4.1.24-full.2jpp are installed My variables JAVA_HOME=/usr/java/j2sdk1.4.1_02 CATALINA_HOME=/var/tomcat4 I've used - none work CLASSPATH=/usr/java/j2sdk1.4.1_02/lib/ CLASSPATH=/var/tomcat4/common/lib/servlet.jar CLASSPATH=/var/tomcat4/common/lib/ On Sat, 31 May 2003, Jason Bainbridge wrote: On Sat, 31 May 2003 07:03, Jonathan Michael Nowacki wrote: When trying to compile a servlet that works on another installation of tomcat I get this error. Taking a guess here... Is CATALINA_HOME\common\lib\servlet.jar in your classpath? Have you got the LE lite version of Tomcat or the full one? I don't think the LE version would cause such an error though, but the full version is definitely recommended. Regards, -- Jason Bainbridge KDE Web Team - http://kde.org [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
