Hi all,
I’m using geoserver 1.6.4 to connect to an Oracle Spatial 9.2 datastore.
I can create a datastore properly, and when I want to create a feature type from an spatial table, it doesn’t load.
The tomcat console is frozen and my geoserver too, no error logs anywhere.
Geoserver starts thinking and never loads my featuretype.
The database is properly configured, so I can query spatial sentences from SQLplus.
Any hint?
Thank you in advance
Patrick O'Brian ha scritto:
Hi all,
I'm using geoserver 1.6.4 to connect to an Oracle Spatial 9.2 datastore.
I can create a datastore properly, and when I want to create a feature type from an spatial table, it doesn't load.
The tomcat console is frozen and my geoserver too, no error logs anywhere.
Geoserver starts thinking and never loads my featuretype.The database is properly configured, so I can query spatial sentences from SQLplus.
Any hint?
Try to enable full logging, and then look at the console or the error
log while GeoServer is trying to configure the feature type.
See anything interesting in the logs?
Cheers
Andrea
The log is stuck at:
04 jun 20:36:45 DEBUG [data.oracle] - returning true for tablename: EQUIPMENT
04 jun 20:36:48 TRACE [data.jdbc] - Unknown SQL Type: LONG RAW
04 jun 20:36:48 DEBUG [data.oracle] - the sql statement for srid is SELECT SRID FROM MDSYS.ALL_SDO_GEOM_METADATA WHERE TABLE_NAME=‘X_CENTER’ AND COLUMN_NAME=‘GEOMETRY1’
and the same sentence in SQLplus is executed in 878ms…
2008/6/4 Andrea Aime <aaime@anonymised.com>:
Patrick O’Brian ha scritto:
Hi all,
I’m using geoserver 1.6.4 to connect to an Oracle Spatial 9.2 datastore.
I can create a datastore properly, and when I want to create a feature type from an spatial table, it doesn’t load.
The tomcat console is frozen and my geoserver too, no error logs anywhere.
Geoserver starts thinking and never loads my featuretype.The database is properly configured, so I can query spatial sentences from SQLplus.
Any hint?
Try to enable full logging, and then look at the console or the error
log while GeoServer is trying to configure the feature type.
See anything interesting in the logs?Cheers
Andrea
I’ve digged in the problem, every user needs select grant on MDSYS.ALL_SDO_GEOM_METADATA… but it has and can’t access data…
It seems to be an oracle spatial configuration problem, not geoserver’s…
I’ll post with the solution…
thanks
2008/6/4 Patrick O’Brian <paddyobrian79@anonymised.com>:
The log is stuck at:
04 jun 20:36:45 DEBUG [data.oracle] - returning true for tablename: EQUIPMENT
04 jun 20:36:48 TRACE [data.jdbc] - Unknown SQL Type: LONG RAW
04 jun 20:36:48 DEBUG [data.oracle] - the sql statement for srid is SELECT SRID FROM MDSYS.ALL_SDO_GEOM_METADATA WHERE TABLE_NAME=‘X_CENTER’ AND COLUMN_NAME=‘GEOMETRY1’and the same sentence in SQLplus is executed in 878ms…
2008/6/4 Andrea Aime <aaime@anonymised.com>:
Patrick O’Brian ha scritto:
Hi all,
I’m using geoserver 1.6.4 to connect to an Oracle Spatial 9.2 datastore.
I can create a datastore properly, and when I want to create a feature type from an spatial table, it doesn’t load.
The tomcat console is frozen and my geoserver too, no error logs anywhere.
Geoserver starts thinking and never loads my featuretype.The database is properly configured, so I can query spatial sentences from SQLplus.
Any hint?
Try to enable full logging, and then look at the console or the error
log while GeoServer is trying to configure the feature type.
See anything interesting in the logs?Cheers
Andrea
Finally, it was an Oracle Spatial problem.
The view was corrupt… we had to drop and build it again…
Hope it helps…
2008/6/4 Patrick O’Brian <paddyobrian79@anonymised.com>:
I’ve digged in the problem, every user needs select grant on MDSYS.ALL_SDO_GEOM_METADATA… but it has and can’t access data…
It seems to be an oracle spatial configuration problem, not geoserver’s…
I’ll post with the solution…
thanks
2008/6/4 Patrick O’Brian <paddyobrian79@anonymised.com>:
The log is stuck at:
04 jun 20:36:45 DEBUG [data.oracle] - returning true for tablename: EQUIPMENT
04 jun 20:36:48 TRACE [data.jdbc] - Unknown SQL Type: LONG RAW
04 jun 20:36:48 DEBUG [data.oracle] - the sql statement for srid is SELECT SRID FROM MDSYS.ALL_SDO_GEOM_METADATA WHERE TABLE_NAME=‘X_CENTER’ AND COLUMN_NAME=‘GEOMETRY1’and the same sentence in SQLplus is executed in 878ms…
2008/6/4 Andrea Aime <aaime@anonymised.com>:
Patrick O’Brian ha scritto:
Hi all,
I’m using geoserver 1.6.4 to connect to an Oracle Spatial 9.2 datastore.
I can create a datastore properly, and when I want to create a feature type from an spatial table, it doesn’t load.
The tomcat console is frozen and my geoserver too, no error logs anywhere.
Geoserver starts thinking and never loads my featuretype.The database is properly configured, so I can query spatial sentences from SQLplus.
Any hint?
Try to enable full logging, and then look at the console or the error
log while GeoServer is trying to configure the feature type.
See anything interesting in the logs?Cheers
Andrea