| Re: [udig-users] Connection is closed on line editing and committing |
> Just to verify whats going on:
> * Do you have null geometries in the database?
No, there are no null geometries in the referenced tables.
> * Or even Geometries without an valid SRID?
The geometries in our database have an own SRID, which we defined ourselves. Since this was very close to 31468, we chose that one as the CRS in uDig 1.3.2 layers and maps and everything worked out just fine. If the problem with uDig 1.4.0 is now, that it tries to find our own SRID, is there a way to add our own SRID to uDig?
>
> - Frank
>
> 2013/8/19 Peilke, Hendrik <hendrik.peilke@xxxxxxxxx>
>>> I discovered a problem in uDig 1.3.2: It occurs when drawing lines using the standard line drawing tool and committing as soon as drawing is finished (by hitting the commit button immediately after [enter] or double clicking). If the described procedure is done multiple times, I get a connection is closed exception before the fifth iteration. Something (renderer) called a connection.close() (on the dbcp connection wrapper) on the EditManager-transaction-connection. After the connection was closed, no more lines can be drawn.
>>
>> I seem to recall running into this and fixing it last year.
>>
>>> I am using an Oracle database connection (on a win32 system), although I don?t think, after debugging, that it has anything to do with it.
>>> I cannot confirm if this error still exists in uDig 1.4.0, because I after adding an oracle spatial geometry layer, the renderer.draw() just gives me a lot of null pointer exceptions.
>>
>> Would be interested to know the stack trace of that, I cannot remember the differences between 1.3.2 and 1.4.0.
>>
> The stack trace is:
>
> !ENTRY net.refractions.udig.project 2 0 2013-08-14 08:31:51.026
> !MESSAGE class java.lang.NullPointerException occured during rendering: null
> !STACK 0
> net.refractions.udig.project.render.RenderException: class java.lang.NullPointerException occured during rendering: null
> at net.refractions.udig.render.internal.feature.basic.BasicFeatureRenderer.render(BasicFeatureRenderer.java:484)
> at net.refractions.udig.render.internal.feature.basic.BasicFeatureRenderer.render(BasicFeatureRenderer.java:315)
> at net.refractions.udig.project.internal.render.impl.RenderJob.startRendering(RenderJob.java:117)
> at net.refractions.udig.project.internal.render.impl.RenderJob.run(RenderJob.java:222)
> at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
> Caused by: java.lang.NullPointerException
> at net.refractions.udig.render.internal.feature.basic.BasicFeatureRenderer.prepareDraw(BasicFeatureRenderer.java:203)
> at net.refractions.udig.render.internal.feature.basic.BasicFeatureRenderer.render(BasicFeatureRenderer.java:352)
> ... 4 more
>
> It would be great, if you could help on this error.
>
>>> Main cause of the use of uDig, mentioned above, is to have every change safely committed to the database (not relying on the reliability of the program). Is there any other method (like turning auto commit on for the edit connection)? Can the connection somehow be recovered in that scenario, like by reinitializing the transaction? Has somebody an idea, how the problem can be fixed?
>>
>> I had not considered making an "auto commit" mode, mostly as with shape files that involves writing out the entire shapefile each time.
>>
>> However one thing you can do is go to the catalog, right click, and "reset" the database. This will recreate it with a new connection pool.
>>
> Thanks. That worked.
IBYKUS AG für Informationstechnologie, Erfurt / HRB 108616 - D-Jena / Vorstand: Helmut C. Henkel, Dr. Lutz Richter
Vorsitzender des Aufsichtsrates: Dr. Wolfgang Habel