I develop a process with oracle bpm. this process have some activities that send attachments and comments together. my question is that where do save this attachments and comments? in database or file system? which table or which directory? i use default attachments and comments in HumanTasks.I hve to understand this files where do save, because i have to save this in my DB and use this in other processes.
can anybody help me?
This really depends, both approaches file/database works. If it was me then I would use the file system. Make sure this file system is mounted for clustering. This can be any directory you want.
The database is another option, but has more maintenance overhead. In my experience especially as you use attachment using file base performs better (as long if your hard disc is of reasonable standard)