X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=source%2Fmircoders%2Fentity%2FEntityVideo.java;h=65397b5ba3be7b29e7dc68c1133502e7261b54e6;hb=7cceb33aa6141506ca8cfb7952790ec5c912681b;hp=dfb1cf7d056e228a1f03337d1c32d4e0fb546c00;hpb=8563841098b6ab3e6233f61519e58b41dcc30266;p=mir.git diff --git a/source/mircoders/entity/EntityVideo.java b/source/mircoders/entity/EntityVideo.java index dfb1cf7d..65397b5b 100755 --- a/source/mircoders/entity/EntityVideo.java +++ b/source/mircoders/entity/EntityVideo.java @@ -64,59 +64,6 @@ public class EntityVideo extends EntityUploadedMedia // // methods - public byte[] getVideoData() throws StorageObjectException - { - - Connection con=null;Statement stmt=null; - byte[] video_data=null; - - try { - con = theStorageObject.getPooledCon(); - con.setAutoCommit(false); - stmt = con.createStatement(); - ResultSet rs = theStorageObject.executeSql(stmt,"select video_data from video where id="+getId()); - if(rs!=null) { - if (rs.next()) { - video_data = rs.getBytes(1); - } - rs.close(); - } - } - catch (Exception e) {theLog.printDebugInfo("-- getImage gescheitert: "+e.toString());} - finally { - try {con.setAutoCommit(true); } catch (Exception e) {;} - theStorageObject.freeConnection(con,stmt); } - - return video_data; - } - - public void setVideoData(byte[] uploadData) throws StorageObjectException - { - if (uploadData!=null) { - Connection con=null;PreparedStatement pstmt=null; - try { - - con = theStorageObject.getPooledCon(); - con.setAutoCommit(false); - theLog.printDebugInfo("setvideo :: trying to insert video"); - - // setting values - String sql = "update videos set image_data=? where id="+getId(); - theLog.printDebugInfo("setvideo: "+ sql); - pstmt = con.prepareStatement(sql); - pstmt.setBytes(1, uploadData); - pstmt.executeUpdate(); - sql="update content set is_produced='0' where to_media="+getId(); - pstmt = con.prepareStatement(sql); - pstmt.executeUpdate(); - } - catch (Exception e) {theLog.printDebugInfo("setvideo :: setvideo gescheitert: "+e.toString());} - finally { - try {con.setAutoCommit(true); } catch (Exception e) {;} - theStorageObject.freeConnection(con,pstmt); } - } - } - public void update() throws StorageObjectException { super.update(); try {