-- Justin Deoliveira The Open Planning Project http://topp.openplans.org
--- Begin Message --->From [EMAIL PROTECTED] Fri Dec 23 03:07:08 2005 Return-path: <[EMAIL PROTECTED]> Received: from [10.9.9.15] (helo=odie.runbox.com) by fenris.runbox.com with esmtp (Exim 4.50) id 1EpcKq-0002pg-9Q for [EMAIL PROTECTED]; Fri, 23 Dec 2005 03:07:08 +0100 Received: from exim by odie.runbox.com with spamfilter (Exim 4.34) id 1EpcKo-0001HH-1I for [EMAIL PROTECTED]; Fri, 23 Dec 2005 03:07:07 +0100 Received: from [66.35.250.225] (helo=lists-outbound.sourceforge.net) by odie.runbox.com with esmtp (Exim 4.34) id 1EpcKn-0001HB-AX for [EMAIL PROTECTED]; Fri, 23 Dec 2005 03:07:05 +0100 Received: from sc8-sf-list2-b.sourceforge.net (sc8-sf-list2-b.sourceforge.net [10.3.1.8]) by sc8-sf-spam2.sourceforge.net (Postfix) with ESMTP id 7332E12FC9; Thu, 22 Dec 2005 18:07:04 -0800 (PST) Received: from sc8-sf-mx1-b.sourceforge.net ([10.3.1.91] helo=mail.sourceforge.net) by sc8-sf-list2.sourceforge.net with esmtp (Exim 4.30) id 1EpcJl-0001bt-LW; Thu, 22 Dec 2005 18:06:01 -0800 Received: from aibo.runbox.com ([193.71.199.94] helo=cujo.runbox.com) by mail.sourceforge.net with esmtps (TLSv1:DES-CBC3-SHA:168) (Exim 4.44) id 1EpcJi-0003ZT-Kd; Thu, 22 Dec 2005 18:06:01 -0800 Received: from [10.9.9.110] (helo=snoopy.runbox.com) by greyhound.runbox.com with esmtp (Exim 4.34) id 1EpcJb-0004Vx-BW; Fri, 23 Dec 2005 03:05:51 +0100 Received: from [24.68.154.216] (helo=[192.168.0.14]) by snoopy.runbox.com with asmtp (uid:525244 ) (Exim 4.34) id 1EpcJa-0005no-Q2; Fri, 23 Dec 2005 03:05:51 +0100 Message-ID: <[EMAIL PROTECTED]> From: Justin Deoliveira <[EMAIL PROTECTED]> User-Agent: Mozilla Thunderbird 1.0.6-1.1.fc4 (X11/20050720) X-Accept-Language: en-us, en MIME-Version: 1.0 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED], Geoserver-devel <[EMAIL PROTECTED]>, [EMAIL PROTECTED] References: <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> In-Reply-To: <[EMAIL PROTECTED]> Content-Type: multipart/mixed; boundary="------------070306040502030501030100" Subject: [Geoserver-users] Oracle Spatial multipolygon layer problem: / by zero Sender: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] X-BeenThere: [EMAIL PROTECTED] X-Mailman-Version: 2.0.9-sf.net Precedence: bulk List-Unsubscribe: <https://lists.sourceforge.net/lists/listinfo/geoserver-users>, <mailto:[EMAIL PROTECTED]> List-Id: Help for geoserver users <geoserver-users.lists.sourceforge.net> List-Post: <mailto:[EMAIL PROTECTED]> List-Help: <mailto:[EMAIL PROTECTED]> List-Subscribe: <https://lists.sourceforge.net/lists/listinfo/geoserver-users>, <mailto:[EMAIL PROTECTED]> List-Archive: <http://sourceforge.net/mailarchive/forum.php?forum=geoserver-users> Date: Thu, 22 Dec 2005 18:05:48 -0800 X-Spam-Checker-Version: SpamAssassin 3.0.2 (2004-11-16) on odie.runbox.com X-Spam-Status: No, score=0.0 required=5.0 tests=none autolearn=disabled version=3.0.2 X-Spam-Level:This is a multi-part message in MIME format. --------------070306040502030501030100 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Sorry I wrote down that query incorrectly "select wktext from cs_srs where srid = ..." is the actual query used by the datastore which seems right minus the MDSYS schema that is missing. The divide by zero problem lies in the SDO classes. The GTYPE (which I think means Geometry Type) is coming back as 3, when it should be a number in the thousands. I will continue to dig deeper and see what I find. I am ccing the geotools list. Hopefully the module maintainer can help up us out as well. I have attached a test case which exercises both problems. -Justin Luca Morandini wrote: > Justin Deoliveira wrote: > >> >> After digging into this I am pretty sure the problem is that the >> oracle datastore cannot determine the proper crs, which causes >> subsequent operatins (such as the rendering) to fail. >> >> You will have to excuse my lack of oracle spatial knowledge here. It >> seems the 'cs_crs' table is used to build the crs info. In this case >> the table does not exist where in lies the problem. > > > Well, the table does exist, though it's placed under the MDSYS schema > and lacks a global synonym, hence it has to be reffered as MDSYS.CS_SRS > > Are you sure GeoServer cannot reach it ? > > Regards, > > -------------------- > Luca Morandini > www.lucamorandini.it > -------------------- > > > > ------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. Do you grep through log > files > for problems? Stop! Download the new AJAX search engine that makes > searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! > http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click > _______________________________________________ > Geoserver-users mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/geoserver-users > -- Justin Deoliveira The Open Planning Project http://topp.openplans.org --------------070306040502030501030100 Content-Type: text/x-java; name="Test.java" Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="Test.java" import java.sql.Connection; import java.util.HashMap; import java.util.Properties; import org.geotools.data.FeatureSource; import org.geotools.data.jdbc.ConnectionPool; import org.geotools.data.oracle.OracleConnectionFactory; import org.geotools.data.oracle.OracleDataStore; import junit.framework.TestCase; public class Test extends TestCase { public void test() throws Exception { String host = "www.lucamorandini.it"; String port = "1521"; String user = "gistat"; String pass = "gistat"; String inst = "orcl"; String schema = "GISTAT"; OracleConnectionFactory fact = new OracleConnectionFactory(host,port,inst); fact.setLogin(user,pass); ConnectionPool cPool = fact.getConnectionPool();; Connection conn = cPool.getConnection(); OracleDataStore dstore = new OracleDataStore(cPool, schema, new HashMap()); FeatureSource fs = dstore.getFeatureSource("COMUNI"); fs.getFeatures().getBounds(); } } --------------070306040502030501030100-- ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click _______________________________________________ Geoserver-users mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/geoserver-users
--- End Message ---
