#4 the update after the "select for update"

[Anonymous]

I am getting the following with weblogic 5.1 & oracle
8i database

java.rmi.RemoteException: Could not update the High
Key. at
org.ejbutils.uid.UIDHighKeyGeneratorBean.getNextHighKey
(UIDHighKeyGeneratorBean.java:212)

I know about the AutoCommit issue in oracle and made
the change that you have mentioned.

What do you think the problem is?

[Nobody/Anonymous]

Logged In: NO

I have the same problem with weblogic 6.0 and oracle8i for
winnt, have you overcome that problem ? please let me know

[Emmanuel Sciara]

Logged In: YES
user_id=91163

Yes this is a known problem although I am not quiet sure
where it comes from.
It should be due to some setting on oracle 8i and the way
it handles transactions.

I think somebody mentioned the problem and a possible cause
on a thread on theServerSide. I will try to have a look,
but if anybody has time to look into this feel free.

[Emmanuel Sciara]

Logged In: YES
user_id=91163

Thanks a lot to Nguyen Huu Dung who seem to have found the
solution to the problem!

I will update the code when I have some time. Following is
his email to me:

Hi !

I 've finally made the ejbutils run well with oracle !

The problem is in ejbutils.sql file.

NAME CHAR(25) NOT NULL,
VALUE CHAR(28) NOT NULL

In your code :
ps = con.prepareStatement
(selectForUpdateQueryString);
ps.setString(1, theName);

the prepareStatement.setString did not map correctly to
Oracle CHAR type
when I changed CHAR to VARCHAR, it worked well

NAME VARCHAR(25) NOT NULL,
VALUE VARCHAR(28) NOT NULL

Thanks