Hi Luigi, how do you create the qualifiers?
2007/10/1, Luigi Giannini <[EMAIL PROTECTED]>: > > 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 PROTECTED]>: > > ... , 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 PROTECTED] > Tel. 328.1161861 > Fax 0883.1950191 > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/ildenae%40gmail.com > > This email sent to [EMAIL PROTECTED] > -- Daniele Corti AIM: S0CR4TE5 Messenger: [EMAIL PROTECTED] -- 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
