So I tried the EROraclePlugIn and it works. It also generates different
SQL for updating my REVIEWER_DATA table. There is only one SQL statement
in the transaction:
UPDATE REVIEWER_DATA SET HAS_DONE_EXTERNAL_REVIEW = ?,
REVIEW_QUALIFICATIONS = ? WHERE (...)
No second SELECT, no EMPTY_CLOB()
not sure this is in yours or not, but i think the method you want is
OraclePlugIn's updateLOBs method.
ms
On May 25, 2011, at 12:30 PM, Michael Hast wrote:
> Hi:
>
> Thanks for the hint. The external type is all caps VARCHAR2. There is no
> surprise there. I will try out the Wonder Oracle plu
Hi:
Thanks for the hint. The external type is all caps VARCHAR2. There is no
surprise there. I will try out the Wonder Oracle plugin and see how it
behaves.
Michael.
On 5/25/2011 4:14 AM, Mike Schrag wrote:
Out of curiosity . Any chance the external types of those other locking attribut
Out of curiosity . Any chance the external types of those other locking
attributes are not in all caps? "varchar2" vs "VARCHAR2"?
Sent from my iPhone
On May 25, 2011, at 1:07 AM, Chuck Hill wrote:
> Hi Michael,
>
> On May 24, 2011, at 8:43 PM, Michael Hast wrote:
>
>> Hi:
>>
>> We had a
Hi Michael,
On May 24, 2011, at 8:43 PM, Michael Hast wrote:
> Hi:
>
> We had an interesting problem today. We have an entity called ReviewerData
> which has a personId and fiscalYear compound primary key. It also has 3 more
> attributes, a CLOB field, a varchar2(4000) and an Integer attribute
Hi:
We had an interesting problem today. We have an entity called
ReviewerData which has a personId and fiscalYear compound primary key.
It also has 3 more attributes, a CLOB field, a varchar2(4000) and an
Integer attribute. All attributes except the CLOB are marked as a
locking attribute (se
