X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=source%2Fmircoders%2Fentity%2FEntityOther.java;h=ba4d46852c21d9f7b3ed520cf0ab9cae7c10c97b;hb=d74a52d5f65389e5cf89d3fcf14d07afbb78a9f9;hp=6cd505a3e1df5916efd28b5fb4d8a4e8cf8b0c6c;hpb=c6a2204d8d75293256fd17c07e54971d7672359a;p=mir.git diff --git a/source/mircoders/entity/EntityOther.java b/source/mircoders/entity/EntityOther.java index 6cd505a3..ba4d4685 100755 --- a/source/mircoders/entity/EntityOther.java +++ b/source/mircoders/entity/EntityOther.java @@ -1,25 +1,39 @@ -package mircoders.entity; - -import java.lang.*; -import java.io.*; -import java.util.*; -import java.sql.*; - /* - * kind of hack for postgres non-standard LargeObjects that Poolman - * doesn't know about. see all the casting, LargeObj stuff in getIcon, getOther - * at some point when postgres has normal BLOB support, this should go. + * Copyright (C) 2001, 2002 The Mir-coders group + * + * This file is part of Mir. + * + * Mir is free software; you can redistribute it and/or modify + * it under the terms of the GNU General Public License as published by + * the Free Software Foundation; either version 2 of the License, or + * (at your option) any later version. + * + * Mir is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU General Public License for more details. + * + * You should have received a copy of the GNU General Public License + * along with Mir; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + * + * In addition, as a special exception, The Mir-coders gives permission to link + * the code of this program with any library licensed under the Apache Software License, + * The Sun (tm) Java Advanced Imaging library (JAI), The Sun JIMI library + * (or with modified versions of the above that use the same license as the above), + * and distribute linked combinations including the two. You must obey the + * GNU General Public License in all respects for all of the code used other than + * the above mentioned libraries. If you modify this file, you may extend this + * exception to your version of the file, but you are not obligated to do so. + * If you do not wish to do so, delete this exception statement from your version. */ -import org.postgresql.Connection; -import org.postgresql.largeobject.LargeObject; -import org.postgresql.largeobject.LargeObjectManager; -import mir.entity.*; -import mir.misc.*; -import mir.storage.*; +package mircoders.entity; + +import java.util.Map; /** - * This class handles storage of other data and meta data + * This class handles database of other data and meta data * * @author mh * @version 11.11.2000 @@ -28,113 +42,16 @@ import mir.storage.*; public class EntityOther extends EntityUploadedMedia { - public EntityOther() - { - super(); - } - - public EntityOther(StorageObject theStorage) { - this(); - 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 { - theStorageObject.executeUpdate("update content set is_produced='0' where to_media="+getId()); - } catch (SQLException e) { - throwStorageObjectException(e, "EntityOther :: update :: failed!! "); - } - } - - public void setValues(HashMap theStringValues) - { - if (theStringValues != null) { - if (!theStringValues.containsKey("is_published")) - theStringValues.put("is_published","0"); - } - super.setValues(theStringValues); - } + public EntityOther() { + super(); + } + + public void setFieldValues(Map theStringValues) { + if (theStringValues != null) { + if (!theStringValues.containsKey("is_published")) + theStringValues.put("is_published", "0"); + } + super.setFieldValues(theStringValues); + } }