Jdbc+mysql 报错，急！高手们帮我看看

godaddyTest · 发表于 2010-4-27 23:46:21

java.lang.Exception: com.mysql.jdbc.CommunicationsException:
Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION **
java.net.ConnectException
MESSAGE: Connection refused STACKTRACE: java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:367)
at java.net.Socket.connect(Socket.java:524) at java.net.Socket.connect(Socket.java:474)
at java.net.Socket.(Socket.java:371)
at java.net.Socket.(Socket.java:213)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)
at com.mysql.jdbc.MysqlIO.(MysqlIO.java:271)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2771)
at com.mysql.jdbc.Connection.(Connection.java:1555)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
.............................
.............................
.............................

很无奈，晚上的解决方案这这里好像都不能用。

谁能帮帮我啊！

[ 本帖最后由 godaddyTest 于 2010-4-27 11:49 PM 编辑 ]

godaddyTest · 发表于 2010-4-28 09:20:18

谁能告诉我啊。

add.c · 发表于 2010-4-28 09:28:06

你是要用jsp连接mysql吗?
下面是一个连接的例子
<%@ page contentType="text/html; charset=iso-8859-1" language="java"
import="java.sql.*" errorPage="" %>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body><h1>GDtest
</h1>
<% String url = "jdbc:mysql://mysql server:3306/databasename";
String user= "";
String pass= "";
try{
Class.forName ("com.mysql.jdbc.Driver").newInstance ();
Connection conn = DriverManager.getConnection(url, user, pass);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("mysql statment");

while(rs.next())
{
%>
<table> <tr>
<td><%= rs.getString("fname") %></td>
<td><%= rs.getString("lname") %></td>
</tr></table>
<%}
rs.close();
conn.close();
}catch(Exception e)
{
out.println(e.toString());
}
%>
</body>
</html>

godaddyTest · 发表于 2010-4-28 11:12:05

这些都没有问题，
可是连接的时候报错啊！

从晚上找方案说是连接池的问题！

add.c · 发表于 2010-4-28 11:18:06

呃我对这个不熟悉
看提示说是因为 underlying exception: ** BEGIN NESTED EXCEPTION **

gman · 发表于 2011-6-1 11:49:25

关注、学习，记下了

[提问] Jdbc+mysql 报错，急！高手们帮我看看

回复 4# 的帖子

GoDaddy讨论

[提问] Jdbc+mysql 报错，急！ 高手们帮我看看

回复 4# 的帖子

GoDaddy讨论

[提问] Jdbc+mysql 报错，急！高手们帮我看看