Hi, Can somebody please review these changes and commit them to the cvs? We at Framfab depend on these for a customer and would really like to see it find it's way into mmbase.
This works well for us when using the oci8 jdbc driver from 8.1.7 on NT, the clob and blob types work properly now. Unfortunately the thin driver still has a 4000 byte limit on column values.. Thanx, Remco On Tue, Oct 08, 2002 at 10:38, Aldo Babucci wrote: > 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. > //---------------------------------------------------------------------- > ---------------- >
