Thanks for your quick reply! I've attached the original post, which contains a diff and a modified version of MMOracle.java.
Remco On Fri, Oct 25, 2002 at 16:35, Rob van Maris wrote: > I'm willing to review these changes. We have installed MMBase on > WebLogic/Oracle for a client, and needed to adapt the MMBase supportclass > for Oracle in a number of places. Haven't committed the changes to CVS > already, but will do so soon. > > Please you send me your sourcefiles - they didn't make it to de mailinglist. > > Regards, > > Rob van Maris > Developer > > Finalist IT Group > Java Specialists
--- Begin Message ---Hi all, I have found some bugs in this Java class: MMOracle.java In attachment there is this class modified by me (MODIFIED_MMOracle.java) and a difference file between the original class and my modification (MMOracle.java.diff). Below a few clarifications. //---------------------------------------------------------------------- ---------------- Bug Fix in methods: getDBText(ResultSet rs,int idx) and removeNode(MMObjectBuilder bul,MMObjectNode node). 1. getDBText, was not take care that when try to retrieved a field from the oracle DB as clob but it is not a clob, oracle driver give an exception: "Invalid column type". 2. removeNode, was not take care that Oracle is not an Object Oriented DB, so tables inherited doesn't exists, so when delete insrel it also necessary to delete rows in subtable of insrel. Added more debugs information in method: getDBKeyOld(). P.S. If the db is empty (without table created) when start tomcat, mmbase created the tables without problems and all work fine, but the method getDBKeyOld() give this strange error: "MMBase -> while getting a new key number: ORA-00942: table or view does not exist" on the table object. Seems to me, that this method is invoked before the object table is created. //---------------------------------------------------------------------- ----------------
MMOracle.java.diff
Description: Binary data--- End Message ---
Description: Binary data
