|
Search tenon.com
Thanks to:
|
|
iTools
Greeting fellow mysql, tomcat, java. et al. users
I'm having a problem interacting with MySQL using JDBC with a test JSP and a servlet.
I haver created and deploy simple anonymous servlets with my Tomcat installation (anonymous meaning just uncommenting the invoker servlet lines in the Tomcat specific web.xml file: /Library/Tenon/Tomcat/conf/web.xml (see http://www.coreservlets.com/Apache-Tomcat-Tutorial/ for more info). This allows one not to have to configure and deploy an application specific web.xml for each servlet. Just drop it in the /Library/Tenon/Tomcat/webapps/ROOT/WEB-INF/classes
http://www.intrepid.ws/mysqljdbc.jsp
My JSP reveals (Getting Connection ... SQLException: Server configuration denies access to data source)
http://www.intrepid.ws/servlet/jdbcExample
My servlet reveals <x-tad-bigger>java.lang.ClassCastException
org.apache.catalina.servlets.InvokerServlet.serveRequest(InvokerServlet.java:416)
org.apache.catalina.servlets.InvokerServlet.doGet(InvokerServlet.java:180)
javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856
Following the advice of various MySQL websites, I executed </x-tad-bigger><x-tad-smaller>GRANT ALL PRIVILEGES ON [dbname].* to
'[user]'@'[hostname]' identified by
'[password]'
thane
flust privileges.
</x-tad-smaller><x-tad-bigger>All also put the neccessary mysql-connectory-java-3.1.8.-bin.jar in my CLASSPATH and in all the locations recommended. however, I had continue to see the same access errors. Has anyone worked around this?
Thanks,
Alex </x-tad-bigger>
|
| <Prev in Thread] |
Current Thread |
[Next in Thread> |
- JDBC MySQL Issue,
Alex Petzinger <=
|
| Tenon Home |
Products |
Order |
Contact Us |
About Tenon |
Register |
Tech Support |
Resources |
Press Room |
Mailing Lists |
|
Copyright©2003 Tenon Intersystems, 232 Anacapa Street, Suite 2A, Santa Barbara,
CA 93101. All rights reserved.
Questions about our website - Contact:
webmaster@tenon.com.
|
|