Re: ANY DB2 Experts Here????
Re: ANY DB2 Experts Here????
- Subject: Re: ANY DB2 Experts Here????
- From: James Cicenia <email@hidden>
- Date: Tue, 22 Mar 2005 13:17:36 -0600
OK -
It only doesn't seem to work from WO. I tested the queries via
QuantumDB a plugin for eclipse and they work. So I guess
you must be right (like always), so how difficult is a plugin to write?
And I don't have Practical WebObjects on me, it is at
home at the moment. Is the answer in there? ;-)
Otherwise, any pointers to example plugins etc would be great as I
can't use straight jdbc for this area of my application.
- James Cicenia
On Mar 22, 2005, at 1:10 PM, Chuck Hill wrote:
And if it only does not work from WO, there may be restrictions in DB2
on using bindings with these functions. Plugin time! :-)
Chuck
On Mar 22, 2005, at 11:06 AM, Sacha Mallais wrote:
On Mar 22, 2005, at 10:09 am, James Cicenia wrote:
All queries that generate UPPER in them crash!
Maybe explain what this means a little better.
This is related to my other question where I was using
CaseInsensitiveLike, I got around that one
by just using a straight SQL call as I was only testing for
existence.
HOWEVER, my very cool report generator that uses DTW will not work
if any of the queries create
an UPPER in the SQL. However, if I cut and paste the generated sql
from the exception it will work?!!!!
In the vague recesses of my memory, I barely recall something about
the DB2 JDBC driver not liking the UPPER function on certain data
types. IIRC, we eventually just used a collation.
Here's a link that might help:
http://www.ibm.com/developerworks/db2/library/techarticle/
0203adamache/0203adamache.html?isrc_d=99999999
sacha
--
Sacha Michel Mallais - 800 lb. gorilla
Global Village Consulting Inc.: http://www.global-village.net/
ObAd: read "Practical WebObjects" <fnord>
http://www.global-village.net/products/practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
village.net
This email sent to email@hidden
--
Practical WebObjects - a book for intermediate WebObjects developers
who want to increase their overall knowledge of WebObjects, or those
who are trying to solve specific application development problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
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