X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=source%2Fmircoders%2Fentity%2FEntityOther.java;h=de1334b65d5344995fea284de87acd919b096cb0;hb=e98015ace7d45c4633645a2309c0209962a4d0a1;hp=1c063fefb8b27817c1a367a10e99ab28f6d148e9;hpb=8563841098b6ab3e6233f61519e58b41dcc30266;p=mir.git diff --git a/source/mircoders/entity/EntityOther.java b/source/mircoders/entity/EntityOther.java index 1c063fef..de1334b6 100755 --- a/source/mircoders/entity/EntityOther.java +++ b/source/mircoders/entity/EntityOther.java @@ -69,87 +69,6 @@ public class EntityOther extends EntityUploadedMedia setStorage(theStorage); } - // - // methods - - - - public byte[] getOther() throws StorageObjectException - { - theLog.printDebugInfo("--getother started"); - java.sql.Connection con=null;Statement stmt=null; - byte[] img_data=null; - - try { - con = theStorageObject.getPooledCon(); - con.setAutoCommit(false); - LargeObjectManager lom; - java.sql.Connection jCon; - stmt = con.createStatement(); - ResultSet rs = theStorageObject.executeSql(stmt, - "select other_data from other where id="+getId()); - jCon = ((com.codestudio.sql.PoolManConnectionHandle)con) - .getNativeConnection(); - lom = ((org.postgresql.Connection)jCon).getLargeObjectAPI(); - if(rs!=null) { - if (rs.next()) { - LargeObject lob = lom.open(rs.getInt(1)); - img_data = lob.read(lob.size()); - lob.close(); - //img_data = rs.getBytes(1); - } - rs.close(); - } - } catch (Exception e) { - e.printStackTrace(); - theLog.printError("EntityOther -- getOther failed"+e.toString()); - throwStorageObjectException(e, "EntityOther -- getOther failed: "); - } - finally { - try { - con.setAutoCommit(true); - } catch (Exception e) { - e.printStackTrace(); - theLog.printError( - "EntityOther -- getOther reseting transaction mode failed" - +e.toString()); - } - theStorageObject.freeConnection(con,stmt); - } - - return img_data; - } - - public void setOther(byte[] otherData, String otherType) - throws StorageObjectException { - - if (otherData!=null) { - java.sql.Connection con=null;PreparedStatement pstmt=null; - try { - - theLog.printDebugInfo("settother :: making internal representation of other"); - theLog.printDebugInfo("settother :: made internal representation of other"); - theLog.printDebugInfo("settother :: getOther"); - - if ( otherData!=null) { - con = theStorageObject.getPooledCon(); - con.setAutoCommit(false); - theLog.printDebugInfo("settother :: trying to insert other"); - - // setting values - pstmt.setBytes(1, otherData); - String sql="update content set is_produced='0' where to_media="+getId(); - pstmt = con.prepareStatement(sql); - pstmt.executeUpdate(); - } - } - catch (Exception e) {throwStorageObjectException(e, "settother :: setOther gescheitert: ");} - finally { - try { if (con!=null) con.setAutoCommit(true); } catch (Exception e) {;} - theStorageObject.freeConnection(con,pstmt); } - } - } - public void update() throws StorageObjectException { super.update(); try {