Re: Web Service with PostgreSQL
Re: Web Service with PostgreSQL
- Subject: Re: Web Service with PostgreSQL
- From: Lachlan Deck <email@hidden>
- Date: Wed, 3 Oct 2007 09:48:08 +1000
On 02/10/2007, at 6:29 PM, Luigi Giannini wrote:
2007/10/2, Lachlan Deck <email@hidden>:
Are you using any of the WO PostgresqlPlugIn/s or however they're
named?
(Best to keep this on the mailing list...)
I read on Apple WO docs that any JDBC driver is a good PlugIn. Isn't?
I downloaded from PostgreSQL site
(http://jdbc.postgresql.org/download.html) the latest JDBC driver
(8.2-506 JDBC 3) for Java 1.5 platform and for PostgreSQL v. 8.2
That's fine. You'll definitely need that. But what I was referring to
was the plugin for WO.
You'll need to take a look at one of the following:
- http://wiki.objectstyle.org/confluence/display/WO/Project+WONDER-
Frameworks-PostgresqlPlugin
Note: if you're using WOLips you'll not need the EOModelerBundle
- http://wiki.objectstyle.org/confluence/display/WO/EOF-Using+EOF-
Database+Adaptors+and+Plugins
Note: this is older docs. I'd use the Wonder one.
Any further questions about that can also be directed to the wonder
mailing list. http://wonder.sourceforge.net/index.php
On 02/10/2007, at 1:06 AM, Luigi Giannini wrote:
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.disableBindVariable
s
= true
Or there's others thing to monitor and fix?
Can someone help me ?
A suggestion?
A tip?
Thanks in advance !
with regards,
--
Lachlan Deck
_______________________________________________
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