[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
|
Re: [udig-users] uDig and Oracle
|
Hi Jody,
Thanks for your answers
I tried to connect to oracle in the uDig 1.2-M9 version using C:\temp\udig-1.2-M9.win32.win32.x86\udig\udig.bat
After a long time in the catalog an entry Oracle Spatial appears. When I open it i see the tables. When I right click on a table and "add to new map" , an error message appears (see below).
My "normal" uDig (1.1.1) connects fine to the same oracle connection. The representation of the oracle connection in the catalog is different though.
uDig version Name in Catalog Installation
uDig 1.1.1 Oracle Spatial ax0141.oracle.jdbc (works) Normal installation
uDig 1.2-M9 Oracle Spatial (doesn't work) C:\temp\udig-1.2-M9.win32.win32.x86\udig\udig.bat
uDig 1.2-M8 Oracle Spatial (doesn't work) C:\temp\udig-1.2-M8.win32.win32.x86\udig\udig.bat
uDig 1.2-M6 Oracle Spatial ax0141.oracle.jdbc (doesn't work) C:\temp\udig-1.2-M6.win32.win32.x86\udig\udig.bat
BTW
when (in 1.1.1) I open at first the oracle table, it says Netherlands National System in the map editor, when I then open the same table using the geoserver connection, it still says Netherlands National System. Both layers don't match
The other way
when (in 1.1.1) I open at first the geoserver connection, it says Amersfoort /RD New (EPSG:28992) in the map editor, when i open the same table using the oracle connection, it still says Amersfoort /RD New (EPSG:28992), both layers do match.
The Netherlands National System seems to be a Custum CRS in uDig
PROJCS["Netherlands National System", GEOGCS["Netherlands Bessel",
DATUM["Netherlands Bessel", SPHEROID["Bessel 1841", 6377397.155, 299.1528128]],
PRIMEM["Greenwich", 0.0], UNIT["degree", 0.017453292519943295],
AXIS["Lon", EAST], AXIS["Lat", NORTH]],
PROJECTION["Stereographic"], PARAMETER["central_meridian", 5.387639],
PARAMETER["latitude_of_origin", 52.156161000000004], PARAMETER["scale_factor", 0.999908],
PARAMETER["false_easting", 155000.0], PARAMETER["false_northing", 463000.0],
UNIT["m", 1.0], AXIS["x", EAST],
AXIS["y", NORTH]]and can't be found in uDigs Standard CRS list
Well a lot of information ... :-)
Thanks
Error message as mentioned above:
java.lang.NullPointerException
at org.eclipse.emf.ecore.util.EcoreEList.resolveProxy(EcoreEList.java:212)
at org.eclipse.emf.ecore.util.EcoreEList.resolve(EcoreEList.java:167)
at org.eclipse.emf.ecore.util.EObjectWithInverseResolvingEList.resolve(EObjectWithInverseResolvingEList.java:99)
at org.eclipse.emf.common.util.BasicEList.get(BasicEList.java:354)
at net.refractions.udig.project.internal.impl.SynchronizedEObjectWithInverseResolvingEList.get(SynchronizedEObjectWithInverseResolvingEList.java:78)
at org.eclipse.emf.common.util.AbstractEList$EIterator.doNext(AbstractEList.java:709)
at org.eclipse.emf.common.util.AbstractEList$EIterator.next(AbstractEList.java:696)
at net.refractions.udig.project.internal.impl.LayersList2.addDeepAdapter(LayersList2.java:67)
at net.refractions.udig.project.internal.impl.MapImpl.addDeepAdapter(MapImpl.java:1722)
at net.refractions.udig.project.ui.internal.RenderManagerDynamic.basicSetMapInternal(RenderManagerDynamic.java:389)
at net.refractions.udig.project.internal.render.impl.RenderManagerImpl.eInverseAdd(RenderManagerImpl.java:488)
at net.refractions.udig.project.internal.impl.MapImpl.setRenderManagerInternalGen(MapImpl.java:1148)
at net.refractions.udig.project.internal.impl.MapImpl.setRenderManagerInternal(MapImpl.java:1189)
at net.refractions.udig.project.ui.viewers.MapViewer.setMap(MapViewer.java:182)
at net.refractions.udig.project.ui.internal.MapEditor.createPartControl(MapEditor.java:923)
at org.eclipse.ui.internal.EditorReference.createPartHelper(EditorReference.java:662)
at org.eclipse.ui.internal.EditorReference.createPart(EditorReference.java:462)
at org.eclipse.ui.internal.WorkbenchPartReference.getPart(WorkbenchPartReference.java:595)
at org.eclipse.ui.internal.PartPane.setVisible(PartPane.java:313)
at org.eclipse.ui.internal.presentations.PresentablePart.setVisible(PresentablePart.java:180)
at org.eclipse.ui.internal.presentations.util.PresentablePartFolder.select(PresentablePartFolder.java:270)
at org.eclipse.ui.internal.presentations.util.LeftToRightTabOrder.select(LeftToRightTabOrder.java:65)
at org.eclipse.ui.internal.presentations.util.TabbedStackPresentation.selectPart(TabbedStackPresentation.java:473)
at org.eclipse.ui.internal.PartStack.refreshPresentationSelection(PartStack.java:1256)
at org.eclipse.ui.internal.PartStack.setSelection(PartStack.java:1209)
at org.eclipse.ui.internal.PartStack.showPart(PartStack.java:1608)
at org.eclipse.ui.internal.PartStack.add(PartStack.java:499)
at org.eclipse.ui.internal.EditorStack.add(EditorStack.java:103)
at org.eclipse.ui.internal.PartStack.add(PartStack.java:485)
at org.eclipse.ui.internal.EditorStack.add(EditorStack.java:112)
at org.eclipse.ui.internal.EditorSashContainer.addEditor(EditorSashContainer.java:63)
at org.eclipse.ui.internal.EditorAreaHelper.addToLayout(EditorAreaHelper.java:225)
at org.eclipse.ui.internal.EditorAreaHelper.addEditor(EditorAreaHelper.java:213)
at org.eclipse.ui.internal.EditorManager.createEditorTab(EditorManager.java:778)
at org.eclipse.ui.internal.EditorManager.openEditorFromDescriptor(EditorManager.java:677)
at org.eclipse.ui.internal.EditorManager.openEditor(EditorManager.java:638)
at org.eclipse.ui.internal.WorkbenchPage.busyOpenEditorBatched(WorkbenchPage.java:2854)
at org.eclipse.ui.internal.WorkbenchPage.busyOpenEditor(WorkbenchPage.java:2762)
at org.eclipse.ui.internal.WorkbenchPage.access$11(WorkbenchPage.java:2754)
at org.eclipse.ui.internal.WorkbenchPage$10.run(WorkbenchPage.java:2705)
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)
at org.eclipse.ui.internal.WorkbenchPage.openEditor(WorkbenchPage.java:2701)
at org.eclipse.ui.internal.WorkbenchPage.openEditor(WorkbenchPage.java:2685)
at net.refractions.udig.project.ui.commands.OpenProjectElementCommand.openMap(OpenProjectElementCommand.java:81)
at net.refractions.udig.project.ui.commands.OpenProjectElementCommand.access$1(OpenProjectElementCommand.java:79)
at net.refractions.udig.project.ui.commands.OpenProjectElementCommand$1.run(OpenProjectElementCommand.java:70)
at net.refractions.udig.ui.PlatformGIS$2.run(PlatformGIS.java:270)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:134)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3855)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3476)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2405)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2369)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2221)
at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:500)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:493)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at net.refractions.udig.internal.ui.UDIGApplication.start(UDIGApplication.java:136)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:194)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:368)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
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:559)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:514)
at org.eclipse.equinox.launcher.Main.run(Main.java:1311)
2010/1/16 Jody Garnett
<jody.garnett@xxxxxxxxx>
Thanks for the picture.
I talked to a Andrea from the GeoTools project who looks after referencing.
GeoServer by default forces the EPSG you declare in the feature type
configuration. Maybe uDig does not instead, it uses the native one?
GeoServer can do that as well, you have to set the "leave native"
srs handling policy
He is correct we do not "force" anything - accepting the features as they come out of the datastore and trusting the CRS description to be accurate.
You can however do the forcing yourself; right click on the layer and "choose" a CRS for it - uDig will then force that CRS on the features coming back.
Do you mind trying this and letting me know if it fixes anything? You may need to try with uDig 1.2-M9 (which is on the download site but not announced yet).
Jody
On 11/01/2010, at 9:10 PM, Jan Willem van der Lichte wrote:
Hi Jody,
Sorry for the late response but, here is a picture of same data but throught a different channel
The orange data is a representation of the Oracle data using uDig directly (Oracle SRID 90112) presentation uDig: EPSG:28992
The grey data is the same oracle table, but served as a wms through Geoserver
Thanks,
Jan Willem
2010/1/8 Jody Garnett
<jody.garnett@xxxxxxxxx>
That does sound odd; I cannot think of a reason for this as both
projects using the same rendering library.
We *do* have a different copy of the epsg codes for projections; but I
think those have been updated recently and should be consistent.
Could you send a picture showing the difference?
Jody
On Wed, Dec 30, 2009 at 9:00 PM, Jan Willem van der Lichte
<
jwgvanderlichte@xxxxxxxxx> wrote:
> Hi List,
>
> A weird thing is happening.
>
> I have an Oracle spatial table with data for which the SRID is set to Oracle
> 90112 (let's call it A)
> From this table I made a wms-service with geoserver (let's call it B)
>
> If I use uDIg and connect A using the uDig Oracle Spatial data source
> and connect B using the uDig data source Web Map Server,
> both layers do NOT match.
>
> The geoserver WMS looks ok.
>
> Has anyone else had this problem?
>
> --
> Met groet,
> Jan Willem
>
>
>
--
Met groet,
Jan Willem
--
Met groet,
Jan Willem
