Parametros para conexão com Oracle XE

Olá pessoal,

Tenho um projeto no J2EE no NetBeans utilizando um BD MySql. Abaixo segue os parâmetros para conexão com o MySql só para explicar melhor. Agora utilizarei o Driver ojdbc14.jar para conectar no Oracle

&lt;?xml version="1.0" encoding="UTF-8"?&gt;
&lt;web-app version="2.4" xmlns="http&#58;//java.sun.com/xml/ns/j2ee" xmlns&#58;xsi="http&#58;//www.w3.org/2001/XMLSchema-instance" xsi&#58;schemaLocation="http&#58;//java.sun.com/xml/ns/j2ee http&#58;//java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"&gt;
    &lt;context-param&gt;
        &lt;param-name&gt;jdbc_driver&lt;/param-name&gt;
        &lt;param-value&gt;org.gjt.mm.mysql.Driver&lt;/param-value&gt;
    &lt;/context-param&gt;
    &lt;context-param&gt;
        &lt;param-name&gt;jdbc_url&lt;/param-name&gt;
        &lt;param-value&gt;jdbc&#58;mysql&#58;//localhost&#58;3306/agenda&lt;/param-value&gt;
    &lt;/context-param&gt;
    &lt;context-param&gt;
        &lt;param-name&gt;jdbc_user&lt;/param-name&gt;
        &lt;param-value&gt;usuario&lt;/param-value&gt;
    &lt;/context-param&gt;
    &lt;context-param&gt;
        &lt;param-name&gt;jdbc_password&lt;/param-name&gt;
        &lt;param-value&gt;senha&lt;/param-value&gt;
    &lt;/context-param&gt;
    &lt;session-config&gt;
        &lt;session-timeout&gt;
            30
        &lt;/session-timeout&gt;
    &lt;/session-config&gt;
    &lt;welcome-file-list&gt;
        &lt;welcome-file&gt;
            formlogin.html
        &lt;/welcome-file&gt;
    &lt;/welcome-file-list&gt;
&lt;/web-app&gt;

A pergunta é. Qual o parâmetro que devo utilizar em <param-name>jdbc_driver</param-name> ???

Grato.
Wallfox

Olá jairelton

Fix meu web.xml assim:

&lt;?xml version="1.0" encoding="UTF-8"?&gt;
&lt;web-app version="2.4" xmlns="http&#58;//java.sun.com/xml/ns/j2ee" xmlns&#58;xsi="http&#58;//www.w3.org/2001/XMLSchema-instance" xsi&#58;schemaLocation="http&#58;//java.sun.com/xml/ns/j2ee http&#58;//java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"&gt;
  &lt;context-param&gt;
    &lt;param-name&gt;jdbc_driver&lt;/param-name&gt;
    &lt;param-value&gt;oracle.jdbc.driver.OracleDriver&lt;/param-value&gt;
  &lt;/context-param&gt;
  &lt;context-param&gt;
    &lt;param-name&gt;jdbc_url&lt;/param-name&gt;
    &lt;param-value&gt;jdbc&#58;oracle&#58;thin&#58;hr/hr@localhost&#58;1521/XE&lt;/param-value&gt;
  &lt;/context-param&gt;
  &lt;context-param&gt;
    &lt;param-name&gt;jdbc_user&lt;/param-name&gt;
    &lt;param-value&gt;system&lt;/param-value&gt;
  &lt;/context-param&gt;
  &lt;context-param&gt;
    &lt;param-name&gt;jdbc_password&lt;/param-name&gt;
    &lt;param-value&gt;senha&lt;/param-value&gt;
  &lt;/context-param&gt;
  &lt;session-config&gt;
    &lt;session-timeout&gt;
            30
        &lt;/session-timeout&gt;
  &lt;/session-config&gt;
  &lt;welcome-file-list&gt;
    &lt;welcome-file&gt;
            index.jsp
        &lt;/welcome-file&gt;
  &lt;/welcome-file-list&gt;
&lt;/web-app&gt;

Estou recebendo a seguinte mensagem de erro:

type Exception report

message

description The server encountered an internal error &#40;&#41; that prevented it from fulfilling this request.

exception

javax.servlet.ServletException&#58; Problemas com a consulta ao BD!
	org.apache.jasper.runtime.PageContextImpl.doHandlePageException&#40;PageContextImpl.java&#58;848&#41;
	org.apache.jasper.runtime.PageContextImpl.handlePageException&#40;PageContextImpl.java&#58;781&#41;
	org.apache.jsp.index_jsp._jspService&#40;index_jsp.java&#58;109&#41;
	org.apache.jasper.runtime.HttpJspBase.service&#40;HttpJspBase.java&#58;97&#41;
	javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;802&#41;
	org.apache.jasper.servlet.JspServletWrapper.service&#40;JspServletWrapper.java&#58;322&#41;
	org.apache.jasper.servlet.JspServlet.serviceJspFile&#40;JspServlet.java&#58;291&#41;
	org.apache.jasper.servlet.JspServlet.service&#40;JspServlet.java&#58;241&#41;
	javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;802&#41;
	org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter&#40;MonitorFilter.java&#58;362&#41;

root cause

java.lang.Exception&#58; Problemas com a consulta ao BD!
	org.apache.jsp.index_jsp._jspService&#40;index_jsp.java&#58;95&#41;
	org.apache.jasper.runtime.HttpJspBase.service&#40;HttpJspBase.java&#58;97&#41;
	javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;802&#41;
	org.apache.jasper.servlet.JspServletWrapper.service&#40;JspServletWrapper.java&#58;322&#41;
	org.apache.jasper.servlet.JspServlet.serviceJspFile&#40;JspServlet.java&#58;291&#41;
	org.apache.jasper.servlet.JspServlet.service&#40;JspServlet.java&#58;241&#41;
	javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;802&#41;
	org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter&#40;MonitorFilter.java&#58;362&#41;

note The full stack trace of the root cause is available in the Apache Tomcat/5.5.9 logs.

O que estou fazendo errado??? O meu banco está rodando direitinho e para teste eu utilizo o Squirel com esta jdbc_url e tudo OK.

Grato.
Wallfox

2 Respostas

Topicos relacionados