GeoPackage error

[Stefan Ziegler]

Hi 

I get an error when trying to save a postgis layer to geopackage:

Caught: java.io.IOException: Error occurred creating table

java.io.IOException: Error occurred creating table

at org.geotools.jdbc.JDBCDataStore.createSchema(JDBCDataStore.java:714)

at org.geotools.jdbc.JDBCDataStore$createSchema.call(Unknown Source)

at geoscript.workspace.Workspace.create(Workspace.groovy:121)

at geoscript.workspace.Workspace$create$3.callCurrent(Unknown Source)

at geoscript.workspace.Workspace.create(Workspace.groovy:111)

at geoscript.workspace.Workspace$create$2.callCurrent(Unknown Source)

at geoscript.workspace.Workspace.add(Workspace.groovy:150)

at geoscript.workspace.Workspace.add(Workspace.groovy)

at geoscript.workspace.Workspace$add$1.callCurrent(Unknown Source)

at geoscript.workspace.Workspace.add(Workspace.groovy:131)

at geoscript.workspace.Workspace$add$0.call(Unknown Source)

at export.run(export.groovy:13)

Caused by: java.lang.RuntimeException: Unable to map stand_am( java.sql.Date)

at org.geotools.jdbc.JDBCDataStore.createTableSQL(JDBCDataStore.java:2061)

at org.geotools.jdbc.JDBCDataStore.createSchema(JDBCDataStore.java:700)

... 11 more

"stand_am" is a postgresql date type. I'm using GeoScript master on Ubuntu 12.04 with Java7.

A GeoTools problem?

regards

Stefan

[jericks]

Yep, this is a GeoTools issue.  Can you bring this up on the GeoTools users list?  In the meantime, you can use the PostGIS.createView(layerName, SQL, geometryField) method to select a subset of Fields.  The GeoPackage Workspace is pretty new, so it's cool that your using it already.   Let us know how it goes!

Jared