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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
