[PLUG] jsp-mysql connection problem

[Arun Khan]

On Fri, Apr 30, 2010 at 12:41 AM, Vinayak Kulkarni
<kulkarnivd2007 at yahoo.co.in> wrote:
> Hi All
> Yesterday night, i tried to establish a connection with my mysql database from jsp using jdbc:mysql on mandriva.
>
> But despite of entering correct port no(of mysql) and username, password, tomcat is returning message that resource() is not available.

Although you do not mention specifically, I presume everything is on
the same machine right?  If not then enable MySQL to accept
connections from the IP no. of your application server.  In most
distros, the default for MySQL is to answer queries from "localhost"
only.

> I checked following things,
> 1. mysqld service was running
> 2. and port no of tomcat and mysqld were not same

3. Check for iptables rules (fw) and disable all.

-- Arun Khan