001 package railo.commons.sql; 002 003 import java.lang.reflect.Method; 004 import java.sql.Blob; 005 import java.sql.Connection; 006 007 import railo.commons.lang.ClassUtil; 008 import railo.runtime.op.Caster; 009 010 public class OracleBlob { 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 setBytes; 017 018 public static Blob createBlob(Connection conn,byte[] barr,Blob defaultValue) { 019 try{ 020 Class clazz = ClassUtil.loadClass("oracle.sql.BLOB"); 021 022 // BLOB.DURATION_SESSION 023 if(duration==null) duration = Caster.toInteger(clazz.getField("DURATION_SESSION").getInt(null)); 024 // BLOB.MODE_READWRITE 025 if(mode==null) mode = Caster.toInteger(clazz.getField("MODE_READWRITE").getInt(null)); 026 027 //BLOB blob = BLOB.createTemporary(conn, false, BLOB.DURATION_SESSION); 028 if(createTemporary==null)createTemporary = clazz.getMethod("createTemporary", new Class[]{Connection.class,boolean.class,int.class}); 029 Object blob = createTemporary.invoke(null, new Object[]{conn,Boolean.FALSE,duration}); 030 031 //blob.open(BLOB.MODE_READWRITE); 032 if(open==null)open = clazz.getMethod("open", new Class[]{int.class}); 033 open.invoke(blob, new Object[]{mode}); 034 035 //blob.setBytes(1,barr); 036 if(setBytes==null)setBytes = clazz.getMethod("setBytes", new Class[]{long.class,byte[].class}); 037 setBytes.invoke(blob, new Object[]{Long.valueOf(1),barr}); 038 039 return (Blob) blob; 040 } 041 catch(Throwable t){ 042 //print.printST(t); 043 } 044 return defaultValue; 045 } 046 047 }