Re: Web Service with PostgreSQL
Re: Web Service with PostgreSQL
- Subject: Re: Web Service with PostgreSQL
- From: "Daniele Corti" <email@hidden>
- Date: Mon, 1 Oct 2007 17:11:10 +0200
Hi Luigi,
how do you create the qualifiers?
2007/10/1, Luigi Giannini <email@hidden>:
Hi to everyone!
I'm a newbie to webobjects. I'm starting modeling a DB on PostgreSQL
then try to create a web service (via Xcode preconfigured template).
If I create an operation with an = operator it runs. But if I create
an operation with a like or
caseIsensitiveLike operator it fails with this error:
Exception:
com.webobjects.foundation.NSForwardException
[org.apache.axis.AxisFault] java.lang.IllegalArgumentException:
com.webobjects.jdbcadaptor.JDBCAdaptorException: EvaluateExpression
failed: <com.webobjects.jdbcadaptor.JDBCExpression: "SELECT
t0.pat_attrs, t0.pat_id, t0.pat_id_issuer, t0.pat_name,
t0.pk,
t0.priv_type FROM public.priv_patient t0 WHERE UPPER(t0.pat_name) LIKE
UPPER(?) ESCAPE '\'" withBindings: 1:"ANTONACCIO"(patName)>:
Next exception:SQL State:42601 -- error code: 0 -- msg: ERROR:
unterminated quoted string at or near "'\'": Exception trying to
invoke operation: searchPrivPatient
I read that the problem is the generated SQL and I think that a
suggestion made by Guido Neitzer on a similar topic on August (turning
off the variable binding) can help solve this problem but I don't know
where add this setting:
Guido Neitzer <email@hidden>:
> ... , it seems you use the PostgreSQL plugin - so, if that is okay
> for you, you can try turning on off the variable binding with:
>
> com.webobjects.jdbcadaptor.PostgresqlExpression.disableBindVariables
> = true
Or there's others thing to monitor and fix?
Can someone help me ?
A suggestion?
A tip?
Thanks in advance !
--
Luigi Giannini
_____________________
email@hidden
Tel.
328.1161861
Fax 0883.1950191
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (
This email sent to email@hidden
--
Daniele Corti
AIM: S0CR4TE5
Messenger:
email@hidden
--
Computers are like air conditioners -- they stop working properly if you open
WINDOWS
--
What about the four lusers of the apocalypse? I nominate:
"advertising", "can't log in", "power switch" and "what backup?"
--Alistair Young
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden