Quantcast

Oracle plugin fail

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Oracle plugin fail

jcamara
Hi, list,

I'm trying to connect an instance of Oracle10g with uDig using 'Catalog'
-> 'Import' -> 'Oracle Spatial'.

Once I fill the connection parameters (ip/port/user/pass...) I could see
the Oracle Spatial item in the Catalog. But, if try to expand it, only
can see 'Searching contents...', and console shows:

org.eclipse.swt.SWTException: Failed to execute runnable
(java.lang.NullPointerException)
    at org.eclipse.swt.SWT.error(SWT.java:3884)
    at org.eclipse.swt.SWT.error(SWT.java:3799)
    at
org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:137)
    at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3885)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3506)
    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)
    at org.eclipse.equinox.launcher.Main.main(Main.java:1287)
Caused by: java.lang.NullPointerException
    at
net.refractions.udig.catalog.internal.oracle.OracleGeoResource.getStatus(OracleGeoResource.java:82)
    at
net.refractions.udig.catalog.internal.oracle.OracleGeoResource.createInfo(OracleGeoResource.java:137)
    at
net.refractions.udig.catalog.IGeoResource.getInfo(IGeoResource.java:215)
    at
net.refractions.udig.catalog.ui.ResolveLabelProviderSimple.getText(ResolveLabelProviderSimple.java:92)
    at
org.eclipse.jface.viewers.DecoratingLabelProvider.getText(DecoratingLabelProvider.java:129)
    at
org.eclipse.jface.viewers.ViewerComparator.compare(ViewerComparator.java:135)
    at
org.eclipse.jface.viewers.ViewerComparator$1.compare(ViewerComparator.java:187)
    at java.util.Arrays.mergeSort(Unknown Source)
    at java.util.Arrays.mergeSort(Unknown Source)
    at java.util.Arrays.mergeSort(Unknown Source)
    at java.util.Arrays.mergeSort(Unknown Source)
    at java.util.Arrays.sort(Unknown Source)
    at
org.eclipse.jface.viewers.ViewerComparator.sort(ViewerComparator.java:185)
    at
org.eclipse.jface.viewers.AbstractTreeViewer.getSortedChildren(AbstractTreeViewer.java:625)
    at
org.eclipse.jface.viewers.AbstractTreeViewer.updateChildren(AbstractTreeViewer.java:2578)
    at
org.eclipse.jface.viewers.AbstractTreeViewer.internalRefreshStruct(AbstractTreeViewer.java:1863)
    at
org.eclipse.jface.viewers.TreeViewer.internalRefreshStruct(TreeViewer.java:716)
    at
org.eclipse.jface.viewers.AbstractTreeViewer.internalRefresh(AbstractTreeViewer.java:1838)
    at
org.eclipse.jface.viewers.AbstractTreeViewer.internalRefresh(AbstractTreeViewer.java:1794)
    at
org.eclipse.jface.viewers.StructuredViewer$8.run(StructuredViewer.java:1484)
    at
org.eclipse.jface.viewers.StructuredViewer.preservingSelection(StructuredViewer.java:1392)
    at
org.eclipse.jface.viewers.TreeViewer.preservingSelection(TreeViewer.java:402)
    at
org.eclipse.jface.viewers.StructuredViewer.preservingSelection(StructuredViewer.java:1353)
    at
org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1482)
    at org.eclipse.jface.viewers.ColumnViewer.refresh(ColumnViewer.java:548)
    at
net.refractions.udig.catalog.ui.AbstractResolveContentProvider$1.run(AbstractResolveContentProvider.java:113)
    at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
    at
org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:134)
    ... 23 more

I tried the connection with default driver (oracle-driver.jar) and
specific Oracle10g driver (ojdbc14.jar) with same results.

Database works fine with OpenJump 1.3.1.

Anybody could connect with Oracle Spatial with 1.2RC3?

Very thanks in advance.

--
Javier Cámara Pérez
Área de Ejecución de Proyectos SIG
Subdirección de Sistemas de Información
E.P. Desarrollo Agrario y Pesquero
Oficina Provincial de Córdoba
Avda. Menéndez Pidal s/n
14004 - Córdoba
Telf: 50.59.12 / 957.00.59.12 | Skype: jcamaradap

_______________________________________________
User-friendly Desktop Internet GIS (uDig)
http://udig.refractions.net
http://lists.refractions.net/mailman/listinfo/udig-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Oracle plugin fail

Jody Garnett-2
Sigh; it was a one line fix (now committed). What platform are you on, I could issue a "snapshot" release for you to test against.

The other thing to do if you are having trouble is we can try using the GeoTools DataStore wizard to connect to oracle. It has a few more options; but is not as fancy.

Jody

On 25/05/2010, at 7:34 PM, [hidden email] wrote:

> Hi, list,
>
> I'm trying to connect an instance of Oracle10g with uDig using 'Catalog'
> -> 'Import' -> 'Oracle Spatial'.
>
> Once I fill the connection parameters (ip/port/user/pass...) I could see
> the Oracle Spatial item in the Catalog. But, if try to expand it, only
> can see 'Searching contents...', and console shows:
>
> org.eclipse.swt.SWTException: Failed to execute runnable
> (java.lang.NullPointerException)
>    at org.eclipse.swt.SWT.error(SWT.java:3884)
>    at org.eclipse.swt.SWT.error(SWT.java:3799)
>    at
> org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:137)
>    at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3885)
>    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3506)
>    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)
>    at org.eclipse.equinox.launcher.Main.main(Main.java:1287)
> Caused by: java.lang.NullPointerException
>    at
> net.refractions.udig.catalog.internal.oracle.OracleGeoResource.getStatus(OracleGeoResource.java:82)
>    at
> net.refractions.udig.catalog.internal.oracle.OracleGeoResource.createInfo(OracleGeoResource.java:137)
>    at
> net.refractions.udig.catalog.IGeoResource.getInfo(IGeoResource.java:215)
>    at
> net.refractions.udig.catalog.ui.ResolveLabelProviderSimple.getText(ResolveLabelProviderSimple.java:92)
>    at
> org.eclipse.jface.viewers.DecoratingLabelProvider.getText(DecoratingLabelProvider.java:129)
>    at
> org.eclipse.jface.viewers.ViewerComparator.compare(ViewerComparator.java:135)
>    at
> org.eclipse.jface.viewers.ViewerComparator$1.compare(ViewerComparator.java:187)
>    at java.util.Arrays.mergeSort(Unknown Source)
>    at java.util.Arrays.mergeSort(Unknown Source)
>    at java.util.Arrays.mergeSort(Unknown Source)
>    at java.util.Arrays.mergeSort(Unknown Source)
>    at java.util.Arrays.sort(Unknown Source)
>    at
> org.eclipse.jface.viewers.ViewerComparator.sort(ViewerComparator.java:185)
>    at
> org.eclipse.jface.viewers.AbstractTreeViewer.getSortedChildren(AbstractTreeViewer.java:625)
>    at
> org.eclipse.jface.viewers.AbstractTreeViewer.updateChildren(AbstractTreeViewer.java:2578)
>    at
> org.eclipse.jface.viewers.AbstractTreeViewer.internalRefreshStruct(AbstractTreeViewer.java:1863)
>    at
> org.eclipse.jface.viewers.TreeViewer.internalRefreshStruct(TreeViewer.java:716)
>    at
> org.eclipse.jface.viewers.AbstractTreeViewer.internalRefresh(AbstractTreeViewer.java:1838)
>    at
> org.eclipse.jface.viewers.AbstractTreeViewer.internalRefresh(AbstractTreeViewer.java:1794)
>    at
> org.eclipse.jface.viewers.StructuredViewer$8.run(StructuredViewer.java:1484)
>    at
> org.eclipse.jface.viewers.StructuredViewer.preservingSelection(StructuredViewer.java:1392)
>    at
> org.eclipse.jface.viewers.TreeViewer.preservingSelection(TreeViewer.java:402)
>    at
> org.eclipse.jface.viewers.StructuredViewer.preservingSelection(StructuredViewer.java:1353)
>    at
> org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1482)
>    at org.eclipse.jface.viewers.ColumnViewer.refresh(ColumnViewer.java:548)
>    at
> net.refractions.udig.catalog.ui.AbstractResolveContentProvider$1.run(AbstractResolveContentProvider.java:113)
>    at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
>    at
> org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:134)
>    ... 23 more
>
> I tried the connection with default driver (oracle-driver.jar) and
> specific Oracle10g driver (ojdbc14.jar) with same results.
>
> Database works fine with OpenJump 1.3.1.
>
> Anybody could connect with Oracle Spatial with 1.2RC3?
>
> Very thanks in advance.
>
> --
> Javier Cámara Pérez
> Área de Ejecución de Proyectos SIG
> Subdirección de Sistemas de Información
> E.P. Desarrollo Agrario y Pesquero
> Oficina Provincial de Córdoba
> Avda. Menéndez Pidal s/n
> 14004 - Córdoba
> Telf: 50.59.12 / 957.00.59.12 | Skype: jcamaradap
>
> _______________________________________________
> User-friendly Desktop Internet GIS (uDig)
> http://udig.refractions.net
> http://lists.refractions.net/mailman/listinfo/udig-devel

_______________________________________________
User-friendly Desktop Internet GIS (uDig)
http://udig.refractions.net
http://lists.refractions.net/mailman/listinfo/udig-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Oracle plugin fail

jcamara
I'm on WinXp_SP3 32 bits with uDig 1.2RC3.

Tested DataStore wizard with the same result:

[...]
Caused by: java.lang.NullPointerException
    at
net.refractions.udig.catalog.internal.oracle.OracleGeoResource.getStatus(OracleGeoResource.java:82)
    at
net.refractions.udig.catalog.internal.oracle.OracleGeoResource.createInfo(OracleGeoResource.java:137)
    at
net.refractions.udig.catalog.IGeoResource.getInfo(IGeoResource.java:215)
[...]

Now, I'm testing many datasources (ECW, WFS, OracleSpatial, ... that
works fine in OpenJump) with hopeless results :(

Will post the issues thay I'm finding...please, sorry for the pain.

Very thanks in advance.

Jody Garnett escribió:

> Sigh; it was a one line fix (now committed). What platform are you on, I could issue a "snapshot" release for you to test against.
>
> The other thing to do if you are having trouble is we can try using the GeoTools DataStore wizard to connect to oracle. It has a few more options; but is not as fancy.
>
> Jody
>
> On 25/05/2010, at 7:34 PM, [hidden email] wrote:
>
>  
>> Hi, list,
>>
>> I'm trying to connect an instance of Oracle10g with uDig using 'Catalog'
>> -> 'Import' -> 'Oracle Spatial'.
>>
>> Once I fill the connection parameters (ip/port/user/pass...) I could see
>> the Oracle Spatial item in the Catalog. But, if try to expand it, only
>> can see 'Searching contents...', and console shows:
>>
>> org.eclipse.swt.SWTException: Failed to execute runnable
>> (java.lang.NullPointerException)
>>    at org.eclipse.swt.SWT.error(SWT.java:3884)
>>    at org.eclipse.swt.SWT.error(SWT.java:3799)
>>    at
>> org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:137)
>>    at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3885)
>>    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3506)
>>    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)
>>    at org.eclipse.equinox.launcher.Main.main(Main.java:1287)
>> Caused by: java.lang.NullPointerException
>>    at
>> net.refractions.udig.catalog.internal.oracle.OracleGeoResource.getStatus(OracleGeoResource.java:82)
>>    at
>> net.refractions.udig.catalog.internal.oracle.OracleGeoResource.createInfo(OracleGeoResource.java:137)
>>    at
>> net.refractions.udig.catalog.IGeoResource.getInfo(IGeoResource.java:215)
>>    at
>> net.refractions.udig.catalog.ui.ResolveLabelProviderSimple.getText(ResolveLabelProviderSimple.java:92)
>>    at
>> org.eclipse.jface.viewers.DecoratingLabelProvider.getText(DecoratingLabelProvider.java:129)
>>    at
>> org.eclipse.jface.viewers.ViewerComparator.compare(ViewerComparator.java:135)
>>    at
>> org.eclipse.jface.viewers.ViewerComparator$1.compare(ViewerComparator.java:187)
>>    at java.util.Arrays.mergeSort(Unknown Source)
>>    at java.util.Arrays.mergeSort(Unknown Source)
>>    at java.util.Arrays.mergeSort(Unknown Source)
>>    at java.util.Arrays.mergeSort(Unknown Source)
>>    at java.util.Arrays.sort(Unknown Source)
>>    at
>> org.eclipse.jface.viewers.ViewerComparator.sort(ViewerComparator.java:185)
>>    at
>> org.eclipse.jface.viewers.AbstractTreeViewer.getSortedChildren(AbstractTreeViewer.java:625)
>>    at
>> org.eclipse.jface.viewers.AbstractTreeViewer.updateChildren(AbstractTreeViewer.java:2578)
>>    at
>> org.eclipse.jface.viewers.AbstractTreeViewer.internalRefreshStruct(AbstractTreeViewer.java:1863)
>>    at
>> org.eclipse.jface.viewers.TreeViewer.internalRefreshStruct(TreeViewer.java:716)
>>    at
>> org.eclipse.jface.viewers.AbstractTreeViewer.internalRefresh(AbstractTreeViewer.java:1838)
>>    at
>> org.eclipse.jface.viewers.AbstractTreeViewer.internalRefresh(AbstractTreeViewer.java:1794)
>>    at
>> org.eclipse.jface.viewers.StructuredViewer$8.run(StructuredViewer.java:1484)
>>    at
>> org.eclipse.jface.viewers.StructuredViewer.preservingSelection(StructuredViewer.java:1392)
>>    at
>> org.eclipse.jface.viewers.TreeViewer.preservingSelection(TreeViewer.java:402)
>>    at
>> org.eclipse.jface.viewers.StructuredViewer.preservingSelection(StructuredViewer.java:1353)
>>    at
>> org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1482)
>>    at org.eclipse.jface.viewers.ColumnViewer.refresh(ColumnViewer.java:548)
>>    at
>> net.refractions.udig.catalog.ui.AbstractResolveContentProvider$1.run(AbstractResolveContentProvider.java:113)
>>    at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
>>    at
>> org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:134)
>>    ... 23 more
>>
>> I tried the connection with default driver (oracle-driver.jar) and
>> specific Oracle10g driver (ojdbc14.jar) with same results.
>>
>> Database works fine with OpenJump 1.3.1.
>>
>> Anybody could connect with Oracle Spatial with 1.2RC3?
>>
>> Very thanks in advance.
>>
>> --
>> Javier Cámara Pérez
>> Área de Ejecución de Proyectos SIG
>> Subdirección de Sistemas de Información
>> E.P. Desarrollo Agrario y Pesquero
>> Oficina Provincial de Córdoba
>> Avda. Menéndez Pidal s/n
>> 14004 - Córdoba
>> Telf: 50.59.12 / 957.00.59.12 | Skype: jcamaradap
>>
>> _______________________________________________
>> User-friendly Desktop Internet GIS (uDig)
>> http://udig.refractions.net
>> http://lists.refractions.net/mailman/listinfo/udig-devel
>>    
>
> _______________________________________________
> User-friendly Desktop Internet GIS (uDig)
> http://udig.refractions.net
> http://lists.refractions.net/mailman/listinfo/udig-devel
>  


--
Javier Cámara Pérez
Área de Ejecución de Proyectos SIG
Subdirección de Sistemas de Información
E.P. Desarrollo Agrario y Pesquero
Oficina Provincial de Córdoba
Avda. Menéndez Pidal s/n
14004 - Córdoba
Telf: 50.59.12 / 957.00.59.12 | Skype: jcamaradap

_______________________________________________
User-friendly Desktop Internet GIS (uDig)
http://udig.refractions.net
http://lists.refractions.net/mailman/listinfo/udig-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Oracle plugin fail

jcamara
I'm trying to make Oracle Connection by code using next snnipet:

URL connectionURL = new
URL("jdbc:oracle:thin:***/***@[address]:1521:[SID]");
IService service = new
OracleServiceExtension().createService(connectionURL, null);
List<? extends IGeoResource> resources = service.resources(new
NullProgressMonitor());

Inspecting wiki I think that this is the way, but I'm not sure.

My MANIFEST.MF looks like:

Require-Bundle: org.eclipse.ui,
 org.eclipse.core.runtime,
 net.refractions.udig.project;bundle-version="1.2.0",
 net.refractions.udig.catalog.oracle;bundle-version="1.2.0",
 net.refractions.udig.project.ui;bundle-version="1.2.0"

but Eclipse can't solves the import for 'OracleServiceExtension'.

Putting import line by hand:

import net.refractions.udig.catalog.internal.oracle.OracleServiceExtension;

Shows next error message:

"The type OracleServiceExtension is not accessible due to restriction on
required library
D:\uDig\1.2RC3_testing\target\udig_sdk\plugins\net.refractions.udig.catalog.oracle_1.2.0.201005181202.jar"

If try quick fix and test the plugin, I'm getting the error:

java.lang.NoClassDefFoundError:
net/refractions/udig/catalog/internal/oracle/OracleServiceImpl

Anybody has some idea on where I'm missing?

Very thanks in advance.

--
Javier Cámara Pérez
Área de Ejecución de Proyectos SIG
Subdirección de Sistemas de Información
E.P. Desarrollo Agrario y Pesquero
Oficina Provincial de Córdoba
Avda. Menéndez Pidal s/n
14004 - Córdoba
Telf: 50.59.12 / 957.00.59.12 | Skype: jcamaradap

_______________________________________________
User-friendly Desktop Internet GIS (uDig)
http://udig.refractions.net
http://lists.refractions.net/mailman/listinfo/udig-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Oracle plugin fail

Jody Garnett-2
You need to be sure to declare the dependency on the net.refractions.udig.catalog.oracle plugin.
We also need to check that the plugin exports out the classes you are interested in using.

jody

On 26/05/2010, at 10:39 PM, [hidden email] wrote:

> I'm trying to make Oracle Connection by code using next snnipet:
>
> URL connectionURL = new
> URL("jdbc:oracle:thin:***/***@[address]:1521:[SID]");
> IService service = new
> OracleServiceExtension().createService(connectionURL, null);
> List<? extends IGeoResource> resources = service.resources(new
> NullProgressMonitor());
>
> Inspecting wiki I think that this is the way, but I'm not sure.
>
> My MANIFEST.MF looks like:
>
> Require-Bundle: org.eclipse.ui,
> org.eclipse.core.runtime,
> net.refractions.udig.project;bundle-version="1.2.0",
> net.refractions.udig.catalog.oracle;bundle-version="1.2.0",
> net.refractions.udig.project.ui;bundle-version="1.2.0"
>
> but Eclipse can't solves the import for 'OracleServiceExtension'.
>
> Putting import line by hand:
>
> import net.refractions.udig.catalog.internal.oracle.OracleServiceExtension;
>
> Shows next error message:
>
> "The type OracleServiceExtension is not accessible due to restriction on
> required library
> D:\uDig\1.2RC3_testing\target\udig_sdk\plugins\net.refractions.udig.catalog.oracle_1.2.0.201005181202.jar"
>
> If try quick fix and test the plugin, I'm getting the error:
>
> java.lang.NoClassDefFoundError:
> net/refractions/udig/catalog/internal/oracle/OracleServiceImpl
>
> Anybody has some idea on where I'm missing?
>
> Very thanks in advance.
>
> --
> Javier Cámara Pérez
> Área de Ejecución de Proyectos SIG
> Subdirección de Sistemas de Información
> E.P. Desarrollo Agrario y Pesquero
> Oficina Provincial de Córdoba
> Avda. Menéndez Pidal s/n
> 14004 - Córdoba
> Telf: 50.59.12 / 957.00.59.12 | Skype: jcamaradap
>
> _______________________________________________
> User-friendly Desktop Internet GIS (uDig)
> http://udig.refractions.net
> http://lists.refractions.net/mailman/listinfo/udig-devel

_______________________________________________
User-friendly Desktop Internet GIS (uDig)
http://udig.refractions.net
http://lists.refractions.net/mailman/listinfo/udig-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Oracle plugin fail

jcamara
In reply to this post by Jody Garnett-2
Hi again,

I'm fighting with Oracle yet, but we can't progress with it.

Tried with uDig 1.1.1 and works fine, recovering all tables perfectly.
With 1.2RC3_SDK, results as previous message.

Now, I've just try with svn-trunk version of:
net.refractions.udig.catalog.oracle Plugin, which seems to connect fine,
but can't get tables properly. Restore all tables items... but with same
name. If try add to map, it's results with a 'new layer' that start
crashing uDig.

I attach screenshot (ORACLE_Punto_Layer_Type isn't an Oracle
layer...it's a wfs layer).

Any suggestion about how can I go forward?

Very thanks in advance.


Jody Garnett escribió:

> Sigh; it was a one line fix (now committed). What platform are you on, I could issue a "snapshot" release for you to test against.
>
> The other thing to do if you are having trouble is we can try using the GeoTools DataStore wizard to connect to oracle. It has a few more options; but is not as fancy.
>
> Jody
>
> On 25/05/2010, at 7:34 PM, [hidden email] wrote:
> [...]
>  
> _______________________________________________
> User-friendly Desktop Internet GIS (uDig)
> http://udig.refractions.net
> http://lists.refractions.net/mailman/listinfo/udig-devel
>  
--
Javier Cámara Pérez
Área de Ejecución de Proyectos SIG
Subdirección de Sistemas de Información
E.P. Desarrollo Agrario y Pesquero
Oficina Provincial de Córdoba
Avda. Menéndez Pidal s/n
14004 - Córdoba
Telf: 50.59.12 / 957.00.59.12 | Skype: jcamaradap


_______________________________________________
User-friendly Desktop Internet GIS (uDig)
http://udig.refractions.net
http://lists.refractions.net/mailman/listinfo/udig-devel

OracleFromTrunk.PNG (144K) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Oracle plugin fail

Jody Garnett-2
You indicated on IRC that things were working now?
What was the fix so I can update the codebase :)

Jody

On 03/06/2010, at 8:31 PM, [hidden email] wrote:

> Hi again,
>
> I'm fighting with Oracle yet, but we can't progress with it.
>
> Tried with uDig 1.1.1 and works fine, recovering all tables perfectly.
> With 1.2RC3_SDK, results as previous message.
>
> Now, I've just try with svn-trunk version of:
> net.refractions.udig.catalog.oracle Plugin, which seems to connect fine,
> but can't get tables properly. Restore all tables items... but with same
> name. If try add to map, it's results with a 'new layer' that start
> crashing uDig.
>
> I attach screenshot (ORACLE_Punto_Layer_Type isn't an Oracle
> layer...it's a wfs layer).
>
> Any suggestion about how can I go forward?
>
> Very thanks in advance.
>
>
> Jody Garnett escribió:
>> Sigh; it was a one line fix (now committed). What platform are you on, I could issue a "snapshot" release for you to test against.
>>
>> The other thing to do if you are having trouble is we can try using the GeoTools DataStore wizard to connect to oracle. It has a few more options; but is not as fancy.
>>
>> Jody
>>
>> On 25/05/2010, at 7:34 PM, [hidden email] wrote:
>> [...]
>>
>> _______________________________________________
>> User-friendly Desktop Internet GIS (uDig)
>> http://udig.refractions.net
>> http://lists.refractions.net/mailman/listinfo/udig-devel
>>
> --
> Javier Cámara Pérez
> Área de Ejecución de Proyectos SIG
> Subdirección de Sistemas de Información
> E.P. Desarrollo Agrario y Pesquero
> Oficina Provincial de Córdoba
> Avda. Menéndez Pidal s/n
> 14004 - Córdoba
> Telf: 50.59.12 / 957.00.59.12 | Skype: jcamaradap
>
> <OracleFromTrunk.PNG>_______________________________________________
> User-friendly Desktop Internet GIS (uDig)
> http://udig.refractions.net
> http://lists.refractions.net/mailman/listinfo/udig-devel

_______________________________________________
User-friendly Desktop Internet GIS (uDig)
http://udig.refractions.net
http://lists.refractions.net/mailman/listinfo/udig-devel
Loading...