Bonjour,
Pour apporté des amélioration à une application qui tourne déja,j'ai du télécharger tout les fichiers(jsp,class,...) de cette application depuis le serveur.
malgré que l'application tourne(sans aucun pb),sur "eclipse" il m'affiche des erreurs au niveau d"import" de ConnectionPool qui contien les paramétre de la BD.
ce qui me prive de apporter mes ajouts.
ce pb me tracase depuis plusqu'un moisvoisi l'une des pages JSP
<%@ page language="java" import="javax.sql.*, com.reporting.ConnectionPool" pageEncoding="UTF-8" %>
<html>
<head>
<title>Description Serveurs</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<style type="text/css">
<!--
body {
background-color: #CCCCCC;
}
.style11 { color: #000066;
font-family: Arial, Helvetica, sans-serif;
font-weight: bold;
font-size: 36px;
}
.style12 {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
}
.Style13 {font-size: 24px}
.Style16 {color: #006699}
.Style18 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold; }
.Style21 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold; color: #000000; }
.Style23 {font-size: 24px; color: #000099; }
.Style24 {color: #000066}
-->
</style>
</head>
<body>
<% // String ServerName = request.getParameter("ServerName");
Connection conn = null;
Statement stmt = null;
ResultSet RS = null;
String sql="";
try
{ session.getAttribute("globlvar");
conn = ConnectionPool.getOPENVIEWConnection();
stmt = conn.createStatement();
sql="SELECT * FROM (SELECT TEXT_PART,NVL(TO_CHAR(instruction),' ') instruction ,APPLICATION, NVL(TO_CHAR(SERVICE_NAME),' ') SERVICE_NAME ,count(*) Nbr_apparition ";
sql+="FROM ( ";
sql+="SELECT mess.TEXT_PART, ins.TEXT_PART instruction , APPLICATION, SERVICE_NAME from OPC_INSTRUCTIONS ins,OPC_OP.OPC_NODE_NAMES serv, OPC_OP.OPC_HIST_MESSAGES, OPC_OP.OPC_HIST_MSG_TEXT mess ";
sql+="where mess.MESSAGE_NUMBER = OPC_HIST_MESSAGES.MESSAGE_NUMBER ";
if(session.getAttribute("globlvar")!=null && !session.getAttribute("globlvar").equals(""))
{sql+="AND serv.NODE_NAME like '" + session.getAttribute("globlvar") +"' ";}
sql+="AND serv.NODE_ID = OPC_HIST_MESSAGES.NODE_ID ";
sql+="AND OPC_HIST_MESSAGES.INSTRUCTION_ID = ins.INSTRUCTION_ID (+) ";
sql+="AND SEVERITY > 30 ) ";
sql+="group by TEXT_PART , APPLICATION , SERVICE_NAME,instruction ";
sql+="order by Nbr_apparition desc ";
sql+=") where rownum < 20 ";
RS = stmt.executeQuery(sql);
if (RS.next()) {
%>
<TABLE width="100%" border="1" align="center" cellspacing="0" bordercolor="#000000" bgcolor="#3399CC" class="Style24">
<TR>
<TD ><DIV align="center"><SPAN class="Style18">Alert</SPAN></DIV></TD>
<TD ><DIV align="center"><SPAN class="Style18">Application</SPAN></DIV></TD>
<TD ><DIV align="center"><SPAN class="Style18">Service</SPAN></DIV></TD>
<TD><DIV align="center"><SPAN class="Style18">Nbr</SPAN></DIV></TD>
<TD ><DIV align="center"><SPAN class="Style18">Instruction</SPAN></DIV></TD>
</TR>
<% while (RS.next()){%>
<TR bgcolor="#FFFFFF">
<TD><%=RS.getString(1)%></TD>
<TD><DIV align="center"><%=RS.getString(3)%></DIV></TD>
<TD><DIV align="center"><%=RS.getString(4)%></DIV></TD>
<TD><DIV align="center"><%=RS.getString(5)%></DIV></TD>
<TD><DIV align="center"><%=RS.getString(2)%></DIV></TD>
</TR>
<%}
%></TABLE>
<%} else {
%>
<P align="center"><SPAN class="Style23">No warning message</SPAN></P><%}
conn.close();}catch (Exception e) { e.printStackTrace(); } %></body>
</html>
ce qui est en "gras" se sont les erreur
Merci pour votre aide
Configuration: Windows XP
Internet Explorer 6.0
eclipse
tomcat
oracle
