Error in Creating MySQL Connection Pool in Weblogic serve

Posted on 2006-05-07
Last Modified: 2010-07-27


I am getting Error while creating MySQL Connection Pool in Weblogic server.

OS is WindowXP
Database is in Linux.

Error :
weblogic.common.ResourceException: weblogic.common.ResourceException: Could not
create pool connection. The DBMS driver exception was: Access denied for user 'sri'@'' (using password: YES)

How to solve this problem ? Could you please give me hint.
Question by:Anupama_2005
    LVL 92

    Accepted Solution

    Looks like that user does not have a login for the database. Check that login exists and password is correct, and crete it if not there already.
    LVL 8

    Assisted Solution

    mySQL also sets limits on which hosts a user can connect from. So in the example youve printed, you got the user 'sr' connecting from host ''. Unless this IP address has been explicitly been granted access, this user can’t connect from that host (even if the username and password are correct.

    I assume your mySQL server is not on the same machine as your weblogic server? mySQL automatically adds 'localhost' as a granted host, but if this is not the case in your situation, you’ll need to explicitly add the host name/IP address your attem5tpign to connect from.


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Java had always been an easily readable and understandable language.  Some relatively recent changes in the language seem to be changing this pretty fast, and anyone that had not seen any Java code for the last 5 years will possibly have issues unde…
    Introduction This article is the first of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article explains our test automation goals. Then rationale is given for the tools we use to a…
    Viewers will learn about the different types of variables in Java and how to declare them. Decide the type of variable desired: Put the keyword corresponding to the type of variable in front of the variable name: Use the equal sign to assign a v…
    Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now