I've commited a new postgres driver version that adds the command
blob_select_file. It's used in tcl as follows:
ns_pg blob_select_file $db $lob_id $filename
where:
db is the database handle
lob_id is the same lob_id used in the other lob hack commands.
filename is a file name of your choice.
I've also added a tcl function called "database_lob_to_tcl_string"
which is used as follows:
set msg_body [database_lob_to_tcl_string $db $lob_id]
There both only used in the webmail module so far. If anybody
encounters any problems with new driver let me know. The changes were
minor, so it should work o.k.
Webmail seems to be functional now except for some scalability
problems:
- JDBC Driver is extremly slow
- Java virtual machine is started each time somebody sends a message
- Java virtual machine runs out of memory when mail is sent that has
a large attachment
But other than those minor problems, it works great :).