Hi list, we are currently testing the Oracle-integration in Geoserver via Oracle OCI.
Our Geoserver-Version is 2.1.3, the Oracle-Database is 10.2.0.3. The Oracle instant-client is installed on the machine where Geoserver resides. SQL-plus is working without problems but the same cannot be said for Geoserver. Here is what happens: - Creating the new Oracle-OCI-store with alias, schema and the other connection-params works without problems - When we try to create a new layer based on this store, the tables for the defined schema are listed, but when we click on "Publish" for a spatial table the following error occurs: For non-spatial tables the publish-form is displayed normally. Does anyone have a clue where the reason for this behavior could be? Another user has posted a similar problem here: http://osgeo-org.1560.n6.nabble.com/getting-data-from-OracleDB-in-production-td3801495.html#a3801496 where the solution seemed to be that you have to connect to the database with the credentials of the schema-owner to make it work. Unfortunately I donĀ“t have those credentials but apart from that: Is that the real reason for the problems? Best regards and thanks in advance Max Stephan -- View this message in context: http://osgeo-org.1560.n6.nabble.com/Layer-publishing-from-Oracle-OCI-not-working-with-Geoserver-2-1-3-tp4663532p4663532.html Sent from the GeoServer - User mailing list archive at Nabble.com. ------------------------------------------------------------------------------ This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users