Re: Tomcat 6 & Postgresql NIGHTMARE!
The problem is most likely with your java security policy.
You will need to make some changes to the file /etc/tomcat6/policy.d/04webapps.policy (assuming that your tomcat files are in /etc/tomcat6)
Backup the file before messing with it, because if you mess it up (bad syntax, etc) tomcat will not start.
You can either try to find the correct permissions, or grant all permissions.
To grant all permissions, add the following to the beginning of the file:
If you don't want to do that, you might try something like:
Also, check your tomcat log file -- if a security permission is causing the webapp to fail, it should show you what permission you need.
permission java.net.SocketPermission "address.of.your.postgres.server.com","resolve,connect";
Hope this helps!
Here we are, trapped in the amber of the moment. There is no why.