hello,
can anyone tell me what types of data geoserver can consider. I have done many tests but there only integer and string work.
for example if I create a table with numric or bigint it doesn’t work :
--------table--------------
create table test(id int8, c1 numeric(10,5))
---------schema.xml--------------
<xs:complexType name=“test_Type”>
xs:complexContent
<xs:extension base=“gml:AbstractFeatureType”>
xs:sequence
<xs:element name=“id” type=“long”/>
<xs:element name=“c1” type=“decimal”/>
xs:sequence
</xs:extension>
</xs:complexContent>
</xs:complexType>
this gives an error : … result null .
RQ : if i create attribute with int or string it works
thanks
Mehdi ESSID
LSIS - Université de Provence - CMI,
Technopôle de château Gombert
39, rue Joliot-Curie
F-13453 Marseille Cedex 13
TEL : 04 91 11 35 41
Mehdi ESSID
LSIS - Université de Provence - CMI,
Technopôle de château Gombert
39, rue Joliot-Curie
F-13453 Marseille Cedex 13
TEL : 04 91 11 35 41
The current supported types are:
varchar -> String
int4 -> Integer
float8 -> Double
float4 -> Float
geometry-> Geometry (jts)
date -> Date
These are all explicitly defined in the geotools postgis datasource. I'm
going to do some testing to see if I can use the postgres driver's type
map, as it should define more. If that's not possible I'll at the very
least add numeric and bigint explicitly. I also need to test if our gml
producer will handle things correctly. But thanks for bringing this up,
I'll let you knwo when I have a solution. And if there are any other data
types that people need that aren't currently supported by geoserver then
let me know.
Chris
On Tue, 9 Sep 2003, mehdi essid wrote:
hello,
can anyone tell me what types of data geoserver can consider. I have done many tests but there only integer and string work.
for example if I create a table with numric or bigint it doesn't work :
--------table--------------
create table test(id int8, c1 numeric(10,5))
---------schema.xml--------------
<xs:complexType name="test_Type">
<xs:complexContent>
<xs:extension base="gml:AbstractFeatureType">
<xs:sequence>
<xs:element name="id" type="long"/>
<xs:element name="c1" type="decimal"/>
<xs:sequence>
</xs:extension>
</xs:complexContent>
</xs:complexType>
this gives an error : ..... result null .
RQ : if i create attribute with int or string it works
thanks
-----------------------------------------------------------------------------
Mehdi ESSID
LSIS - Université de Provence - CMI,
Technopôle de château Gombert
39, rue Joliot-Curie
F-13453 Marseille Cedex 13
TEL : 04 91 11 35 41
-----------------------------------------------------------------------------
Mehdi ESSID
LSIS - Université de Provence - CMI,
Technopôle de château Gombert
39, rue Joliot-Curie
F-13453 Marseille Cedex 13
TEL : 04 91 11 35 41
Ok, I've just commmitted explicit support for int2 -> Short and int8 ->
Long. BigDecimal seems to be having a bit of problems with explicitly
setting it in geotools. But that shouldn't affect users, as I also added
code to generically handle most any object type. So numerics should work
fine, as well as other types that are not on the list. So if you're
interested in these updates then check out from cvs, or wait until 0.99
thanks,
Chris
On Tue, 9 Sep 2003, Chris Holmes wrote:
The current supported types are:
varchar -> String
int4 -> Integer
float8 -> Double
float4 -> Float
geometry-> Geometry (jts)
date -> Date
These are all explicitly defined in the geotools postgis datasource. I'm
going to do some testing to see if I can use the postgres driver's type
map, as it should define more. If that's not possible I'll at the very
least add numeric and bigint explicitly. I also need to test if our gml
producer will handle things correctly. But thanks for bringing this up,
I'll let you knwo when I have a solution. And if there are any other data
types that people need that aren't currently supported by geoserver then
let me know.
Chris
On Tue, 9 Sep 2003, mehdi essid wrote:
> hello,
> can anyone tell me what types of data geoserver can consider. I have done many tests but there only integer and string work.
> for example if I create a table with numric or bigint it doesn't work :
>
> --------table--------------
> create table test(id int8, c1 numeric(10,5))
>
> ---------schema.xml--------------
> <xs:complexType name="test_Type">
> <xs:complexContent>
> <xs:extension base="gml:AbstractFeatureType">
> <xs:sequence>
>
> <xs:element name="id" type="long"/>
> <xs:element name="c1" type="decimal"/>
> <xs:sequence>
>
>
> </xs:extension>
> </xs:complexContent>
> </xs:complexType>
>
> this gives an error : ..... result null .
>
> RQ : if i create attribute with int or string it works
> thanks
>
> -----------------------------------------------------------------------------
> Mehdi ESSID
> LSIS - Université de Provence - CMI,
> Technopôle de château Gombert
> 39, rue Joliot-Curie
> F-13453 Marseille Cedex 13
> TEL : 04 91 11 35 41
>
> -----------------------------------------------------------------------------
> Mehdi ESSID
> LSIS - Université de Provence - CMI,
> Technopôle de château Gombert
> 39, rue Joliot-Curie
> F-13453 Marseille Cedex 13
> TEL : 04 91 11 35 41
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel