Win a copy of Java 9 Revealed this week in the Features new in Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

db connection problem  RSS feed

 
Rafael Fagundes
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello all.
In a jsp application, I�m trying to conect to the application�s db (MySQL) by:
// jsp file
<%
YYY.Atividade atv;
atv = new YYY.Atividade();
atv.criaConexaoBD();
%>
// bean
public void criaConexaoBD()throws ClassNotFoundException, IllegalAccessException,InstantiationException, SQLException
{
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://130.1.1.130/mdb1";
Class.forName(driver).newInstance();
this.conexaoBanco = DriverManager.getConnection(url, "root", "");
this.v_statement = this.conexaoBanco.createStatement();
}

I�m getting this server (Tomcat v. 5.0) message:

ERRO :java.sql.SQLException: Invalid authorization specification, message from server: "Access denied for user: 'root'@'egdesenvolv.globoprdom.com.br' (Using password: NO)" .

Even using a password or changing the user i�m getting the same trouble...I know that if i use
url= "jdbc:mysql://localhost/mdb1";
the connection work�s...

Does somebody know�s what�s wrong?
Thank�s for your attention,
Rafael.
[ October 11, 2004: Message edited by: Rafael Castro Fagundes ]
 
Adeel Ansari
Ranch Hand
Posts: 2874
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i think it is something about MYSQL Driver. see the specification of MYSQL Driver. may be it differs when your DB is remote.
 
Bear Bibeault
Author and ninkuma
Marshal
Posts: 65893
135
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Since this is much more about JDBC than the JSP enclosing it, I'm moving this along to the JDBC forum.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!