Spring Roo: Saving/Retreving BLOB object in Spring Roo

Jochen Szostek says:

Thanks for sharing!

Might merge this into my project(s) and if I might find useful stuff to be added, I’ll be back. :)

grts

Jose Delgado says:

Jochen, publish the link when possible… It will be great to see it working on other projects.
If you want to see it working now. Visit the WorldAlmanac on the Cities Menu.

Cheers jD

Jose Delgado says:

Jochen,

It is the Document Document showcase…

Thx
jD

Pedro Cavaléro says:

Thank you! I was looking for it for a while and I think your post is the only place to get this information! Thanks for sharing!

cblicious says:

Thanks very much fpr this great sample ! :D

Randy says:

Great tutorial. Thanks! One question though. Will the browser cache the image given that it doesn’t change?

Faroo says:

Web site is very useful for me but i want this application in struts
can help me?

jD says:

Faroo,

I suggest you review article in this link http://viralpatel.net/tutorial-save-get-blob-object-spring-3-mvc-hibernate/. It is closer to an struts implementation. Or just
google “struts file uploads” you will tons of implementations out there.

Thx
jD

Faroo says:

Hi Jd,
the above application display the imgage from database how can i display in my jsp like above page i am also using same fields and same data but retriving data success but how can i display

jac says:

Good tutorial. When i try it , I have error with multi-tagx et file-tagx file , I don’t know the content of this file .

Thanks for your help

jD says:

@ jac,

What kind of error?…
Many other readers have tried it without any problem. Check you development configuration.

Thank you

Niklas Saers says:

Dear JD, thanks for a great article. Just one question: with this approach you load the entire BLOB up in RAM before sending it, right? While this works great for small images, larger files will be a problem. Do you have any recommendation on how to keep the memory footprint of the request low while keeping the simplicity you’re offering?

Cheers

Nik

Diego says:

Hi Jose,

I think Spring Roo in the intention is a very nice technology.
What its pitfall is , in my opinion, is the fact that it tries to bring Rails concept to the Java world, something Grails has already done.
I have also written about Roo: http://a-developer-life.blogspot.com/2011/03/spring-roo-what-disappointment.html

N. Berntsen says:

Great that you share this stuff. A little feedback

Your code sample:

newByteArrayMultipartFileEditor());

should have a space in it:

new ByteArrayMultipartFileEditor());

Moving the download link up in bit in the blog might help find it.

jD says:

Hello N. Berntsen ,

Thank you for bringing it to my attention…
The source code is coming from compiled/executable code. So the issue found happen when the article was out to my hands. I don’t want to sound defensive or blame others. I only say that is a weakness of the open source ecosystem and it shouldn’t be a big deal.

B. Roogards
jD

jD says:

@N. Berntsen,

Your site is showing an error when I tried to submit following blob…

Couple of question on the applicability of Model2Roo. Roo creates only scaffold-ed implementations which will be changed by the developer all the time. 1)Is Model2Roo able to reflect the introduced changes to the roo script and to uml project?

2)Most of the time you use Roo DBRE tool to create the project entities from a legacy database. How do you apply Model2Roo in this case?

B. Roogards
jD

Lifang says:

hello really nice workk i was wondering if i could use this example for uploading documents only ? is it possible ?

jD says:

@Lifang,

Yes… not a problem.

Roogards

jD says:

@Lifang,

As it is, the implementation shown could handle small to medium size docs…
In other to handle really big size docs it would have to be modified a little bit to use the filesystem instead the database to store it.

i believe this is a better answer to your question.

Thx and B. Roogards again
jD

Lifang says:

Hello i have followw all the guidelines i am having this error:
No tag “multi” defined in tag library associated with uri “urn:jsptagdir:/WEB-INF/tags/form”
this is due to the multi tag :S

Alex says:

Great tutorial but what about the option B?
Could you tell me how to do it? cuz i got a database schema and add a field named “picture” in one table but when I did reverse engineering it added that field on the form but can’t upload any pic.

Thanks in advance

Alex

jD says:

Alex,

Your picture field is just a blob a datatype referred in the article as content…
Just follow along the code for this field and make the correspondent modifications for your case.

Roogards
jD

Phil says:

Hey, Thanks for the Tutorial,

One Question, why use IOUtils.copy() in the DocumentController (thowing error by the way) instead of simply out.write(doc.getContent());?

Thanks

Phil

out.write(doc.getContent());

@RequestMapping(value = "/showdoc/{id}", method = RequestMethod.GET)
    public String showdoc(	@PathVariable("id") Long id,
    						HttpServletResponse response,
    						Model model) {
    	
    	Document doc = Document.findDocument(id);
    	

        try {
            response.setHeader("Content-Disposition", "inline;filename=\"" +doc.getFilename()+ "\"");

            OutputStream out = response.getOutputStream();
            response.setContentType(doc.getContentType());

            // IOUtils.copy( new ByteArrayInputStream(doc.getContent()) , out);
            out.write(doc.getContent());
            out.flush();
         
 
        } catch (IOException e) {
            e.printStackTrace();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return null;
    }

jD says:

@Phil,

The main purpose of my tutorial is to contrast traditional Spring web development vs. Roo development. In order to that I used the referred “original” tutorial referred at the top.
I hope I met my purpose.

At the time of upgrading the tutorial for handling big blog is will include your point.

Please visit my blog at http://pragmatikroo.blogspot.com. where you will find “probably” the largest collection of Roo articles available at this point.

Feedback is always welcome

Thank you and B. Roogards
jD

iar says:

This is a great article. You mention the commons-io dependency error at the end. My problem is that when I add this dependency (copy directly into the pom.xml or add from STS GUI context menu), nothing happens.

How can I get STS to download and enlist the new dependency with the existing ones?
Thanks.

iar says:

I found it: in STS, the Project context menu | Maven | Update Dependencies.
However, STS does not copy it to Tomcat, which uses the workspace location.

jD says:

@ian,

Thank you for you comment about my article…
Add the dependency straight into the pom,xml.

B. Roogards
jD

jD says:

I meant @iar,

Thank you for you comment about my article…
Add the dependency straight into the pom,xml.

B. Roogards
jD
Your

isaac fisher says:

it solved my problem. thanks a lot.

feng says:

Hi, Thanks for the Tutorial.
I run it successfully. Here I have question about update Blob in DB by Spring Roo. You disable the update in above code. Bu I am interested in how to update Blob in DB by Spring Roo. DO you have any investigation on update?

Feng

Bob says:

Hello,
I think “out.flush();” should be changed to “out.close();”. Or else, “java.net.SocketException: Connection reset by peer: socket write error” will occur.
Thanks for your sharing. It works well.

Bob

jD says:

@Bob,
I’ll clean it up…

Thank you for the fix.
jD

Robert says:

Great tutorial. :)

padesig says:

Hello all,

I have implemented this solution in a project, using ROO 1.2.0.RC1 and all seems working (I have noticed a —ClientAbortException: java.net.SocketException: Software caused connection abort: socket write error— but write and read worked well, anyway); now I have done the migration from ROO 1.2.0.RC1 to ROO 1.2.0.RELEASE (the current General Available) and I have noticed that I cannot write to or read from database; please, let me know if there are solutions to this…. the error is always —ClientAbortException: java.net.SocketException: Software caused connection abort: socket write error— created by at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:358)…

Neo says:

Thanks for the tutorial, it works like a charm, i actually dont need the multipart tag as it is supported by roo now.

But when I tried to do the same in update, I got some hibernate execption. Anyone did this for update as well ?

Miro says:

Can you please describe how to update image? In your tutorial you disabled, but I would like to know how to do update of image. What extra needs to be done? Thanks

Claus Guttesen says:

Thank you for the example. First I couldn’t display the image. After some trying (and failing) the following change to the controller was all I needed. In your example model.attribute() Document.findDocument(id) was the second argument.

This is on os x lion, roo 1.1.5, I have changed the class from Document to File:

@RequestMapping(value = “/{id}”, method = RequestMethod.GET)
public String show(@PathVariable(“id”) Long id, Model model) {
File file = File.findFile(id);
file.setUrl(“http://localhost:8080/gloppen/files/showfile/” + id);
model.addAttribute(“file”, file);
model.addAttribute(“itemId”, id);
return “files/show”;
}

regards
Claus

Vito Meuli says:

Many thanks Jose for sharing with us!
I really appreciate your efforts for the Roo community.

Just tryed it and it works like a charm.
I’m still having problems with the iframe…I don’t know it so I’ll need to study it a little bit. (the HTML code after the is not rendered from the browser, even if it is in the page).

Cheers,
Vito Meuli

John says:

Thanks for your tutorial. I almost bring it work in my Spring Roo project. However, when I click create New Document link, I got the following error.
SEVERE: Servlet.service() for servlet turbops threw exception
org.xml.sax.SAXException: No tag “multi” defined in tag library associated with uri “urn:jsptagdir:/WEB-INF/tags/form”

How I can fix it. Thanks.

Oliver says:

Hi jD, thanks very much for your work. This solution looks very promising, and similar to others I’ve seen, but when I try to upload a file I consistently get the error “The request sent by the client was syntactically incorrect ().” I’m using Roo 1.2.2-RELEASE. Enabling TRACE logging on Spring yields an exception:

TRACE org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod – Error resolving argument [3] [type=org.springframework.web.multipart.MultipartFile]
…
org.springframework.web.bind.MissingServletRequestParameterException: Required MultipartFile parameter ‘content’ is not present

It maps to the controller method well, but it seems something is wrong with the content parameter. It seems to be working behind the scenes however, since the log produces:

2012-09-21 13:14:24,602 [tomcat-http–46] DEBUG org.springframework.web.multipart.commons.CommonsMultipartResolver – Found multipart file [content] of size 13567 bytes with original filename [alpacca.jpg], stored at [C:\Programming\springsource\vfabric-tc-server-developer-2.7.1.RELEASE\spring-insight-instance\work\Catalina\localhost\upload-project\upload_5cc40fc_139e6c87815__7ffb_00000005.tmp]

Do you have any idea what might be going on?

Dhruv says:

hi jD,
i am a noob to spring roo. then i found your great tutorial to help me in my learning. Nice job with Roo :)
could you help me out with the error i am getting [similar to the many others :) ]?
the error message states ” No tag “multi” defined in tag library associated with uri “urn:jsptagdir:/WEB-INF/tags/form” ”
how do i go about this?
really appreciate any help on this
thanks and roogards
Dhruv

Dhruv says:

Ooops found out that it was my mistake in not going through the source code properly
thanks
Dhruv

karen85 says:

Hi, Thanks for the Tutorial.
I run it successfully. Here I have question about update Blob in DB by Spring Roo. You disable the update in above code. Bu I am interested in how to update Blob in DB by Spring Roo. DO you have any investigation on update?

Mahesh says:

Hi Jose,

Thanks for the excellent work u have made many life’s easy .
I am interested in second approach the Reverse engineering approach can u guide me to achieve the same functionality of file upload and view
can u please provide me the link to the doc

Jeff says:

Is this a typo in your roo creation script?

field numbert –fieldName size –

Jeff thurston says:

You have a typo in your roo sample creation script.

field numbert –fieldName size –

I like where are going with but you do provide enough details for someone new to Spring Roo, file names that have to modified and their locations would be a bonus.