• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Escape character question
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Escape character question

  • Subject: Re: Escape character question
  • From: Anjo Krank <email@hidden>
  • Date: Mon, 24 Oct 2005 21:40:13 +0200
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)
at
com.webobjects.appserver._private.WOComponentRequestHandler._dispatch WithPreparedSession(WOComponentRequestHandler.java:287)
at
com.webobjects.appserver._private.WOComponentRequestHandler._dispatch WithPreparedApplication(WOComponentRequestHandler.java:322)
at
com.webobjects.appserver._private.WOComponentRequestHandler._handleRe quest(WOComponentRequestHandler.java:358)
at
com.webobjects.appserver._private.WOComponentRequestHandler.handleReq uest(WOComponentRequestHandler.java:432)
at
com.webobjects.appserver.WOApplication.dispatchRequest (WOApplication.java:1306)
at
com.webobjects.appserver._private.WOWorkerThread.runOnce (WOWorkerThread.java:173)
at
com.webobjects.appserver._private.WOWorkerThread.run (WOWorkerThread.java:254)
at java.lang.Thread.run(Thread.java:552)

Kind regards,

Ismael Jones
email@hidden




______________________________________________
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:
40cluster9.com

This email sent to email@hidden




_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40logicunited.com

This email sent to email@hidden


_______________________________________________
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




  • Follow-Ups:

      

    • Re: MORE Escape character question

      • From: Ismael Perdido <email@hidden>
      • 





References: 


 >Escape character question (From: Ismael Perdido <email@hidden>)


 >Re: Escape character question (From: David Teran <email@hidden>)






    

  • Prev by Date:
Re: Escape character question

    • 

  • Next by Date:
Re: SSL with WO 5 documentation?

    • 

  • Previous by thread:
Re: Escape character question

    • 

  • Next by thread:
Re: MORE Escape character question

    • 

  • Index(es):

      

    • Date
      • 

    • Thread
      • 

    

    •