[Gnumed-devel] re: restart tomcat please

[catmat]

Hello Carlos, can you restart tomcat ?
I've come across OutOfMemoryError , and when I try to restart
catalina I get permission denied for server.xml and log/catalina.out.

(Maybe there is a leak in this version of tomcat?)

also , There seems to be a problem with the jdbc postgres driver, maybe 
its a bit old.
I had to manually do statement.execute("commit;begin") in order to get  
set constraints xxx deferred
to work .
( necessary for vaccination linking to a default clin_episode, as there are
new triggers to check for mandatory naming of clin_episode,
either/xor health issue or clin_narrative
)

I think it's the jdbc driver, because both psql and pyPgSQL don't have a 
problem with
the same SQL.

also , is it possible for a web postgres super user (i.e. like gm-dbo, 
e.g. gm-web ):

the idea is to have
the same named public users in tomcat-users.xml  (e.g. any-doc, test-doc)
so if they log in successfully via web authentication ( currently BASIC) ,
then the web application will change to that user using 'set session 
authorization any-doc'
prior to executing SQL, and make use of the schema's detailed permission 
setup.

At the moment, all I need is for tomcat to be restarted so I can resume 
testing.