Secteurs -------------------------------------------------------
Secteur 0
![:P](https://www.developpez.net/forums/images/smilies/icon_razz.gif)
[0,S3,Secteur3,252,CINQ]
Secteur 1
![:P](https://www.developpez.net/forums/images/smilies/icon_razz.gif)
[0,S7,Secteur7,252,CINQ]
Secteur 2
![:P](https://www.developpez.net/forums/images/smilies/icon_razz.gif)
[0,S1,Secteur1,252,CINQ]
Secteur 3
![:P](https://www.developpez.net/forums/images/smilies/icon_razz.gif)
[0,S4,Secteur4,252,CINQ]
Secteur 4
![:P](https://www.developpez.net/forums/images/smilies/icon_razz.gif)
[0,S8,Secteur8,252,CINQ]
Secteur 5
![:P](https://www.developpez.net/forums/images/smilies/icon_razz.gif)
[0,S9,Secteur9,252,CINQ]
Secteur 6
![:P](https://www.developpez.net/forums/images/smilies/icon_razz.gif)
[0,S2,Secteur2,252,CINQ]
Secteur 7
![:P](https://www.developpez.net/forums/images/smilies/icon_razz.gif)
[0,S5,Secteur5,252,CINQ]
Secteur 8
![:P](https://www.developpez.net/forums/images/smilies/icon_razz.gif)
[0,S6,Secteur6,252,CINQ]
Secteur 9
![:P](https://www.developpez.net/forums/images/smilies/icon_razz.gif)
[0,S10,Secteur10,252,CINQ]
Secteur 10
![:P](https://www.developpez.net/forums/images/smilies/icon_razz.gif)
[0,S11,Secteur11,252,CINQ]
Adresse ---------------------------------------------------------
Famille ---------------------------------------------------------
Personne ---------------------------------------------------------
Exception in thread "AWT-EventQueue-0" org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [INSERT INTO STRUCTURE (CODE,VERSION,LIBELLE,TYPESTRUCTURE,COMMUNAUTE) VALUES(?)]; Parameter index out of range (2 > number of parameters, which is 1).; nested exception is java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1).
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:106)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:792)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:850)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:858)
at mis.cinq.dao.DaoSpringJdbc.saveStructure(DaoSpringJdbc.java:633)
at mis.cinq.service.ServiceSpringJdbc.saveStructures(ServiceSpringJdbc.java:503)
at mis.cinq.view.ViewChargement.TransfertFileDb(ViewChargement.java:367)
at mis.cinq.view.ViewChargement.TransfertButtonActionPerformed(ViewChargement.java:233)
at mis.cinq.view.ViewChargement.access$000(ViewChargement.java:32)
at mis.cinq.view.ViewChargement$1.actionPerformed(ViewChargement.java:80)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:5517)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3135)
at java.awt.Component.processEvent(Component.java:5282)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3984)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3819)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1791)
at java.awt.Component.dispatchEvent(Component.java:3819)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
Caused by: java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1).
at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:2493)
at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:2522)
at com.mysql.jdbc.PreparedStatement.setInt(PreparedStatement.java:2475)
at com.mysql.jdbc.PreparedStatement.setObject(PreparedStatement.java:2718)
at org.apache.commons.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:165)
at org.springframework.jdbc.core.StatementCreatorUtils.setValue(StatementCreatorUtils.java:346)
at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValueInternal(StatementCreatorUtils.java:217)
at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValue(StatementCreatorUtils.java:145)
at org.springframework.jdbc.core.ArgPreparedStatementSetter.setValues(ArgPreparedStatementSetter.java:51)
at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:796)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591)
... 33 more
Partager