[ infob @ 23.10.2007. 15:35 ] @
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! |