Insert BLOB into a DB

[Esteban Cairol]

Hello!

Im having a problem when trying to insert a blob type variable into the Data Base (MySQL 4.1). In fact, the exception triggers when the the p.setBlob() is done, where p is the PreparedStatement.

Some details you may want to know before read the error:
- Im using Hibernate to convert from FormFile to Blob. I didn't install Hibernate complete on my application, in fact, I just put the hibernate3.jar on the classpath to use this converting function. Its not used for anything else.
- Im using Java 4.1 and Apache Tomcat 4.1

The exception is this:

java.lang.UnsupportedOperationException: Blob may not be manipulated from creating session
at org.hibernate.lob.BlobImpl.excep(BlobImpl.java:104)
at org.hibernate.lob.BlobImpl.getBytes(BlobImpl.java:50)
at org.hibernate.lob.SerializableBlob.getBytes(SerializableBlob.java:35)
at com.mysql.jdbc.PreparedStatement.setBlob(PreparedStatement.java:2296)
at pool.ConexionBD.setBlob(ConexionBD.java:380)
at gestores.GestorArchivo.registrarArchivo(GestorArchivo.java:40)
at logica.InterfazArchivo.subirArchivo(InterfazArchivo.java:37)
at acciones.ArchivoAccion.execute(ArchivoAccion.java:49)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:145)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:955)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:139)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:955)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2460)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:133)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:119)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:955)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:127)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:955)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:157)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:536)   

The code:

Method that creates the connection.

public synchronized boolean subirArchivo(String nombre, FormFile file, int sector) throws Exception {
 ConexionBD conn = new ConexionBD();
        try{
        /* The class Hibernate (in the hibernate3.jar) converts to BLOB type the file that comes as FormFile */
        Blob fileBlob = Hibernate.createBlob(file.getInputStream());
            boolean r = GestorArchivo.getInstancia().registrarArchivo(conn, nombre, fileBlob, sector);
            return r;
        }catch (SQLException ex){
            throw new SQLException...

Function registrarArchivo (this is like.. "uploadFile")

 public synchronized boolean registrarArchivo(ConexionBD conn, String nombre, Blob file, int sector) throws SQLException {
        String consulta = "INSERT INTO TArchivo VALUES (default, ?, ?, ?)";
        
        try{
        conn.setSQL(consulta);
            conn.setString(1, nombre);
            *conn.setBlob(2, file);*
            conn.setInt(3, sector);
        }catch(Exception e){
        e.printStackTrace();
        }

That line with the * is where the app is breaking.

Finally, the setBlob method:

public void setBlob(int variable, Blob valor) throws SQLException {
        if( valor == null ){
            p.setNull( variable, java.sql.Types.BLOB );
        }else{
            p.setBlob( variable, valor );
        }   
    } 

Please, if you could help me I'll appreciate it a lot..!
Thanks!
[ July 14, 2007: Message edited by: Esteban Cairol ]

[Jeanne Boyarsky]

Esteban,
I'm going to move this to our Hibernate forum. Since the stack trace has Hibernate classes in it, I think people will be more likely to know the answer there.

[Esteban Cairol]

Originally posted by Jeanne Boyarsky:
Esteban,
I'm going to move this to our Hibernate forum. Since the stack trace has Hibernate classes in it, I think people will be more likely to know the answer there.

Ok.. thanks!

[Paul Sturrock]

Im using Hibernate to convert from FormFile to Blob. I didn't install Hibernate complete on my application, in fact, I just put the hibernate3.jar on the classpath to use this converting function. Its not used for anything else

Hmm. Sounds like a dodgy thing to do - there's probably more going on in the Hibernate class than a simple bean. Could you not just use a byte array?

[Esteban Cairol]

Originally posted by Paul Sturrock:

Hmm. Sounds like a dodgy thing to do - there's probably more going on in the Hibernate class than a simple bean. Could you not just use a byte array?

Thanks for answering Paul.
What I have to do is to insert a file into the Data Base. It could be an image, or other type of files..

I haven't found another way to do that than using a byte array (I mean, a BLOB). If you know other way to do that, it would be great.

Thanks!