Tenon Intersystems Please see text links at bottom of page for navigation
Please see text links at bottom of page for navigation

Search tenon.com

Thanks to:

iTools

JDBC MySQL Issue

To: itools@xxxxxxxxxxxxxxx
Subject: JDBC MySQL Issue
From: Alex Petzinger <agent86@xxxxxxxxxxx>
Date: Thu, 9 Jun 2005 13:30:54 -0700
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 |

Powered By iTools

Copyright©2003 Tenon Intersystems, 232 Anacapa Street, Suite 2A, Santa Barbara, CA 93101. All rights reserved.
Questions about our website - Contact: webmaster@tenon.com.


Tenon Home  Tenon Home  Tenon Home  Tenon Home Product Info  Tenon Ordering Contact About Register Support Resources Press Mailing Lists