Bonjour,
Depuis des jours j'essaye de faire la connexion entre oracle et netbeans mais rien et je dois rendre mon travail lundi, je vous en supplie aider moi
ma page jsp
<%@taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"%>
<%--
Document : index
Created on : 27 mars 2009, 20:35:10
Author : HF
--%>
<sql:setDataSource
var="customerDS"
driver="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@127.0.0.1:1521:ORCL"
user="system"
password="admin"
/>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<h1>Hello World!</h1>
<sql:query var="affiche" scope="request" dataSource="">
SELECT libelle FROM categories;
</sql:query>
</body>
</html>
ma classe java:
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
/**
*
* @author HF
*/
import java.sql.*;
import oracle.jdbc.driver.*;
class TestJDBC{
String sQuery;
TestJDBC(){
this.sQuery="select libelle from categories";
Statement sStat=null;
Connection cCon=null;
try{
Class cDriverOracle=Class.forName("oracle.jdbc.driver.OracleDriver");
Driver dDriverOracle=(java.sql.Driver)cDriverOracle.newInstance();
DriverManager.registerDriver(dDriverOracle);
cCon=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:ORCL","system","admin");
}
catch(Exception e){
System.out.println("--Pbm en chargeant le driver JDBC oracle--");
e.printStackTrace();
}
try{
sStat=cCon.createStatement();
ResultSet rs=sStat.executeQuery(sQuery);
rs.next();
System.out.println("Resultat requete: "+rs.getObject(1));
sStat.close();
}
catch(Exception sqlE){
System.out.println("La Requête n'a pas abouti");
sqlE.printStackTrace();
}
}
public static void main(String[] sArgs){
TestJDBC tj=new TestJDBC();
}
}
l'erreur afficher lors de la compilation:
http://img25.imageshack.us/img25/3896/capturerohb.jpg
