We have a large web application that has 600Gb+ data. 400Gb of which are file attachments stored in Notes databases.
We are currently building a proof of concept to store file attachments to a RDBMS instead of Notes databases. We successfully store the file attachment to RDBMS via LS2J. Nevertheless, opening the attachment stored in RDBMS seems to be a lot more harder. We want to provide users a url link to launch the attachment. Our current design is to provide a url link to a Java agent with the RDBMS record key appended in the url. We got all things working in the Java agent except setting up the mime type in the HTTP header.
Is there a way to manipulate the http header in Java agents? Or do you have other suggestions to launch attachments stored in RDBMS via Domino?