[Geotools-gt2-users] Failed to connect to the EPSG database

[Matthias L. <mat...@gf...>]

Hi,

A long time ago I had this before... but I cannot remember. What's 
happening here and how can I get rid of this EPSG database exception?

My application gets ashapefile and does some intersection processing 
with other spatial data in a postgis db. All data in EPSG 4326.


Many thanks in advance

Matthias

13.08.2011 11:56:08 
org.geotools.referencing.factory.epsg.ThreadedPostgreSQLEpsgFactory 
isAvailable
WARNUNG: Unavailable authority factory: European Petroleum Survey Group
org.opengis.referencing.FactoryException: Failed to connect to the EPSG 
database.
	at 
org.geotools.referencing.factory.epsg.ThreadedEpsgFactory.createBackingStore(ThreadedEpsgFactory.java:420)
	at 
org.geotools.referencing.factory.DeferredAuthorityFactory.getBackingStore(DeferredAuthorityFactory.java:130)
	at 
org.geotools.referencing.factory.BufferedAuthorityFactory.isAvailable(BufferedAuthorityFactory.java:233)
	at 
org.geotools.referencing.factory.DeferredAuthorityFactory.isAvailable(DeferredAuthorityFactory.java:117)
	at 
org.geotools.factory.FactoryRegistry.isAvailable(FactoryRegistry.java:668)
	at 
org.geotools.factory.FactoryRegistry.isAcceptable(FactoryRegistry.java:500)
	at org.geotools.factory.FactoryRegistry$1.filter(FactoryRegistry.java:191)
	at javax.imageio.spi.FilterIterator.advance(Unknown Source)
	at javax.imageio.spi.FilterIterator.<init>(Unknown Source)
	at javax.imageio.spi.ServiceRegistry.getServiceProviders(Unknown Source)
	at 
org.geotools.factory.FactoryRegistry.getServiceProviders(FactoryRegistry.java:196)
	at 
org.geotools.referencing.ReferencingFactoryFinder.getFactories(ReferencingFactoryFinder.java:176)
	at 
org.geotools.referencing.ReferencingFactoryFinder.getCRSAuthorityFactories(ReferencingFactoryFinder.java:451)
	at 
org.geotools.referencing.DefaultAuthorityFactory.getBackingFactory(DefaultAuthorityFactory.java:88)
	at 
org.geotools.referencing.DefaultAuthorityFactory.<init>(DefaultAuthorityFactory.java:69)
	at org.geotools.referencing.CRS.getAuthorityFactory(CRS.java:199)
	at org.geotools.referencing.CRS.decode(CRS.java:437)
	at org.geotools.referencing.CRS.decode(CRS.java:365)
	at org.geotools.jdbc.SQLDialect.createCRS(SQLDialect.java:530)
	at 
org.geotools.jdbc.JDBCFeatureSource.buildFeatureType(JDBCFeatureSource.java:299)
	at 
org.geotools.jdbc.JDBCDataStore.createFeatureSource(JDBCDataStore.java:712)
	at 
org.geotools.data.store.ContentDataStore.getFeatureSource(ContentDataStore.java:383)
	at 
org.geotools.data.store.ContentDataStore.getFeatureSource(ContentDataStore.java:348)
	at 
org.geotools.data.store.ContentDataStore.getFeatureSource(ContentDataStore.java:101)
	at 
org.fosslab.geotools.FeatureCollectionFactory.getFeatureCollectionFromPostgis(FeatureCollectionFactory.java:207)
	at 
org.fosslab.process.gcap.internal.PostGisWrapper.getFeatureCollection(PostGisWrapper.java:105)
	at 
org.fosslab.process.aais.processes.AreaClassifier.process(AreaClassifier.java:246)
	at 
org.fosslab.process.aais.processes.AreaClassifier.process(AreaClassifier.java:128)
	at 
org.fosslab.process.aais.test.sdi_tridec_tr.AreaClassifierTest.testL0PostgisZippedURL4Martin(AreaClassifierTest.java:605)
	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.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
	at 
org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
	at 
org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
	at 
org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
	at 
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:76)
	at 
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
	at 
org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:49)
	at 
org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
	at 
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
	at 
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
	at 
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
	at 
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
Caused by: org.postgresql.util.PSQLException: Verbindung verweigert. 
Überprüfen Sie die Korrektheit von Hostnamen und der Portnummer und dass 
der Datenbankserver TCP/IP-Verbindungen annimmt.
	at 
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:136)
	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 java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at 
org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:87)
	at 
org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:70)
	at 
org.geotools.referencing.factory.epsg.DirectEpsgFactory.getConnection(DirectEpsgFactory.java:3077)
	at 
org.geotools.referencing.factory.epsg.ThreadedEpsgFactory.createBackingStore(ThreadedEpsgFactory.java:415)
	... 50 more
Caused by: java.net.ConnectException: Connection refused: connect
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.PlainSocketImpl.doConnect(Unknown Source)
	at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
	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)
	... 62 more