La connexion fonctionne ainsi !!! Merci bcp !!!
Cependant... je ne sais pas si c'est dû à ce paramètre manquant mais voici d'autre erreurs relevées :
run:
jdbc:ucanaccess://xxx...mdb
WARNING:Error in the metadata of the table ChargeAffaire: table's row count in the metadata is 51 but 50 records have been found and loaded by UCanAccess. All will work fine, but it's better to repair your database.
WARNING:Error in the metadata of the table PlageHoraire: table's row count in the metadata is 0 but 5 records have been found and loaded by UCanAccess. All will work fine, but it's better to repair your database.
WARNING:Error in the metadata of the table Societe: table's row count in the metadata is 137 but 138 records have been found and loaded by UCanAccess. All will work fine, but it's better to repair your database.
Connexion établie avec succès
java.lang.UnsupportedOperationException: Cannot write indexes of this type due to unsupported collating sort order SortOrder[1036(0)] for text index (Db=xxx.mdb;Table=Annexe;Index=1)
at com.healthmarketscience.jackcess.impl.IndexData$ReadOnlyColumnDescriptor.writeNonNullValue(IndexData.java:1839)
at com.healthmarketscience.jackcess.impl.IndexData$ColumnDescriptor.writeValue(IndexData.java:1523)
at com.healthmarketscience.jackcess.impl.IndexData.createEntryBytes(IndexData.java:1244)
at com.healthmarketscience.jackcess.impl.IndexData.prepareAddRow(IndexData.java:581)
at com.healthmarketscience.jackcess.impl.IndexData.prepareAddRow(IndexData.java:559)
at com.healthmarketscience.jackcess.impl.TableImpl.addRows(TableImpl.java:1599)
at com.healthmarketscience.jackcess.impl.TableImpl.addRow(TableImpl.java:1462)
at net.ucanaccess.converters.UcanaccessTable.addRow(UcanaccessTable.java:44)
at net.ucanaccess.commands.InsertCommand.insertRow(InsertCommand.java:101)
at net.ucanaccess.commands.InsertCommand.persist(InsertCommand.java:148)
at net.ucanaccess.jdbc.UcanaccessConnection.flushIO(UcanaccessConnection.java:315)
at net.ucanaccess.jdbc.UcanaccessConnection.commit(UcanaccessConnection.java:205)
at net.ucanaccess.jdbc.AbstractExecute.executeBase(AbstractExecute.java:161)
at net.ucanaccess.jdbc.ExecuteUpdate.execute(ExecuteUpdate.java:50)
at net.ucanaccess.jdbc.UcanaccessStatement.executeUpdate(UcanaccessStatement.java:220)
at coactivite2.Annexe.recupererIdAnnexeCree(Annexe.java:203)
at coactivite2.Fenetre$EcouteurFenetre.windowOpened(Fenetre.java:7910)
at java.awt.Window.processWindowEvent(Window.java:1862)
at javax.swing.JFrame.processWindowEvent(JFrame.java:274)
at java.awt.Window.processEvent(Window.java:1823)
at java.awt.Component.dispatchEventImpl(Component.java:4651)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
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)
UCAExc:::3.0.6 Cannot write indexes of this type due to unsupported collating sort order SortOrder[1036(0)] for text index (Db=xxx.mdb;Table=Annexe;Index=1)
UCAExc:::3.0.6 connection exception: closed
UCAExc:::3.0.6 connection exception: closed
UCAExc:::3.0.6 connection exception: closed
UCAExc:::3.0.6 connection exception: closed
Annexe : Erreur lors de l'affichage du tableau Upload! UCAExc:::3.0.6 connection exception: closed
UCAExc:::3.0.6 connection exception: closed
UCAExc:::3.0.6 connection exception: closed
UCAExc:::3.0.6 connection exception: closed
UCAExc:::3.0.6 connection exception: closed
Quelle procédure utiliserais tu pour continuer ?
C'est possible que la base soit aussi mal faite à la base et qu'avec la nouvelle procédure, des erreurs font surfaces ?
Partager