bonjour a tous.
je voudrais pouvoir stocker le resultat d'une requete dans un fichier text mais je n'y arrive pas je travaille avec java.
voici le code :
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
 
psRequete=connection.prepareStatement(requete,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);				
			//requete est la variable qui contient mon select
resRequete =psRequete.executeQuery();
			if(resRequete.first()){	
		FileOutputStream fos = new FileOutputStream("c://fichier.txt");
				fos.close();
				BufferedWriter scriptlist=new BufferedWriter(new FileWriter(liste[count]));
				PrintWriter p=new PrintWriter(scriptlist);
 
// voici la ou je charge le fichier txt
				 				do{													p.println(resRequete.getString("arretN.age")+"|"+resRequete.getString("dev")+"|"+
							  resRequete.getString("ncp")+"|"+resRequete.getString("clc")+"|"+resRequete.getString("nom[1,20]")+"|"+
							  resRequete.getString("pre[1,15]")+"|"+resRequete.getString("dco")+"|"+resRequete.getString("ddm")+"|"+
							  resRequete.getString("arr")+"|"+resRequete.getString("sde")+"|"+resRequete.getString("arretN.aut")+"|"+
							  resRequete.getString("mvtcm")+"|"+resRequete.getString("mvtcm_1")+"|"+resRequete.getString("mvtcm_2")+"|"+
							  resRequete.getString("mvtdm")+"|"+resRequete.getString("mvtdm_1")+"|"+resRequete.getString("mvtdm_2")+"|"+
							  resRequete.getString("agiom_1")+"|"+resRequete.getString("agiom_2")+"|"+resRequete.getString("ges")+"|"+
							  resRequete.getString("lib1"));		
				}while(resRequete.next());
			}
voici l'erreur console :

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
java.sql.SQLException: No such column name
	at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:373)
	at com.informix.jdbc.IfxResultSet.findColumn(IfxResultSet.java:615)
	at com.informix.jdbc.IfxResultSet.getString(IfxResultSet.java:756)
	at logiquemetier.Traitement_scriptsql.processquerystat(Traitement_scriptsql.java:276)
	at mainpackage.ArreteFrame.actionPerformed(ArreteFrame.java:303)
	at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
	at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
	at java.awt.Component.processMouseEvent(Unknown Source)
	at javax.swing.JComponent.processMouseEvent(Unknown Source)
	at java.awt.Component.processEvent(Unknown Source)
	at java.awt.Container.processEvent(Unknown Source)
	at java.awt.Component.dispatchEventImpl(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Window.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.run(Unknown Source)