[es] - Error: oracle.jdbc not found

infob

Član broj: 144678
Poruke: 34
91.191.15.*

Profil

^{23.10.2007. u 15:35 - pre 202 meseci}

Pozdrav! Pri pokretanju aplikacije u JDeveloper-u javlja mi se greska: "Error: oracle.jdbc not found".
Kako da definisem put do ojdbc14.jar fajla, koji sam kopirao u "D:\jdeveloper\jdev\mywork\m_n_z\ViewController\public_html\WEB-INF\lib", tj. da li je to fajl koji se trazi i, ako ne ovdje, gdje da ga definisem?

web.xml:

Code:
<?xml version = '1.0' encoding = 'windows-1252'?>
<web-app 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" version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee">
    <description>Empty web.xml file for Web Application</description>
    <servlet-mapping>
     <servlet-name>FileManager</servlet-name>
     <url-pattern>/servlet/FileManager</url-pattern>
    </servlet-mapping>
    <servlet>
        <servlet-name>action</servlet-name>
        <servlet-class>org.apache.struts.action.ActionServlet</servlet-class>
        <init-param>
            <param-name>config</param-name>
            <param-value>/WEB-INF/struts-config.xml</param-value>
        </init-param>
        <load-on-startup>1</load-on-startup>
    </servlet>
    <servlet-mapping>
        <servlet-name>action</servlet-name>
        <url-pattern>*.do</url-pattern>
    </servlet-mapping>
    <session-config>
        <session-timeout>35</session-timeout>
    </session-config>
    <mime-mapping>
        <extension>html</extension>
        <mime-type>text/html</mime-type>
    </mime-mapping>
    <mime-mapping>
        <extension>txt</extension>
        <mime-type>text/plain</mime-type>
    </mime-mapping>
    <welcome-file-list>
        <welcome-file>/login.jsp</welcome-file>
    </welcome-file-list>
</web-app>

Poziv iz .jsp stranica bi isao preko:
db.jsp

Code:
<%@ page import="java.sql.*"%>
<%
try{
    Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
}catch (Exception ex){
    out.println(ex.toString());
}
String xDb_Conn_Str = "jdbc:oracle:thin:@localhost:1521:xe";
Connection conn = null;
try{
    conn = DriverManager.getConnection(xDb_Conn_Str,"nikola","nick");
}catch (SQLException ex){
    out.println(ex.toString());
}
%>

a ovo je jedan od fajlova na kojima jdeveloper, pri pokretanju, izbaci gresku:
formatview.jsp

Code:
<%@ page session="true" buffer="16kb" import="java.sql.*,java.util.*,java.text.*"%>
<%@ page import="oracle.jdbc.*" %>
<%@ page contentType="text/html; charset=UTF-8" %>
<% Locale locale = Locale.getDefault();
response.setLocale(locale);%>
<% session.setMaxInactiveInterval(30*60); %>
<%@ include file="db.jsp" %>
<%@ include file="jspmkrfn.jsp" %>
<%
String tmpfld = null;
String escapeString = "''";
String key = request.getParameter("key");
if (key == null || key.length() == 0) { response.sendRedirect("Formatlist.jsp");}

// Get action
String a = request.getParameter("a");
if (a == null || a.length() == 0) {
    a = "I";    // Display with input box
}
String x_ID_F = "";
String x_Naziv_F = "";

// Open Connection to the database
try{
    conn.setAutoCommit(false);
    OracleStatement stmt = (OracleStatement) conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
    stmt.executeQuery("ALTER SESSION SET CURRENT_SCHEMA = NIKOLA");
    OracleResultSet rs = null;
    if (a.equals("I")) {// Get a record to display
        String tkey = "'" + key.replaceAll("'",escapeString) + "'";
        String strsql = "SELECT * FROM \"Format\" WHERE \"ID_F\"=" + tkey;
        rs = (OracleResultSet) stmt.executeQuery(strsql);
        if (!rs.next()) {
            out.clear();
            response.sendRedirect("Formatlist.jsp");
        }else{
            rs.first();
        }

        // Get field values
        // ID_F

        if (rs.getString("ID_F") != null){
            x_ID_F = rs.getString("ID_F");
        }else{
            x_ID_F = "";
        }

        // Naziv_F
        if (rs.getString("Naziv_F") != null){
            x_Naziv_F = rs.getString("Naziv_F");
        }else{
            x_Naziv_F = "";
        }
    }
%>
<%@ include file="header.jsp" %>
<p><span class="jspmaker">View TABLE: Format<br><br><a href="Formatlist.jsp">Back to List</a></span></p>
<p>
<form>
<table border="0" cellspacing="2" cellpadding="4" bgcolor="#CCCCCC">
    <tr>
        <td bgcolor="#FF3300"><span class="jspmaker" style="color: #FFFFFF;">ID F</span> </td>
        <td bgcolor="#F5F5F5"><span class="jspmaker"><% out.print(x_ID_F); %></span> </td>
    </tr>
    <tr>
        <td bgcolor="#FF3300"><span class="jspmaker" style="color: #FFFFFF;">Naziv F</span> </td>
        <td bgcolor="#F5F5F5"><span class="jspmaker"><% out.print(x_Naziv_F); %></span> </td>
    </tr>
</table>
</form>
<p>
<%
    rs.close();
    rs = null;
    stmt.close();
    stmt = null;
    conn.close();
    conn = null;
}catch(SQLException ex){
    out.println(ex.toString());
}
%>
<%@ include file="footer.jsp" %>

Nikako da nadjem rjesenje. Hvala na pomoci!

Odgovor na temu