users@glassfish.java.net

RE: question on images and DB

From: Eve Pokua <gorgeous65_at_msn.com>
Date: Thu, 17 Sep 2009 15:14:00 +0100

Hi,

Matter
 
I believe i might take your suggestion, even though images takes up more space.
I believe maintenance of the application would be easier. And syn data from the
DB which relates to the particular image would be easier.
 
i was reading this:
 
http://www.extremeexperts.com/sql/FAQ/StoreImages.aspx
 
Hi

 

Hassan
 
Just put them in the filesystem. Storing large binaries in a relational
db is a pointless complication. IMO.

 

How so I manage this.

 

If I have 0ver 200 items I have to syn an image on a filesystem- store

the image in a folder and point each row of data I collect from the database

with an image. How is that possible?

 

To achive your suggestion I have to:

 

<td width="9"><img src="images/mainTab_Inactive_left.gif" ></td>.
<td width="9"><img src="images/mainTab_Inactive_left.gif" ></td>.


 

similar to the able.. But remember I am using displaytag. eg.:

 

<display:table name="test">
  <display:column property="id" title="ID" />
  <display:column property="name" />
  <display:column property="email" />
  <display:column property="status" />
  <display:column property="description" title="Comments"/>

<td width="9"><img src="images/mainTab_Inactive_left.gif" ></td>.

</display:table>

 

If I was storing in a DB, I would do something like this:

 

<display:table name="test">
  <display:column property="id" title="ID" />
  <display:column property="name" />
  <display:column property="email" />
  <display:column property="status" />
  <display:column property="description" title="Comments"/>

<display:column property="image"/>

 

"image" would be a field within the DB which stores the image.

 

Makes it easy to syn.

 

What you think?

 

eve

 

 

 

 

 

 
eve
 
> Date: Thu, 17 Sep 2009 06:28:14 -0700
> From: glassfish_at_javadesktop.org
> To: users_at_glassfish.dev.java.net
> Subject: Re: question on images and DB
>
> Most DBs have a BLOB or CBLOB type that you can use for large binary object types. Since this is a GF forum and not an MSSQL forum you're better off reading the relevant documentation or tracking down an MSSQL support forum for more help on this.
>
> [b]<rant>[/b]Why do some people ask such random questions in this forum? Seriously weird.[b]</rant>[/b]
> [Message sent by forum member 'matterbury' (matterbury_at_abinitio.com)]
>
> http://forums.java.net/jive/thread.jspa?messageID=364417
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>


                                                _________________________________________________________________ Share your photos with Windows Live Photos – Free. http://clk.atdmt.com/UKM/go/134665338/direct/01/