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);
}
}
|