Hi,

I developed a jsp web app in netbeans. Then I loaded it to the remote server which uses a Tomcat. However, I got an error say;

"Unable to get connection, DataSource invalid:"

Yet it works alright on my PC. I have the META-IMF/ context set as;

Java Code:
<Context path="/myData">
    <Resource name="jdbc/myData" auth="Container" type="javax.sql.DataSource"
        maxActive="100" maxIdle="30" maxWait="10000"
        username="root" password="kwesiaryee" driverClassName="com.mysql.jdbc.Driver"
        url="jdbc:mysql://localhost:3306/myData"/>
</Context>
and the WEB-IMF/web.xml set as;

Java Code:
<welcome-file-list>
        <welcome-file>index.jsp</welcome-file>
    </welcome-file-list>
    <resource-ref>
        <description>jdbc:mysql://localhost:3306/myData</description>
        <res-ref-name>jdbc/myData</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
        <res-sharing-scope>Shareable</res-sharing-scope>
    </resource-ref>
Yet when I launch the website from the remote tomcat 5.25 server it gives me the above errors. I even have the mysql driver installed in the WEB-INF/ lib folder, still I get the same problems.

Can someone help me solve this problem.