SQL Power Software Forum

Mac (OSX 10.6)
PostgreSQL 8.3

Continue to get java.lang.RuntimeException when trying to utilize the Google Address Lookup. Appears to require API KEY prior to loading, is there something I am doing incorrectly? Any help much appreciated.

Full Error Text:

java.lang.RuntimeException: Error generating munge step component: ca.sqlpower.matchmaker.swingui.munge.GoogleAddressLookupMungeComponent. Possibly caused by an error thrown in the constructor.
	at ca.sqlpower.matchmaker.swingui.SwingSessionContextImpl.getMungeComponent(SwingSessionContextImpl.java:612)
	at ca.sqlpower.matchmaker.swingui.munge.MungePen$MungePenMungeProcessListener.mmChildrenInserted(MungePen.java:812)
	at ca.sqlpower.matchmaker.event.MatchMakerEventSupport.fireChildrenInserted(MatchMakerEventSupport.java:219)
	at ca.sqlpower.matchmaker.event.MatchMakerEventSupport.fireChildrenInserted(MatchMakerEventSupport.java:175)
	at ca.sqlpower.matchmaker.AbstractMatchMakerObject.addImpl(AbstractMatchMakerObject.java:106)
	at ca.sqlpower.matchmaker.munge.MungeProcess.addImpl(MungeProcess.java:280)
	at ca.sqlpower.matchmaker.munge.MungeProcess.addImpl(MungeProcess.java:38)
	at ca.sqlpower.matchmaker.AbstractMatchMakerObject.addChild(AbstractMatchMakerObject.java:77)
	at ca.sqlpower.matchmaker.swingui.munge.MungePen.addMungeStep(MungePen.java:586)
	at ca.sqlpower.matchmaker.swingui.munge.MungePen.drop(MungePen.java:1067)
	at java.awt.dnd.DropTarget.drop(DropTarget.java:434)
	at sun.awt.dnd.SunDropTargetContextPeer.processDropMessage(SunDropTargetContextPeer.java:500)
	at sun.awt.dnd.SunDropTargetContextPeer$EventDispatcher.dispatchDropEvent(SunDropTargetContextPeer.java:812)
	at sun.awt.dnd.SunDropTargetContextPeer$EventDispatcher.dispatchEvent(SunDropTargetContextPeer.java:736)
	at sun.awt.dnd.SunDropTargetEvent.dispatch(SunDropTargetEvent.java:30)
	at java.awt.Component.dispatchEventImpl(Component.java:4571)
	at java.awt.Container.dispatchEventImpl(Container.java:2143)
	at java.awt.Component.dispatchEvent(Component.java:4544)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4618)
	at java.awt.LightweightDispatcher.processDropTargetEvent(Container.java:4353)
	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4207)
	at java.awt.Container.dispatchEventImpl(Container.java:2129)
	at java.awt.Window.dispatchEventImpl(Window.java:2475)
	at java.awt.Component.dispatchEvent(Component.java:4544)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:635)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:296)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:211)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:201)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:196)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:188)
	at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
Caused by: java.lang.reflect.InvocationTargetException
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
	at ca.sqlpower.matchmaker.swingui.SwingSessionContextImpl.getMungeComponent(SwingSessionContextImpl.java:610)
	... 30 more
Caused by: java.lang.RuntimeException: Failed to refresh step Google Maps Address Lookup
	at ca.sqlpower.matchmaker.swingui.munge.AbstractMungeComponent.<init>(AbstractMungeComponent.java:255)
	at ca.sqlpower.matchmaker.swingui.munge.GoogleAddressLookupMungeComponent.<init>(GoogleAddressLookupMungeComponent.java:52)
	... 35 more
Caused by: java.lang.IllegalStateException: Can't open step: Google Maps API Key is required.
	at ca.sqlpower.matchmaker.munge.GoogleAddressLookup.doOpen(GoogleAddressLookup.java:112)
	at ca.sqlpower.matchmaker.munge.AbstractMungeStep.open(AbstractMungeStep.java:502)
	at ca.sqlpower.matchmaker.munge.AbstractMungeStep.open(AbstractMungeStep.java:480)
	at ca.sqlpower.matchmaker.swingui.munge.AbstractMungeComponent.<init>(AbstractMungeComponent.java:251)
	... 36 more

Hi there,

To use the Google Address Lookup, you need to sign up for a Google Maps API key

http://code.google.com/apis/maps/signup.html

I believe it should work with DQguru if you signup with a URL of http://localhost.