[Geoserver-users] convert shp to oracle and display not correct

Worawit_worr · March 22, 2006, 11:18am

I use oracle 10g for database.
I convert shape file to sdo with shp2sdo.exe. and added data to oracle
by following steps from
http://www.oracle.com/technology/software/products/spatial/files/text_files/using_shp2sdo.txt
after that I added data store and added feature(use same style as shape
file)

finally I used mapPreview.do to preview my map and the map displayed
incorrectly
my correct map is

http://www.nabble.com/user-images/2577.jpg
and this is incorrect one

http://www.nabble.com/user-images/2578.jpg

How should I solve it?

--
View this message in context: http://www.nabble.com/convert-shp-to-oracle-and-display-not-correct-t1323249.html#a3530348
Sent from the GeoServer - User forum at Nabble.com.

Luca_Morandini2 · March 22, 2006, 3:26pm

worr wrote:

I use oracle 10g for database.
I convert shape file to sdo with shp2sdo.exe. and added data to oracle
by following steps from

You have set the SRID via the "-s" option, haven't you ?

Regards,

P.S.
The incorrect map is just beatiful

--------------------
Luca Morandini
www.lucamorandini.it
--------------------

Worawit_worr · March 22, 2006, 5:53pm

yes,i have set it.
How should i do next?
--
View this message in context: http://www.nabble.com/convert-shp-to-oracle-and-display-not-correct-t1323249.html#a3537428
Sent from the GeoServer - User forum at Nabble.com.

Luca_Morandini2 · March 22, 2006, 6:02pm

worr wrote:

yes,i have set it.
How should i do next?

Hmm... I'd get the geometry as GML (via WFS) and check it: this will hopefully shed some light on the nature of the problem.

Regards,

--------------------
Luca Morandini
www.lucamorandini.it
--------------------

Worawit_worr · March 22, 2006, 6:44pm

I'm newbie. How I send it or you see via WFS?

PS.

In step that I convert from shape to sdo.
this is some create table sql.
CREATE TABLE CHANGWAT_BOUNDARY (
  AREA NUMBER,
  PERIMETER NUMBER,
  THAI_BND_ NUMBER,
  THAI_BND_I NUMBER,
  PROV_CODE VARCHAR2(2),
  PROV_NAME VARCHAR2(50),
  PROV_THAI VARCHAR2(50),
  PART VARCHAR2(2),
  GEOM MDSYS.SDO_GEOMETRY);

and ctl file

LOAD DATA
INFILE *
TRUNCATE
CONTINUEIF NEXT(1:1) = '#'
INTO TABLE CHANGWAT_BOUNDARY
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS (
   AREA,
   PERIMETER,
   THAI_BND_,
   THAI_BND_I,
   PROV_CODE NULLIF PROV_CODE = BLANKS,
   PROV_NAME NULLIF PROV_NAME = BLANKS,
   PROV_THAI NULLIF PROV_THAI = BLANKS,
   PART ,
   GEOM COLUMN OBJECT
   (
     SDO_GTYPE INTEGER EXTERNAL,
     SDO_SRID INTEGER EXTERNAL,
     SDO_ELEM_INFO VARRAY TERMINATED BY '|/'
       (X FLOAT EXTERNAL),
     SDO_ORDINATES VARRAY TERMINATED BY '|/'
       (X FLOAT EXTERNAL)
   )
)

when I use sqlldr command
show error
-------------------------
SQL*Loader-350: Syntax error at line 15.
Expecting positive integer or column name, found keyword part.
PART NULLIF PART = BLANKS,
----------------------
so I delete word "NULLIF PART = BLANKS"
and run sqlldr again

i don't show error.Does it cause of problem?

--
View this message in context: http://www.nabble.com/convert-shp-to-oracle-and-display-not-correct-t1323249.html#a3538482
Sent from the GeoServer - User forum at Nabble.com.

Luca_Morandini2 · March 22, 2006, 7:50pm

worr wrote:

I'm newbie. How I send it or you see via WFS?

http://<yourserver>/geoserver/wfs?request=getfeature&typename=<your featuretype>

In step that I convert from shape to sdo.
this is some create table sql.
CREATE TABLE CHANGWAT_BOUNDARY (
AREA NUMBER, PERIMETER NUMBER, THAI_BND_ NUMBER, THAI_BND_I NUMBER, PROV_CODE VARCHAR2(2), PROV_NAME VARCHAR2(50), PROV_THAI VARCHAR2(50), PART VARCHAR2(2), GEOM MDSYS.SDO_GEOMETRY);

Please, define a primary key (nothing to do with your problem probably, but a PK has to be defined).

Regards,

--------------------
Luca Morandini
www.lucamorandini.it
--------------------

Worawit_worr · March 23, 2006, 4:51am

Ahh. When I called getFeature it shows error

XML Parsing Error: reference to invalid character number
Location:
http://localhost:8080/geoserver/wfs/GetFeature?typeName=topp:CHANGWAT_BOUNDARY
Line Number 2, Column 34055:

there are some of gml I have already arranged
-------------------------------------------------------------------------
<wfs:FeatureCollection xmlns:wfs="http://www.opengis.net/wfs"
xmlns:topp="http://www.openplans.org/topp"
xmlns:gml="http://www.opengis.net/gml"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.openplans.org/topp
http://localhost:8080/geoserver/wfs/DescribeFeatureType?typeName=topp:CHANGWAT_BOUNDARY
http://www.opengis.net/wfs
http://localhost:8080/geoserver/schemas/wfs/1.0.0/WFS-basic.xsd">
<gml:boundedBy><gml:Box
srsName="http://www.opengis.net/gml/srs/epsg.xml#4326">
<gml:coordinates decimal="." cs="," ts=" ">-180,-90 180,90</gml:coordinates>
</gml:Box>
</gml:boundedBy>
<gml:featureMember>
<topp:CHANGWAT_BOUNDARY fid="CHANGWAT_BOUNDARY.63">
<topp:AREA>4717855</topp:AREA>
<topp:PERIMETER>9731.484</topp:PERIMETER>
<topp:THAI_BND_I>271</topp:THAI_BND_I>
<topp:PROV_CODE>08</topp:PROV_CODE>
<topp:PROV_NAME>CHONBURI</topp:PROV_NAME>
<topp:PROV_THAI>???</topp:PROV_THAI>
<topp:PART>E</topp:PART>
<topp:GEOM>
<gml:Polygon srsName="http://www.opengis.net/gml/srs/epsg.xml#4326">
<gml:outerBoundaryIs>
<gml:LinearRing>
<gml:coordinates decimal="." cs="," ts=" ">-176.3125,12 -127.875,-84
-95.125,-2.25 99.625,-47.125 -72.0625,-90 10.3125,-69.875 93,-68.875
-7.625,-66 -111.875,-69 -60.25,-46.625 -37.8125,-72.5 169.875,-75.625
-133.5625,-17.75 -133,-62.5 -11.125,-42 166.625,-61 165.6875,9 -86.1875,-37
-132.625,-85 78.125,1 -71.4375,77.375 -133.125,-59 -83.3125,31
-106.8125,26.125 -116.625,-80.375 142.625,-2.875 19.125,39 -63.0625,0.125
176.875,-33.75 37.125,-73.125 -96.625,-62 2.3125,-27 -24.625,85 -175.75,73
-146.875,51 -44,12.875 26.6875,75.5 118.5,-63 129.125,-80.375 -29.25,51.125
-162.25,-34.75 -116.625,60 -173.1875,-88 -176.3125,12</gml:coordinates>
</gml:LinearRing>
</gml:outerBoundaryIs>
</gml:Polygon>
</topp:GEOM>
</topp:CHANGWAT_BOUNDARY>
</gml:featureMember>
-------------------------------------------

regard,
worr
--
View this message in context: http://www.nabble.com/convert-shp-to-oracle-and-display-not-correct-t1323249.html#a3546352
Sent from the GeoServer - User forum at Nabble.com.

Jukka_Rahkonen · March 23, 2006, 8:36am

Hi,

I have limited experience on this with my first successful shapefile loading to Oracle 9i with shp2sdo just one week ago. However, I am almost sure that your problem is just in data loading. Your Geoserver is most probably showing exactly and correctly what you have inserted in Oracle.

Shp2sdo creates, as you know, three files with extention .sql, .ctr and .dat. Of those the .sql-file contains the SQL sentences needed to create an empty Oracle table that corresponds the structure of the original shapefile.

The other two files are belonging together. The .dat file contains all the data of the shapefile in ascii-format and the .ctr file gives instructions for Oracle SQL-loader program about how that data should be split and inserted into the previously created table. Thus if you just edit the .ctr file created by shp2sdo utility it is very likely that the data gets inserted in a wrong way.

Another thing is that in your case shp2sdo obviously was not able to build valid control and data files but you got that error message instead. The error occurs in SQL-loader control file at line 15. I believe originally that line was like:
PART NULLIF PART = BLANKS, (am I correct?)
which gives an instruction to insert data to column named "PART", and insert NULL value if there is nothing but blank characters in .dat file between the corresponding separator marks. The column PART seems to be of datatype "VARCHAR2" and the width of the column is 2.

Without seeing the datafile I cannot say why this field is not accepted by SQL loader. The syntax is the same as with the other attribute fields, which are accepted. I do not know either what happens now if you remove that "NULLIF PART = BLANKS" section. Possibly something strange if there really are blanks in the data at this place.

I think I would try the following if I had the same pboblem:

- Have a look on the original shapefile and check is the data in PROV_CODE and PART columns are alike. They both are of type VARCHAR2 with width of 2 in Oracle but for some reason only the first one is accepted.
- Try to change the name of the PART column in the shapefiel to for example PART_CODE just to be sure that SQL loader has not reserved some special meaning for "PART". I do not believe this, actually.
- Finally, make a copy of the shapefile and remove the PART-column totally to see if the reason is in the data you have in this column. I believe that without this column you will be able to load the data to Oracle without problems and show it with your Geoserver.

At least for my own data it was necessary to run the "SDO_MIGRATE.TO_CURRENT" procedure but I guess that you have done that already. There are also procedures "SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT" and "SDO_GEOM.VALIDATE_LAYER_WITH_CONTEXT" which should check if the spatial data are valid, but I do not believe that is you problem. Your problem seems to arise from that the data are not correctly inserted to Oracle at all.

Good luck with your trial. My first experience on Geoserver with spatial data in Oracle 9i is very promising. I have 1.3 million polygons there at the moment, and they can be catched and delivered through Geoserver WFS quite nicely.

Regards,

Jukka Rahkonen

when I use sqlldr command
show error
-------------------------
SQL*Loader-350: Syntax error at line 15.
Expecting positive integer or column name, found keyword part.
PART NULLIF PART = BLANKS,
----------------------
so I delete word "NULLIF PART = BLANKS"
and run sqlldr again

i don't show error.Does it cause of problem?

Luca_Morandini2 · March 23, 2006, 9:59am

worr wrote:

Ahh. When I called getFeature it shows error

XML Parsing Error: reference to invalid character number
Location:
http://localhost:8080/geoserver/wfs/GetFeature?typeName=topp:CHANGWAT_BOUNDARY
Line Number 2, Column 34055:

As Jukka already pointed out, there may be issues with the alphanumeric data in your shapefile: try deleting everything but the geometry and adding a numeric Primary Key (shp2sdo can add this PK automatically).

Regards,

--------------------
Luca Morandini
www.lucamorandini.it
--------------------

Worawit_worr · March 23, 2006, 11:13am

Rahkonen Jukka wrote:

I think I would try the following if I had the same pboblem:

- Have a look on the original shapefile and check is the data in PROV_CODE
and PART columns are alike. They both are of type VARCHAR2 with width of 2
in Oracle but for some reason only the first one is accepted.
- Try to change the name of the PART column in the shapefiel to for
example PART_CODE just to be sure that SQL loader has not reserved some
special meaning for "PART". I do not believe this, actually.
- Finally, make a copy of the shapefile and remove the PART-column totally
to see if the reason is in the data you have in this column. I believe
that without this column you will be able to load the data to Oracle
without problems and show it with your Geoserver.

Thank. But I changed column "part" to "part_code" and tried to use sqlldr
again.It didn't show any error,but it still showed the incorrect map.
--
View this message in context: http://www.nabble.com/convert-shp-to-oracle-and-display-not-correct-t1323249.html#a3549951
Sent from the GeoServer - User forum at Nabble.com.

Worawit_worr · March 24, 2006, 5:05am

Now,It can display map correctly.
Thank "Jukka" from his toppic
http://www.nabble.com/Problem-with-Oracle-9i-FeatureType---Solved-t1330116.html

I solved it by changing part to part_code
Also I didn't use -s option when I used shp2sdo command
but shp2sdo still don't create primary key automatic. SoI create key
manually

but I still have some problem when i request getFeature
-------------------------------------
XML Parsing Error: reference to invalid character number
Location:
http://localhost:8080/geoserver/wfs/GetFeature?typeName=topp:CHANGWAT_BOUNDARY
Line Number 2, Column 8296:
-----------------------------------

I don't know why?

This is exception from geoserver console
-----------------------------------------
906624 [INFO] org.vfny.geoserver.servlets.PartialBufferStrategy -
OutputStream was successfully aborted.
906634 [WARNING] org.vfny.geoserver.ServiceException - encountered error:
null error:Translator error
StackTrace: javax.xml.transform.TransformerException: Translator error
  at
org.geotools.xml.transform.TransformerBase.transform(TransformerBase.java:122)
  at
org.geotools.xml.transform.TransformerBase.transform(TransformerBase.java:97)
  at
org.vfny.geoserver.wfs.responses.GML2FeatureResponseDelegate.encode(GML2FeatureResponseDelegate.java:225)
  at
org.vfny.geoserver.wfs.responses.FeatureResponse.writeTo(FeatureResponse.java:131)
-------------------------------------------------------------

--
View this message in context: http://www.nabble.com/convert-shp-to-oracle-and-display-not-correct-t1323249.html#a3565881
Sent from the GeoServer - User forum at Nabble.com.

Luca_Morandini2 · March 24, 2006, 7:03am

worr wrote:

Also I didn't use -s option when I used shp2sdo command

Did you manually add the SRID information later ?

but shp2sdo still don't create primary key automatic. SoI create key
manually

Really ?
So, you issued the "-i" option in your shp2sdo command and didn't create a numeric primary key column... hmmmm... very strange.
Anyway, which version of shp2sdo are you using ?

Regards,

--------------------
Luca Morandini
www.lucamorandini.it
--------------------

Worawit_worr · March 24, 2006, 9:12am

Sorry,I missing.I didn't add "-i" option in my command so it didn't create
primary key
and I didn't add SRID latter so my SRID is null.

My shp2sdo version is 2.15 21-May-2004
--
View this message in context: http://www.nabble.com/convert-shp-to-oracle-and-display-not-correct-t1323249.html#a3567621
Sent from the GeoServer - User forum at Nabble.com.

Luca_Morandini2 · March 24, 2006, 9:54am

worr wrote:

Sorry,I missing.I didn't add "-i" option in my command so it didn't create
primary key

You should add it.

and I didn't add SRID latter so my SRID is null.

Hmmm... did you succeed in creating the spatial index ?

Regards,

--------------------
Luca Morandini
www.lucamorandini.it
--------------------

Worawit_worr · March 27, 2006, 2:59am

yes. I ceated it manually.
I confuse something.Is SRID the same as Spatial Index?
--
View this message in context: http://www.nabble.com/convert-shp-to-oracle-and-display-not-correct-t1323249.html#a3603166
Sent from the GeoServer - User forum at Nabble.com.

Jukka_Rahkonen · March 28, 2006, 3:39pm

Hi,

Might there be some controlled and documented procedure to make WFS-T work with Oracle (OCI) FeatureType? I made a quick try with deeJUMP that should be WFS-T client but as you already guess, with no success.

There was some information on "Start Geoserver" console screen, but what should I look for? Or should I turn on some logging or debugging feature? Is the Map Buílder WFS-T demo the preferred client for testing?

Regards,

-Jukka-

Chris_Holmes1 · March 30, 2006, 4:37pm

Rahkonen Jukka wrote:

Hi,
Might there be some controlled and documented procedure to make WFS-T work with Oracle (OCI) FeatureType?

>I made a quick try with deeJUMP that should be WFS-T client but as you already guess, with no success.
There's nothing special about oracle with WFS-T, if the user connection param configured with geoserver has update/delete/insert permissions on oracle then it should just work. I didn't know that deeJUMP has WFS-T capabilities, and indeed I think it may just not...

There was some information on "Start Geoserver" console screen, but what should I look for? Or should I

>turn on some logging or debugging feature? Is the Map Buílder WFS-T demo the preferred client for testing?
uDig - http://udig.refractions.net is probably the preferred client for testing. MapBuilder takes a bit of configuration, uDig you can just point it at geoserver and start editing. Make use of the 1.1 series though. It's pretty stable now, and it has _much_ better editing facilities.

best regards,

Chris

Regards,
-Jukka-

-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Chris Holmes
The Open Planning Project
thoughts at: http://cholmes.wordpress.com

Jukka_Rahkonen · March 31, 2006, 10:03am

Chris Holmes wrote:

Rahkonen Jukka wrote:

Hi,

Might there be some controlled and documented procedure to make WFS-T work with Oracle (OCI) FeatureType?

>>I made a quick try with deeJUMP that should be WFS-T client but as you

already guess, with no success.

There's nothing special about oracle with WFS-T, if the user connection
param configured with geoserver has update/delete/insert permissions on
oracle then it should just work. I didn't know that deeJUMP has WFS-T
capabilities, and indeed I think it may just not...

DeeJUMP does indeed have those capabilities, I just think that it has not been tested against Geoserver. It's a pity because I think that JUMP has really nice vector handling features and it has kind of a professional touch in user interface etc. I could well imagine myself doing real digitising and editing work with it. Right now I can read WFS featuretypes from my Geoserver, including Oracle tables and views, just fine with deeJUMP but I cannot make any transactions. Not even to "tasmania_cities" shapefile that I can edit with a "Mapbuilder/Geoserver (Tasmania)" demo that came with Geoserver installation.

Because of this Tasmania cities case I think I can rely on that everything is OK with my Geoserver WFS-T and shapefile datastore. Next I consider to progress so, that:
- I will try to update my data in Oracle with whatever WFS-T client just to know that it is possible
- I would like to record from Geoserver side what deeJUMP client actually is sending to it and give that information to deeGree and Geoserver developers in a hope that those two one day could discuss with each other.

There was some information on "Start Geoserver" console screen, but what should I look for? Or should I
turn on some logging or debugging feature? Is the Map Buílder WFS-T
demo the preferred client for testing?

uDig - http://udig.refractions.net is probably the preferred client for
testing. MapBuilder takes a bit of configuration, uDig you can just
point it at geoserver and start editing. Make use of the 1.1 series
though. It's pretty stable now, and it has _much_ better editing
facilities.

In that case I will re-install uDig, I used to have it but for some reason just didn't like it.

-Jukka-

P.S. I add here below what I have caught so far. I uncommented something called Configure the request log from jetty.xml and now I am getting some kind of a log on my hard disk. However this log seems not to collect any details about "POST" calls that might be most interesting in this case. However, here is what appears in the log file when I connect to Geoserver with deeJUMP:

127.0.0.1 - - [31/Mar/2006:09:38:40 +0000] "GET /geoserver/wfs?request=GetCapabilities&version=1.0.0&SERVICE=WFS HTTP/1.1" 200 15412
127.0.0.1 - - [31/Mar/2006:09:38:40 +0000] "GET /geoserver/wfs?SERVICE=WFS&REQUEST=DescribeFeatureType&version=1.0.0&OUTPUTFORMAT=XMLSCHEMA&TYPENAME=topp:tasmania_state_boundaries HTTP/1.1" 200 1687

Seems like the client sends GetCapabilities request and after that automatically DescribeFeatureType request about the first featuretype on the list.

Then I select Tasmania cities from the list on the client and the log says:
127.0.0.1 - - [31/Mar/2006:09:42:07 +0000] "GET /geoserver/wfs?SERVICE=WFS&REQUEST=DescribeFeatureType&version=1.0.0&OUTPUTFORMAT=XMLSCHEMA&TYPENAME=topp:tasmania_cities HTTP/1.1" 200 1855

Next I download the layer, so the client must send some GetFeature&TypeName request, but the log says just:
127.0.0.1 - - [31/Mar/2006:09:43:17 +0000] "POST /geoserver/wfs HTTP/1.1" 200 2598

However, in "Start Geoserver" window I can see all this:
2103040 [INFO] org.vfny.geoserver.wfs.servlets.WfsDispatcher - req_type is 2
2103040 [INFO] org.vfny.geoserver.servlets.AbstractService - Looking for config
ured service responses' strategy
2103040 [INFO] org.vfny.geoserver.servlets.AbstractService - Looking for config
ured service strategy PARTIAL-BUFFER
2103040 [INFO] org.vfny.geoserver.servlets.AbstractService - Using service stra
tegy class org.vfny.geoserver.servlets.PartialBufferStrategy
2103040 [INFO] org.vfny.geoserver.servlets.AbstractService - Set buffer size to
50
2103040 [INFO] org.vfny.geoserver.servlets.AbstractService - handling request:
DescribeFeatureType Request [outputFormat: XMLSCHEMA [feature types: topp:tasman
ia_cities]
2103060 [INFO] org.vfny.geoserver.servlets.AbstractService - Service handled
2173010 [INFO] org.vfny.geoserver.util.requests.readers.DispatcherXmlReader - g
etting request type from org.vfny.geoserver.util.requests.DispatcherHandler@anonymised.com
060
2173010 [INFO] org.vfny.geoserver.wfs.servlets.WfsDispatcher - req_type is 3
2173010 [INFO] org.vfny.geoserver.servlets.AbstractService - Looking for config
ured service responses' strategy
2173010 [INFO] org.vfny.geoserver.servlets.AbstractService - Looking for config
ured service strategy PARTIAL-BUFFER
2173010 [INFO] org.vfny.geoserver.servlets.AbstractService - Using service stra
tegy class org.vfny.geoserver.servlets.PartialBufferStrategy
2173010 [INFO] org.vfny.geoserver.servlets.AbstractService - Set buffer size to
50
2173010 [INFO] org.vfny.geoserver.servlets.AbstractService - handling request:
Request: null
output format:GML2
max features:2147483647
version:
queries:
  Query
   feature type: topp:tasmania_cities
   [properties: ALL ]
2173030 [INFO] org.vfny.geoserver.servlets.AbstractService - Service handled

This all works. Now if I try to insert new feature to tasmania_cities, the Jetty-log tells only:
127.0.0.1 - - [31/Mar/2006:09:54:40 +0000] "POST /geoserver/wfs HTTP/1.1" 200 546
And to console window comes this much text:
[Fatal Error] :1:331: The prefix "topp" for element "topp:tasmania_cities" is no
t bound.
2855452 [WARNING] org.vfny.geoserver.ServiceException - encountered error: org.
xml.sax.SAXParseException: The prefix "topp" for element "topp:tasmania_cities"
is not bound.
StackTrace: org.xml.sax.SAXParseException: The prefix "topp" for element "topp:t
asmania_cities" is not bound.
        at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
        at org.vfny.geoserver.util.requests.readers.DispatcherXmlReader.read(Dis
patcherXmlReader.java:81)
        at org.vfny.geoserver.wfs.servlets.WfsDispatcher.doPost(WfsDispatcher.ja
va:167)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:358
)
        at org.mortbay.jetty.servlet.WebApplicationHandler$Chain.doFilter(WebApp
licationHandler.java:342)
        at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCha
racterEncodingFilter.java:122)
        at org.mortbay.jetty.servlet.WebApplicationHandler$Chain.doFilter(WebApp
licationHandler.java:334)
        at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicati
onHandler.java:286)
        at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:5
67)
        at org.mortbay.http.HttpContext.handle(HttpContext.java:1807)
        at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplication
Context.java:525)
        at org.mortbay.http.HttpContext.handle(HttpContext.java:1757)
        at org.mortbay.http.HttpServer.service(HttpServer.java:879)
        at org.mortbay.http.HttpConnection.service(HttpConnection.java:790)
        at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:961)
        at org.mortbay.http.HttpConnection.handle(HttpConnection.java:807)
        at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:
197)
        at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:276)
        at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:511)

best regards,

Chris

Regards,

-Jukka-

-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Chris Holmes
The Open Planning Project
thoughts at: http://cholmes.wordpress.com

Jukka_Rahkonen · March 31, 2006, 1:27pm

Chris Holmes wrote:

uDig - http://udig.refractions.net is probably the preferred client for
testing. MapBuilder takes a bit of configuration, uDig you can just
point it at geoserver and start editing. Make use of the 1.1 series
though. It's pretty stable now, and it has _much_ better editing
facilities.

I installed uDig 1.1.M6 and made a quick test. I can show the featuretypes that came with Geoserver installation and those I have made from my local shapefiles. Obviously I can also edit them via WFS-T, at least I succeeded with tasmania_cities. Unfortunately it was not that easy with my Oracle data. Those I can not even show with uDig, it is telling me something like "RenderingProblem rendering: Exception rendering layer DefaultMapLayer..."

I have to continue the struggle next week.

-Jukka-

Chris_Holmes1 · March 31, 2006, 5:10pm

Rahkonen Jukka wrote:

Chris Holmes wrote:

uDig - http://udig.refractions.net is probably the preferred client for
testing. MapBuilder takes a bit of configuration, uDig you can just
point it at geoserver and start editing. Make use of the 1.1 series
though. It's pretty stable now, and it has _much_ better editing
facilities.

I installed uDig 1.1.M6 and made a quick test. I can show the featuretypes that came with Geoserver installation and those I have made from my local shapefiles. Obviously I can also edit them via WFS-T, at least I succeeded with tasmania_cities. Unfortunately it was not that easy with my Oracle data. Those I can not even show with uDig, it is telling me something like "RenderingProblem rendering: Exception rendering layer DefaultMapLayer..."

You get the rendering problems connecting to oracle directly? Or oracle on geoserver _through_ wfs?

Also, you can make use of the uDig list, though they'll likely ask for more details about your set up and error you're getting.

Chris

I have to continue the struggle next week.
-Jukka-

-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Chris Holmes
The Open Planning Project
thoughts at: http://cholmes.wordpress.com