• 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
Problem matching against Oracle CLOB
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Problem matching against Oracle CLOB


  • Subject: Problem matching against Oracle CLOB
  • From: "John Boynton" <email@hidden>
  • Date: Wed, 09 Apr 2003 10:29:05 -0700

Hi.

I've submitted a bug report (# 3222966) on this problem to Apple, but
would like to know about any possible workarounds from folks here.

The problem is this: If you try to do a query match against an attribute
whose external data type is CLOB, the qualifier looks like

	text caseinsensitivelike '*<your entered text>*'

and WebObjects generates SQL that has

	WHERE UPPER(T0.TEXT) LIKE UPPER(EMPTY_CLOB())

instead of what you'd expect:

	WHERE UPPER(T0.TEXT) LIKE UPPER('*<your entered text>*')

and Oracle9i throws the exception "ORA-22275: invalid LOB locator
specified."


Do any of you know a workaround, short of writing raw SQL by hand? I'd
like to avoid that because of an existing structure that creates
qualifiers, and I would like to be able to use raw rows and EOs
interchangeably in certain instances.

I've also tried LONG, but it is scheduled for desupport by Oracle, and
Oracle 9i doesn't allow LIKE against a LONG. I'd use VARCHAR2 but for
Oracle's 4K limit on those; I need more room than this. I also tried the
hack of using VARCHAR2 or LONG in the model while keeping the CLOB on the
database column, but I get null results when retrieving the attribute of
interest.

There's a working sample application at
http://scribe.artlogic.com/scripts/WebObjects.dll/ClobTest which
demonstrates the problem.

Any help would be appreciated.

Thanks,
John
--
John Boynton
Web Applications Engineer
Art & Logic, www.artlogic.com
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.

  • Follow-Ups:
    • Re: Problem matching against Oracle CLOB
      • From: Kaj Hejer <email@hidden>
  • Prev by Date: Re: action binding with conditionals
  • Next by Date: Re: Problem matching against Oracle CLOB
  • Previous by thread: Re: Localizable.strings question
  • Next by thread: Re: Problem matching against Oracle CLOB
  • Index(es):
    • Date
    • Thread