How to store image in database?

[Winster]

Hi,

Is there any way to store an image in database? I have a multi tenant
envrionment and application logo should be a user/tenant uploaded image.

In OFBiz, I could see only a file managed storage system for images. Is
that true?


Thanks
Winster T Jose
Director - Technology and Architecture
Chathurangam Creative Solutions Private Ltd.
Cell: [phone]
Mail: [hidden email]

[Malin Nicolas]

Hi,

Do you look the content application ? You can use a content to save
image and load on you template decoractor by <content> element

Nicolas

Le 10/01/2013 10:42, Winster Jose a écrit :

> Hi,
>
> Is there any way to store an image in database? I have a multi tenant
> envrionment and application logo should be a user/tenant uploaded image.
>
> In OFBiz, I could see only a file managed storage system for images. Is
> that true?
>
>
> Thanks
> Winster T Jose
> Director - Technology and Architecture
> Chathurangam Creative Solutions Private Ltd.
> Cell: [phone]
> Mail: [hidden email]
>

[Winster]

Hi Malin ,thanks for the reply.

But even for a content, the associated datasource stores the image in file
system and not in database. It just stores the location in ObjectInfo
field. Am I correct?


On Thu, Jan 10, 2013 at 3:17 PM, Malin Nicolas <
[hidden email]> wrote:

> Hi,
>
> Do you look the content application ? You can use a content to save image
> and load on you template decoractor by <content> element
>
> Nicolas
>
> Le 10/01/2013 10:42, Winster Jose a écrit :
>
>  Hi,
>>
>> Is there any way to store an image in database? I have a multi tenant
>> envrionment and application logo should be a user/tenant uploaded image.
>>
>> In OFBiz, I could see only a file managed storage system for images. Is
>> that true?
>>
>>
>> Thanks
>> Winster T Jose
>> Director - Technology and Architecture
>> Chathurangam Creative Solutions Private Ltd.
>> Cell: [phone]
>> Mail: [hidden email]
>>
>>
>

--
Winster T Jose
Director - Technology and Architecture
Chathurangam Creative Solutions Private Ltd.
Cell: [phone]
Mail: [hidden email]

[Malin Nicolas]

Depends on your dataResourceType.

By default OFBiz use OFBIZ_FILE, but some process use other type as
IMAGE_OBJECT on your case.

The ressource will store on ImageDataRessource entity as you wish.

Nicolas

Le 10/01/2013 11:59, Winster Jose a écrit :

> Hi Malin ,thanks for the reply.
>
> But even for a content, the associated datasource stores the image in file
> system and not in database. It just stores the location in ObjectInfo
> field. Am I correct?
>
>
> On Thu, Jan 10, 2013 at 3:17 PM, Malin Nicolas <
> [hidden email]> wrote:
>
>> Hi,
>>
>> Do you look the content application ? You can use a content to save image
>> and load on you template decoractor by <content> element
>>
>> Nicolas
>>
>> Le 10/01/2013 10:42, Winster Jose a écrit :
>>
>>   Hi,
>>> Is there any way to store an image in database? I have a multi tenant
>>> envrionment and application logo should be a user/tenant uploaded image.
>>>
>>> In OFBiz, I could see only a file managed storage system for images. Is
>>> that true?
>>>
>>>
>>> Thanks
>>> Winster T Jose
>>> Director - Technology and Architecture
>>> Chathurangam Creative Solutions Private Ltd.
>>> Cell: [phone]
>>> Mail: [hidden email]
>>>
>>>
>

Maybe off topic.
But it general it is considered a bad idea to store an image in a database.
(several reasons, e.g. performance)
Normally one only stores the url of the image in the database.

Kind regards

Tore

On 10/01/13 10:42, Winster Jose wrote:

> Hi,
>
> Is there any way to store an image in database? I have a multi tenant
> envrionment and application logo should be a user/tenant uploaded image.
>
> In OFBiz, I could see only a file managed storage system for images. Is
> that true?
>
>
> Thanks
> Winster T Jose
> Director - Technology and Architecture
> Chathurangam Creative Solutions Private Ltd.
> Cell: [phone]
> Mail: [hidden email]
>

[Sumit Pandit]

Agreed with Tore,

Reference to Winster's question-
Yes it store the image in the data base in BLOB format when dataResourceTypeId=IMAGE_OBJECT is used,
for reference please have a look at following urls -

https://demo-trunk.ofbiz.apache.org/content/control/EditDataResource?dataResourceId=Winster_Jose 
https://demo-trunk.ofbiz.apache.org/content/control/UploadImage?dataResourceId=Winster_Jose 
https://demo-trunk.ofbiz.apache.org/webtools/control/FindGeneric?entityName=ImageDataResource&find=true&VIEW_SIZE=50&VIEW_INDEX=0 

--
Thanks And Regards
Sumit Pandit
Tata Consultancy Services
Cell:- 917503046188
____________________________________________

----- Original Message -----

| From: [hidden email]
| To: [hidden email]
| Sent: Friday, January 11, 2013 11:11:48 AM
| Subject: Re: How to store image in database?

| Maybe off topic.
| But it general it is considered a bad idea to store an image in a
| database.
| (several reasons, e.g. performance)
| Normally one only stores the url of the image in the database.

| Kind regards

| Tore

| On 10/01/13 10:42, Winster Jose wrote:
| > Hi,
| >
| > Is there any way to store an image in database? I have a multi
| > tenant
| > envrionment and application logo should be a user/tenant uploaded
| > image.
| >
| > In OFBiz, I could see only a file managed storage system for
| > images. Is
| > that true?
| >
| >
| > Thanks
| > Winster T Jose
| > Director - Technology and Architecture
| > Chathurangam Creative Solutions Private Ltd.
| > Cell: [phone]
| > Mail: [hidden email]
| >
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you

[Winster]

Thank you Malin, Sumit and Tore.

That really helped me a lot.


On Fri, Jan 11, 2013 at 11:20 AM, Sumit Pandit <[hidden email]> wrote:

> Agreed with Tore,
>
> Reference to Winster's question-
> Yes it store the image in the data base in BLOB format when
> dataResourceTypeId=IMAGE_OBJECT is used,
> for reference please have a look at following urls -
>
>
> https://demo-trunk.ofbiz.apache.org/content/control/EditDataResource?dataResourceId=Winster_Jose
>
> https://demo-trunk.ofbiz.apache.org/content/control/UploadImage?dataResourceId=Winster_Jose
>
> https://demo-trunk.ofbiz.apache.org/webtools/control/FindGeneric?entityName=ImageDataResource&find=true&VIEW_SIZE=50&VIEW_INDEX=0
>
> --
> Thanks And Regards
> Sumit Pandit
> Tata Consultancy Services
> Cell:- 917503046188
> ____________________________________________
>
> ----- Original Message -----
>
> | From: [hidden email]
> | To: [hidden email]
> | Sent: Friday, January 11, 2013 11:11:48 AM
> | Subject: Re: How to store image in database?
>
> | Maybe off topic.
> | But it general it is considered a bad idea to store an image in a
> | database.
> | (several reasons, e.g. performance)
> | Normally one only stores the url of the image in the database.
>
> | Kind regards
>
> | Tore
>
> | On 10/01/13 10:42, Winster Jose wrote:
> | > Hi,
> | >
> | > Is there any way to store an image in database? I have a multi
> | > tenant
> | > envrionment and application logo should be a user/tenant uploaded
> | > image.
> | >
> | > In OFBiz, I could see only a file managed storage system for
> | > images. Is
> | > that true?
> | >
> | >
> | > Thanks
> | > Winster T Jose
> | > Director - Technology and Architecture
> | > Chathurangam Creative Solutions Private Ltd.
> | > Cell: [phone]
> | > Mail: [hidden email]
> | >
> =====-----=====-----=====
> Notice: The information contained in this e-mail
> message and/or attachments to it may contain
> confidential or privileged information. If you are
> not the intended recipient, any dissemination, use,
> review, distribution, printing or copying of the
> information contained in this e-mail message
> and/or attachments to it are strictly prohibited. If
> you have received this communication in error,
> please notify us by reply e-mail or telephone and
> immediately and permanently delete the message
> and any attachments. Thank you
>
>
>

--
Winster T Jose
Director - Technology and Architecture
Chathurangam Creative Solutions Private Ltd.
Cell: [phone]
Mail: [hidden email]