---------------------------------------------------------------- BEFORE YOU POST, search the faq at <http://java.apache.org/faq/> WHEN YOU POST, include all relevant version numbers, log files, and configuration files. Don't make us guess your problem!!! ---------------------------------------------------------------- would it not make much more sense to break the problem down? Take the core of the servlet and repackage it it as a standalone Java app. instead of a servlet. run it from the command line. If it fails with the same problem, you have proved that the problem is NOT with JServ. you can then focus your attention where it belongs. o/w, you know it MAY be a JServ or an Apache issue (or just bad servlet code). But at least it will tell you where you should be asking questions. My two cents. Jim >>I really hate to do this because I'm not sure it's a JServ problem. I had >>posted it on Friday to the mySQL mailing list, and recieved some 'me too' >>answers, but nobody had a solution, so I thought I'd try here anyways. >> >>I'm using Apache 1.3.12 with ApacheJserv 1.1.2 and mySQL 3.22.32 running on >>localhost. I can connect via the console with my username 'root' and >>password I have set up. I can connect via PHP4 using the same username and >>password, however when trying to connect via Java using the mm.mySQL JDBC >>drivers, it won't connect. Would anybody know what I should be looking at >>to correct this? >> >>The code in question is: >> >> try { >> // The newInstance() call is a work around for some >> // broken Java implementations as noted in mm.mySQL docs >> Class.forName("org.gjt.mm.mysql.Driver").newInstance(); >> } >> catch (Exception E) { >> out.println("Unable to load driver."); >> E.printStackTrace(); >> } >> >> try { >> Connection C = >>DriverManager.getConnection("jdbc:mysql://localhost/JavaTest?user=root&passw >>ord=chablis"); >> C.close(); >> } >> catch (SQLException E) { >> out.println("SQLException: " + E.getMessage() + "<BR>"); >> out.println("SQLState: " + E.getSQLState() + "<BR>"); >> out.println("VendorError: " + E.getErrorCode() + "<BR>"); >> } >> >>Here's what gets printed in the browser: >> >>SQLException: Server configuration denies access to data source >>SQLState: 08001 >>VendorError: 0 >> >>In the getConnection() I have tried all sorts of combinations: >>Connection C = >>DriverManager.getConnection("jdbc:mysql://localhost:3306/JavaTest?user=root& >>password=somevalue"); >>Connection C = >>DriverManager.getConnection("jdbc:mysql://localhost/JavaTest", "root", >>"somevalue"); >>Connection C = >>DriverManager.getConnection("jdbc:mysql://localhost/JavaTest", "user=root", >>"password=somevalue"); >> >>Could somebody, anybody help me out with this? >> >>Joseph (Joe) Sheble >>a.k.a. Wizaerd ========================================================================== Jim Miani ICANON Associates, Inc. Phone: 610-313-1850 x 121 Fax: 610-313-1848 NEWZware™ is a product of ICANON Inc. - Visit our web site at http://www.icanon.com/ for more information on ICANON, the company, and its suite of products and services. -- -------------------------------------------------------------- Please read the FAQ! <http://java.apache.org/faq/> To subscribe: [EMAIL PROTECTED] To unsubscribe: [EMAIL PROTECTED] Search Archives: <http://www.mail-archive.com/java-apache-users%40list.working-dogs.com/> Problems?: [EMAIL PROTECTED]
