Hello Ben,
Please see the attached DDL for the table. As you can see, the objected is
never null, and isn't shouldn't be big - it is numbered 1 - 1949.
Thank you,
Christy
-----Original Message-----
From: Ben Caradoc-Davies [mailto:ben.caradoc-dav...@csiro.au]
Sent: Sunday, March 17, 2013 10:14 PM
To: christy@azgs
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] App Schema Resolution
Christy,
this is rather odd. Even if the argument is not a string (and by #1 it means
the second argument), the first thing strConcat tries to do is to convert it to
a string. The only thing that I can think of that might cause this to fail is
that the type is some big integer that it cannot handle, or null. Ordinary
integers should be converted.
Can we please see the DDL for the source table?
Is objectid ever null?
select count(1) from yourtablename where objectid is null;
Kind regards,
Ben.
On 15/03/13 04:09, christy@azgs wrote:
> We have achieved schema resolution! That is, as long as we use the
> getId() idExpression. However, because we'd like to use our integer
> field 'objectid', we need to figure out how to concatenate an integer
> with that field OR make that read as a string. We tried the following,
> but we get that
> "java.lang.IllegalArgumentException: Filter Function problem for
> function strConcat argument #1 - expected type String" error:
>
>
> <idExpression>
>
> <OCQL>strConcat('BT', objectid)</OCQL>
>
> </idExpression>
>
> And we also tried:
> <idExpression>
>
> <OCQL>strConcat('BT', strTrim(objectid))</OCQL>
> </idExpression>
>
> Resulting in the same error. Thanks to anyone with ideas.
>
>
>
> --
> View this message in context:
> http://osgeo-org.1560.n6.nabble.com/Re-App-Schema-Resolution-tp5040030
> p5040472.html Sent from the GeoServer - User mailing list archive at
> Nabble.com.
>
> ----------------------------------------------------------------------
> -------- Everyone hates slow websites. So do we.
> Make your web apps faster with AppDynamics Download AppDynamics Lite
> for free today:
> http://p.sf.net/sfu/appdyn_d2d_mar
> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
--
Ben Caradoc-Davies <ben.caradoc-dav...@csiro.au> Software Engineer CSIRO Earth
Science and Resource Engineering Australian Resources Research Centre
<?xml version="1.0" encoding="UTF-8"?>
<report>
<header>
<generated>Mon 18 Mar 2013 08:06:30 AM MST</generated>
<server>kyanite (kyanite:5432)</server>
<database>azgs</database>
<schema>sde</schema>
<title>Table DDL report - azboreholetemperatures</title>
</header>
<section id="s1" number="1" name="Table DDL">
<table>
<columns>
</columns>
<rows>
</rows>
</table>
<sql>-- Table: azboreholetemperatures
-- DROP TABLE azboreholetemperatures;
CREATE TABLE azboreholetemperatures
(
objectid integer NOT NULL,
observationuri character varying(255),
wellname character varying(255),
apino character varying(255),
headeruri character varying(255),
otherid character varying(255),
othername character varying(255),
boreholename character varying(255),
label character varying(255),
operator character varying(255),
leasename character varying(255),
leaseowner character varying(255),
leaseno character varying(255),
spuddate timestamp without time zone,
endeddrillingdate timestamp without time zone,
welltype character varying(255),
status character varying(255),
commodityofinterest character varying(255),
statusdate timestamp without time zone,
function_ character varying(255),
production character varying(255),
producinginterval character varying(255),
releasedate timestamp without time zone,
field character varying(255),
otherlocationname character varying(255),
county character varying(255),
state character varying(255),
plss_meridians character varying(255),
twp character varying(255),
rge character varying(255),
section_ numeric(38,8),
sectionpart character varying(255),
parcel character varying(255),
utm_e numeric(38,8),
utm_n numeric(38,8),
utmdatumzone character varying(255),
latdegree numeric(38,8),
longdegree numeric(38,8),
srs character varying(255),
locationuncertaintystatement text,
locationuncertaintycode character varying(255),
locationuncertaintyradius numeric(38,8),
drillertotaldepth numeric(38,8),
depthreferencepoint character varying(255),
lengthunits character varying(255),
wellboreshape character varying(255),
trueverticaldepth numeric(38,8),
elevationkb numeric(38,8),
elevationdf numeric(38,8),
elevationgl numeric(38,8),
formationtd character varying(255),
bitdiametercollar character varying(255),
bitdiametertd numeric(38,8),
diameterunits character varying(255),
notes text,
measuredtemperature numeric(38,8),
correctedtemperature numeric(38,8),
temperatureunits character varying(255),
timesincecirculation character varying(255),
circulationduration numeric(38,8),
measurementprocedure text,
correctiontype character varying(255),
depthofmeasurement numeric(38,8),
measurementdatetime timestamp without time zone,
measurementformation character varying(255),
measurementsource text,
relatedresource text,
casinglogger character varying(255),
casingbottomdepthdriller numeric(38,8),
casingtopdepth numeric(38,8),
casingpipediameter numeric(38,8),
casingweight numeric(38,8),
casingweightunits character varying(255),
casingthickness character varying(255),
drillingfluid character varying(255),
salinity character varying(255),
mudresistivity character varying(255),
density character varying(255),
fluidlevel character varying(255),
ph numeric(38,8),
viscosity character varying(255),
fluidloss character varying(255),
measurementnotes text,
informationsource text,
globalid character varying(38) NOT NULL DEFAULT '{00000000-0000-0000-0000-000000000000}'::character varying,
shape geometry,
CONSTRAINT enforce_srid_shape CHECK (st_srid(shape) = 4326)
)
WITH (
OIDS=FALSE
);
ALTER TABLE azboreholetemperatures
OWNER TO sde;
GRANT ALL ON TABLE azboreholetemperatures TO sde;
-- Index: a453_ix1
-- DROP INDEX a453_ix1;
CREATE INDEX a453_ix1
ON azboreholetemperatures
USING gist
(shape );
-- Index: r462_sde_rowid_uk
-- DROP INDEX r462_sde_rowid_uk;
CREATE UNIQUE INDEX r462_sde_rowid_uk
ON azboreholetemperatures
USING btree
(objectid )
WITH (FILLFACTOR=75);
-- Index: uuid_462
-- DROP INDEX uuid_462;
CREATE INDEX uuid_462
ON azboreholetemperatures
USING btree
(globalid )
WITH (FILLFACTOR=75);
-- Index: uuid_oid_462
-- DROP INDEX uuid_oid_462;
CREATE UNIQUE INDEX uuid_oid_462
ON azboreholetemperatures
USING btree
(globalid , objectid )
WITH (FILLFACTOR=75);
</sql>
</section>
</report>
------------------------------------------------------------------------------
Own the Future-Intel® Level Up Game Demo Contest 2013
Rise to greatness in Intel's independent game demo contest.
Compete for recognition, cash, and the chance to get your game
on Steam. $5K grand prize plus 10 genre and skill prizes.
Submit your demo by 6/6/13. http://p.sf.net/sfu/intel_levelupd2d
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
