Re: [udig-users] Trouble connecting with JDBCDataStore

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [udig-users] Trouble connecting with JDBCDataStore
From: Jody Garnett <jody.garnett@xxxxxxxxx>
Date: Thu, 1 Jul 2010 22:28:15 +1000
Delivered-to: udig-users@xxxxxxxxxxxxxxxxxxxxxx
Domainkey-signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=subject:mime-version:content-type:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to:x-mailer; b=qUn4VJkb+Dy89ty4817FyFB/GjyJssaEgnFriJi6o6TjDnUGNHhxRVFLd2kc13Z8bo Njnln2d3VBUtpruM7xHBjIg1MSY+gxSbKqAqYEmM4eN0B6L9Yadk/HiUzSqxGPMlwkU4 5wvuRDMODIT7mb+4pWoKhrJZs/6rb8EIsd7Mk=
List-archive: <http://lists.refractions.net/pipermail/udig-users>
List-help: <mailto:udig-users-request@lists.refractions.net?subject=help>
List-subscribe: <http://lists.refractions.net/mailman/listinfo/udig-users>, <mailto:udig-users-request@lists.refractions.net?subject=subscribe>
List-unsubscribe: <http://lists.refractions.net/mailman/options/udig-users>, <mailto:udig-users-request@lists.refractions.net?subject=unsubscribe>
Hi David:

Thanks for the detail David; as mentioned we just recently changed our
datastore implementation for PostGIS (to be the same one as GeoServer).

So I don't think you are alone in this; I just think uDig hits PostGIS a bit harder
then GeoServer (in particular the zoom to layer needs to know the entire
area of the layer). 

It may be obvious from the sql commands you used; but can I confirm that
you did create a spatial index? Looking at the spatial index is one of the ways
we try and determine the correct bounds for zoom to layer.

Once again you have caught me in a busy week and I wont personally be able
to look at any of this. The extra detail should be added to the existing bug
report.

Jody

On 01/07/2010, at 10:04 PM, David Epstein wrote:

> Hi Jody,
> 
> Thank you for your guidance. I have tried to connect to the table using
> two methods:
> 
> 1) Layer-->Add-->postGIS
> 
> This is the original way I tried. The programmer mentioned having
> trouble connecting since you need to add the hostname to a configuration
> file (pg_hba.conf). I had "localhost" in that file and seem to be able
> to connect to the database since I can see a list of available layers.
> If I change the hostname to just "local", which is not in my conf file,
> then the Add Data window returns "Unrecognized connection failure.
> Check parameters and database.". So, I cannot even see database contacts
> without a listed hostname. As mentioned though, using this method, I
> cannot see the layer in the Table viewer or map viewer.
> 
> 
> 2) Layer-->Add-->Datastore-->postgis   
> (and also the option with caps "postGIS")
> 
> This is the method the programmer/tester suggested. I can see the table
> in the Table view at the bottom of the screen. But, the layer does not
> display. "Zoom to layer" does nothing. I can see some of the geometry by
> selecting a row in the table and right-clicking "show selection". I can
> zoom a bit to see more of the geometry, but it eventually disappears.
> Really really strange. Note, the table view says "BigDecimel type does
> not have an editor" when I click on a row.
> 
> 
> Getting weirder
> ---------------
> 
> The datastore-loaded postGIS file will display correctly (though slowly)
> behind the shapefile. If I delete the shapefile, the postGIS will
> continue to zoom. But, "zoom to layer" makes it disappear and it does
> not return. 
> 
> The shapefile has Bounds of (-179.1,17.8)(179.7,71.3). The postGIS file
> has bounds of (-52.0,14.2)(172.0,83.2). SRID=4269.
> 
> I've attached a log. Welcome to the twilight zone.
> 
> Do you think I should re-install or compile from source? How can I be
> the only one encountering such unusual behavior?
> 
> 
> -david
> 
> 
> 
> 
> 
> !SESSION 2010-07-01 07:23:35.662
> -----------------------------------------------
> eclipse.buildId=unknown
> java.version=1.6.0_20
> java.vendor=Sun Microsystems Inc.
> BootLoader constants: OS=linux, ARCH=x86_64, WS=gtk, NL=en_US
> Command-line arguments:  -os linux -ws gtk -arch x86_64
> -data /home/davideps/uDigWorkspace
> 
> !ENTRY org.eclipse.osgi 2 1 2010-07-01 07:23:48.031
> !MESSAGE NLS missing message: cancel_description in:
> net.refractions.udig.ui.internal.messages
> 
> !ENTRY org.eclipse.osgi 2 1 2010-07-01 07:23:48.080
> !MESSAGE NLS missing message: cancel_tooltip in:
> net.refractions.udig.ui.internal.messages
> 
> !ENTRY org.eclipse.osgi 2 1 2010-07-01 07:23:48.080
> !MESSAGE NLS missing message: orientation_horizontal_description in:
> net.refractions.udig.ui.internal.messages
> 
> !ENTRY org.eclipse.osgi 2 1 2010-07-01 07:23:48.080
> !MESSAGE NLS missing message: orientation_horizontal_tooltip in:
> net.refractions.udig.ui.internal.messages
> 
> !ENTRY org.eclipse.osgi 2 1 2010-07-01 07:23:48.080
> !MESSAGE NLS missing message: orientation_vertical_description in:
> net.refractions.udig.ui.internal.messages
> 
> !ENTRY org.eclipse.osgi 2 1 2010-07-01 07:23:48.081
> !MESSAGE NLS missing message: orientation_vertical_tooltip in:
> net.refractions.udig.ui.internal.messages
> 
> !ENTRY org.eclipse.osgi 2 1 2010-07-01 07:23:48.081
> !MESSAGE NLS missing message: orientation_single_description in:
> net.refractions.udig.ui.internal.messages
> 
> !ENTRY org.eclipse.osgi 2 1 2010-07-01 07:23:48.081
> !MESSAGE NLS missing message: orientation_single_tooltip in:
> net.refractions.udig.ui.internal.messages
> 
> !ENTRY org.eclipse.osgi 2 1 2010-07-01 07:23:48.081
> !MESSAGE NLS missing message: orientation_automatic_description in:
> net.refractions.udig.ui.internal.messages
> 
> !ENTRY org.eclipse.osgi 2 1 2010-07-01 07:23:48.081
> !MESSAGE NLS missing message: orientation_automatic_tooltip in:
> net.refractions.udig.ui.internal.messages
> 
> !ENTRY net.refractions.udig.ui 1 0 2010-07-01 07:23:48.082
> !MESSAGE net.refractions.udig.ui.WorkbenchConfiguration
> "net.refractions.udig.internal.ui.UDIGWorkbenchConfiguration" specified
> but no valid extension found.
> Please check that the extension exists and that it is valid.
> 
> !ENTRY net.refractions.udig.ui 1 0 2010-07-01 07:23:48.191
> !MESSAGE net.refractions.udig.ui.MenuBuilder
> "net.refractions.udig.ui.uDigMenuBuilder" specified but no valid
> extension found.
> Please check that the extension exists and that it is valid.
> 
> !ENTRY net.refractions.udig.ui 1 0 2010-07-01 07:23:48.630
> !MESSAGE EnablementUtil: Expected child of
> net.refractions.udig.render.wms.basic.operation but didn't find one...
> 
> !ENTRY net.refractions.udig.catalog.imageio 2 0 2010-07-01 07:23:50.546
> !MESSAGE GDAL Not Available ... some image formats disabled: 
> Expected environment variable resolve to:
> 
> LD_LIBRARY_PATH=/home/davideps/Software/udig/jre/lib/amd64/server:/home/davideps/Software/udig/jre/lib/amd64:/home/davideps/Software/udig/jre/../lib/amd64:/usr/lib64/xulrunner-addons
> 	DYLD_LIBRARY_PATH=null
> 	GDAL_DATA=/home/davideps/Software/udig/gdal_data
> 
> java.libary.path=/home/davideps/Software/udig/jre/lib/amd64/server:/home/davideps/Software/udig/jre/lib/amd64:/home/davideps/Software/udig/jre/../lib/amd64:/usr/lib64/xulrunner-addons:/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
> 
> 
> !ENTRY net.refractions.udig.catalog.internal.postgis 4 0 2010-07-01
> 07:24:18.212
> !MESSAGE Error connecting to database template1
> !STACK 0
> org.apache.commons.dbcp.SQLNestedException: Cannot create
> PoolableConnectionFactory (The connection attempt failed.)
> 	at
> org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
> 	at
> org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
> 	at
> net.refractions.udig.catalog.internal.postgis.ui.PostgisDatabaseConnectionRunnable.run(PostgisDatabaseConnectionRunnable.java:82)
> 	at net.refractions.udig.ui.PlatformGIS$1.call(PlatformGIS.java:105)
> 	at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
> 	at java.util.concurrent.FutureTask.run(Unknown Source)
> 	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown
> Source)
> 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
> 	at java.lang.Thread.run(Unknown Source)
> Caused by: org.postgresql.util.PSQLException: The connection attempt
> failed.
> 	at
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:150)
> 	at
> org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
> 	at
> org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
> 	at
> org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
> 	at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
> 	at org.postgresql.Driver.makeConnection(Driver.java:393)
> 	at org.postgresql.Driver.connect(Driver.java:267)
> 	at
> org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
> 	at
> org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
> 	at
> org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
> 	at
> org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
> 	... 8 more
> Caused by: java.net.UnknownHostException: local
> 	at java.net.PlainSocketImpl.connect(Unknown Source)
> 	at java.net.SocksSocketImpl.connect(Unknown Source)
> 	at java.net.Socket.connect(Unknown Source)
> 	at java.net.Socket.connect(Unknown Source)
> 	at java.net.Socket.<init>(Unknown Source)
> 	at java.net.Socket.<init>(Unknown Source)
> 	at org.postgresql.core.PGStream.<init>(PGStream.java:62)
> 	at
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:76)
> 	... 18 more
> 
> !ENTRY net.refractions.udig.project 1 0 2010-07-01 07:24:48.615
> !MESSAGE Layer: county99_table could not find a GeoResource with
> id:jdbc.postgis://postgres:postgres@localhost:5432/US_National#county99_table
> 
> !ENTRY org.eclipse.osgi 2 1 2010-07-01 07:24:48.668
> !MESSAGE NLS missing message: PostGisWizardPage_0 in:
> net.refractions.udig.catalog.postgis.internal.messages
> 
> !ENTRY org.eclipse.osgi 2 1 2010-07-01 07:24:48.668
> !MESSAGE NLS missing message: PostGisWizardPage_title in:
> net.refractions.udig.catalog.postgis.internal.messages
> 
> !ENTRY org.eclipse.osgi 2 1 2010-07-01 07:24:48.668
> !MESSAGE NLS missing message: PostGisWizardPage_button_looseBBox_tooltip
> in: net.refractions.udig.catalog.postgis.internal.messages
> 
> !ENTRY org.eclipse.osgi 2 1 2010-07-01 07:24:48.668
> !MESSAGE NLS missing message: PostGisWizardPage_button_looseBBox_text
> in: net.refractions.udig.catalog.postgis.internal.messages
> 
> !ENTRY org.eclipse.osgi 2 1 2010-07-01 07:24:48.669
> !MESSAGE NLS missing message: PostGisWizardPage_button_wkb_tooltip in:
> net.refractions.udig.catalog.postgis.internal.messages
> 
> !ENTRY org.eclipse.osgi 2 1 2010-07-01 07:24:48.669
> !MESSAGE NLS missing message: PostGisWizardPage_button_wkb_text in:
> net.refractions.udig.catalog.postgis.internal.messages
> 
> !ENTRY net.refractions.udig.catalog 2 0 2010-07-01 07:24:48.669
> !MESSAGE Error while getting the bounds of a layer
> !STACK 0
> java.lang.RuntimeException: java.lang.NullPointerException
> 	at
> org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:484)
> 	at
> org.geotools.jdbc.JDBCFeatureStore.getBoundsInternal(JDBCFeatureStore.java:178)
> 	at
> org.geotools.data.store.ContentFeatureSource.getBounds(ContentFeatureSource.java:366)
> 	at
> org.geotools.data.store.ContentFeatureSource.getBounds(ContentFeatureSource.java:338)
> 	at
> net.refractions.udig.catalog.PostgisResourceInfo.getBounds(PostgisResourceInfo.java:76)
> 	at
> net.refractions.udig.project.internal.impl.GeoResourceInfoInterceptor
> $Wrapper.getBounds(GeoResourceInfoInterceptor.java:68)
> 	at
> net.refractions.udig.project.internal.impl.LayerImpl.obtainBoundsFromResources(LayerImpl.java:2014)
> 	at
> net.refractions.udig.project.internal.impl.LayerImpl.getBounds(LayerImpl.java:1985)
> 	at
> net.refractions.udig.project.internal.impl.MapImpl.getBounds(MapImpl.java:676)
> 	at
> net.refractions.udig.project.internal.impl.InitMapBoundsInterceptor.run(InitMapBoundsInterceptor.java:43)
> 	at
> net.refractions.udig.project.internal.impl.LayersList2.runNonDeprecatedInterceptors(LayersList2.java:200)
> 	at
> net.refractions.udig.project.internal.impl.LayersList2.runLayerInterceptor(LayersList2.java:187)
> 	at
> net.refractions.udig.project.internal.impl.LayersList2.runAddInterceptors(LayersList2.java:174)
> 	at
> net.refractions.udig.project.internal.impl.LayersList2.inverseAdd(LayersList2.java:102)
> 	at
> org.eclipse.emf.common.notify.impl.NotifyingListImpl.addUnique(NotifyingListImpl.java:292)
> 	at
> org.eclipse.emf.ecore.xmi.impl.XMLHelperImpl.setValue(XMLHelperImpl.java:1179)
> 	at
> org.eclipse.emf.ecore.xmi.impl.XMLHandler.setFeatureValue(XMLHandler.java:2657)
> 	at
> org.eclipse.emf.ecore.xmi.impl.XMLHandler.setFeatureValue(XMLHandler.java:2647)
> 	at
> org.eclipse.emf.ecore.xmi.impl.XMLHandler.createObjectFromFeatureType(XMLHandler.java:2166)
> 	at
> org.eclipse.emf.ecore.xmi.impl.XMLHandler.createObject(XMLHandler.java:2034)
> 	at
> org.eclipse.emf.ecore.xmi.impl.XMIHandler.createObject(XMIHandler.java:134)
> 	at
> org.eclipse.emf.ecore.xmi.impl.XMLHandler.handleFeature(XMLHandler.java:1839)
> 	at
> org.eclipse.emf.ecore.xmi.impl.XMLHandler.processElement(XMLHandler.java:1023)
> 	at
> org.eclipse.emf.ecore.xmi.impl.XMIHandler.processElement(XMIHandler.java:87)
> 	at
> org.eclipse.emf.ecore.xmi.impl.XMLHandler.startElement(XMLHandler.java:1001)
> 	at
> org.eclipse.emf.ecore.xmi.impl.XMLHandler.startElement(XMLHandler.java:712)
> 	at
> org.eclipse.emf.ecore.xmi.impl.XMIHandler.startElement(XMIHandler.java:169)
> 	at
> com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startElement(Unknown Source)
> 	at
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source)
> 	at
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl
> $FragmentContentDriver.next(Unknown Source)
> 	at
> com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source)
> 	at
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
> 	at
> com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
> 	at
> com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
> 	at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown
> Source)
> 	at
> com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source)
> 	at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl
> $JAXPSAXParser.parse(Unknown Source)
> 	at javax.xml.parsers.SAXParser.parse(Unknown Source)
> 	at
> org.eclipse.emf.ecore.xmi.impl.XMLLoadImpl.load(XMLLoadImpl.java:181)
> 	at
> org.eclipse.emf.ecore.xmi.impl.XMLResourceImpl.doLoad(XMLResourceImpl.java:180)
> 	at
> org.eclipse.emf.ecore.resource.impl.ResourceImpl.load(ResourceImpl.java:1494)
> 	at
> org.eclipse.emf.ecore.resource.impl.ResourceImpl.load(ResourceImpl.java:1282)
> 	at
> org.eclipse.emf.ecore.resource.impl.ResourceSetImpl.demandLoad(ResourceSetImpl.java:255)
> 	at
> org.eclipse.emf.ecore.resource.impl.ResourceSetImpl.demandLoadHelper(ResourceSetImpl.java:270)
> 	at
> org.eclipse.emf.ecore.resource.impl.ResourceSetImpl.getResource(ResourceSetImpl.java:397)
> 	at
> org.eclipse.emf.ecore.resource.impl.ResourceSetImpl.getEObject(ResourceSetImpl.java:216)
> 	at org.eclipse.emf.ecore.util.EcoreUtil.resolve(EcoreUtil.java:202)
> 	at org.eclipse.emf.ecore.util.EcoreUtil.resolve(EcoreUtil.java:262)
> 	at
> org.eclipse.emf.ecore.impl.BasicEObjectImpl.eResolveProxy(BasicEObjectImpl.java:1475)
> 	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 java.util.Collections$UnmodifiableCollection$1.next(Unknown Source)
> 	at
> net.refractions.udig.project.internal.commands.CreateMapCommand.nameTaken(CreateMapCommand.java:115)
> 	at
> net.refractions.udig.project.internal.commands.CreateMapCommand.run(CreateMapCommand.java:79)
> 	at net.refractions.udig.project.command.CommandManager
> $Executor.execute(CommandManager.java:400)
> 	at net.refractions.udig.project.command.CommandManager
> $Executor.run(CommandManager.java:325)
> 	at net.refractions.udig.project.command.CommandManager
> $Executor.run(CommandManager.java:311)
> 	at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
> Caused by: java.lang.NullPointerException
> 	at
> org.geotools.jdbc.JDBCDataStore.createConnection(JDBCDataStore.java:1420)
> 	at
> org.geotools.jdbc.JDBCDataStore.getConnection(JDBCDataStore.java:1377)
> 	at
> org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:473)
> 	... 62 more
> 
> !ENTRY net.refractions.udig.project 1 0 2010-07-01 07:24:48.896
> !MESSAGE MapImpl#getDefaultBounds(): Returning valid area of EPSG:NAD83
> 
> !ENTRY net.refractions.udig.project 1 0 2010-07-01 07:24:48.966
> !MESSAGE MapImpl#getDefaultBounds(): Returning valid area of EPSG:NAD83
> 
> !ENTRY net.refractions.udig.catalog 2 0 2010-07-01 07:24:49.099
> !MESSAGE Error while getting the bounds of a layer
> !STACK 0
> java.lang.RuntimeException: java.lang.NullPointerException
> 	at
> org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:484)
> 	at
> org.geotools.jdbc.JDBCFeatureStore.getBoundsInternal(JDBCFeatureStore.java:178)
> 	at
> org.geotools.data.store.ContentFeatureSource.getBounds(ContentFeatureSource.java:366)
> 	at
> org.geotools.data.store.ContentFeatureSource.getBounds(ContentFeatureSource.java:338)
> 	at
> net.refractions.udig.catalog.PostgisResourceInfo.getBounds(PostgisResourceInfo.java:76)
> 	at
> net.refractions.udig.project.internal.impl.GeoResourceInfoInterceptor
> $Wrapper.getBounds(GeoResourceInfoInterceptor.java:68)
> 	at
> net.refractions.udig.project.internal.impl.LayerImpl.obtainBoundsFromResources(LayerImpl.java:2014)
> 	at
> net.refractions.udig.project.internal.impl.LayerImpl.getBounds(LayerImpl.java:1985)
> 	at
> net.refractions.udig.project.internal.impl.MapImpl.getBounds(MapImpl.java:676)
> 	at
> net.refractions.udig.project.internal.impl.InitMapBoundsInterceptor.run(InitMapBoundsInterceptor.java:43)
> 	at
> net.refractions.udig.project.internal.impl.LayersList2.runNonDeprecatedInterceptors(LayersList2.java:200)
> 	at
> net.refractions.udig.project.internal.impl.LayersList2.runLayerInterceptor(LayersList2.java:187)
> 	at
> net.refractions.udig.project.internal.impl.LayersList2.runAddInterceptors(LayersList2.java:174)
> 	at
> net.refractions.udig.project.internal.impl.LayersList2.inverseAdd(LayersList2.java:102)
> 	at
> org.eclipse.emf.common.notify.impl.NotifyingListImpl.addUnique(NotifyingListImpl.java:292)
> 	at
> org.eclipse.emf.ecore.xmi.impl.XMLHelperImpl.setValue(XMLHelperImpl.java:1179)
> 	at
> org.eclipse.emf.ecore.xmi.impl.XMLHandler.setFeatureValue(XMLHandler.java:2657)
> 	at
> org.eclipse.emf.ecore.xmi.impl.XMLHandler.setFeatureValue(XMLHandler.java:2647)
> 	at
> org.eclipse.emf.ecore.xmi.impl.XMLHandler.createObjectFromFeatureType(XMLHandler.java:2166)
> 	at
> org.eclipse.emf.ecore.xmi.impl.XMLHandler.createObject(XMLHandler.java:2034)
> 	at
> org.eclipse.emf.ecore.xmi.impl.XMIHandler.createObject(XMIHandler.java:134)
> 	at
> org.eclipse.emf.ecore.xmi.impl.XMLHandler.handleFeature(XMLHandler.java:1839)
> 	at
> org.eclipse.emf.ecore.xmi.impl.XMLHandler.processElement(XMLHandler.java:1023)
> 	at
> org.eclipse.emf.ecore.xmi.impl.XMIHandler.processElement(XMIHandler.java:87)
> 	at
> org.eclipse.emf.ecore.xmi.impl.XMLHandler.startElement(XMLHandler.java:1001)
> 	at
> org.eclipse.emf.ecore.xmi.impl.XMLHandler.startElement(XMLHandler.java:712)
> 	at
> org.eclipse.emf.ecore.xmi.impl.XMIHandler.startElement(XMIHandler.java:169)
> 	at
> com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startElement(Unknown Source)
> 	at
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source)
> 	at
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl
> $FragmentContentDriver.next(Unknown Source)
> 	at
> com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source)
> 	at
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
> 	at
> com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
> 	at
> com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
> 	at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown
> Source)
> 	at
> com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source)
> 	at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl
> $JAXPSAXParser.parse(Unknown Source)
> 	at javax.xml.parsers.SAXParser.parse(Unknown Source)
> 	at
> org.eclipse.emf.ecore.xmi.impl.XMLLoadImpl.load(XMLLoadImpl.java:181)
> 	at
> org.eclipse.emf.ecore.xmi.impl.XMLResourceImpl.doLoad(XMLResourceImpl.java:180)
> 	at
> org.eclipse.emf.ecore.resource.impl.ResourceImpl.load(ResourceImpl.java:1494)
> 	at
> org.eclipse.emf.ecore.resource.impl.ResourceImpl.load(ResourceImpl.java:1282)
> 	at
> org.eclipse.emf.ecore.resource.impl.ResourceSetImpl.demandLoad(ResourceSetImpl.java:255)
> 	at
> org.eclipse.emf.ecore.resource.impl.ResourceSetImpl.demandLoadHelper(ResourceSetImpl.java:270)
> 	at
> org.eclipse.emf.ecore.resource.impl.ResourceSetImpl.getResource(ResourceSetImpl.java:397)
> 	at
> org.eclipse.emf.ecore.resource.impl.ResourceSetImpl.getEObject(ResourceSetImpl.java:216)
> 	at org.eclipse.emf.ecore.util.EcoreUtil.resolve(EcoreUtil.java:202)
> 	at org.eclipse.emf.ecore.util.EcoreUtil.resolve(EcoreUtil.java:262)
> 	at
> org.eclipse.emf.ecore.impl.BasicEObjectImpl.eResolveProxy(BasicEObjectImpl.java:1475)
> 	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 java.util.Collections$UnmodifiableCollection$1.next(Unknown Source)
> 	at
> net.refractions.udig.project.internal.commands.CreateMapCommand.nameTaken(CreateMapCommand.java:115)
> 	at
> net.refractions.udig.project.internal.commands.CreateMapCommand.run(CreateMapCommand.java:79)
> 	at net.refractions.udig.project.command.CommandManager
> $Executor.execute(CommandManager.java:400)
> 	at net.refractions.udig.project.command.CommandManager
> $Executor.run(CommandManager.java:325)
> 	at net.refractions.udig.project.command.CommandManager
> $Executor.run(CommandManager.java:311)
> 	at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
> Caused by: java.lang.NullPointerException
> 	at
> org.geotools.jdbc.JDBCDataStore.createConnection(JDBCDataStore.java:1420)
> 	at
> org.geotools.jdbc.JDBCDataStore.getConnection(JDBCDataStore.java:1377)
> 	at
> org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:473)
> 	... 62 more
> 
> !ENTRY net.refractions.udig.project 1 0 2010-07-01 07:24:49.102
> !MESSAGE MapImpl#getDefaultBounds(): Returning valid area of EPSG:NAD83
> 
> !ENTRY net.refractions.udig.project 1 0 2010-07-01 07:24:49.137
> !MESSAGE MapImpl#getDefaultBounds(): Returning valid area of EPSG:NAD83
> 
> !ENTRY net.refractions.udig.project 1 0 2010-07-01 07:24:49.193
> !MESSAGE MapImpl#getDefaultBounds(): Returning valid area of EPSG:NAD83
> 
> !ENTRY net.refractions.udig.project 1 0 2010-07-01 07:24:50.420
> !MESSAGE MapImpl#getDefaultBounds(): Returning valid area of EPSG:NAD83
> 
> !ENTRY net.refractions.udig.ui 1 0 2010-07-01 07:24:51.629
> !MESSAGE 
> !STACK 0
> java.lang.NullPointerException
> 	at
> org.geotools.jdbc.JDBCDataStore.createConnection(JDBCDataStore.java:1420)
> 	at
> org.geotools.jdbc.JDBCDataStore.getConnection(JDBCDataStore.java:1377)
> 	at
> org.geotools.jdbc.JDBCFeatureSource.getCountInternal(JDBCFeatureSource.java:404)
> 	at
> org.geotools.data.store.ContentFeatureSource.getCount(ContentFeatureSource.java:409)
> 	at
> org.geotools.jdbc.JDBCFeatureStore.getCountInternal(JDBCFeatureStore.java:172)
> 	at
> org.geotools.data.store.ContentFeatureSource.getCount(ContentFeatureSource.java:409)
> 	at
> org.geotools.data.store.ContentFeatureCollection.size(ContentFeatureCollection.java:290)
> 	at
> org.geotools.feature.collection.DecoratingFeatureCollection.size(DecoratingFeatureCollection.java:168)
> 	at net.refractions.udig.ui.FeatureTableContentProvider
> $ContentLoader.setEnabled(FeatureTableContentProvider.java:344)
> 	at net.refractions.udig.ui.FeatureTableContentProvider
> $ContentLoader.run(FeatureTableContentProvider.java:243)
> 	at net.refractions.udig.ui.PlatformGIS$Runner.run(PlatformGIS.java:187)
> 	at net.refractions.udig.ui.PlatformGIS$Runner.run(PlatformGIS.java:212)
> 	at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
> 
> !ENTRY net.refractions.udig.ui 1 0 2010-07-01 07:24:51.629
> !MESSAGE Error loading features
> !STACK 0
> java.lang.NullPointerException
> 	at
> org.geotools.jdbc.JDBCDataStore.createConnection(JDBCDataStore.java:1420)
> 	at
> org.geotools.jdbc.JDBCDataStore.getConnection(JDBCDataStore.java:1377)
> 	at
> org.geotools.jdbc.JDBCFeatureSource.getCountInternal(JDBCFeatureSource.java:404)
> 	at
> org.geotools.data.store.ContentFeatureSource.getCount(ContentFeatureSource.java:409)
> 	at
> org.geotools.jdbc.JDBCFeatureStore.getCountInternal(JDBCFeatureStore.java:172)
> 	at
> org.geotools.data.store.ContentFeatureSource.getCount(ContentFeatureSource.java:409)
> 	at
> org.geotools.data.store.ContentFeatureCollection.size(ContentFeatureCollection.java:290)
> 	at
> org.geotools.feature.collection.DecoratingFeatureCollection.size(DecoratingFeatureCollection.java:168)
> 	at net.refractions.udig.ui.FeatureTableContentProvider
> $ContentLoader.setEnabled(FeatureTableContentProvider.java:344)
> 	at net.refractions.udig.ui.FeatureTableContentProvider
> $ContentLoader.run(FeatureTableContentProvider.java:243)
> 	at net.refractions.udig.ui.PlatformGIS$Runner.run(PlatformGIS.java:187)
> 	at net.refractions.udig.ui.PlatformGIS$Runner.run(PlatformGIS.java:212)
> 	at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
> 
> !ENTRY net.refractions.udig.project 2 0 2010-07-01 07:24:52.052
> !MESSAGE Problem rendering: Exception rendering layer
> DefaultMapLayer[ Test, VISIBLE, UNSELECTED,
> style=StyleImpl[ name=Default Styler],
> data=net.refractions.udig.project.internal.impl.UDIGFeatureStore@7fd6dad8, query=Query: [Request All Features]
>   feature type: null
>   filter: Filter.INCLUDE
>   [properties:  ALL ]]
> !STACK 0
> net.refractions.udig.project.render.RenderException: Problem rendering:
> Exception rendering layer DefaultMapLayer[ Test, VISIBLE, UNSELECTED,
> style=StyleImpl[ name=Default Styler],
> data=net.refractions.udig.project.internal.impl.UDIGFeatureStore@7fd6dad8, query=Query: [Request All Features]
>   feature type: null
>   filter: Filter.INCLUDE
>   [properties:  ALL ]]
> 	at
> net.refractions.udig.render.internal.feature.basic.BasicFeatureRenderer.render(BasicFeatureRenderer.java:378)
> 	at
> net.refractions.udig.render.internal.feature.basic.BasicFeatureRenderer.render(BasicFeatureRenderer.java:224)
> 	at
> net.refractions.udig.project.internal.render.impl.RenderJob.startRendering(RenderJob.java:108)
> 	at
> net.refractions.udig.project.internal.render.impl.RenderJob.run(RenderJob.java:213)
> 	at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
> Caused by: java.lang.Exception: Exception rendering layer
> DefaultMapLayer[ Test, VISIBLE, UNSELECTED,
> style=StyleImpl[ name=Default Styler],
> data=net.refractions.udig.project.internal.impl.UDIGFeatureStore@7fd6dad8, query=Query: [Request All Features]
>   feature type: null
>   filter: Filter.INCLUDE
>   [properties:  ALL ]]
> 	at
> org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:703)
> 	at
> org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:524)
> 	at
> net.refractions.udig.render.internal.feature.basic.BasicFeatureRenderer.render(BasicFeatureRenderer.java:350)
> 	... 4 more
> Caused by: java.lang.NullPointerException
> 	at
> org.geotools.jdbc.JDBCDataStore.createConnection(JDBCDataStore.java:1420)
> 	at
> org.geotools.jdbc.JDBCDataStore.getConnection(JDBCDataStore.java:1377)
> 	at
> org.geotools.jdbc.JDBCFeatureSource.getReaderInternal(JDBCFeatureSource.java:545)
> 	at
> org.geotools.jdbc.JDBCFeatureStore.getReaderInternal(JDBCFeatureStore.java:209)
> 	at
> org.geotools.data.store.ContentFeatureSource.getReader(ContentFeatureSource.java:481)
> 	at
> org.geotools.data.store.ContentFeatureCollection.iterator(ContentFeatureCollection.java:263)
> 	at
> org.geotools.renderer.lite.StreamingRenderer.drawOptimized(StreamingRenderer.java:1859)
> 	at
> org.geotools.renderer.lite.StreamingRenderer.processStylers(StreamingRenderer.java:1792)
> 	at
> org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:699)
> 	... 6 more
> !SESSION 2010-07-01 07:25:04.001
> -----------------------------------------------
> eclipse.buildId=unknown
> java.version=1.6.0_20
> java.vendor=Sun Microsystems Inc.
> BootLoader constants: OS=linux, ARCH=x86_64, WS=gtk, NL=en_US
> Command-line arguments:  -os linux -ws gtk -arch x86_64
> -data /home/davideps/uDigWorkspace
> 
> !ENTRY org.eclipse.osgi 2 1 2010-07-01 07:25:08.871
> !MESSAGE NLS missing message: cancel_description in:
> net.refractions.udig.ui.internal.messages
> 
> !ENTRY org.eclipse.osgi 2 1 2010-07-01 07:25:08.871
> !MESSAGE NLS missing message: cancel_tooltip in:
> net.refractions.udig.ui.internal.messages
> 
> !ENTRY org.eclipse.osgi 2 1 2010-07-01 07:25:08.871
> !MESSAGE NLS missing message: orientation_horizontal_description in:
> net.refractions.udig.ui.internal.messages
> 
> !ENTRY org.eclipse.osgi 2 1 2010-07-01 07:25:08.871
> !MESSAGE NLS missing message: orientation_horizontal_tooltip in:
> net.refractions.udig.ui.internal.messages
> 
> !ENTRY org.eclipse.osgi 2 1 2010-07-01 07:25:08.871
> !MESSAGE NLS missing message: orientation_vertical_description in:
> net.refractions.udig.ui.internal.messages
> 
> !ENTRY org.eclipse.osgi 2 1 2010-07-01 07:25:08.871
> !MESSAGE NLS missing message: orientation_vertical_tooltip in:
> net.refractions.udig.ui.internal.messages
> 
> !ENTRY org.eclipse.osgi 2 1 2010-07-01 07:25:08.871
> !MESSAGE NLS missing message: orientation_single_description in:
> net.refractions.udig.ui.internal.messages
> 
> !ENTRY org.eclipse.osgi 2 1 2010-07-01 07:25:08.871
> !MESSAGE NLS missing message: orientation_single_tooltip in:
> net.refractions.udig.ui.internal.messages
> 
> !ENTRY org.eclipse.osgi 2 1 2010-07-01 07:25:08.872
> !MESSAGE NLS missing message: orientation_automatic_description in:
> net.refractions.udig.ui.internal.messages
> 
> !ENTRY org.eclipse.osgi 2 1 2010-07-01 07:25:08.872
> !MESSAGE NLS missing message: orientation_automatic_tooltip in:
> net.refractions.udig.ui.internal.messages
> 
> !ENTRY net.refractions.udig.ui 1 0 2010-07-01 07:25:08.873
> !MESSAGE net.refractions.udig.ui.WorkbenchConfiguration
> "net.refractions.udig.internal.ui.UDIGWorkbenchConfiguration" specified
> but no valid extension found.
> Please check that the extension exists and that it is valid.
> 
> !ENTRY net.refractions.udig.ui 1 0 2010-07-01 07:25:08.978
> !MESSAGE net.refractions.udig.ui.MenuBuilder
> "net.refractions.udig.ui.uDigMenuBuilder" specified but no valid
> extension found.
> Please check that the extension exists and that it is valid.
> 
> !ENTRY net.refractions.udig.ui 1 0 2010-07-01 07:25:09.274
> !MESSAGE EnablementUtil: Expected child of
> net.refractions.udig.render.wms.basic.operation but didn't find one...
> 
> !ENTRY net.refractions.udig.catalog.imageio 2 0 2010-07-01 07:25:09.862
> !MESSAGE GDAL Not Available ... some image formats disabled: 
> Expected environment variable resolve to:
> 
> LD_LIBRARY_PATH=/home/davideps/Software/udig/jre/lib/amd64/server:/home/davideps/Software/udig/jre/lib/amd64:/home/davideps/Software/udig/jre/../lib/amd64:/usr/lib64/xulrunner-addons
> 	DYLD_LIBRARY_PATH=null
> 	GDAL_DATA=/home/davideps/Software/udig/gdal_data
> 
> java.libary.path=/home/davideps/Software/udig/jre/lib/amd64/server:/home/davideps/Software/udig/jre/lib/amd64:/home/davideps/Software/udig/jre/../lib/amd64:/usr/lib64/xulrunner-addons:/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
> 
> 
> !ENTRY net.refractions.udig.project 1 0 2010-07-01 07:26:07.704
> !MESSAGE Layer: county99_table could not find a GeoResource with
> id:jdbc.postgis://postgres:postgres@localhost:5432/US_National#county99_table
> 
> !ENTRY net.refractions.udig.project 1 0 2010-07-01 07:26:31.538
> !MESSAGE After 2 seconds unable to cancel county99 pg Renderer
> 
> !ENTRY net.refractions.udig.project 1 0 2010-07-01 07:26:31.539
> !MESSAGE After 2 seconds unable to cancel All Layers Renderer
> 
> !ENTRY net.refractions.udig.project 1 0 2010-07-01 07:26:38.247
> !MESSAGE After 2 seconds unable to cancel county99 pg Renderer
> 
> !ENTRY net.refractions.udig.project 1 0 2010-07-01 07:26:38.247
> !MESSAGE After 2 seconds unable to cancel All Layers Renderer
> 
> !ENTRY net.refractions.udig.project 1 0 2010-07-01 07:28:15.115
> !MESSAGE After 2 seconds unable to cancel county99 pg Renderer
> 
> !ENTRY net.refractions.udig.project 1 0 2010-07-01 07:28:15.115
> !MESSAGE After 2 seconds unable to cancel All Layers Renderer
> 
> !ENTRY net.refractions.udig.project 1 0 2010-07-01 07:28:15.965
> !MESSAGE After 2 seconds unable to cancel county99 pg Renderer
> 
> !ENTRY net.refractions.udig.project 1 0 2010-07-01 07:28:29.520
> !MESSAGE After 2 seconds unable to cancel county99 pg Renderer
> 
> !ENTRY net.refractions.udig.project 1 0 2010-07-01 07:28:29.520
> !MESSAGE After 2 seconds unable to cancel All Layers Renderer
> 
> !ENTRY net.refractions.udig.project 1 0 2010-07-01 07:28:35.733
> !MESSAGE After 2 seconds unable to cancel county99 pg Renderer
> 
> !ENTRY net.refractions.udig.project 1 0 2010-07-01 07:28:35.734
> !MESSAGE After 2 seconds unable to cancel All Layers Renderer
> 
> !ENTRY net.refractions.udig.project 1 0 2010-07-01 07:28:38.222
> !MESSAGE After 2 seconds unable to cancel county99 pg Renderer
> 
> !ENTRY net.refractions.udig.project 1 0 2010-07-01 07:28:40.877
> !MESSAGE After 2 seconds unable to cancel county99 pg Renderer
> 
> !ENTRY net.refractions.udig.project 1 0 2010-07-01 07:28:40.877
> !MESSAGE After 2 seconds unable to cancel All Layers Renderer
> 
> !ENTRY net.refractions.udig.project 1 0 2010-07-01 07:29:41.090
> !MESSAGE After 2 seconds unable to cancel County99 d00 Renderer
> 
> !ENTRY net.refractions.udig.project 1 0 2010-07-01 07:29:41.182
> !MESSAGE After 2 seconds unable to cancel county99 pg Renderer
> 
> !ENTRY net.refractions.udig.project 1 0 2010-07-01 07:29:41.182
> !MESSAGE After 2 seconds unable to cancel All Layers Renderer
> 
> !ENTRY net.refractions.udig.project 1 0 2010-07-01 07:29:41.264
> !MESSAGE After 2 seconds unable to cancel county99 pg Renderer
> 
> !ENTRY net.refractions.udig.project 1 0 2010-07-01 07:29:41.264
> !MESSAGE After 2 seconds unable to cancel All Layers Renderer
> 
> !ENTRY net.refractions.udig.project 1 0 2010-07-01 07:30:02.499
> !MESSAGE After 2 seconds unable to cancel county99 pg Renderer
> 
> !ENTRY net.refractions.udig.project 1 0 2010-07-01 07:30:02.499
> !MESSAGE After 2 seconds unable to cancel All Layers Renderer
> 
> !ENTRY net.refractions.udig.project 1 0 2010-07-01 07:30:20.151
> !MESSAGE After 2 seconds unable to cancel county99 pg Renderer
> 
> !ENTRY net.refractions.udig.project 1 0 2010-07-01 07:30:20.151
> !MESSAGE After 2 seconds unable to cancel All Layers Renderer
> 
> !ENTRY net.refractions.udig.project 1 0 2010-07-01 07:30:20.785
> !MESSAGE After 2 seconds unable to cancel county99 pg Renderer
> 
>
References:
- Re: [udig-users] Trouble connecting with JDBCDataStore
  - From: Jody Garnett
Prev by Date: Re: [udig-users] Trouble connecting with JDBCDataStore
Next by Date: [udig-users] PostGIS Views not showing in uDIG
Previous by thread: Re: [udig-users] Trouble connecting with JDBCDataStore
Next by thread: [udig-users] PostGIS Views not showing in uDIG
Index(es):
- Date
- Thread
Breadcrumbs
