Hi,
The documentation of the importer extension does not promise that it works with Oracle but because the Oracle stores are selectable in the UI I had a try. I tried to import geoserver_data\data\shapefiles and the result with the states shapefile is as follows. " virhe suoritettaessa herätintä" means "error when executing trigger". I am on Windows and playing with GS 2.5-beta.
By the way, it was not obvious for me that I cannot select states.shp but I need to select the directory that contains the shapefile.
java.io.IOException: Error occurred creating table
at org.geotools.jdbc.JDBCDataStore.createSchema(JDBCDataStore.java:707)
at org.geotools.jdbc.JDBCDataStore.createSchema(JDBCDataStore.java:142)
at org.geoserver.importer.Importer.loadIntoDataStore(Importer.java:989)
at org.geoserver.importer.Importer.doIndirectImport(Importer.java:859)
at org.geoserver.importer.Importer.run(Importer.java:731)
at org.geoserver.importer.Importer.run(Importer.java:681)
at org.geoserver.importer.Importer$4.call(Importer.java:757)
at org.geoserver.importer.Importer$4.call(Importer.java:754)
at org.geoserver.importer.job.Job.call(Job.java:15)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)
Caused by: java.sql.SQLException: ORA-13249: Only alphanumeric characters and "_" are allowed in SDO_DIMNAME
ORA-06512: "MDSYS.MD", line 1723
ORA-06512: "MDSYS.MDERR", line 17
ORA-06512: "MDSYS.CHK_SDO_DIMNAME", line 12
ORA-04088: virhe suoritettaessa herätintä 'MDSYS.CHK_SDO_DIMNAME'
ORA-06512: "MDSYS.SDO_GEOM_TRIG_INS1", line 43
ORA-04088: virhe suoritettaessa herätintä 'MDSYS.SDO_GEOM_TRIG_INS1'
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1687)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1653)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.geotools.data.oracle.OracleDialect.postCreateTable(OracleDialect.java:963)
at org.geotools.jdbc.JDBCDataStore.createSchema(JDBCDataStore.java:704)
... 13 more
-Jukka Rahkonen-
Hi Jukka,
yep, confirmed, it’s due to the axis names of the lat/lon coordinate system being the lambda symbol
instead of a ASCII name like “longitude”
Cheers
Andrea
···
On Tue, Jan 21, 2014 at 3:45 PM, Rahkonen Jukka (Tike) <jukka.rahkonen@anonymised.com> wrote:
Hi,
The documentation of the importer extension does not promise that it works with Oracle but because the Oracle stores are selectable in the UI I had a try. I tried to import geoserver_data\data\shapefiles and the result with the states shapefile is as follows. " virhe suoritettaessa herätintä" means “error when executing trigger”. I am on Windows and playing with GS 2.5-beta.
By the way, it was not obvious for me that I cannot select states.shp but I need to select the directory that contains the shapefile.
java.io.IOException: Error occurred creating table
at org.geotools.jdbc.JDBCDataStore.createSchema(JDBCDataStore.java:707)
at org.geotools.jdbc.JDBCDataStore.createSchema(JDBCDataStore.java:142)
at org.geoserver.importer.Importer.loadIntoDataStore(Importer.java:989)
at org.geoserver.importer.Importer.doIndirectImport(Importer.java:859)
at org.geoserver.importer.Importer.run(Importer.java:731)
at org.geoserver.importer.Importer.run(Importer.java:681)
at org.geoserver.importer.Importer$4.call(Importer.java:757)
at org.geoserver.importer.Importer$4.call(Importer.java:754)
at org.geoserver.importer.job.Job.call(Job.java:15)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)
Caused by: java.sql.SQLException: ORA-13249: Only alphanumeric characters and “_” are allowed in SDO_DIMNAME
ORA-06512: “MDSYS.MD”, line 1723
ORA-06512: “MDSYS.MDERR”, line 17
ORA-06512: “MDSYS.CHK_SDO_DIMNAME”, line 12
ORA-04088: virhe suoritettaessa herätintä ‘MDSYS.CHK_SDO_DIMNAME’
ORA-06512: “MDSYS.SDO_GEOM_TRIG_INS1”, line 43
ORA-04088: virhe suoritettaessa herätintä ‘MDSYS.SDO_GEOM_TRIG_INS1’
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1687)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1653)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.geotools.data.oracle.OracleDialect.postCreateTable(OracleDialect.java:963)
at org.geotools.jdbc.JDBCDataStore.createSchema(JDBCDataStore.java:704)
… 13 more
-Jukka Rahkonen-
CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments & Everything In Between.
Get a Quote or Start a Free Trial Today.
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
Geoserver-devel mailing list
Geoserver-devel@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
–
==
Meet us at GEO Business 2014! in London! Visit http://goo.gl/fES3aK
for more information.
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
On Sun, Mar 30, 2014 at 5:40 PM, Andrea Aime
<andrea.aime@anonymised.com>wrote:
Hi Jukka,
yep, confirmed, it's due to the axis names of the lat/lon coordinate
system being the lambda symbol
instead of a ASCII name like "longitude"
Fixed, along with a few other issues with the importer.
Want to give it another go using a nightly build? All the fixes have been
committed to 2.4.x
and 2.5.x too (you'll need tomorrow's nightly build btw)
Cheers
Andrea
--
Meet us at GEO Business 2014! in London! Visit http://goo.gl/fES3aK
for more information.
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------