<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Dear all,</div><div>I'm trying to load a simple postgres table by code, but I have one problem with a editing session.. (the table has a primary key)</div><div><br></div><div>this is the code:</div><div><br></div><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; color: rgb(73, 45, 246); "><span style="color: #000000">Connection conn2 = DriverManager.getConnection(</span>"jdbc:postgresql://localhost:5432/sidgrid"<span style="color: #000000">,</span>"postgres"<span style="color: #000000">,</span>"postgres"<span style="color: #000000">);</span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; ">String name = <span style="color: #492df6">"lpf"</span>;</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; color: rgb(71, 144, 117); "><span style="color: #000000">String driverInfo=</span><span style="color: #492df6">"postgresql"</span><span style="color: #000000">; </span></div><p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Monaco; min-height: 15.0px"><span class="Apple-tab-span" style="white-space:pre"> </span> <span class="Apple-tab-span" style="white-space:pre"> </span> <br class="webkit-block-placeholder"></p><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; ">LayerFactory.getDataSourceFactory ().addDBDataSourceBySQL(name, conn2, <span style="color: #492df6">"select * from lpf"</span>, driverInfo); </div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; ">DataSource dataSource = LayerFactory.getDataSourceFactory ().createRandomDataSource(name,DataSourceFactory.<span style="color: #2121c4">AUTOMATIC_OPENING</span>);</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; ">SelectableDataSource sds = <span style="color: #971365">new</span> SelectableDataSource(dataSource);</div><p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Monaco; min-height: 15.0px"><span class="Apple-tab-span" style="white-space:pre"> </span> <span class="Apple-tab-span" style="white-space:pre"> </span> <span class="Apple-tab-span" style="white-space:pre"> </span><br class="webkit-block-placeholder"></p><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; ">EditableAdapter edit = <span style="color: #971365">new</span> EditableAdapter();</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; ">edit(sds);</div><p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Monaco; min-height: 15.0px">ProjectTable projectTable = ProjectFactory.createTable(name,edit);</p><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; ">ProjectExtension ext = (ProjectExtension) PluginServices.getExtension(ProjectExtension.<span style="color: #971365">class</span> ); </div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; ">ext.getProject().addDocument(projectTable);</div></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; "><span class="Apple-style-span" style="font-family: Helvetica; font-size: medium; ">and this is the error log:</span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; "><span class="Apple-style-span" style="font-family: Helvetica; font-size: medium; "><br></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; "><span class="Apple-style-span" style="font-family: Helvetica; font-size: medium; "><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; "><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="font-size: medium;">Intento escribir el registro 0 de la capa </span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; "><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="font-size: medium;">null No Primary Keys</span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; "><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="font-size: medium;">DEBUG [AWT-EventQueue-1] (NotificationManager.java:104) - No se pudo guardar la edici?n</span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; "><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="font-size: medium;">java.lang.IllegalStateException: Can't overwrite cause</span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; "><span class="Apple-tab-span" style="white-space:pre"><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="font-size: medium;"> </span></font></span><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="font-size: medium;">at java.lang.Throwable.initCause(Throwable.java:320)</span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; "><span class="Apple-tab-span" style="white-space:pre"><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="font-size: medium;"> </span></font></span><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="font-size: medium;">at com.iver.cit.gvsig.exceptions.visitors.ProcessWriterVisitorException.<init>(ProcessWriterVisitorException.java:11)</span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; "><span class="Apple-tab-span" style="white-space:pre"><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="font-size: medium;"> </span></font></span><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="font-size: medium;">at com.iver.cit.gvsig.fmap.edition.writers.JdbcWriter.process(JdbcWriter.java:106)</span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; "><span class="Apple-tab-span" style="white-space:pre"><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="font-size: medium;"> </span></font></span><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="font-size: medium;">at com.iver.cit.gvsig.fmap.edition.EditableAdapter.saveEdits(EditableAdapter.java:365)</span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; "><span class="Apple-tab-span" style="white-space:pre"><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="font-size: medium;"> </span></font></span><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="font-size: medium;">at com.iver.cit.gvsig.fmap.edition.EditableAdapter.stopEdition(EditableAdapter.java:272)</span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; "><span class="Apple-tab-span" style="white-space:pre"><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="font-size: medium;"> </span></font></span><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="font-size: medium;">at com.iver.cit.gvsig.project.documents.table.gui.Table.stopEditing(Table.java:730)</span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; "><span class="Apple-tab-span" style="white-space:pre"><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="font-size: medium;"> </span></font></span><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="font-size: medium;">at com.iver.cit.gvsig.TableEditStopExtension.stopEditing(TableEditStopExtension.java:71)</span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Monaco; "><span class="Apple-tab-span" style="white-space:pre"><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="font-size: medium;"> </span></font></span><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="font-size: medium;">at com.iver.cit.gvsig.TableEditStopExtension.execute(TableEditStopExtension.java:49)</span></font></div><div>...</div></span></div><div><br></div><div>Some ideas about this problem?</div><div>thanks,</div><div>Claudio</div><div><br></div><div>-------------------------</div><div style="font-size: 12px; ">Claudio Schifani</div><div style="font-size: 12px; ">Phd in Pianificazione Urbana e Territoriale</div><div style="font-size: 12px; "><div><span class="Apple-style-span" style="font-size: medium; ">Istituto di Scienza e Tecnologie dell'Informazione "A. Faedo" (ISTI-CNR)<br>Area della Ricerca CNR di Pisa </span></div></div>
<br></body></html>