How to upload image in database

[shrikanth shrikanth, módosítva 10 év-val korábban]

hello frds,
i have simple requirment i want to upload image in mysql database from jsp to action class as well as i want to retrive image from databse and show to another jsp plz help me.

[Subhash Pavuskar, módosítva 10 év-val korábban]

https://www.liferay.com/community/forums/-/message_boards/message/21627007

[shrikanth shrikanth, módosítva 10 év-val korábban]

i didn't get from this link can u plz send code of u..

[Muhammed Shafeek V, módosítva 10 év-val korábban]

Hi brother, try this

<portlet:actionURL var="uploadFilesURL" name="UploadFiles" />

<liferay-ui:error key="image-size-exceeded"
message="error-image-size-exceeded"/>

<aui:form action="<%= uploadFilesURL %>" enctype="multipart/form-data">
<aui:input type="hidden" name="bookId" value="<%= bookId %>"/>
<aui:input type="hidden" name="redirectURL"
value="<%= redirectURL %>"/>
<aui:input name="coverImage" type="file">
<aui:validator name="acceptFiles">
'jpg, png'
</aui:validator>
</aui:input>



<aui:button type="submit"/>
</aui:form>



public boolean processCommand(PortletRequest portletRequest,
PortletResponse portletResponse)
throws PortletException {

ActionRequest actionRequest = (ActionRequest) portletRequest;
ActionResponse actionResponse = (ActionResponse) portletResponse;

UploadPortletRequest uploadRequest =
PortalUtil.getUploadPortletRequest(actionRequest);

File coverImage = uploadRequest.getFile("coverImage");


return true;
}


And if you want to save that image into db use Image table of liferay.

[shrikanth shrikanth, módosítva 10 év-val korábban]

thanks for replying...........
sir i want to insert image in databse iam not geting how should i send to databse can u plz help me plz send code tht

[ritresh girdhar, módosítva 10 év-val korábban]

shrikanth shrikanth:

thanks for replying...........
sir i want to insert image in databse iam not geting how should i send to databse can u plz help me plz send code tht

Try this "http://stackoverflow.com/questions/18821813/upload-using-servlet-java-netbean-to-mysql-database"

But this is not best practice to save image in database, You should use some JSR 170,or place image in file system and add their path in db.

[shrikanth shrikanth, módosítva 10 év-val korábban]

i wnt to upload my image using service builder

[meera prince, módosítva 10 év-val korábban]

HI
I have used BLOB data type in service builder its working success fully..
The following is example portlet and information use BLOB data type in service builder
I have done this to 6.2 portal and same you can do for other version it will work as for my guess..

http://www.liferaysavvy.com/2013/12/using-blob-data-type-in-liferay-service.html


Regards,

Meera Prince

http://www.liferaysavvy.com

[shrikanth shrikanth, módosítva 10 év-val korábban]

thanks for replying after adding.........how can i retrive to another jsp ans show to another jsp

[meera prince, módosítva 10 év-val korábban]

Hi Try this

import java.sql.Blob;
import java.io.OutputStream;


Photo photo=PhotoLocalServiceUtil.getPhoto(1);
Blob image=photo.getData();
byte[ ] imgData=image.getBytes(1,(int)image.length());
response.setContentType("image/jpg");
OutputStream o = response.getOutputStream();
o.write(imgData);
o.flush();
o.close();

[shrikanth shrikanth, módosítva 10 év-val korábban]

sir this code should i put in jsp.bcoz i want to show image in jsp so how can i show to jsp.

[shrikanth shrikanth, módosítva 10 év-val korábban]

<column name="data" type="Blob" />

Blob is not valid data type in version 6.2 so plz help me

[meera prince, módosítva 10 év-val korábban]

Hi
I have done sample portlet u can download see the code...

http://www.liferaysavvy.com/2013/12/using-blob-data-type-in-liferay-service.html


Regards,
Meera Prince

[shrikanth shrikanth, módosítva 10 év-val korábban]

sir ur code is not working on my laptop blob data type error is throwing plz help me

[meera prince, módosítva 10 év-val korábban]

Hi

What is error in log please send me some deatiled description and screen shot..

Use portal Version 6.2 and Plugins SDK 6.2 +Tomcat 7.x and MySQL 5.1.

Go through following link and set up environment as guided in the article. i made it for same environment...

http://www.liferaysavvy.com/2013/12/liferay-62-portal-development.html


Regards,
Meera Prince.