• 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 ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Storing attachments in Access?

 
Ranch Hand
Posts: 1902
Hibernate Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Before I start, yes, I realize Access is not an ideal database solution.
I've been asked by a coworker to write a JSP/Servlet front-end to an Access database in which we're storing our data on requested enhancements to an application, so the developers can access the list and update it from their desktops. The problem is a request to be able to attach up to two files to these requests.
Anyone have any ideas how I can 'convince' Access, by the JDBC-ODBC bridge, to store the files?
Thanks in advance.
 
Theodore Casser
Ranch Hand
Posts: 1902
Hibernate Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Let me refine this, since I seem to be attracting very little in the way of help.
I've figured out how to get JDBC to store the uploaded file... but not in a format I can use. (It's storing it as binary data, which is great, but I need to be able to retrieve the file in its original format for use.) Any thoughts on what I'm doing wrong?
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic