EJB Tutorial from JBoss: Entity with Blob data
File: BlobEntity.java /* * JBoss, Home of Professional Open Source. * Copyright 2006, Red Hat Middleware LLC, and individual contributors * as indicated by the @author tags. See the copyright.txt file in the * distribution for a full listing of individual contributors. * * This is free software; you can redistribute it and/or modify it * under the terms of the GNU Lesser General Public License as * published by the Free Software Foundation; either version 2.1 of * the License, or (at your option) any later version. * * This software 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 * Lesser General Public License for more details. * * You should have received a copy of the GNU Lesser General Public * License along with this software; if not, write to the Free * Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA * 02110-1301 USA, or see the FSF site: http://www.fsf.org. */ package org.jboss.tutorial.blob.bean; import java.io.Serializable; import java.sql.Blob; import java.sql.Clob; import javax.persistence.Basic; import javax.persistence.Entity; import javax.persistence.FetchType; import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.Lob; /** * Comment * * @author <a href="mailto:bill@jboss.org">Bill Burke</a> * @version $Revision: 57207 $ */ @Entity public class BlobEntity implements Serializable { private long id; private Blob blobby; private Clob clobby; @Id @GeneratedValue(strategy=GenerationType.IDENTITY) public long getId() { return id; } public void setId(long id) { this.id = id; } @Lob @Basic(fetch = FetchType.EAGER) public Blob getBlobby() { return blobby; } public void setBlobby(Blob blobby) { this.blobby = blobby; } @Lob @Basic(fetch = FetchType.EAGER) public Clob getClobby() { return clobby; } public void setClobby(Clob clobby) { this.clobby = clobby; } } File: LobTester.java /* * JBoss, Home of Professional Open Source. * Copyright 2006, Red Hat Middleware LLC, and individual contributors * as indicated by the @author tags. See the copyright.txt file in the * distribution for a full listing of individual contributors. * * This is free software; you can redistribute it and/or modify it * under the terms of the GNU Lesser General Public License as * published by the Free Software Foundation; either version 2.1 of * the License, or (at your option) any later version. * * This software 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 * Lesser General Public License for more details. * * You should have received a copy of the GNU Lesser General Public * License along with this software; if not, write to the Free * Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA * 02110-1301 USA, or see the FSF site: http://www.fsf.org. */ package org.jboss.tutorial.blob.bean; import java.util.HashMap; /** * Comment * * @author <a href="mailto:bill@jboss.org">Bill Burke</a> * @version $Revision: 57207 $ */ public interface LobTester { long create(); HashMap findBlob(long id) throws Exception; String findClob(long id) throws Exception; long create2(); BlobEntity2 findBlob2(long id) throws Exception; } File: LobTesterBean.java /* * JBoss, Home of Professional Open Source. * Copyright 2006, Red Hat Middleware LLC, and individual contributors * as indicated by the @author tags. See the copyright.txt file in the * distribution for a full listing of individual contributors. * * This is free software; you can redistribute it and/or modify it * under the terms of the GNU Lesser General Public License as * published by the Free Software Foundation; either version 2.1 of * the License, or (at your option) any later version. * * This software 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 * Lesser General Public License for more details. * * You should have received a copy of the GNU Lesser General Public * License along with this software; if not, write to the Free * Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA * 02110-1301 USA, or see the FSF site: http://www.fsf.org. */ package org.jboss.tutorial.blob.bean; import java.io.ByteArrayOutputStream; import java.io.IOException; import java.io.ObjectInputStream; import java.io.ObjectOutputStream; import java.util.HashMap; import javax.ejb.Remote; import javax.ejb.Stateless; import javax.persistence.EntityManager; import javax.persistence.PersistenceContext; import javax.persistence.PersistenceContext; import org.hibernate.Hibernate; /** * Comment * * @author <a href="mailto:bill@jboss.org">Bill Burke</a> * @version $Revision: 57207 $ */ @Stateless @Remote(LobTester.class) public class LobTesterBean implements LobTester { @PersistenceContext EntityManager manager; public long create() { BlobEntity blob = new BlobEntity(); HashMap map = new HashMap(); map.put("hello", "world"); ByteArrayOutputStream baos = new ByteArrayOutputStream(); try { ObjectOutputStream oos = new ObjectOutputStream(baos); oos.writeObject(map); blob.setBlobby(Hibernate.createBlob(baos.toByteArray())); } catch (IOException e) { throw new RuntimeException(e); } String clobby = "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work"; blob.setClobby(Hibernate.createClob(clobby)); manager.persist(blob); return blob.getId(); } public HashMap findBlob(long id) throws Exception { BlobEntity blob = manager.find(BlobEntity.class, id); ObjectInputStream ois = new ObjectInputStream(blob.getBlobby().getBinaryStream()); return (HashMap) ois.readObject(); } public String findClob(long id) throws Exception { BlobEntity blob = manager.find(BlobEntity.class, id); return blob.getClobby().getSubString(1, 31); } public long create2() { BlobEntity2 blob = new BlobEntity2(); HashMap map = new HashMap(); map.put("hello", "world"); ByteArrayOutputStream baos = new ByteArrayOutputStream(); try { ObjectOutputStream oos = new ObjectOutputStream(baos); oos.writeObject(map); blob.setBlobby(baos.toByteArray()); } catch (IOException e) { throw new RuntimeException(e); } String clobby = "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work" + "This is a very long string that will be stored in a java.sql.Clob hopefully. We'll see how this works and if it will work"; blob.setClobby(clobby); manager.persist(blob); return blob.getId(); } public BlobEntity2 findBlob2(long id) throws Exception { return manager.find(BlobEntity2.class, id); } } File: BlobEntity2.java /* * JBoss, Home of Professional Open Source. * Copyright 2006, Red Hat Middleware LLC, and individual contributors * as indicated by the @author tags. See the copyright.txt file in the * distribution for a full listing of individual contributors. * * This is free software; you can redistribute it and/or modify it * under the terms of the GNU Lesser General Public License as * published by the Free Software Foundation; either version 2.1 of * the License, or (at your option) any later version. * * This software 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 * Lesser General Public License for more details. * * You should have received a copy of the GNU Lesser General Public * License along with this software; if not, write to the Free * Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA * 02110-1301 USA, or see the FSF site: http://www.fsf.org. */ package org.jboss.tutorial.blob.bean; import java.io.Serializable; import javax.persistence.Basic; import javax.persistence.Entity; import javax.persistence.FetchType; import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.Lob; /** * comment * * @author <a href="mailto:bill@jboss.org">Bill Burke</a> */ @Entity public class BlobEntity2 implements Serializable { private long id; private byte[] blobby; private String clobby; @Id @GeneratedValue(strategy=GenerationType.AUTO) public long getId() { return id; } public void setId(long id) { this.id = id; } @Lob @Basic(fetch = FetchType.EAGER) public byte[] getBlobby() { return blobby; } public void setBlobby(byte[] blobby) { this.blobby = blobby; } @Lob @Basic(fetch = FetchType.EAGER) public String getClobby() { return clobby; } public void setClobby(String clobby) { this.clobby = clobby; } } File: Client.java /* * JBoss, Home of Professional Open Source. * Copyright 2006, Red Hat Middleware LLC, and individual contributors * as indicated by the @author tags. See the copyright.txt file in the * distribution for a full listing of individual contributors. * * This is free software; you can redistribute it and/or modify it * under the terms of the GNU Lesser General Public License as * published by the Free Software Foundation; either version 2.1 of * the License, or (at your option) any later version. * * This software 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 * Lesser General Public License for more details. * * You should have received a copy of the GNU Lesser General Public * License along with this software; if not, write to the Free * Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA * 02110-1301 USA, or see the FSF site: http://www.fsf.org. */ package org.jboss.tutorial.blob.client; import java.util.HashMap; import javax.naming.InitialContext; import org.jboss.tutorial.blob.bean.LobTester; import org.jboss.tutorial.blob.bean.BlobEntity2; /** * Comment * * @author <a href="mailto:bill@jboss.org">Bill Burke</a> * @version $Revision: 57207 $ */ public class Client { public static void main(String[] args) throws Exception { InitialContext ctx = new InitialContext(); LobTester test = (LobTester) ctx.lookup("LobTesterBean/remote"); long blobId = test.create(); HashMap map = test.findBlob(blobId); System.out.println("is hello in map: " + map.get("hello")); System.out.println(test.findClob(blobId)); System.out.println("creating and getting a BlobEntity2 that uses byte[] and String instead of Clob/Blob"); blobId = test.create2(); BlobEntity2 entity = test.findBlob2(blobId); } }
1. | Save Binary Data Through Ejb | ![]() |