[Geotools-gt2-users] org.opengis.referencing.FactoryException while decoding CRS

Mon, 19 Aug 2019 12:59:41 -0700 

      I get the following exception when I attempt to execute
org.geotools.referencing.CRS.decode(String):

org.opengis.referencing.FactoryException: Database failure while creating a
'Datum' object for code "6269".
      at
org.geotools.referencing.factory.epsg.DirectEpsgFactory.databaseFailure(DirectEpsgFactory.java:3348)
      at
org.geotools.referencing.factory.epsg.DirectEpsgFactory.createDatum(DirectEpsgFactory.java:1737)
      at
org.geotools.referencing.factory.AbstractAuthorityFactory.createGeodeticDatum(AbstractAuthorityFactory.java:251)
      at
org.geotools.referencing.factory.BufferedAuthorityFactory.createGeodeticDatum(BufferedAuthorityFactory.java:459)
      at
org.geotools.referencing.factory.epsg.DirectEpsgFactory.createCoordinateReferenceSystem(DirectEpsgFactory.java:2113)
      at
org.geotools.referencing.factory.AbstractAuthorityFactory.createGeographicCRS(AbstractAuthorityFactory.java:601)
      at
org.geotools.referencing.factory.BufferedAuthorityFactory.createGeographicCRS(BufferedAuthorityFactory.java:809)
      at
org.geotools.referencing.factory.epsg.DirectEpsgFactory.createCoordinateReferenceSystem(DirectEpsgFactory.java:2138)
      at
org.geotools.referencing.factory.BufferedAuthorityFactory.createCoordinateReferenceSystem(BufferedAuthorityFactory.java:731)
      at
org.geotools.referencing.factory.AuthorityFactoryAdapter.createCoordinateReferenceSystem(AuthorityFactoryAdapter.java:779)
      at
org.geotools.referencing.factory.FallbackAuthorityFactory.createCoordinateReferenceSystem(FallbackAuthorityFactory.java:624)
      at
org.geotools.referencing.factory.AuthorityFactoryAdapter.createCoordinateReferenceSystem(AuthorityFactoryAdapter.java:779)
      at
org.geotools.referencing.factory.ThreadedAuthorityFactory.createCoordinateReferenceSystem(ThreadedAuthorityFactory.java:635)
      at
org.geotools.referencing.DefaultAuthorityFactory.createCoordinateReferenceSystem(DefaultAuthorityFactory.java:176)
      at org.geotools.referencing.CRS.decode(CRS.java:517)
      at org.geotools.referencing.CRS.decode(CRS.java:433)
      at main.Main.<init>(Main.java:21)
      at main.Main.main(Main.java:100)
Caused by: java.sql.SQLSyntaxErrorException: incompatible data type in
conversion: from SQL type INTEGER to java.sql.Date, value: 1986
      at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
      at org.hsqldb.jdbc.JDBCUtil.throwError(Unknown Source)
      at org.hsqldb.jdbc.JDBCResultSet.getColumnInType(Unknown Source)
      at org.hsqldb.jdbc.JDBCResultSet.getDate(Unknown Source)
      at
org.geotools.referencing.factory.epsg.DirectEpsgFactory.createDatum(DirectEpsgFactory.java:1674)
      ... 19 more
Caused by: org.hsqldb.HsqlException: incompatible data type in conversion:
from SQL type INTEGER to java.sql.Date, value: 1986
     at org.hsqldb.error.Error.error(Unknown Source)
     at org.hsqldb.error.Error.error(Unknown Source)
      ... 22 more

I've been trying to use EPSG:26918, but appears to occur with any EPSG
SRID. I've been executing it like: CRS.decode("EPSG:26918").

Here's the relevant section of my pom:
 <properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<geotools.version>22-SNAPSHOT</geotools.version>
</properties>
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.11</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.geotools</groupId>
<artifactId>gt-shapefile</artifactId>
<version>${geotools.version}</version>
</dependency>
<dependency>
<groupId>org.geotools</groupId>
<artifactId>gt-swing</artifactId>
<version>${geotools.version}</version>
</dependency>
<dependency>
<groupId>com.google.code.gson</groupId>
<artifactId>gson</artifactId>
<version>2.8.5</version>
</dependency>
<dependency>
<groupId>net.postgis</groupId>
<artifactId>postgis-jdbc</artifactId>
<version>2.3.0</version>
</dependency>
<dependency>
<groupId>org.geotools</groupId>
<artifactId>gt-grid</artifactId>
<version>${geotools.version}</version>
</dependency>
<dependency>
<groupId>org.geotools</groupId>
<artifactId>gt-epsg-hsql</artifactId>
<version>21.2</version>
</dependency>
</dependencies>
<repositories>
<repository>
<id>maven2-repository.dev.java.net</id>
<name>Java.net repository</name>
<url>http://download.java.net/maven/2</url>
</repository>
<repository>
<id>osgeo</id>
<name>Open Source Geospatial Foundation Repository</name>
<url>http://download.osgeo.org/webdav/geotools/</url>
</repository>
<repository>
<snapshots>
<enabled>true</enabled>
</snapshots>
<id>boundless</id>
<name>Boundless Maven Repository</name>
<url>https://boundless.artifactoryonline.com/boundless/main</url>
</repository>
</repositories>
<build>
<plugins>
<plugin>
<inherited>true</inherited>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<version>2.5</version>
<configuration>
<source>1.8</source>
<target>1.8</target>
</configuration>
</plugin>
</plugins>
</build>

Any help with this would be greatly appreciated.

_______________________________________________
GeoTools-GT2-Users mailing list
GeoTools-GT2-Users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users






















					Reply via email to