Les Data ne s'affichent pas dans mon JTable

**jacko842** · 27/09/2011, 16h10

Bonjour,

En java(Eclipse) je me connecte à mon AS400 via les driver jtopen_7_3 d'IBM.
Je voudrai renvoyer le résultat de ma requête dans un Jtable en utilisant la classe AbstractTableModel .

Le problème c'est que mon Jtable m'affiche bien les noms des (colonnes)champs mais pas les données .

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
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
 
 
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
 
import javax.swing.JFrame;
 
public class as400 {
 
	/**
         * @param args
         * @throws SQLException 
         */
	public static void main(String[] args) throws SQLException {
		// TODO Auto-generated method stub
 
		Connection cn;
		Statement st = null;
		DriverManager.registerDriver(new com.ibm.as400.access.AS400JDBCDriver());
		cn = DriverManager.getConnection("jdbc:as400://144.164.165.10/POUBELLE","INVITE","INVITE");
		st = cn.createStatement ();
		ResultSet rs = st.executeQuery("select societe,client,nom from clisig");
 
		ResultSetTableModel rtm = new ResultSetTableModel( rs );
 
		TablePanel tablePanel = new TablePanel( rtm );
 
        JFrame mainFrame = new JFrame( "Affiche table " );
        mainFrame.add( tablePanel, BorderLayout.CENTER );
        mainFrame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE );
        mainFrame.setSize( 640, 480 );
        mainFrame.setVisible( true );
		//while(rs.next()){
		//	System.out.println(rs.getInt(1)+" "+rs.getString(2)+" "+rs.getString(3)+" "+rs.getString(4)+" "+rs.getString(5));
		//}
		cn.close();
 
 
	}
 
}

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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
 
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
 
import javax.swing.table.AbstractTableModel;
 
 
public class ResultSetTableModel extends AbstractTableModel
{
  /**
         * 
         */
	private static final long serialVersionUID = 1L;
public ResultSetTableModel( ResultSet resultSet )
  {
    this.resultSet = resultSet;
 
    try 
    {
      this.resultSetMetaData = resultSet.getMetaData();
    } 
    catch (SQLException e) 
    {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }
  }
  @Override
  public int getColumnCount()//qui renvéra le nombre de colonnes
  {
	try 
    {
      return resultSetMetaData.getColumnCount();
    } 
    catch (SQLException e) 
    {
      // TODO Auto-generated catch block
      e.printStackTrace();
      return 0;
    }
  }
 
  @Override
  public int getRowCount()//pour le nombre de lignes
  {
	try
    {
      resultSet.last();
      return resultSet.getRow();
    } 
	catch (SQLException e)
    {
      // TODO Auto-generated catch block
      e.printStackTrace();
      return 0;
    }
  }
 
  @Override
  public Object getValueAt(int rowIndex, int columnIndex) 
  {
    try
    {
      resultSet.absolute( rowIndex + 1 );
      return resultSet.getObject(columnIndex + 1 );
    } 
    catch (SQLException e)
    {
      // TODO Auto-generated catch block
      e.printStackTrace();
      return null;
    }
  }
 
  @Override
  public String getColumnName( int column )//pour que le JTable puisse utiliser les noms des champs comme titres de colonnes,
  {
    try 
    {
      return resultSetMetaData.getColumnName( column + 1 );
    } 
    catch (SQLException e) 
    {
      // TODO Auto-generated catch block
      e.printStackTrace();
      return "";
    }
  }
 
  private ResultSet resultSet;
  private ResultSetMetaData resultSetMetaData;

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
 
import java.awt.BorderLayout;
 
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.TableModel;
 
 
public class TablePanel extends JPanel
{
  /**
         * 
         */
	private static final long serialVersionUID = 1L;
public TablePanel( TableModel model )
  {
    table = new JTable( model );
 
    setLayout( new BorderLayout() );
    add( new JScrollPane( table ), BorderLayout.CENTER );
 
 
  }
  private JTable table;
}

Erreur

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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
 
 
java.sql.SQLException: Cursor state not valid.
	at com.ibm.as400.access.JDError.throwSQLException(JDError.java:415)
	at com.ibm.as400.access.JDError.throwSQLException(JDError.java:387)
	at com.ibm.as400.access.AS400JDBCResultSet.beforePositioning(AS400JDBCResultSet.java:1271)
	at com.ibm.as400.access.AS400JDBCResultSet.last(AS400JDBCResultSet.java:1682)
	at ResultSetTableModel.getRowCount(ResultSetTableModel.java:48)
	at javax.swing.JTable.getRowCount(Unknown Source)
	at javax.swing.plaf.basic.BasicTableUI.createTableSize(Unknown Source)
	at javax.swing.plaf.basic.BasicTableUI.getPreferredSize(Unknown Source)
	at javax.swing.JComponent.getPreferredSize(Unknown Source)
	at javax.swing.ScrollPaneLayout.layoutContainer(Unknown Source)
	at java.awt.Container.layout(Unknown Source)
	at java.awt.Container.doLayout(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validate(Unknown Source)
	at java.awt.Window.show(Unknown Source)
	at java.awt.Component.show(Unknown Source)
	at java.awt.Component.setVisible(Unknown Source)
	at java.awt.Window.setVisible(Unknown Source)
	at as400.main(as400.java:34)
java.sql.SQLException: Cursor state not valid.
	at com.ibm.as400.access.JDError.throwSQLException(JDError.java:415)
	at com.ibm.as400.access.JDError.throwSQLException(JDError.java:387)
	at com.ibm.as400.access.AS400JDBCResultSet.beforePositioning(AS400JDBCResultSet.java:1271)
	at com.ibm.as400.access.AS400JDBCResultSet.last(AS400JDBCResultSet.java:1682)
	at ResultSetTableModel.getRowCount(ResultSetTableModel.java:48)
	at javax.swing.JTable.getRowCount(Unknown Source)
	at javax.swing.plaf.basic.BasicTableUI.createTableSize(Unknown Source)
	at javax.swing.plaf.basic.BasicTableUI.getPreferredSize(Unknown Source)
	at javax.swing.JComponent.getPreferredSize(Unknown Source)
	at javax.swing.JViewport.getViewSize(Unknown Source)
	at javax.swing.plaf.basic.BasicScrollPaneUI.syncScrollPaneWithViewport(Unknown Source)
	at javax.swing.plaf.basic.BasicScrollPaneUI$Handler.viewportStateChanged(Unknown Source)
	at javax.swing.plaf.basic.BasicScrollPaneUI$Handler.stateChanged(Unknown Source)
	at javax.swing.JViewport.fireStateChanged(Unknown Source)
	at javax.swing.JViewport.reshape(Unknown Source)
	at java.awt.Component.setBounds(Unknown Source)
	at java.awt.Component.setBounds(Unknown Source)
	at javax.swing.ScrollPaneLayout.layoutContainer(Unknown Source)
	at java.awt.Container.layout(Unknown Source)
	at java.awt.Container.doLayout(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validate(Unknown Source)
	at java.awt.Window.show(Unknown Source)
	at java.awt.Component.show(Unknown Source)
	at java.awt.Component.setVisible(Unknown Source)
	at java.awt.Window.setVisible(Unknown Source)
	at as400.main(as400.java:34)
java.sql.SQLException: Cursor state not valid.
	at com.ibm.as400.access.JDError.throwSQLException(JDError.java:415)
	at com.ibm.as400.access.JDError.throwSQLException(JDError.java:387)
	at com.ibm.as400.access.AS400JDBCResultSet.beforePositioning(AS400JDBCResultSet.java:1271)
	at com.ibm.as400.access.AS400JDBCResultSet.last(AS400JDBCResultSet.java:1682)
	at ResultSetTableModel.getRowCount(ResultSetTableModel.java:48)
	at javax.swing.JTable.getRowCount(Unknown Source)
	at javax.swing.plaf.basic.BasicTableUI.createTableSize(Unknown Source)
	at javax.swing.plaf.basic.BasicTableUI.getPreferredSize(Unknown Source)
	at javax.swing.JComponent.getPreferredSize(Unknown Source)
	at javax.swing.ViewportLayout.layoutContainer(Unknown Source)
	at java.awt.Container.layout(Unknown Source)
	at java.awt.Container.doLayout(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validate(Unknown Source)
	at java.awt.Window.show(Unknown Source)
	at java.awt.Component.show(Unknown Source)
	at java.awt.Component.setVisible(Unknown Source)
	at java.awt.Window.setVisible(Unknown Source)
	at as400.main(as400.java:34)
java.sql.SQLException: Cursor state not valid.
	at com.ibm.as400.access.JDError.throwSQLException(JDError.java:415)
	at com.ibm.as400.access.JDError.throwSQLException(JDError.java:387)
	at com.ibm.as400.access.AS400JDBCResultSet.beforePositioning(AS400JDBCResultSet.java:1271)
	at com.ibm.as400.access.AS400JDBCResultSet.last(AS400JDBCResultSet.java:1682)
	at ResultSetTableModel.getRowCount(ResultSetTableModel.java:48)
	at javax.swing.JTable.getRowCount(Unknown Source)
	at javax.swing.plaf.basic.BasicTableUI.createTableSize(Unknown Source)
	at javax.swing.plaf.basic.BasicTableUI.getPreferredSize(Unknown Source)
	at javax.swing.JComponent.getPreferredSize(Unknown Source)
	at javax.swing.JTable.setWidthsFromPreferredWidths(Unknown Source)
	at javax.swing.JTable.doLayout(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validate(Unknown Source)
	at java.awt.Window.show(Unknown Source)
	at java.awt.Component.show(Unknown Source)
	at java.awt.Component.setVisible(Unknown Source)
	at java.awt.Window.setVisible(Unknown Source)
	at as400.main(as400.java:34)
java.sql.SQLException: Cursor state not valid.
	at com.ibm.as400.access.JDError.throwSQLException(JDError.java:415)
	at com.ibm.as400.access.JDError.throwSQLException(JDError.java:387)
	at com.ibm.as400.access.AS400JDBCResultSet.checkOpen(AS400JDBCResultSet.java:392)
	at com.ibm.as400.access.AS400JDBCResultSet.beforePositioning(AS400JDBCResultSet.java:1268)
	at com.ibm.as400.access.AS400JDBCResultSet.last(AS400JDBCResultSet.java:1682)
	at ResultSetTableModel.getRowCount(ResultSetTableModel.java:48)
	at javax.swing.JTable.getRowCount(Unknown Source)
	at javax.swing.plaf.basic.BasicTableUI.createTableSize(Unknown Source)
	at javax.swing.plaf.basic.BasicTableUI.getPreferredSize(Unknown Source)
	at javax.swing.JComponent.getPreferredSize(Unknown Source)
	at javax.swing.ScrollPaneLayout.layoutContainer(Unknown Source)
	at java.awt.Container.layout(Unknown Source)
	at java.awt.Container.doLayout(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validate(Unknown Source)
	at java.awt.Window.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
	at java.awt.EventQueue.access$000(Unknown Source)
	at java.awt.EventQueue$1.run(Unknown Source)
	at java.awt.EventQueue$1.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
	at java.awt.EventQueue$2.run(Unknown Source)
	at java.awt.EventQueue$2.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
	at java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(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)
java.sql.SQLException: Cursor state not valid.
	at com.ibm.as400.access.JDError.throwSQLException(JDError.java:415)
	at com.ibm.as400.access.JDError.throwSQLException(JDError.java:387)
	at com.ibm.as400.access.AS400JDBCResultSet.checkOpen(AS400JDBCResultSet.java:392)
	at com.ibm.as400.access.AS400JDBCResultSet.beforePositioning(AS400JDBCResultSet.java:1268)
	at com.ibm.as400.access.AS400JDBCResultSet.last(AS400JDBCResultSet.java:1682)
	at ResultSetTableModel.getRowCount(ResultSetTableModel.java:48)
	at javax.swing.JTable.getRowCount(Unknown Source)
	at javax.swing.plaf.basic.BasicTableUI.createTableSize(Unknown Source)
	at javax.swing.plaf.basic.BasicTableUI.getPreferredSize(Unknown Source)
	at javax.swing.JComponent.getPreferredSize(Unknown Source)
	at javax.swing.ViewportLayout.layoutContainer(Unknown Source)
	at java.awt.Container.layout(Unknown Source)
	at java.awt.Container.doLayout(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validate(Unknown Source)
	at java.awt.Window.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
	at java.awt.EventQueue.access$000(Unknown Source)
	at java.awt.EventQueue$1.run(Unknown Source)
	at java.awt.EventQueue$1.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
	at java.awt.EventQueue$2.run(Unknown Source)
	at java.awt.EventQueue$2.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
	at java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(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)
java.sql.SQLException: Cursor state not valid.
	at com.ibm.as400.access.JDError.throwSQLException(JDError.java:415)
	at com.ibm.as400.access.JDError.throwSQLException(JDError.java:387)
	at com.ibm.as400.access.AS400JDBCResultSet.checkOpen(AS400JDBCResultSet.java:392)
	at com.ibm.as400.access.AS400JDBCResultSet.beforePositioning(AS400JDBCResultSet.java:1268)
	at com.ibm.as400.access.AS400JDBCResultSet.last(AS400JDBCResultSet.java:1682)
	at ResultSetTableModel.getRowCount(ResultSetTableModel.java:48)
	at javax.swing.JTable.getRowCount(Unknown Source)
	at javax.swing.plaf.basic.BasicTableUI.createTableSize(Unknown Source)
	at javax.swing.plaf.basic.BasicTableUI.getPreferredSize(Unknown Source)
	at javax.swing.JComponent.getPreferredSize(Unknown Source)
	at javax.swing.JTable.setWidthsFromPreferredWidths(Unknown Source)
	at javax.swing.JTable.doLayout(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validateTree(Unknown Source)
	at java.awt.Container.validate(Unknown Source)
	at java.awt.Window.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
	at java.awt.EventQueue.access$000(Unknown Source)
	at java.awt.EventQueue$1.run(Unknown Source)
	at java.awt.EventQueue$1.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
	at java.awt.EventQueue$2.run(Unknown Source)
	at java.awt.EventQueue$2.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
	at java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(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)
java.sql.SQLException: Cursor state not valid.
	at com.ibm.as400.access.JDError.throwSQLException(JDError.java:415)
	at com.ibm.as400.access.JDError.throwSQLException(JDError.java:387)
	at com.ibm.as400.access.AS400JDBCResultSet.checkOpen(AS400JDBCResultSet.java:392)
	at com.ibm.as400.access.AS400JDBCResultSet.beforePositioning(AS400JDBCResultSet.java:1268)
	at com.ibm.as400.access.AS400JDBCResultSet.last(AS400JDBCResultSet.java:1682)
	at ResultSetTableModel.getRowCount(ResultSetTableModel.java:48)
	at javax.swing.JTable.getRowCount(Unknown Source)
	at javax.swing.plaf.basic.BasicTableUI.getAdjustedLead(Unknown Source)
	at javax.swing.plaf.basic.BasicTableUI.getAdjustedLead(Unknown Source)
	at javax.swing.plaf.basic.BasicTableUI.access$100(Unknown Source)
	at javax.swing.plaf.basic.BasicTableUI$Handler.repaintLeadCell(Unknown Source)
	at javax.swing.plaf.basic.BasicTableUI$Handler.focusGained(Unknown Source)
	at java.awt.Component.processFocusEvent(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.KeyboardFocusManager.redispatchEvent(Unknown Source)
	at java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(Unknown Source)
	at java.awt.DefaultKeyboardFocusManager.dispatchEvent(Unknown Source)
	at java.awt.Component.dispatchEventImpl(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.dispatchEventImpl(Unknown Source)
	at java.awt.EventQueue.access$000(Unknown Source)
	at java.awt.EventQueue$1.run(Unknown Source)
	at java.awt.EventQueue$1.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
	at java.awt.EventQueue$2.run(Unknown Source)
	at java.awt.EventQueue$2.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
	at java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.awt.SequencedEvent.dispatch(Unknown Source)
	at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
	at java.awt.EventQueue.access$000(Unknown Source)
	at java.awt.EventQueue$1.run(Unknown Source)
	at java.awt.EventQueue$1.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
	at java.awt.EventQueue$2.run(Unknown Source)
	at java.awt.EventQueue$2.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
	at java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(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)

Auriez vous une idée de l'erreur ?
D'avance merci .

**Dark_TeToN** · 29/09/2011, 23h36

Alors déjà vu l'erreur, ça vient de ta partie SQL, un problème de curseur ? (Je n'ai fait que lire...) Regarde du côté de tesscripts en PL/SQL (puisque si mes souvenirs sont exacts, c'est en PL/SQL que l'on manipule des curseurs

)

Sinon concernant ta JTable, c'est pas mal ce que tu as fait, j'ai déjà testé, le seul souci, lorsque j'ai fait ça c'est que les données ne se mettaient jamais à jour... De plus, je n'ai pas vu de CellRenderer, ça pourrait t'être utile ^^

Enfin résoud déjà le problème de SQL et après il est probable que ça fonctionne mais j'ai galéré pas mal sur les JTables je dois avouer !

**jacko842** · 03/10/2011, 09h06

Si je n'utilise pas de Jtable ma requête fonctionne très bien.
Donc je sais pas dans quelle sens chercher .

Merci de ton aide .

**Dark_TeToN** · 03/10/2011, 11h20

Peut-être que cela fonctionne sans la JTable mais cela viens à priori du ResultSet...

De toutes façons les Exceptions ne mentent pas !!!
Et ton exception stipule bien :

java.sql.SQLException: Cursor state not valid.
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:415)

Donc essaie voir de regarder de ce côté là il y a plein de posts sur le sujet sur internet comme tu peux le voir ICI

Sinon essaie d'effectuer le traitement du ResultSet dans ton main et de remettre tes résultats dans un objet et cet objet sera donné en argument à ton AbstractTableModel pour contruire ta JTable...

Mais il y a l'air d'avoir plein de questions sur ce sujet avec plein de réponses différentes...

**atha2** · 04/10/2011, 18h47

Si je me trompe pas quand tu essaye de lire les données, tu as fermé la connexion.
A partir du moment ou tu fait un setVisible(true), toutes les opérations d'affichage sont faite dans le thread graphique (ou un autre thread créé). Donc comme après le setVisible(true) tu fermes la connexion à la base de donnée au moment de l'affichage des données (ou d'un refresh de l'interface), ton cursor n'est plus valide.

Enfin ça doit être un truc dans le genre. Pour résoudre ton problème tu peux :

supprimer la fermeture de la connexion (pas top)
lire toutes tes données, les stockées dans un tableau et fermer ta connexion (ce qu'il faut faire)

Les Data ne s'affichent pas dans mon JTable

Composants Java

Discussions similaires

Partager

Partager