Parametros para conexão com Oracle XE

Programação Java
#1

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

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

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

Grato.
Wallfox

#2

oracle.jdbc.driver.OracleDriver

#3

Olá jairelton

Fix meu web.xml assim:

&lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?&gt;
&lt;web-app version=&quot;2.4&quot; xmlns=&quot;http&#58;//java.sun.com/xml/ns/j2ee&quot; xmlns&#58;xsi=&quot;http&#58;//www.w3.org/2001/XMLSchema-instance&quot; xsi&#58;schemaLocation=&quot;http&#58;//java.sun.com/xml/ns/j2ee http&#58;//java.sun.com/xml/ns/j2ee/web-app_2_4.xsd&quot;&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

#4