[Pljava-dev] Trigger problem

[Mark Colman]

Hi Thomas,
> My guess would be that you have a jar containing the 
> javax.mail stuff on 
> the classpath when you compile and run your test harness but 
> you never 
> load this jar into your database. The JVM is then unable to 
> instantiate 
> your SendMail class since it's depedent on Message, MimeMessage, etc.

You're absolutely right.  I have now executed

Select
sqlj.install_jar('file:///c:/j2sdk1.4.2_09/lib/Mail.jar','Mail',true);
Select
sqlj.install_jar('file:///c:/j2sdk1.4.2_09/lib/Activation.jar','Activation',
true);
Select sqlj.set_classpath('public','Activation:Mail:SendMail');

The old error has been replaced by:

server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.

Which I guess means my SendMail.send method is faulty in some way.  Any
further suggestions?  In particular, could I amend my exception handler to
write any error messages to the PostgreSQL log file?

Mark