Problemas con conexión a oracle con jdbc

lorozco
29 de Mayo del 2003
Por favor necesito ayuda.

Soy nuevo en esto de jsp y tengo problemas al tratar de conectarme a una base de datos oracle, tengo tomcat 4.1, jdk1.3.1_08 y bajé los driver de oracle ojdbc14.jar y classes12.zip.

El tomcat funciona bien, y tengo definida correctarmente mi CLASSPATH apuntando a las clases que contienen los drivers.

A continuación el código que uso para intentar la conexión:

<%@ page language = "java" %>

<%@ page import = "java.util.*"%>
<%@ page import = "oracle.jdbc.driver.*" %>
<%@ page import = "java.io.*" %>
<%@ page import = "java.lang.*" %>
<%@ page import = "java.sql.*" %>
<%@ page import = "javax.servlet.http.*" %>


<HTML>
<HEAD>
<TITLE>Prueba de conexion</TITLE>
</HEAD>
<BODY BGCOLOR="black" TEXT="WHITE">
<center>
<h2> Prueba de Conexion </h2>

<%

try {

//Esta parte la he probado por si sola y no manda error

Class.forName ("oracle.jdbc.driver.OracleDriver");

DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());

out.println ("Loading Oracle JDBC driver");

}catch (ClassNotFoundException cnfe){
System.err.println ("Error loading driver:"+cnfe);
System.exit(1);
}

%>

//El problema está en esta parte


<% Connection conn = null;

conn = DriverManager.getConnection ("jdbc:oracle:thin:@172.16.0.26:1521","edb","leo","leo");

out.println ("Coneccion exitosa");
%>

</BODY>
</HTML>


cuando lo ejecuto me sale el siguiente error:

HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: No se puede compilar la clase para JSP

An error occurred at line: -1 in the jsp file: null

Generated servlet error:
[javac] Since fork is true, ignoring compiler setting.
[javac] Compiling 1 source file
[javac] Since fork is true, ignoring compiler setting.
[javac] C:Archivos de programaApache GroupTomcat 4.1workStandalonelocalhostexamplesjspprimerointento_jsp.java:86: cannot resolve symbol
[javac] symbol : method getConnection (java.lang.String,java.lang.String)
[javac] location: class java.sql.DriverManager
[javac] conn = DriverManager.getConnection("jdbc:oracle:thin:@172.16.0.27:1521","edb","leo","leo");

[javac] 1 error



at org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:130)
at org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:293)
at org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:353)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:370)
at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:473)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:190)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
at java.lang.Thread.run(Thread.java:479)


Agradeciría cualquier sugerencia.