httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Giustizia" <luca.sabat...@giustizia.it>
Subject [users@httpd] Problem with JavaServerPage
Date Mon, 03 Nov 2003 13:14:31 GMT
Good morning at all
 
I write from Italy and it's first time i write. So sorry if i do not use
in the correct way the mailing list.
 
However this is my problem
 
My infrastructure
Database Server   : Win2000 Server with Oracle 9i installed without
Apache  
Application Server: Win2000 Server with Oracle 9i Rel2 ( 9.2.0.1.0 )
with  Apache 1.3.22 installed and configured by Oracle
Client                  : 1500 client with various version of Windows (
95, 98, 98SE XP, 2000 )
 
My problem:
I create a java package
Package Name: Connetti
Source file:        Connessione.java
Compiled file:     Connessione.class
Here a small part
 
Source file Connessione.java
=====================
 
package Connetti;
 
import java.sql.*;
import java.io.*; 
 
public class Connessione
 {
  java.util.Properties Riferimento_Database    = null; 
  Connection           Riferimento_Connessione = null;

  public String Utente      = null;
  public String Password    = null;
  public String Tnsnames    = null;
//
  public void Parametri_Database() 
   {
    Riferimento_Database = new java.util.Properties();
    Riferimento_Database.put("user"    ,  Utente);
    Riferimento_Database.put("password",  Password);
    Riferimento_Database.put("database",  Tnsnames);
   }
 
 
Package Connetti has it's own directory call D:\Procedura\JAVA\Connetti;
The CLASSPATH is:
CLASSPATH=C:\oracle\ora92\jdbc\lib\classes12.zip;C:\oracle\ora92\jdbc\li
b\nls_charset12.zip;
C:\oracle\ora92\jdbc\lib\jta.zip;C:\oracle\ora92\jdbc\lib\jndi.zip;D:\Pr
ocedura\JAVA;
D:\Procedura\JAVA\Class;D:\Procedura\JAVA\Connetti;

I create a small JavaServerPage application which use that package
Here a small part
 
Source Query_Oracle.jsp
========================
 
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<%@ page import="Connetti.*" %>
 
<html>
 
<head>
<meta http-equiv="Content-Language" content="it">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Visualizzazione Sintetica Procedimento</title>
</head>
 
<body>
<% 
    String  utente      = request.getParameter("Utente");
    String  password    = request.getParameter("Password");
    String  anno        = request.getParameter("Anno");
    String  progressivo = request.getParameter("Progressivo");
    //
    try
     {
      Connetti.Connessione param = new Connetti.Connessione ();
      param.Utente      = utente;
      param.Password    = password;
      param.Tnsnames    = "mydb";
      param.Parametri_Database();

 
I start my Apache on the application server 
I run my Query_oracle.jsp in this way
http://myserver:7778/jsp/Query_Oracle.jsp
<http://myserver:7778/jsp/Query_Oracle.jsp> 
 
I get this error
 
URI richiesta:/jsp/Query_Oracle.jsp
 
Eccezione:
oracle.jsp.provider.JspCompileException: 
Errori di
compilazione:d:\procedura\jsp\_pages\_jsp\\_Query__Oracle.javaLine 
# Error 14 Package Connetti not found in import. import Connetti.*;  
 at oracle.jsp.app.JspJavacCompiler.compile(JspJavacCompiler.java)
 at oracle.jsp.app.JspAppLoader.reloadPage(JspAppLoader.java)
 at oracle.jsp.app.JspAppLoader.loadPage(JspAppLoader.java)
 at oracle.jsp.app.JspAppLoader.getPage(JspAppLoader.java)
 at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java)
 at oracle.jsp.JspServlet.doDispatch(JspServlet.java)
 at oracle.jsp.JspServlet.internalService(JspServlet.java)
 at oracle.jsp.JspServlet.service(JspServlet.java)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
 at
org.apache.jserv.JServConnection.processRequest(JServConnection.java:456
)
 at org.apache.jserv.JServConnection.run(JServConnection.java:294)
 at java.lang.Thread.run(Thread.java:484)
 
It seem to be a configuration error 
 
Oracle said to modify the Jserv.properties adding
wrapper.classpath=pathname.
 
But what must i write ?
 
My package  is call Connetti;
Source file is Connessione.java;
Class  file is Connessione.class;
 
In Jserv.properties i see only .zip and .jar file 
 
Must i create a jar file ?
How-to create a jar file ?
The name of jar file     ?
 
And than ...
 
wrapper.classpath=d:\Procedura\JAVA\Connetti
Only the whole pathname ?
wrapper.classpath=d:\Procedura\JAVA\Connetti\Connetti               The
whole pathname plus package name ?
wrapper.classpath=d:\Procedura\JAVA\Connetti\Connessione.jar    The
whole pathname plus jar file which contain 
 
class file which has inside package name ?
Can someone say how-to-solve ?
Thank You

Mime
View raw message