| Author |
db connection problem
|
Rafael Fagundes
Ranch Hand
Joined: Sep 23, 2004
Posts: 52
|
|
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 ]
|
Thanks,
Rafa
|
 |
Adeel Ansari
Ranch Hand
Joined: Aug 15, 2004
Posts: 2874
|
|
|
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
Joined: Jan 10, 2002
Posts: 56150
|
|
|
Since this is much more about JDBC than the JSP enclosing it, I'm moving this along to the JDBC forum.
|
[Smart Questions] [JSP FAQ] [Books by Bear] [Bear's FrontMan] [About Bear]
|
 |
 |
|
|
subject: db connection problem
|
|
|