• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Ron McLeod
  • Rob Spoor
  • Tim Cooke
  • Junilu Lacar
  • Henry Wong
  • Liutauras Vilda
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Tim Holloway
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
  • Al Hobbs
  • Mikalai Zaikin
  • Piet Souris

Large text

Posts: 26
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi all,
I am building a webapp using servlet/jsp with mySql. My question is "How to handle big articles from editors"
For instance, beginning of every week, my sports column editor updates content of the "Sports Section". I would like to make it so that the editor can type his column into a textarea (only the editor has access to) and click submit button to update the content. In behind the scene, I would use servlet and jsp to update the page (all visitors have access to) dynamically. What would be the most efficient way to store the content, which can be more than 1,000,000 characters, and make a call from servlet or jsp to update the page? I can only think of using "BLOB" data type in the database, but it somehow doesn't sound so appealing. Is there any other way that you could think of?
Saloon Keeper
Posts: 24295
Android Eclipse IDE Tomcat Server Redhat Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
One way would be to write the actual text out to a file and store the filename in the database.
Or you might consider a "CLOB", which is a Character Large Object. Which is sometimes actually implemented that way, but transparent to the database programmer.
Yeah, but does being a ninja come with a dental plan? And what about this tiny ad?
Thread Boost feature
    Bookmark Topic Watch Topic
  • New Topic