Re: Web security book

2003-02-21 Thread Jim.W.Berg
Professional Java Security  by Garms and Somerfield (WROX) 
Excellent build up of security using Hamlet as the example  (e.g How does 
the King of England know that the message that he received in a locked box 
from the King of Denmark hasn't been tampered with.  How could it have 
been tampered with?)
Jim Berg 
Sr. Software Specialist
PSCI
610-270-4158
[EMAIL PROTECTED]




Marco Tedone [EMAIL PROTECTED]

21-Feb-2003 07:24
Please respond to Struts Users Mailing List 
[EMAIL PROTECTED]

 
 

To: Struts-user-list 

cc: 
Subject:Web security book

Hi, does anyone of you could suggest to me a good book on web security 
using
java?

Regards,

Marco

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]







RE: [OT] Modeling tools

2003-02-10 Thread Jim.W.Berg
If they could only integrate the pieces better...

Jim Berg 
Sr. Software Specialist
PSCI
610-270-4158
[EMAIL PROTECTED]




Mark Galbreath [EMAIL PROTECTED]

10-Feb-2003 10:29
Please respond to Struts Users Mailing List 
[EMAIL PROTECTED]

 
 

To: 'Struts Users Mailing List'

cc: 
Subject:RE: [OT] Modeling tools

There is no alternative to Rose.

Mark Galbreath
Principal Consultant, Workflow Process Engineering and Systems Integration
http://www.QAT.com
410-703-367 / 800-799-8545

Never attribute to malice that which can be adequately explained by
stupidity.  ~Hanlon's Razor



-Original Message-
From: Durham David Cntr 805CSS/SCBE [mailto:[EMAIL PROTECTED]] 
Sent: Monday, February 10, 2003 10:04 AM
To: [EMAIL PROTECTED]
Subject: [OT] Modeling tools


Wondering what kind of modeling tools you would recommended.  I'm looking
for alternatives to Rational Rose and Poseidon.  Thanks.

-Dave

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]







Re: [OT Flame War Warning] What's a CMS?

2002-11-19 Thread Jim.W.Berg
NOFLAW has reported an insipid Flame War breakout in the Struts mailing
list

Jim Berg
Sr. Software Specialist
PSCI
610-270-4158
[EMAIL PROTECTED]


   

Kevin A. Smith   

[EMAIL PROTECTED] 

   

 To: Struts Users Mailing List   

19-Nov-2002 10:27  

Please respond tocc:   

Struts Users MailingSubject: [OT] What's a CMS?   

List  

[EMAIL PROTECTED] 

pache.org 

   

   




I respectfully disagree on your Blogging != CMS assertion. At least for the
more fully-featured blogging systems (Roller, Radio, and Blogger). I think
of these as one-person/single-site CMS's.

--Kevin

-Original Message-
From: James Higginbotham [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 19, 2002 10:19 AM
To: Struts Users Mailing List
Subject: RE: Struts in CMS ?


Blogging != CMS.. Google CMS and get a formal definition. I just did a
requirements gathering project to find a true CMS solution, and I don't
know how many people classified blogging and cheesy web site publishing
as a CMS solution (well, at least 350 before I quite counting). Just a
pet peave of mine - trying to inform, nothing more.

FYI,
James

 -Original Message-
 From: Kevin A. Smith [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, November 19, 2002 7:55 AM
 To: Struts Users Mailing List
 Subject: RE: Struts in CMS ?


 The Roller weblogging package uses Struts. Here's a couple of links:

 Project home page: http://www.rollerweblogger.org/page/project
 Develper Diary: http://rollerweblogger.org/page/roller

 --Kevin

 -Original Message-
 From: Fabrice FOUREL [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, November 19, 2002 7:40 AM
 To: [EMAIL PROTECTED]
 Subject: Struts in CMS ?


 Hello,

 Does anyboy know if opencms (or another cms tool) support
 Struts-based application ? I saw there's an integration of
 JSPs (and JSP tags).

 Thanks.

 Fabrice Fourel



 --
 To unsubscribe, e-mail:
 mailto:struts-user- [EMAIL PROTECTED]
 For
 additional commands,
 e-mail: mailto:[EMAIL PROTECTED]


 --
 To unsubscribe, e-mail:
 mailto:struts-user- [EMAIL PROTECTED]
 For
 additional commands,
 e-mail: mailto:[EMAIL PROTECTED]



--
To unsubscribe, e-mail:   
mailto:[EMAIL PROTECTED]
For additional commands, e-mail: 
mailto:[EMAIL PROTECTED]


--
To unsubscribe, e-mail:   
mailto:[EMAIL PROTECTED]
For additional commands, e-mail: 
mailto:[EMAIL PROTECTED]







--
To unsubscribe, e-mail:   mailto:[EMAIL PROTECTED]
For additional commands, e-mail: mailto:[EMAIL PROTECTED]




Re: New Struts Article posted on OnJava

2002-11-01 Thread Jim.W.Berg
to anyone trying to reach this page, make surethat you pick up the l in 
html.  My email program has it on the next line.

Jim Berg 
Sr. Software Specialist
PSCI
610-270-4158
[EMAIL PROTECTED]




[EMAIL PROTECTED]

01-Nov-2002 10:53
Please respond to Struts Users Mailing List 
[EMAIL PROTECTED]

 
 

To: struts-user

cc: 
Subject:New Struts Article posted on OnJava

Sorry for the self promotion, but I thought this article 
might help some on thes list. I wrote a Struts lessons 
learned article for O'Reilly that contains information 
that is discussed here on the list frequently, but never 
hurts to be explained in more detail. 

Here's the link to the article:
http://www.onjava.com/pub/a/onjava/2002/10/30/jakarta.htm
l

Enjoy,
chuck

--
To unsubscribe, e-mail:   mailto:struts-user-unsubscribe;jakarta.apache.org
For additional commands, e-mail: mailto:struts-user-help;jakarta.apache.org







RE: Can V in MVC be Swing in Struts?

2002-10-18 Thread Jim.W.Berg
We have a prototype that we are using that uses Struts as the framework.
We have a JTree applet that is displayed as part of the view component.
This way we get to use an Explorer-type interface with the power of the
JTree Swing component.  The tags to implement a tree pane was pretty ugly
on our first attempt.  The applet approach made everything much cleaner.
We have a set of classes to populate the tree model for the applet.

Jim Berg
Sr. Software Specialist
PSCI
610-270-4158
[EMAIL PROTECTED]


   

Xue-Feng Yang

[EMAIL PROTECTED]  

   

 To: Struts Users Mailing List   

17-Oct-2002 00:19  

Please respond tocc:   

Struts Users MailingSubject: RE: Can V in MVC be 
Swing in Struts? 
List  

[EMAIL PROTECTED] 

pache.org 

   

   




JSP is interpreted into a servlet in a servlet
container such as Tomcat. So JSP should work on this.
Servlet is not only designed for HTML browser, so is
JSP.

I will try it and believe this should work!

 --- David Graham [EMAIL PROTECTED] wrote:  I
think you're trying to force technologies into
 areas they weren't designed
 for.  What would the JSP do if it didn't have HTML
 in it?  JSP's main job is
 displaying dynamic html.  Swing for client apps,
 Struts for webapps.

 David






 From: Xue-Feng Yang [EMAIL PROTECTED]
 Reply-To: Struts Users Mailing List
 [EMAIL PROTECTED]
 To: Struts Users Mailing List
 [EMAIL PROTECTED],
 [EMAIL PROTECTED]
 Subject: RE: Can V in MVC be Swing in Struts?
 Date: Thu, 17 Oct 2002 00:08:36 -0400 (EDT)
 
 The response could be a String, an XML, a HTML or a
 HexString.
 
 I am wondering if I can make a JSP without HTML
 tags.
 If this is the case, then the thing can be done. So
 far, I use servlet to do this. It would be nice if
 I
 can built on Struts.
 
 --- Andrew Hill [EMAIL PROTECTED]
 wrote:
   Ah well in that case yes, I dont see why not.
   Didnt think of that scenario!
  
   What sort of response would you be returning to
 this
   swing client? xml?
  
   -Original Message-
   From: Xue-Feng Yang [mailto:just4look;yahoo.com]
   Sent: Thursday, October 17, 2002 11:57
   To: Struts Users Mailing List;
   [EMAIL PROTECTED]
   Subject: RE: Can V in MVC be Swing in Struts?
  
  
   The Swing app I mentioned talks to servlets via
   HTTP/HTTPS.
  
--- Andrew Hill
 [EMAIL PROTECTED]
   wrote:  Practically speaking no - as Struts is
 very
   much web
oriented and reliant on
a lot of the servlet container functionality
 (ie:
requests and responses,
etc...).
   
   
-Original Message-
From: Xue-Feng Yang
 [mailto:just4look;yahoo.com]
Sent: Thursday, October 17, 2002 11:48
To: Struts Users Mailing List
Subject: Can V in MVC be Swing in Struts?
   
   
Can V in MVC be Swing in Struts?
   
   
  

__
Post your free ad now!
 http://personals.yahoo.ca
   
--
To unsubscribe, e-mail:
   
  
 mailto:struts-user-unsubscribe;jakarta.apache.org
For additional commands, e-mail:
mailto:struts-user-help;jakarta.apache.org
   
   
--
To unsubscribe, e-mail:
   
  
 mailto:struts-user-unsubscribe;jakarta.apache.org
For additional commands, e-mail:
mailto:struts-user-help;jakarta.apache.org
   
  
  

__
   Post your free ad now! http://personals.yahoo.ca
  
   --
   To unsubscribe, e-mail:
  
 mailto:struts-user-unsubscribe;jakarta.apache.org
   For additional commands, e-mail:
   mailto:struts-user-help;jakarta.apache.org
  
  
   --
   To unsubscribe, e-mail:
  
 

RE: [BEER]Disadvantages of Struts

2002-09-12 Thread Jim.W.Berg

Do we really need to expose the skeletons?  Especially when they have been 
imbibing (RE:BEER)

Jim Berg 
[EMAIL PROTECTED]




Galbreath, Mark [EMAIL PROTECTED]

12-Sep-2002 07:48
Please respond to Struts Users Mailing List 
[EMAIL PROTECTED]

 
 

To: 'Struts Users Mailing List'

cc: 
Subject:RE: Disadvantages of Struts

Having to put up with me on this list?

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 12, 2002 12:21 AM

Hi All,

Can any one tell me what are the disadvantages of Struts?.
Your help is appreciated

thanks and regards
Raghu


--
To unsubscribe, e-mail:   mailto:[EMAIL PROTECTED]
For additional commands, e-mail: mailto:[EMAIL PROTECTED]







RE: If you haven't seen this yet.

2002-06-21 Thread Jim.W.Berg

And I have never seen a Rattlesnake that had a turtle shell!

Jim Berg 
Sr. Software Specialist
PSCI
610-270-4158
[EMAIL PROTECTED]




Galbreath, Mark [EMAIL PROTECTED]

21-Jun-2002 07:04
Please respond to Struts Users Mailing List 
[EMAIL PROTECTED]

 
 

To: 'Struts Users Mailing List'

cc: 
Subject:RE: If you haven't seen this yet.

I guess Flash scripters don't know the difference between a Dalmation and 
a
Black Lab, huh?  That's the kind of attention-to-detail I'd be looking 
for!
;-)

-Original Message-
From: James Mitchell [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 21, 2002 12:38 AM
To: Struts Users Mailing List
Subject: If you haven't seen this yet.


Mark, I thought you'd like this one :-)

http://www.theserverside.com/home/thread.jsp?thread_id=14080



James Mitchell
Software Engineer\Struts Evangelist
Struts-Atlanta, the Open Minded Developer Network
http://struts-atlanta.open-tools.org

--
To unsubscribe, e-mail:
mailto:[EMAIL PROTECTED]
For additional commands, e-mail:
mailto:[EMAIL PROTECTED]

--
To unsubscribe, e-mail:   mailto:[EMAIL PROTECTED]
For additional commands, e-mail: mailto:[EMAIL PROTECTED]







RE: SQL STatements in a Properties file.

2002-06-10 Thread Jim.W.Berg

The reason for putting your SQL in a properties files is so that you or
whomever is doing research or maintenance on the code can find all of the
SQL in one place, instead of having to search all over for DAO's ( which
can get pretty ugly).  Abstraction is usually good, obfuscation is not
good.

Jim Berg
Sr. Software Specialist
PSCI
610-270-4158
[EMAIL PROTECTED]


   

Vikram Goyal01   

vikram_goyal01@infosy 

s.com 

 To: Struts Users Mailing List, 
Struts-Atlanta   
   

07-Jun-2002 00:55cc:   

Please respond toSubject: RE: SQL STatements in a 
Properties file. 
Struts Users Mailing  

List  

[EMAIL PROTECTED] 

pache.org 

   

   




I am not quite sure that putting your SQL in a properties file is such a
good idea. Whats the advantage?
If the advantage is that you dont have to change the source code because of
query changes, then I think that it is misleading. If the query changes,
there must have been a business requriement for it --  you have to change
functionality somewhere -- Means you have to change your source code to
take advantage of this new query somewhere down the line (EJB, Action, JSP
) -- So you end up touching your source code. The whole idea of DAO's is
to abstract your queries and data access. Having another level of
abstraction is IMHO pointless.

Rgs
Vikram

-Original Message-
From: James Mitchell [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 07, 2002 4:44 AM
To: Struts Users Mailing List
Subject: RE: SQL STatements in a Properties file.


The framework knows nothing of sql.

However, I have also pondered the using the message resources for something
like this.
I guess if your data layer had access to the message resourcesyou could
do something like this.

sql.customers.get=Select * from customers
sql.customer.get=Select * from customers where id = {0}
sql.customer.update=update customers set name={0}, address={1} where id =
{3}
sql.customer.delete=detete from customers where id = {0}

Although, this can get pretty messy quickly.
Have you considered using an OR tool???


James Mitchell
Software Engineer\Struts Evangelist
Struts-Atlanta, the Open Minded Developer Network
http://struts-atlanta.open-tools.org
ICQ: 27651409
AOLIM: jmitchtx (and NO I don't use AOL;)


 -Original Message-
 From: Olikkadavath, Bobby [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, June 06, 2002 1:57 PM
 To: [EMAIL PROTECTED]
 Subject: SQL STatements in a Properties file.


 Hi,
 A newbie question...
 I want to dynamically pickup SQL queries from a Properties file
 (Similar to
 how we use the bean : Message  and the ApplicationResourceProperties FIle
 for Static content in a JSP).
 Does the framework have an implementation exclusively for this or should
I
 create something on my own.

 Thanks
 Bobby



--
To unsubscribe, e-mail:   
mailto:[EMAIL PROTECTED]
For additional commands, e-mail: 
mailto:[EMAIL PROTECTED]


--
To unsubscribe, e-mail:   
mailto:[EMAIL PROTECTED]
For additional commands, e-mail: 
mailto:[EMAIL PROTECTED]







--
To unsubscribe, e-mail:   mailto:[EMAIL PROTECTED]
For additional commands, e-mail: mailto:[EMAIL PROTECTED]




Re: New Site

2002-04-10 Thread Jim.W.Berg

I would also check that your JSP's are pre-compiled.  The JSP's are
compiled as servlets wen they are first called after changes.  That can
take some time as well.  We have been getting excellent performance across
a T1 over the Atlantic that goes from Philly to Raleigh to the UK and back
aain.

Jim Berg
Sr. Software Specialist
PSCI
610-270-4158
[EMAIL PROTECTED]


   

Pete Carapetyan  

pete@datafundamentals 

.com  

 To: Struts Users Mailing List   

   

10-Apr-2002 08:10cc:   

Please respond toSubject: Re: New Site 

Struts Users Mailing  

List  

[EMAIL PROTECTED] 

pache.org 

   

   




Galbreath, Mark wrote:

 This is not very encouraging.  At 6:30 AM EST on a T-1 I finally gave up
 when the page had not fully loaded after 3 minutes(!!).  My personal
 experience with Struts (we are committed to it at this point for
VoiceStream
 Global Wireless's new ecommerce sites) is that it slows processing and
page
 deleivery considerably.  Anyone else notice this?

No.

I would look for a bug in your code, not in Struts. Have you run a profiler
on it to see where it is spending it's time?


 Mark

 -Original Message-
 From: Martin Samm [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 09, 2002 8:27 AM
 To: [EMAIL PROTECTED]
 Subject: New Site

 Just thought i'd another 'Powered By Struts' site to the list -
 www.peoplenews.com.
 Its a showbiz / gossip site which until recently ran on Vignette (yuk) .
 While the content may not be to everyone's taste, it is popular, about
19M
 hits last month. It's been running for 2 days, so may have a couple of
 teething problems, but it does seem to have scaled well.
 --
 Martin Samm
 [EMAIL PROTECTED]

 --
 To unsubscribe, e-mail:
 mailto:[EMAIL PROTECTED]
 For additional commands, e-mail:
 mailto:[EMAIL PROTECTED]

 --
 To unsubscribe, e-mail:   
mailto:[EMAIL PROTECTED]
 For additional commands, e-mail: 
mailto:[EMAIL PROTECTED]

--
To unsubscribe, e-mail:   
mailto:[EMAIL PROTECTED]
For additional commands, e-mail: 
mailto:[EMAIL PROTECTED]







--
To unsubscribe, e-mail:   mailto:[EMAIL PROTECTED]
For additional commands, e-mail: mailto:[EMAIL PROTECTED]




Re: Why Struts - Ryan Norman

2002-03-27 Thread Jim.W.Berg

Ryan,
   Struts is app server neutral.  I am currently working on a project 
using struts and WebLogic. We have saved a tremendous amount of time by 
implementing struts as our framework.  You should not be looking at this 
as struts and Tomcat versus Web Sphere and ?  You should look at this as 
struts and whichever ap server you want. 

Jim Berg 





Ryan Norman [EMAIL PROTECTED]

27-Mar-2002 12:48
Please respond to Struts Users Mailing List 
[EMAIL PROTECTED]

 
 

To: struts-user, LA Java User Group

cc: 
Subject:Why Struts - Ryan Norman

Hi,

I am Ryan Norman.

Are there frameworks available in other commercial Java Web Servers like 
Web Sphere, iPlanet, JRun, etc.

. If so why should somebody use struts framework rather than using the Web 
Server's native framework?
. Are there people who are using struts with commercial Java Web Server 
like Web Sphere, iPlanet, JRun, etc.

Thanks in advance

Ryan Norman






Re: Struts with (Oracle's) UIX (presentation layer taglib)

2002-02-28 Thread Jim.W.Berg

What is a guy from Chicago doing with Cleveland?  How do I look at the 
tags?  Are they on OTN?  Or is this a partner promo?

Jim Berg  U of Chicago '78
Sr. Software Specialist
PSCI
[EMAIL PROTECTED]




Bomb Diggy [EMAIL PROTECTED]

27-Feb-2002 16:16
Please respond to Struts Users Mailing List 
[EMAIL PROTECTED]

 
 

To: struts-user

cc: 
Subject:Struts with (Oracle's) UIX (presentation layer taglib)


Has anyone tried to use Struts with Oracle's UIX
presentation layer tag libs?

The UIX stuff seems fairly extensive, and even
includes some controller-related functionality, but I
haven't been able to figure it out yet.  The UIX
Controller also has somewhat limited functionality,
supposedly, compared to Oracle's new fandangled
MVC-concept Project Cleveland - I have *no* idea what
Cleveland is attempting to do, but it looks
aggressive.

I'd feel much more comfortable with using Struts as a
controller...



__
Do You Yahoo!?
Yahoo! Greetings - Send FREE e-cards for every occasion!
http://greetings.yahoo.com

--
To unsubscribe, e-mail:   mailto:[EMAIL PROTECTED]
For additional commands, e-mail: mailto:[EMAIL PROTECTED]






RE: changing from *.do to /do/* screws up everything? - Jerry Sp ringersums up...

2002-02-27 Thread Jim.W.Berg

Are you saying that beer on friday contributes to sloppy designs and lazy 
coding?

Jim Berg 
Sr. Software Specialist
PSCI
[EMAIL PROTECTED]




Galbreath, Mark [EMAIL PROTECTED]

27-Feb-2002 15:02
Please respond to Struts Users Mailing List 
[EMAIL PROTECTED]

 
 

To: 'Struts Users Mailing List'

cc: 
Subject:RE: changing from *.do to /do/* screws up everything? - Jerry 
Sp ringer 
sums up...


They're only as exposed as you make them!  A JSP is a presentation layer
object and belongs in the web-app directory.  Burying them in the same 
space
as the controller invites sloppy designs and lazy coding.

(Perhaps I should wait until Friday for this?)

Mark

-Original Message-
From: Rob Breeds [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 27, 2002 2:54 PM

It seems that migrating from a *.do to /do/* is not as straightforward as
I'd hoped. Especially if putting JSPs under WEB-INF (which is better than
leaving them exposed).

--
To unsubscribe, e-mail:   mailto:[EMAIL PROTECTED]
For additional commands, e-mail: mailto:[EMAIL PROTECTED]






Re: Nathan Smith/Corporate/FSC is out of the office.

2002-02-19 Thread Jim.W.Berg

Why do I care?

Jim Berg
Sr. Software Specialist
PSCI
[EMAIL PROTECTED]


--
To unsubscribe, e-mail:   mailto:[EMAIL PROTECTED]
For additional commands, e-mail: mailto:[EMAIL PROTECTED]




RE: Can anyone help me how to unsubscribe

2002-02-06 Thread Jim.W.Berg

You can send an email to the following:
[EMAIL PROTECTED]

When you get a response back, make sure that you send a blank reply to the 
address indicated in the message.  If you do not follow the instructions, 
then you will not be unsubscribed.  I successfully unsubscribed last 
Friday and then resubscribed on Monday just to check it out.  I suspect 
that either the second message is not being sent by the subscribers, or 
the second message is not correct.  The former is probably the most 
frequent occurance. 
 Good luck.   Remember Scotty never did trust the transporters.


Jim Berg 
Sr. Software Specialist
PSCI
[EMAIL PROTECTED]




Galbreath, Mark [EMAIL PROTECTED]

06-Feb-2002 08:07
Please respond to Struts Users Mailing List 
[EMAIL PROTECTED]

 
 

To: 'Struts Users Mailing List'

cc: 
Subject:RE: Can anyone help me how to unsubscribe


Welcome to the Hotel California

Mark

-Original Message-
From: Krishnamoorthy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 1:12 AM
To: Struts Users Mailing List
Subject: Can anyone help me how to unsubscribe


Actually I tried in all the possible ways to unsubscribe.
Not only me lots of other guys are tring to do it.but no use ,
could anyone help us to unsubscribe from struts.

Thanks
Kicha


--
To unsubscribe, e-mail:
mailto:[EMAIL PROTECTED]
For additional commands, e-mail:
mailto:[EMAIL PROTECTED]

--
To unsubscribe, e-mail:   mailto:[EMAIL PROTECTED]
For additional commands, e-mail: mailto:[EMAIL PROTECTED]






Re: How to Unsubscribe

2002-02-01 Thread Jim.W.Berg

Read the next to last line in your mesage that was sent. Or any message 
that you receive.

Jim Berg 
Sr. Software Specialist
PSCI
[EMAIL PROTECTED]




Tony Chen [EMAIL PROTECTED]

01-Feb-2002 08:01
Please respond to Struts Users Mailing List 
[EMAIL PROTECTED]

 
 

To: struts-user

cc: 
Subject:How to Unsubscribe


Hello,
I like to Unsubscribe from the mail list. Can someone show how to?
Thanks!

--tony

_
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx


--
To unsubscribe, e-mail:   mailto:[EMAIL PROTECTED]
For additional commands, e-mail: mailto:[EMAIL PROTECTED]






RE: When to store files in DB vs. File system

2001-12-03 Thread Jim.W.Berg

Another issue to consider when evaluating file system versus database is
synchronizing your database backup with the file system backup if you are
keeping file state information in the database.  I've managed a couple of
document systems where the documents are in a file system and the state of
the doc is in the database.  It was difficult to do any type of incremental
backup that kept the database and the documents in synch.  We ended up do
full backups everytime just to be safe.

Jim Berg
Sr. Software Specialist
PSCI
[EMAIL PROTECTED]


   

Gavin Terrill

[EMAIL PROTECTED]   

   

 To: Struts Users Mailing List   

03-Dec-2001 11:03  

Please respond tocc:   

Struts Users MailingSubject: RE: When to store files 
in DB vs. File system
List  

[EMAIL PROTECTED] 

pache.org 

   

   





I would recommend using the file system, and storing the location in the
db:
- the file system is faster
- storing files in the DB tends to generate enormous database physical
files, so back ups become an issue
- integrating with a freetext search engine becomes harder (you may need
this down the track)

We have not seen issues with the number of files in a directory,
although we also partition files across directories to minimize the
number of files and avoid OS limitations (a simple way to do this is to
use \MM\DD as the directory structure).

vendor
You may also want to check out: http://www.karora.com/DocConn.htm
/vendor

Gavin Terrill
CTO, Karora Technologies Inc.
http://www.karora.com



-Original Message-
From: Ted Husted [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 6:48 AM
To: Struts Users Mailing List
Subject: Re: When to store files in DB vs. File system


I've seen a lot of implementations do this sort of thing, especially
when archive emails and the like.

I've also heard that people find many OS's start to slow down with even
1000 files in a directory, so I believe many such systems use that as an
increment /1/000 - /1/999.

A general piece of good advice is that databases excel at storing
itty-bitty pieces of information, and files systems are good for storing
a larger blocks. If you decouple the actual files from the rest of the
database, you also have the opportunity to centralize that stored on a
machine optimized for that purpose.

If you need something to index those files, I'd have a look at Lucene
;-)

http://jakarta.apache.org/lucene


-- Ted Husted, Husted dot Com, Fairport NY USA.
-- Custom Software ~ Technical Services.
-- Tel +1 716 737-3463
-- http://www.husted.com/struts/

Darryl Nortje wrote:

 Hi.

 Everyone is going to tell you that you must store it in the database.
 The reason are that in different OS's, there is a limit to how many
 files you can store in each directory. (windows i think is 1). I
 was faced with this same problem under a time constraint, so never
 took the time to figure out how to store the file directly into the
 database. So i went the a directory storing route. What I did was
 Create a directory root\1\1a\1aa\file.extension like this. Set a limit

 to the amount of files in this directory and when that limit was
 reached incremented the directory name to root\1\1a\1ab etc etc. And
 then just stored the directory and filename in the database and
 retrieved it like that. I'm pretty sure that this is not the correct
 way to do this sort of thing, but it does work. I will be watching
 this mail to find out how to do it properly.

 -Original Message-
 From: Andy Timm [mailto:[EMAIL PROTECTED]]
 Sent: Monday, December 03, 2001 9:53 AM
 To: [EMAIL PROTECTED]
 Subject: When to store files in DB vs. File