Re: MORE Escape character question
Re: MORE Escape character question
- Subject: Re: MORE Escape character question
- From: Ismael Perdido <email@hidden>
- Date: Tue, 25 Oct 2005 03:48:59 +0200 (CEST)
Anjo,
Just asked David the same question, maybe you can
help. Trying to install the latest PostgresqlPlugIn I
get the follwing error:
'org/apache/tools/ant/Task' does not exist in this
project.
Building in eclipse, tried including ant.jar in the
classpath but didn't help. Do you know what this is?
Thanks much,
Ismael
--- Anjo Krank <email@hidden> escribió:
> He doesn't. You see that he has a plain
> JDBCExpression in the stack
> trace.
>
> Am 24.10.2005 um 21:37 schrieb David Teran:
>
> > are you using the Postgresql plugin from project
> wonder? If so,
> > which version (preferable the current cvs
> version).
> >
> > regards, David
> >
> > Am 24.10.2005 um 21:00 schrieb Ismael Perdido:
> >
> >
> >> Hi all,
> >>
> >> I am having trouble sending a 'like' operator
> query
> >> from WO5.2.3 to Postgresql8 (also installed
> project
> >> wonder). It apparently bombs on the escape
> character
> >> being used by default ('\').
> >>
> >> Is there a way to modify this character or work
> around
> >> it WITHOUT having to use the EOAdaptorChannel to
> send
> >> the SQL directly to the server? Below is the
> error.
> >> Any advice would be greatly appreciated.
> >>
> >> com.webobjects.jdbcadaptor.JDBCAdaptorException:
> >> EvaluateExpression failed:
> >> <com.webobjects.jdbcadaptor.JDBCExpression:
> "SELECT
> >> t0.address, t0.city, t0.email1, t0.fullname,
> >> t0.grade_id, t0.password, t0.phone1,
> RTRIM(t0.state),
> >> t0.u_id, t0.zip FROM public.userinfo t0 WHERE
> >> UPPER(t0.fullname) LIKE UPPER(?) ESCAPE '\'"
> >> withBindings: 1:"%o%"(fullname)>:
> >> Next exception:SQL State:42601 -- error code:
> 0 --
> >> msg: ERROR: unterminated quoted string at or near
> >> "'\'"
> >> at
> >>
>
com.webobjects.jdbcadaptor.JDBCContext._jdbcErrorWithChannel
>
> >> (JDBCContext.java:138)
> >> at
> >>
>
com.webobjects.jdbcadaptor.JDBCChannel._evaluateExpression
>
> >> (JDBCChannel.java:310)
> >> at
> >>
>
com.webobjects.jdbcadaptor.JDBCChannel.evaluateExpression
>
> >> (JDBCChannel.java:261)
> >> at
> >>
>
com.webobjects.jdbcadaptor.JDBCChannel.selectAttributes
>
> >> (JDBCChannel.java:185)
> >> at
> >>
>
com.webobjects.eoaccess.EODatabaseChannel._selectWithFetchSpecificati
>
> >> onEditingContext(EODatabaseChannel.java:879)
> >> at
> >>
>
com.webobjects.eoaccess.EODatabaseChannel.selectObjectsWithFetchSpeci
>
> >> fication(EODatabaseChannel.java:216)
> >> at
> >>
>
com.webobjects.eoaccess.EODatabaseContext._objectsWithFetchSpecificat
>
> >> ionEditingContext(EODatabaseContext.java:3196)
> >> at
> >>
>
com.webobjects.eoaccess.EODatabaseContext.objectsWithFetchSpecificati
>
> >> on(EODatabaseContext.java:3337)
> >> at
> >>
>
com.webobjects.eocontrol.EOObjectStoreCoordinator.objectsWithFetchSpe
>
> >> cification(EOObjectStoreCoordinator.java:539)
> >> at
> >>
>
com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecificati
>
> >> on(EOEditingContext.java:4053)
> >> at
> >>
>
com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecificati
>
> >> on(EOEditingContext.java:4438)
> >> at
> ContactList.setContacts(ContactList.java:33)
> >> at
> ContactList.searchContacts(ContactList.java:39)
> >> at
> >>
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> >> Method)
> >> at
> >> sun.reflect.NativeMethodAccessorImpl.invoke
> >> (NativeMethodAccessorImpl.java:39)
> >> at
> >> sun.reflect.DelegatingMethodAccessorImpl.invoke
> >> (DelegatingMethodAccessorImpl.java:25)
> >> at
> java.lang.reflect.Method.invoke(Method.java:324)
> >> at
> >> KeyValueCodingProtectedAccessor.methodValue
> >> (KeyValueCodingProtectedAccessor.java:54)
> >> at
> >> com.webobjects.foundation.NSKeyValueCoding
> >>
>
$_MethodBinding.valueInObject(NSKeyValueCoding.java:1160)
> >> at
> >> com.webobjects.foundation.NSKeyValueCoding
> >>
>
$DefaultImplementation.valueForKey(NSKeyValueCoding.java:1268)
> >> at
> >>
>
com.webobjects.appserver.WOComponent.valueForKey(WOComponent.java:
>
> >> 1539)
> >> at
> >>
>
com.webobjects.foundation.NSKeyValueCoding$Utility.valueForKey
>
> >> (NSKeyValueCoding.java:498)
> >> at
> >>
> com.webobjects.foundation.NSKeyValueCodingAdditions
> >> $DefaultImplementation.valueForKeyPath
> >> (NSKeyValueCodingAdditions.java:212)
> >> at
> >>
> com.webobjects.appserver.WOComponent.valueForKeyPath
>
> >> (WOComponent.java:1600)
> >> at
> >>
>
com.webobjects.appserver._private.WOKeyValueAssociation.valueInCompon
>
> >> ent(WOKeyValueAssociation.java:46)
> >> at
> >>
>
com.webobjects.appserver._private.WOImageButton.invokeAction
>
> >> (WOImageButton.java:239)
> >> at
> >>
>
com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction
>
> >> (WODynamicGroup.java:101)
> >> at
> >>
>
com.webobjects.appserver._private.WODynamicGroup.invokeAction
>
> >> (WODynamicGroup.java:110)
> >> at
> >>
>
com.webobjects.appserver._private.WOForm.invokeAction(WOForm.java:82)
> >> at
> >>
>
com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction
>
> >> (WODynamicGroup.java:101)
> >> at
> >>
>
com.webobjects.appserver._private.WODynamicGroup.invokeAction
>
> >> (WODynamicGroup.java:110)
> >> at
> >>
>
com.webobjects.appserver.WOComponent.invokeAction(WOComponent.java:
>
> >> 945)
> >> at
> >>
>
com.webobjects.appserver.WOSession.invokeAction(WOSession.java:1166)
> >> at
> >>
> com.webobjects.appserver.WOApplication.invokeAction
> >> (WOApplication.java:1375)
> >> at
> >>
>
com.webobjects.appserver._private.WOComponentRequestHandler._dispatch
>
> >>
> WithPreparedPage(WOComponentRequestHandler.java:196)
>
=== message truncated ===
______________________________________________
Renovamos el Correo Yahoo!
Nuevos servicios, más seguridad
http://correo.yahoo.es
_______________________________________________
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