嘿,我遇到了这个错误:
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:
Could not create connection to database server.
Attempted reconnect 3 times. Giving up.
我只是想连接到数据库。使用这段代码:
<%@page import="java.sql.*"%>
<%
try{
// Class.forName("com.mysql.jdbc.Driver");
Class.forName("org.gjt.mm.mysql.Driver");
out.println("found");
} catch (ClassNotFoundException ex){
out.println("Erro<br/>");
out.println(ex.toString());
} catch (Exception e){
out.println(e.toString());
}
Connection ocon;
try{
ocon = DriverManager.getConnection("jdbc:mysql://localhost/cpjcoimbra?autoReconnect=true", "*****", "*****"); //password matches
out.print("connected");
} catch (Exception e){
out.println(e.toString()+"<br/>");
}
%>
它能够找到驱动程序,但是当我尝试连接到数据库时出现了错误。
我在catalina 50.local.policy文件中拥有该权限。
grant codeBase "file:/var/lib/tomcat6/WEB-INF/lib/-" {
permission java.security.AllPermission;
};
有人知道为什么会出现这个错误吗?
编辑: service mysql status 显示如下:
* /usr/bin/mysqladmin Ver 8.42 Distrib 5.1.37, for debian-linux-gnu on i486
Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 5.1.37-1ubuntu5
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 1 hour 32 min 21 sec
Threads: 1 Questions: 103 Slow queries: 0 Opens: 171 Flush tables: 1 Open tables: 41 Queries per second avg: 0.18