----------------------------------------------------------------
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!!!
----------------------------------------------------------------
Joe,
The error you are getting
SQLException: Server configuration denies access to data source
SQLState: 08001
VendorError: 0
Seems to indicate the the mySQL server is denying the JDBC connection to
the dbuser you are trying to connect with. Is there some kind of special
permission you need in mySQL to connect via JDBC ?
James
At 07:33 7/24/00, you wrote:
>----------------------------------------------------------------
>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!!!
>----------------------------------------------------------------
>
>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
>========================================
>Wizaerd's Realm
>http://www.wizaerd.com
>3D Art, ColdFusion, Illustration, Canvas
>a little bit of everything...
>========================================
>
>
>--
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/php/manual.php" before
>posting. To request this thread, e-mail [EMAIL PROTECTED]
>
>To unsubscribe, send a message to:
> <[EMAIL PROTECTED]>
>
>If you have a broken mail client that cannot send a message to the above
>address(Microsoft Outlook), you can use
>http://lists.mysql.com/php/unsubscribe.php
>
>
>
>--
>--------------------------------------------------------------
>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]
--
--------------------------------------------------------------
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]
