Re: [udig-devel] oracle status update

["Jukka Sirviö" <Jukka.Sirvio@xxxxxxxxxxxx>]

Hello!
It's no-go for me also, I followed your instructions and tested this on 
separate machine with only uDig 1.0.1 executable installed. Connection to 
DB seems to work (because schemas are received to drop-down menu) but I 
get npe after selecting the schema and pressing next button. NPE attached.

I tested this against 10.1.0.2.0 and 9.2.0.6.0 -database versions with 
appropriate drivers. From both datasources I got the same NPE.

I guess that we need only one jdbc driver and that is oracle 10g's 
ojdbc14.jar (it is mentioned for use with java 1.4 and 1.5). Currently the 
wizard page request two jdbc packages? uDig oracle plug-in (in geotools 
side) needs the OLD sdoapi classes also but that is totally different 
issue apart from jdbc classes. If also the sdoapi classes are needed to be 
selected separately then I suggest the following labels to wizard page 
(even I'm totally ugly with inventing descriptive UI-labels):
JDBC Driver for java 1.5:
SDOApi 8.1.7:

Attachment you will find also Oracle's JDBC interoperability matrix, pleas 
note that Oracle recommends to use 10g drivers because they are quite much 
powerfull when compared against earlier drivers.


Sincerely:
Jukka







Jesse Eichar <jeichar@xxxxxxxxxxxxxxx>
Sent by: udig-devel-bounces@xxxxxxxxxxxxxxxxxxxxx
07/09/2005 18:04
Please respond to User-friendly Desktop Internet GIS
 
        To:     User-friendly Desktop Internet GIS 
<udig-devel@xxxxxxxxxxxxxxxxxxxxx>
        cc: 
        Subject:        Re: [udig-devel] oracle status update


I've exported the oracle jars again for you to try.  I tried it and it 
worked, here is what I did:

1.  Delete old net.refractions.udig.libs_1.0.1 directory
2.  Delete net.refractions.udig.catalog.oracle_1.0.1.jar
3.  Unzip the oracle.zip 
(http://udig.refractions.net/downloads/oracle.zip) into plugins 
directory (double check that they are all there).
4.  Run udig
_______________________________________________
User-friendly Desktop Internet GIS (uDig)
http://udig.refractions.net
http://lists.refractions.net/mailman/listinfo/udig-devel

Interoperability Matrix

			Db10.2.0.x	Db10.1.0.x	Db 9.2.0.x	Db pre_9.2.0.x 
JDBC 10.2.0.x 		Yes 		Yes 		Yes 		(1) 
JDBC 10.1.0.x 		Yes 		Yes 		Yes 		(1) 
JDBC 9.2.0.x 		Yes 		Yes 		Yes 		(1) 
JDBC pre_9.2.0.x 	(1) 		(1) 		(1) 		(1) 

(1): See Oracle Client Interoperability in Metalink Notes #203849.1 & #207303.1

We recommend the Oracle JDBC 10g drivers, which are at least 33% faster on average; SQL types to Java types conversion up to 30 times faster (customer feedback).

java.lang.NullPointerException
	at net.refractions.udig.catalog.internal.oracle.ui.OracleSpatialWizardPage.getResources(OracleSpatialWizardPage.java:368)
	at net.refractions.udig.catalog.internal.ui.ConnectionPage.getResources(ConnectionPage.java:71)
	at net.refractions.udig.catalog.internal.ui.ConnectionPage$1.run(ConnectionPage.java:126)
	at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:346)
	at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:291)
	at org.eclipse.jface.wizard.WizardDialog.run(WizardDialog.java:830)
	at net.refractions.udig.catalog.internal.ui.ConnectionPage.getNextPage(ConnectionPage.java:146)
	at org.eclipse.jface.wizard.WizardDialog.nextPressed(WizardDialog.java:747)
	at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:345)
	at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:556)
	at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:90)
	at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
	at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843)
	at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3080)
	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2713)
	at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1699)
	at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1663)
	at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:367)
	at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143)
	at net.refractions.udig.internal.ui.UDIGApplication.run(UDIGApplication.java:28)
	at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:226)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:163)
	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.core.launcher.Main.invokeFramework(Main.java:334)
	at org.eclipse.core.launcher.Main.basicRun(Main.java:278)
	at org.eclipse.core.launcher.Main.run(Main.java:973)
	at org.eclipse.core.launcher.Main.main(Main.java:948)