[udig-devel] Create Polygon Geometries

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]

[udig-devel] Create Polygon Geometries

From: Kurucz Péter <kaiserkoenig@xxxxxxxxxxx>
Date: Tue, 30 Oct 2007 18:04:09 +0100 (CET)
Delivered-to: udig-devel@xxxxxxxxxxxxxxxxxxxxxxxxx
List-archive: <http://lists.refractions.net/pipermail/udig-devel>
List-help: <mailto:udig-devel-request@lists.refractions.net?subject=help>
List-subscribe: <http://lists.refractions.net/mailman/listinfo/udig-devel>, <mailto:udig-devel-request@lists.refractions.net?subject=subscribe>
List-unsubscribe: <http://lists.refractions.net/mailman/listinfo/udig-devel>, <mailto:udig-devel-request@lists.refractions.net?subject=unsubscribe>

Hi,

I try to use thy uDig (version 1.1-RC12) and I got a problem. It is not possible to create a new polygon. The drawing is working but the new polygon will not be saved in the postGIS database. I have downloaded the eclipse environment and debugged a bit the tool. My feeling is that the problem isn't located in uDig application but in a bottom layer in postGIS or pastrgres. I suppose that a database transaction will not be closed correctly or not at all, and the tool want to make a new one, and this occur a database exception. The whole transaction will be rollbacked and my new polygon will miss from GUI.

The strange thing is that Create Polygon must be a basic feature but it doesn't work for me. Have anybody idea what can be bad? Is my feeling is right about database transaction error?

Thanks in advance!

The exception is following:

2007.10.30. 17:54:15 org.geotools.data.jdbc.JDBCTextFeatureWriter doInsert

SEVERE: SQL Exception writing geometry columnERROR: null value in column "customer_id" violates not-null constraint

org.postgresql.util.PSQLException: ERROR: null value in column "customer_id" violates not-null constraint

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)

at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:286)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.postgresql.ds.common.PooledConnectionImpl$StatementHandler.invoke(PooledConnectionImpl.java:474)

at $Proxy1.executeUpdate(Unknown Source)

at org.geotools.data.jdbc.JDBCTextFeatureWriter.doInsert(JDBCTextFeatureWriter.java:110)

at org.geotools.data.jdbc.JDBCFeatureWriter.write(JDBCFeatureWriter.java:220)

at org.geotools.data.InProcessLockingManager$1.write(InProcessLockingManager.java:331)

at org.geotools.data.jdbc.JDBCFeatureStore.addFeatures(JDBCFeatureStore.java:400)

at net.refractions.udig.project.internal.impl.UDIGFeatureStore.addFeatures(UDIGFeatureStore.java:163)

at net.refractions.udig.project.internal.commands.edit.AddFeatureCommand.run(AddFeatureCommand.java:120)

at net.refractions.udig.tools.edit.commands.CreateAndSetNewFeature.run(CreateAndSetNewFeature.java:67)

at net.refractions.udig.project.command.UndoableComposite.execute(UndoableComposite.java:81)

at net.refractions.udig.tools.edit.BehaviourCommand.execute(BehaviourCommand.java:65)

at net.refractions.udig.project.command.UndoableComposite.execute(UndoableComposite.java:78)

at net.refractions.udig.tools.edit.behaviour.AcceptWhenOverFirstVertexBehaviour.getCommand(AcceptWhenOverFirstVertexBehaviour.java:87)

at net.refractions.udig.tools.edit.OrderedCompositeEventBehavior.getCommand(OrderedCompositeEventBehavior.java:59)

at net.refractions.udig.tools.edit.MutualExclusiveEventBehavior.getCommand(MutualExclusiveEventBehavior.java:57)

at net.refractions.udig.tools.edit.EditToolHandler.runEventBehaviours(EditToolHandler.java:269)

at net.refractions.udig.tools.edit.EditToolHandler.handleEvent(EditToolHandler.java:229)

at net.refractions.udig.tools.edit.AbstractEditTool.onMouseReleased(AbstractEditTool.java:250)

at net.refractions.udig.project.ui.tool.SimpleTool.mouseReleased(SimpleTool.java:153)

at net.refractions.udig.project.ui.internal.render.displayAdapter.impl.EventJob.sendMouseReleased(EventJob.java:296)

at net.refractions.udig.project.ui.internal.render.displayAdapter.impl.EventJob.runEvent(EventJob.java:87)

at net.refractions.udig.project.ui.internal.render.displayAdapter.impl.EventJob.access$2(EventJob.java:72)

at net.refractions.udig.project.ui.internal.render.displayAdapter.impl.EventJob$1.run(EventJob.java:135)

at org.eclipse.swt.widgets.Display.runTimer(Display.java:3745)

at org.eclipse.swt.widgets.Display.messageProc(Display.java:2967)

at org.eclipse.swt.internal.win32.OS.DispatchMessageW(Native Method)

at org.eclipse.swt.internal.win32.OS.DispatchMessage(OS.java:2265)

at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3291)

at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2389)

at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2353)

at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2219)

at org.eclipse.ui.internal.Workbench$4.run(Workbench.java:466)

at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:289)

at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:461)

at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)

at net.refractions.udig.internal.ui.UDIGApplication.run(UDIGApplication.java:41)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.eclipse.equinox.internal.app.EclipseAppContainer.callMethod(EclipseAppContainer.java:572)

at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:171)

at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:106)

at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:76)

at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:363)

at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:176)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:508)

at org.eclipse.equinox.launcher.Main.basicRun(Main.java:447)

at org.eclipse.equinox.launcher.Main.run(Main.java:1173)

at org.eclipse.equinox.launcher.Main.main(Main.java:1148)

2007.10.30. 17:54:15 org.geotools.data.jdbc.JDBCFeatureWriter close

WARNING: Feature writer calling close when queryData is already closed

Follow-Ups:
- Re: [udig-devel] Create Polygon Geometries
  - From: Jesse Eichar

Prev by Date: [udig-devel] Shapefiles with duplicate columns names ... now possible ; -)
Next by Date: Re: [udig-devel] Create Polygon Geometries
Previous by thread: [udig-devel] Shapefiles with duplicate columns names ... now possible ; -)
Next by thread: Re: [udig-devel] Create Polygon Geometries
Index(es):
- Date
- Thread

Breadcrumbs