Unable to get connection, DataSource invalid:
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;
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;
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.