SQLite only supports TYPE_FORWARD_ONLY cursors

**lemzo84** · 07/11/2012, 13h57

Bonjour, je suis en train de développez une petite application utilisant Java et Sqlite. Lorsque j'insère des données dans la base, ça se passe sans souci, mais lorsque j'interroge la base, j'ai toujours l'erreur "SQLite only supports TYPE_FORWARD_ONLY cursors". Cela fait 2 jours que je cherche sur le net mais je n'arrive pas à résoudre le problème. Merci de votre aide.

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
 
try{
		        	Class.forName("org.sqlite.JDBC");
		            conn = DriverManager.getConnection("jdbc:sqlite:CONTACT.db","sa","sa");
		            System.out.println ("Database connection established");
String sql = "SELECT * FROM CONTACT";
				     java.sql.Statement statement = conn.createStatement(ResultSet.CONCUR_READ_ONLY, ResultSet.CLOSE_CURSORS_AT_COMMIT);
ResultSet a = statement.executeQuery(sql);
TableModel rtm = new ResultSetTableModel(a);
 
			        TablePanel tablePanel = new TablePanel(rtm);
			        mainFrame.getContentPane().add( tablePanel, BorderLayout.CENTER );
			        mainFrame.setSize( 640, 480 );
			        mainFrame.setVisible( true );
 
			     }

**tchize_** · 07/11/2012, 14h10

A quel niveau tu as l'exception (stacktrace complete svp)?

Ce messsage t'indique qu'avec SQLite, on ne peux parcourir un resultset qu'en allant vers l'avant, il n'est pas bi-directionnel. Et quelque part tu essaie probablement d'aller en arrière. Et d'ou sort ce ResultSetTableModel

**lemzo84** · 07/11/2012, 14h24

Le ResultSetTableModel me permet de visualiser les résultats de la requête dans une nouvelle table. J'ai crée 2 classes ResultSetTableModel.java et TablePanel.java pour cela. ça marche lorsque j'utilise une connexion web via PhpMyAdmin. Voici l'erreur que j'ai en exécutant la requête:

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
 
Database connection established
java.sql.SQLException: SQLite only supports TYPE_FORWARD_ONLY cursors
	at org.sqlite.Conn.checkCursor(Conn.java:232)
	at org.sqlite.Conn.createStatement(Conn.java:365)
	at org.sqlite.Conn.createStatement(Conn.java:361)
	at javagui.views.List_contacts$1.actionPerformed(List_contacts.java:130)
	at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
	at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
	at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
	at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
	at java.awt.Component.processMouseEvent(Component.java:6288)
	at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
	at java.awt.Component.processEvent(Component.java:6053)
	at java.awt.Container.processEvent(Container.java:2041)
	at java.awt.Component.dispatchEventImpl(Component.java:4651)
	at java.awt.Container.dispatchEventImpl(Container.java:2099)
	at java.awt.Component.dispatchEvent(Component.java:4481)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
	at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
	at java.awt.Container.dispatchEventImpl(Container.java:2085)
	at java.awt.Window.dispatchEventImpl(Window.java:2478)
	at java.awt.Component.dispatchEvent(Component.java:4481)
	at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:643)
	at java.awt.EventQueue.access$000(EventQueue.java:84)
	at java.awt.EventQueue$1.run(EventQueue.java:602)
	at java.awt.EventQueue$1.run(EventQueue.java:600)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
	at java.awt.EventQueue$2.run(EventQueue.java:616)
	at java.awt.EventQueue$2.run(EventQueue.java:614)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:613)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
Database connection terminated
	at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)

**tchize_** · 07/11/2012, 14h51

Tu ne passe pas les bons paramètres à ta méthode createStatement

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

java.sql.Statement statement = conn.createStatement(ResultSet.CONCUR_READ_ONLY, ResultSet.CLOSE_CURSORS_AT_COMMIT);

D'après la javadoc, le seuls options autorisée pour le premier paramètre sont
ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
Et pour le deuxième
ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE

Donc ton appel devrait être

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
 
conn.setHoldability(ResultSet.CLOSE_CURSORS_AT_COMMIT);
java.sql.Statement statement = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);

**lemzo84** · 07/11/2012, 14h55

Effectivement, j'avais modifié lors de précédents essais mais ça ne passait pas. Voici l'erreur que j'obtenais:

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
295
296
297
298
299
300
301
302
Database connection established
java.sql.SQLException: ResultSet is TYPE_FORWARD_ONLY
	at org.sqlite.Unused.last(Unused.java:128)
	at javagui.views.ResultSetTableModel.getRowCount(ResultSetTableModel.java:56)
	at javax.swing.JTable.getRowCount(JTable.java:2631)
	at javax.swing.plaf.basic.BasicTableUI.createTableSize(BasicTableUI.java:1646)
	at javax.swing.plaf.basic.BasicTableUI.getPreferredSize(BasicTableUI.java:1687)
	at javax.swing.JComponent.getPreferredSize(JComponent.java:1634)
	at javax.swing.ScrollPaneLayout.layoutContainer(ScrollPaneLayout.java:769)
	at java.awt.Container.layout(Container.java:1421)
	at java.awt.Container.doLayout(Container.java:1410)
	at java.awt.Container.validateTree(Container.java:1507)
	at java.awt.Container.validateTree(Container.java:1513)
	at java.awt.Container.validateTree(Container.java:1513)
	at java.awt.Container.validateTree(Container.java:1513)
	at java.awt.Container.validateTree(Container.java:1513)
	at java.awt.Container.validateTree(Container.java:1513)
	at java.awt.Container.validate(Container.java:1480)
	at javax.swing.JInternalFrame.reshape(JInternalFrame.java:1473)
	at java.awt.Component.setBounds(Component.java:2133)
	at java.awt.Component.resize(Component.java:2067)
	at java.awt.Component.setSize(Component.java:2056)
	at javagui.views.List_contacts$1.actionPerformed(List_contacts.java:165)
	at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
	at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
	at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
	at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
	at java.awt.Component.processMouseEvent(Component.java:6288)
	at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
	at java.awt.Component.processEvent(Component.java:6053)
	at java.awt.Container.processEvent(Container.java:2041)
	at java.awt.Component.dispatchEventImpl(Component.java:4651)
	at java.awt.Container.dispatchEventImpl(Container.java:2099)
	at java.awt.Component.dispatchEvent(Component.java:4481)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
	at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
	at java.awt.Container.dispatchEventImpl(Container.java:2085)
	at java.awt.Window.dispatchEventImpl(Window.java:2478)
	at java.awt.Component.dispatchEvent(Component.java:4481)
	at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:643)
	at java.awt.EventQueue.access$000(EventQueue.java:84)
	at java.awt.EventQueue$1.run(EventQueue.java:602)
	at java.awt.EventQueue$1.run(EventQueue.java:600)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
	at java.awt.EventQueue$2.run(EventQueue.java:616)
	at java.awt.EventQueue$2.run(EventQueue.java:614)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:613)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
	at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
java.sql.SQLException: ResultSet is TYPE_FORWARD_ONLY
	at org.sqlite.Unused.last(Unused.java:128)
	at javagui.views.ResultSetTableModel.getRowCount(ResultSetTableModel.java:56)
	at javax.swing.JTable.getRowCount(JTable.java:2631)
	at javax.swing.plaf.basic.BasicTableUI.createTableSize(BasicTableUI.java:1646)
	at javax.swing.plaf.basic.BasicTableUI.getPreferredSize(BasicTableUI.java:1687)
	at javax.swing.JComponent.getPreferredSize(JComponent.java:1634)
	at javax.swing.JViewport.getViewSize(JViewport.java:1018)
	at javax.swing.plaf.basic.BasicScrollPaneUI.syncScrollPaneWithViewport(BasicScrollPaneUI.java:265)
	at javax.swing.plaf.basic.BasicScrollPaneUI$Handler.viewportStateChanged(BasicScrollPaneUI.java:1066)
	at javax.swing.plaf.basic.BasicScrollPaneUI$Handler.stateChanged(BasicScrollPaneUI.java:1008)
	at javax.swing.JViewport.fireStateChanged(JViewport.java:1384)
	at javax.swing.JViewport.reshape(JViewport.java:856)
	at java.awt.Component.setBounds(Component.java:2133)
	at java.awt.Component.setBounds(Component.java:2271)
	at javax.swing.ScrollPaneLayout.layoutContainer(ScrollPaneLayout.java:869)
	at java.awt.Container.layout(Container.java:1421)
	at java.awt.Container.doLayout(Container.java:1410)
	at java.awt.Container.validateTree(Container.java:1507)
	at java.awt.Container.validateTree(Container.java:1513)
	at java.awt.Container.validateTree(Container.java:1513)
	at java.awt.Container.validateTree(Container.java:1513)
	at java.awt.Container.validateTree(Container.java:1513)
	at java.awt.Container.validateTree(Container.java:1513)
	at java.awt.Container.validate(Container.java:1480)
	at javax.swing.JInternalFrame.reshape(JInternalFrame.java:1473)
	at java.awt.Component.setBounds(Component.java:2133)
	at java.awt.Component.resize(Component.java:2067)
	at java.awt.Component.setSize(Component.java:2056)
	at javagui.views.List_contacts$1.actionPerformed(List_contacts.java:165)
	at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
	at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
	at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
	at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
	at java.awt.Component.processMouseEvent(Component.java:6288)
	at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
	at java.awt.Component.processEvent(Component.java:6053)
	at java.awt.Container.processEvent(Container.java:2041)
	at java.awt.Component.dispatchEventImpl(Component.java:4651)
	at java.awt.Container.dispatchEventImpl(Container.java:2099)
	at java.awt.Component.dispatchEvent(Component.java:4481)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
	at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
	at java.awt.Container.dispatchEventImpl(Container.java:2085)
	at java.awt.Window.dispatchEventImpl(Window.java:2478)
	at java.awt.Component.dispatchEvent(Component.java:4481)
	at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:643)
	at java.awt.EventQueue.access$000(EventQueue.java:84)
	at java.awt.EventQueue$1.run(EventQueue.java:602)
	at java.awt.EventQueue$1.run(EventQueue.java:600)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
	at java.awt.EventQueue$2.run(EventQueue.java:616)
	at java.awt.EventQueue$2.run(EventQueue.java:614)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:613)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
	at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
java.sql.SQLException: ResultSet is TYPE_FORWARD_ONLY
	at org.sqlite.Unused.last(Unused.java:128)
	at javagui.views.ResultSetTableModel.getRowCount(ResultSetTableModel.java:56)
	at javax.swing.JTable.getRowCount(JTable.java:2631)
	at javax.swing.plaf.basic.BasicTableUI.createTableSize(BasicTableUI.java:1646)
	at javax.swing.plaf.basic.BasicTableUI.getPreferredSize(BasicTableUI.java:1687)
	at javax.swing.JComponent.getPreferredSize(JComponent.java:1634)
	at javax.swing.ViewportLayout.layoutContainer(ViewportLayout.java:123)
	at java.awt.Container.layout(Container.java:1421)
	at java.awt.Container.doLayout(Container.java:1410)
	at java.awt.Container.validateTree(Container.java:1507)
	at java.awt.Container.validateTree(Container.java:1513)
	at java.awt.Container.validateTree(Container.java:1513)
	at java.awt.Container.validateTree(Container.java:1513)
	at java.awt.Container.validateTree(Container.java:1513)
	at java.awt.Container.validateTree(Container.java:1513)
	at java.awt.Container.validateTree(Container.java:1513)
	at java.awt.Container.validate(Container.java:1480)
	at javax.swing.JInternalFrame.reshape(JInternalFrame.java:1473)
	at java.awt.Component.setBounds(Component.java:2133)
	at java.awt.Component.resize(Component.java:2067)
	at java.awt.Component.setSize(Component.java:2056)
	at javagui.views.List_contacts$1.actionPerformed(List_contacts.java:165)
	at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
	at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
	at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
	at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
	at java.awt.Component.processMouseEvent(Component.java:6288)
	at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
	at java.awt.Component.processEvent(Component.java:6053)
	at java.awt.Container.processEvent(Container.java:2041)
	at java.awt.Component.dispatchEventImpl(Component.java:4651)
	at java.awt.Container.dispatchEventImpl(Container.java:2099)
	at java.awt.Component.dispatchEvent(Component.java:4481)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
	at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
	at java.awt.Container.dispatchEventImpl(Container.java:2085)
	at java.awt.Window.dispatchEventImpl(Window.java:2478)
	at java.awt.Component.dispatchEvent(Component.java:4481)
	at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:643)
	at java.awt.EventQueue.access$000(EventQueue.java:84)
	at java.awt.EventQueue$1.run(EventQueue.java:602)
	at java.awt.EventQueue$1.run(EventQueue.java:600)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
	at java.awt.EventQueue$2.run(EventQueue.java:616)
	at java.awt.EventQueue$2.run(EventQueue.java:614)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:613)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
	at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
java.sql.SQLException: ResultSet is TYPE_FORWARD_ONLY
	at org.sqlite.Unused.last(Unused.java:128)
	at javagui.views.ResultSetTableModel.getRowCount(ResultSetTableModel.java:56)
	at javax.swing.JTable.getRowCount(JTable.java:2631)
	at javax.swing.plaf.basic.BasicTableUI.createTableSize(BasicTableUI.java:1646)
	at javax.swing.plaf.basic.BasicTableUI.getPreferredSize(BasicTableUI.java:1687)
	at javax.swing.JComponent.getPreferredSize(JComponent.java:1634)
	at javax.swing.JTable.setWidthsFromPreferredWidths(JTable.java:3183)
	at javax.swing.JTable.doLayout(JTable.java:3097)
	at java.awt.Container.validateTree(Container.java:1507)
	at java.awt.Container.validateTree(Container.java:1513)
	at java.awt.Container.validateTree(Container.java:1513)
	at java.awt.Container.validateTree(Container.java:1513)
	at java.awt.Container.validateTree(Container.java:1513)
	at java.awt.Container.validateTree(Container.java:1513)
	at java.awt.Container.validateTree(Container.java:1513)
	at java.awt.Container.validateTree(Container.java:1513)
	at java.awt.Container.validate(Container.java:1480)
	at javax.swing.JInternalFrame.reshape(JInternalFrame.java:1473)
	at java.awt.Component.setBounds(Component.java:2133)
	at java.awt.Component.resize(Component.java:2067)
	at java.awt.Component.setSize(Component.java:2056)
	at javagui.views.List_contacts$1.actionPerformed(List_contacts.java:165)
	at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
	at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
	at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
	at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
	at java.awt.Component.processMouseEvent(Component.java:6288)
	at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
	at java.awt.Component.processEvent(Component.java:6053)
	at java.awt.Container.processEvent(Container.java:2041)
	at java.awt.Component.dispatchEventImpl(Component.java:4651)
	at java.awt.Container.dispatchEventImpl(Container.java:2099)
	at java.awt.Component.dispatchEvent(Component.java:4481)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
	at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
	at java.awt.Container.dispatchEventImpl(Container.java:2085)
	at java.awt.Window.dispatchEventImpl(Window.java:2478)
	at java.awt.Component.dispatchEvent(Component.java:4481)
	at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:643)
	at java.awt.EventQueue.access$000(EventQueue.java:84)
	at java.awt.EventQueue$1.run(EventQueue.java:602)
	at java.awt.EventQueue$1.run(EventQueue.java:600)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
	at java.awt.EventQueue$2.run(EventQueue.java:616)
	at java.awt.EventQueue$2.run(EventQueue.java:614)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:613)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
	at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
Database connection terminated
java.sql.SQLException: ResultSet is TYPE_FORWARD_ONLY
	at org.sqlite.Unused.last(Unused.java:128)
	at javagui.views.ResultSetTableModel.getRowCount(ResultSetTableModel.java:56)
	at javax.swing.JTable.getRowCount(JTable.java:2631)
	at javax.swing.plaf.basic.BasicTableUI.createTableSize(BasicTableUI.java:1646)
	at javax.swing.plaf.basic.BasicTableUI.getPreferredSize(BasicTableUI.java:1687)
	at javax.swing.JComponent.getPreferredSize(JComponent.java:1634)
	at javax.swing.ScrollPaneLayout.layoutContainer(ScrollPaneLayout.java:769)
	at java.awt.Container.layout(Container.java:1421)
	at java.awt.Container.doLayout(Container.java:1410)
	at java.awt.Container.validateTree(Container.java:1507)
	at java.awt.Container.validate(Container.java:1480)
	at javax.swing.RepaintManager.validateInvalidComponents(RepaintManager.java:669)
	at javax.swing.SystemEventQueueUtilities$ComponentWorkRequest.run(SystemEventQueueUtilities.java:124)
	at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
	at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:641)
	at java.awt.EventQueue.access$000(EventQueue.java:84)
	at java.awt.EventQueue$1.run(EventQueue.java:602)
	at java.awt.EventQueue$1.run(EventQueue.java:600)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:611)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
	at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
java.sql.SQLException: ResultSet is TYPE_FORWARD_ONLY
	at org.sqlite.Unused.last(Unused.java:128)
	at javagui.views.ResultSetTableModel.getRowCount(ResultSetTableModel.java:56)
	at javax.swing.JTable.getRowCount(JTable.java:2631)
	at javax.swing.plaf.basic.BasicTableUI.createTableSize(BasicTableUI.java:1646)
	at javax.swing.plaf.basic.BasicTableUI.getPreferredSize(BasicTableUI.java:1687)
	at javax.swing.JComponent.getPreferredSize(JComponent.java:1634)
	at javax.swing.ViewportLayout.layoutContainer(ViewportLayout.java:123)
	at java.awt.Container.layout(Container.java:1421)
	at java.awt.Container.doLayout(Container.java:1410)
	at java.awt.Container.validateTree(Container.java:1507)
	at java.awt.Container.validateTree(Container.java:1513)
	at java.awt.Container.validate(Container.java:1480)
	at javax.swing.RepaintManager.validateInvalidComponents(RepaintManager.java:669)
	at javax.swing.SystemEventQueueUtilities$ComponentWorkRequest.run(SystemEventQueueUtilities.java:124)
	at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
	at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:641)
	at java.awt.EventQueue.access$000(EventQueue.java:84)
	at java.awt.EventQueue$1.run(EventQueue.java:602)
	at java.awt.EventQueue$1.run(EventQueue.java:600)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:611)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
	at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)

**tchize_** · 07/11/2012, 14h58

Tes resultset sont forward only, tu ne peux pas utiliser une méthode comme last() dessus. Il faut tout lire au fur et à mesure.

**lemzo84** · 07/11/2012, 15h13

Rassure-toi, j'ai bien lu mais je ne vois pas

**lemzo84** · 07/11/2012, 15h15

Je vais essayer de créer un nouvelle classe qui va uniquement exécuter la requête et m'afficher les résultats dans la console d'éclipse.

**tchize_** · 07/11/2012, 15h17

Envoyé par lemzo84

Rassure-toi, j'ai bien lu mais je ne vois pas

Bien, c'est simple, avec SQLLite tu n'a pas accès à la méthode last() sur ton resultset, tu ne peux pas l'utiliser, comme toute méthode nécessitant de "sauter" d'un endroit à un autre dans ton resultset. Tu va devoir coder sans les utiliser, donc modifier ton ResultSetTableModel.

**lemzo84** · 07/11/2012, 15h33

Message reçu. Je vais voir cela et je met le code pour que, if possible, tu puisse me conseiller sur les modifs à faire.

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
 
package javagui.views;
 
import java.sql.ResultSet;
 
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
 
import javax.swing.table.AbstractTableModel;
 
/*import java.util.*;
import javax.swing.table.*;
 
import java.util.*;
import javax.swing.table.*;*/
 
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()
  {
	try 
    {
      return resultSetMetaData.getColumnCount();
    } 
    catch (SQLException e) 
    {
      // TODO Auto-generated catch block
      e.printStackTrace();
      return 0;
    }
  }
 
  @Override
  public int getRowCount()
  {
	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 )
  {
    try 
    {
      return resultSetMetaData.getColumnName( column + 1 );
    } 
    catch (SQLException e) 
    {
      // TODO Auto-generated catch block
      e.printStackTrace();
      return "";
    }
  }
 
  private ResultSet resultSet;
  private ResultSetMetaData resultSetMetaData;
 
}

**tchize_** · 07/11/2012, 15h41

tout est à revoir, ce code est prévu pour un resultset navigable. Tu va devoir tout lire une seule fois en mémoire et utiliser ce que tu garde en mémoire pour former ta table.

**lemzo84** · 07/11/2012, 15h49

Je viens d'utiliser le code suivant et ça marche. Je te remercie vivement pour ton aide. Excellente journée à toi.

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
 
package sqlitejviewer;
 
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import javax.swing.table.AbstractTableModel;
 
public class ResultSetTableModel extends AbstractTableModel {
    private String[] columnNames;
    private Class[] columnClasses;
    private List<List<Object>> cells = new ArrayList<List<Object>>();
 
    public ResultSetTableModel() {
        columnNames = new String[1];
        columnNames[0] = "Result Set";
 
        List<Object> row = new ArrayList<Object>();
        row.add("No data");
        cells.add(row);
    }
 
    public ResultSetTableModel(ResultSet rs) throws SQLException {
        ResultSetMetaData rsmd = rs.getMetaData();
 
        // SOMETHING TO KEEP AN EYE ON! It looks like the ResultSetMetaData
        // object screws up once the ResultSet itself has been read (ie by
        // rs.next() ). Putting any rsmd.XXXX commands after the "while" loop at
        // the bottom throws a nasty exception. A bug on the SQLite side I think.
 
        columnNames = new String[rsmd.getColumnCount()];
        for (int i = 1; i <= rsmd.getColumnCount(); i++) {
            columnNames[i-1] = rsmd.getColumnName(i);
        }
 
        columnClasses = new Class[rsmd.getColumnCount()];
        for (int i = 1; i <= rsmd.getColumnCount(); i++) {
            int columnType = rsmd.getColumnType(i);
 
            switch (columnType) {
                case java.sql.Types.INTEGER:
                case java.sql.Types.NUMERIC:
                    columnClasses[i-1] = Integer.class;
                    break;
                case java.sql.Types.VARCHAR:
                case java.sql.Types.CHAR:
                    columnClasses[i-1] = String.class;
                    break;
                case java.sql.Types.DECIMAL:
                case java.sql.Types.FLOAT:
                    columnClasses[i-1] = Float.class;
                default:
                    columnClasses[i-1] = Object.class;
                    break;
            }
        }
 
        while (rs.next()) {
            List<Object> row = new ArrayList<Object>();
            for (int i = 1; i <= rsmd.getColumnCount(); i++) {
                row.add(rs.getString(i));
            }
            cells.add(row);
        }
    }
 
    public int getRowCount() {
        return cells.size();
    }
 
    public int getColumnCount() {
        return columnNames.length;
    }
 
    @Override
    public Class getColumnClass(int columnIndex) {
        return columnClasses[columnIndex];
    }
 
    public Object getValueAt(int rowIndex, int columnIndex) {
        return cells.get(rowIndex).get(columnIndex);
    }
 
    @Override
    public String getColumnName(int columnIndex) {
        return columnNames[columnIndex];
    }
 
}

SQLite only supports TYPE_FORWARD_ONLY cursors

JDBC Java

Discussions similaires

Partager

Partager