Visualizzazione Sintetica Procedimento

=20 =20 I get this error =20 URI richiesta:/jsp/Query_Oracle.jsp =20 Eccezione: oracle.jsp.provider.JspCompileException:=20 Errori di compilazione:d:\procedura\jsp\_pages\_jsp\\_Query__Oracle.javaLine=20 # Error 14 Package Connetti not found in import. import Connetti.*; =20 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) =20 It seem to be a configuration error=20 =20 Oracle said to modify the Jserv.properties adding wrapper.classpath=3Dpathname. =20 But what must i write ? =20 My package is call Connetti; Source file is Connessione.java; Class file is Connessione.class; =20 In Jserv.properties i see only .zip and .jar file=20 =20 Must i create a jar file ? How-to create a jar file ? The name of jar file ? =20 And than ... =20 wrapper.classpath=3Dd:\Procedura\JAVA\Connetti Only the whole pathname ? wrapper.classpath=3Dd:\Procedura\JAVA\Connetti\Connetti = The whole pathname plus package name ? wrapper.classpath=3Dd:\Procedura\JAVA\Connetti\Connessione.jar The whole pathname plus jar file which contain=20 =20 class file which has inside package name ? Can someone say how-to-solve ? Thank You ------=_NextPart_000_0020_01C3A214.CCDC9680 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Good morning at all

I write from Italy and it's first time = i write. So=20 sorry if i do not use in the correct way the mailing list.

However this is my = problem

My infrastructure
Database = Server   :=20 Win2000 Server with Oracle 9i installed without Apache =
Application=20 Server: Win2000 Server with Oracle 9i Rel2 ( 9.2.0.1.0=20 ) with  Apache 1.3.22 installed and configured by=20 Oracle
Client         &n= bsp;       =20 : 1500 client with various version of Windows ( 95, 98, 98SE XP, 2000=20 )

My problem:
I create a java = package

Package Name: Connetti
Source=20 file: = Connessione.java
Compiled file: =20 Connessione.class

Here a small part

Source file = Connessione.java

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=

package Connetti;

import java.sql.*;
import = java.io.*;=20

public class = Connessione
{
=20 java.util.Properties Riferimento_Database =3D null; =
=20 Connection =20 Riferimento_Connessione =3D null;

public String=20 Utente      =3D null;
public String=20 Password    =3D null;
public String=20 Tnsnames    =3D null;
//
public void=20 Parametri_Database()
   {
   =20 Riferimento_Database =3D new = java.util.Properties();
   =20 Riferimento_Database.put("user"    , =20 Utente);
    = Riferimento_Database.put("password", =20 Password);
    = Riferimento_Database.put("database", =20 Tnsnames);
   }

Package Connetti has it's own = directory call=20 D:\Procedura\JAVA\Connetti;
The = CLASSPATH=20 is:
CLASSPATH=3DC:\oracle\ora92\jdbc\lib\classes12.zip;C:\oracle\or= a92\jdbc\lib\nls_charset12.zip;
C:\oracle\ora92\jdbc\lib\jta.zip;C:\o= racle\ora92\jdbc\lib\jndi.zip;D:\Procedura\JAVA;
D:\Procedura\JAVA\Cl= ass;D:\Procedura\JAVA\Connetti;

I create a small JavaServerPage = application which=20 use that package

Here a small part

Source=20 Query_Oracle.jsp
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D

<%@ page import=3D"java.sql.*" = %>
<%@=20 page import=3D"java.io.*" %>
<%@ page import=3D"java.util.*"=20 %>
<%@ page import=3D"Connetti.*" %>

<html>

<head>
<meta=20 http-equiv=3D"Content-Language" content=3D"it">
<meta=20 http-equiv=3D"Content-Type" content=3D"text/html;=20 charset=3Dwindows-1252">
<meta name=3D"GENERATOR" = content=3D"Microsoft=20 FrontPage 4.0">
<meta name=3D"ProgId"=20 content=3D"FrontPage.Editor.Document">
<title>Visualizzazion= e=20 Sintetica Procedimento</title>
</head>

<body>
<% =
   =20 String utente      =3D=20 request.getParameter("Utente");
    String =20 password    =3D=20 request.getParameter("Password");
    String =20 anno        =3D=20 request.getParameter("Anno");
    String = progressivo =3D=20 request.getParameter("Progressivo");
   =20 //
    try
    =20 {
      Connetti.Connessione param =3D new=20 Connetti.Connessione ();
     =20 param.Utente      =3D=20 utente;
      = param.Password    =3D=20 password;
      = param.Tnsnames    =3D=20 "mydb";
     =20 param.Parametri_Database();

I start my Apache on the application = server
I=20 run my Query_oracle.jsp in this way http://myserver:7778/= jsp/Query_Oracle.jsp

I get this error

URI = richiesta:/jsp/Query_Oracle.jsp

Eccezione:
oracle.jsp.provider.JspCompileException: =
Errori di=20 compilazione:d:\procedura\jsp\_pages\_jsp\\_Query__Oracle.javaLine =
# Error=20 14 Package Connetti not found in import. import Connetti.*; =
at=20 oracle.jsp.app.JspJavacCompiler.compile(JspJavacCompiler.java)
= at=20 oracle.jsp.app.JspAppLoader.reloadPage(JspAppLoader.java)
at=20 oracle.jsp.app.JspAppLoader.loadPage(JspAppLoader.java)
at=20 oracle.jsp.app.JspAppLoader.getPage(JspAppLoader.java)
at=20 oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java)
&n= bsp;at=20 oracle.jsp.JspServlet.doDispatch(JspServlet.java)
at=20 oracle.jsp.JspServlet.internalService(JspServlet.java)
at=20 oracle.jsp.JspServlet.service(JspServlet.java)
at=20 javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at= =20 org.apache.jserv.JServConnection.processRequest(JServConnection.java:456= )
at=20 org.apache.jserv.JServConnection.run(JServConnection.java:294)
= at=20 java.lang.Thread.run(Thread.java:484)

It seem to be a configuration error =

Oracle said to modify the = Jserv.properties adding=20 wrapper.classpath=3Dpathname.

But what must i write ?

My package is call Connetti;
S= ource file=20 is Connessione.java;
Class file is = Connessione.class;

In Jserv.properties i see only .zip = and .jar file=20

Must i create a jar file ?
How-to = create a jar=20 file ?
The name of jar file ?

And than ...

wrapper.classpath=3Dd:\Procedura\JAVA\Connetti   = ;            = ;            = ;=20 Only the whole pathname=20 ?
wrapper.classpath=3Dd:\Procedura\JAVA\Connetti\Connetti  =             = =20 The whole pathname plus package name=20 ?
wrapper.classpath=3Dd:\Procedura\JAVA\Connetti\Connessione.jar = ;  =20 The whole pathname plus jar file which contain=20
           &n= bsp;           &n= bsp;           &n= bsp;           &n= bsp;           &n= bsp;           &n= bsp;           &n= bsp;           &n= bsp; =20 class file which has inside package name ?

Can someone say how-to-solve = ?
Thank=20 You

------=_NextPart_000_0020_01C3A214.CCDC9680--