Bonjour à tous,

Je cherche la solution à un problème depuis le début de la journée et je ne trouve pas la réponse. P-e que vous sauriez m'aider.
Je veux me connecter à une base de donnée MSSQL via un pont jdbc:odbc

mon code java

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
 
ArrayList aLimites = new ArrayList();
		ArrayList aCoeffR = new ArrayList();
		ArrayList aCoeffN = new ArrayList();
 
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		catch(ClassNotFoundException cnfe){
		System.out.println("La classe sun.jdbc.odbc.JdbcOdbcDriver n'a pas été trouvée");
		cnfe.printStackTrace();
	    }
 
		//Connexion à la base
 
		Statement S = null;
		ResultSet RS = null;
		Connection connect = null;
		try{
 
		connect = DriverManager.getConnection(
				"jdbc:odbc:" + dsnImpots,
				userImpots,
				mdpImpots);
 
		//creation d'un objet statement
		S = connect.createStatement();
		//requet select
		String select = "select limites, coeffR, coeffN from impots";
		//execution de la requete
		RS = S.executeQuery(select);
		while (RS.next()) {
			//exploitation de la ligne courante
			aLimites.add(RS.getString("limites"));
			aCoeffR.add(RS.getString("coeffR"));
			aCoeffN.add(RS.getString("coeffN"));
		}
		} //ligne suivante
		catch(Exception ex)
		{
		 System.out.println("Probleme SQL");
		 ex.printStackTrace();
		}
		finally{
 
 
		//fermeture ressource
 
		RS.close();
		S.close();
		connect.close();
		}
J'ai une exception à la ligne de code

aLimites.add(RS.getString("limites"));

voici l'exception

[19/02/07 14:53:49:390 CET] 4f994f99 SystemErr R java.sql.SQLException: No data found
[19/02/07 14:53:49:406 CET] 4f994f99 SystemErr R at java.lang.Throwable.<init>(Throwable.java)
[19/02/07 14:53:49:406 CET] 4f994f99 SystemErr R at java.lang.Throwable.<init>(Throwable.java)
[19/02/07 14:53:49:406 CET] 4f994f99 SystemErr R at java.sql.SQLException.<init>(SQLException.java:93)
[19/02/07 14:53:49:406 CET] 4f994f99 SystemErr R at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7179)
[19/02/07 14:53:49:406 CET] 4f994f99 SystemErr R at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3948)
[19/02/07 14:53:49:406 CET] 4f994f99 SystemErr R at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java:5735)
[19/02/07 14:53:49:406 CET] 4f994f99 SystemErr R at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:387)
[19/02/07 14:53:49:406 CET] 4f994f99 SystemErr R at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:444)
[19/02/07 14:53:49:406 CET] 4f994f99 SystemErr R at com.calculImpot.ImpotJDBC.<init>(ImpotJDBC.java)
[19/02/07 14:53:49:406 CET] 4f994f99 SystemErr R at com.calculImpot.servlet.Main.init(Main.java)
[19/02/07 14:53:49:406 CET] 4f994f99 SystemErr R at javax.servlet.GenericServlet.init(GenericServlet.java:258)
[19/02/07 14:53:49:406 CET] 4f994f99 SystemErr R at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doInit(StrictServletInstance.java:82)
[19/02/07 14:53:49:406 CET] 4f994f99 SystemErr R at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._init(StrictLifecycleServlet.java:147)
[19/02/07 14:53:49:406 CET] 4f994f99 SystemErr R at com.ibm.ws.webcontainer.servlet.PreInitializedServletState.init(StrictLifecycleServlet.java:270)
[19/02/07 14:53:49:406 CET] 4f994f99 SystemErr R at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.init(StrictLifecycleServlet.java:113)
[19/02/07 14:53:49:406 CET] 4f994f99 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletInstance.init(ServletInstance.java:189)
[19/02/07 14:53:49:406 CET] 4f994f99 SystemErr R at javax.servlet.GenericServlet.init(GenericServlet.java:258)
[19/02/07 14:53:49:406 CET] 4f994f99 SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppServletManager.addServlet(WebAppServletManager.java:876)
[19/02/07 14:53:49:406 CET] 4f994f99 SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppServletManager.loadServlet(WebAppServletManager.java:224)
[19/02/07 14:53:49:406 CET] 4f994f99 SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppServletManager.getServletReference(WebAppServletManager.java:455)
[19/02/07 14:53:49:406 CET] 4f994f99 SystemErr R at com.ibm.ws.webcontainer.webapp.WebApp.getServletReference(WebApp.java:652)
[19/02/07 14:53:49:406 CET] 4f994f99 SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcherInfo.calculateInfo(WebAppRequestDispatcherInfo.java:187)
[19/02/07 14:53:49:406 CET] 4f994f99 SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcherInfo.<init>(WebAppRequestDispatcherInfo.java:68)
[19/02/07 14:53:49:406 CET] 4f994f99 SystemErr R at com.ibm.ws.webcontainer.webapp.WebApp.getRequestDispatcher(WebApp.java:1464)
[19/02/07 14:53:49:406 CET] 4f994f99 SystemErr R at com.ibm.ws.webcontainer.webapp.WebApp.getRequestDispatcher(WebApp.java:1423)
[19/02/07 14:53:49:421 CET] 4f994f99 SystemErr R at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276)
[19/02/07 14:53:49:421 CET] 4f994f99 SystemErr R at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
[19/02/07 14:53:49:421 CET] 4f994f99 SystemErr R at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182)
[19/02/07 14:53:49:421 CET] 4f994f99 SystemErr R at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
[19/02/07 14:53:49:421 CET] 4f994f99 SystemErr R at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
[19/02/07 14:53:49:421 CET] 4f994f99 SystemErr R at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:615)
[19/02/07 14:53:49:421 CET] 4f994f99 SystemErr R at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439)
[19/02/07 14:53:49:421 CET] 4f994f99 SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java)

Avez vous une idée?
Merci d'avance