001    package railo.commons.sql;
002    
003    import java.lang.reflect.Method;
004    import java.sql.Clob;
005    import java.sql.Connection;
006    
007    import railo.commons.lang.ClassUtil;
008    import railo.runtime.op.Caster;
009    
010    public class OracleClob {
011    
012            private static Integer duration;
013            private static Integer mode;
014            private static Method createTemporary;
015            private static Method open;
016            private static Method setString;
017    
018            public static Clob createClob(Connection conn,String value,Clob defaultValue) {
019                    try{
020                            Class clazz = ClassUtil.loadClass("oracle.sql.CLOB");
021                            
022                            // CLOB.DURATION_SESSION;
023                            if(duration==null)      duration = Caster.toInteger(clazz.getField("DURATION_SESSION").getInt(null));
024                            // CLOB.MODE_READWRITE
025                            if(mode==null)          mode = Caster.toInteger(clazz.getField("MODE_READWRITE").getInt(null));
026     
027                            //CLOB c = CLOB.createTemporary(conn, false, CLOB.DURATION_SESSION);
028                            if(createTemporary==null)createTemporary = clazz.getMethod("createTemporary", new Class[]{Connection.class,boolean.class,int.class});
029                            Object clob = createTemporary.invoke(null, new Object[]{conn,Boolean.FALSE,duration});
030                            
031                            // c.open(CLOB.MODE_READWRITE);
032                            if(open==null)open = clazz.getMethod("open", new Class[]{int.class});
033                            open.invoke(clob, new Object[]{mode});
034    
035                            //c.setString(1,value);
036                            if(setString==null)setString = clazz.getMethod("setString", new Class[]{long.class,String.class});
037                            setString.invoke(clob, new Object[]{Long.valueOf(1),value});
038    
039                            return (Clob) clob;
040                    }
041                    catch(Throwable t){
042                            //print.printST(t);
043                    }
044                    return defaultValue;
045            }
046    
047    }