You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@httpd.apache.org by Giustizia <lu...@giustizia.it> on 2003/11/03 14:14:31 UTC
[users@httpd] Problem with JavaServerPage
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