我在学校连接数据库都是学校建好的表空间,用户和密码。
我今天自己装了个oracle数据库,连接数据库出问题了。
提示如下:
java.sql.SQLException: Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=150999297)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:335)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:361)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:442)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:321)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.dudeng.DBOperator.DBconnect.ConnectionDB(DBconnect.java:26)
at com.dudeng.DBOperator.DBconnect.main(DBconnect.java:42)我的类:
package com.dudeng.DBOperator;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;public class DBconnect
{
public static Connection ConnectionDB()
{
Connection con = null;
String ORACLECON = "jdbc:oracle:thin:@127.0.0.1:1521:DUDENG";
String USER = "y";
String PWD = "z";
try
{
//加载数据库连接驱动程序
Class.forName("oracle.jdbc.driver.OracleDriver");
//返回一个连接
con = DriverManager.getConnection(ORACLECON,USER,PWD);
//支持事务
//con.setAutoCommit(false);
}
catch(Exception e)
{
e.printStackTrace();
}
return con;
}
public static void main(String args[])
{
try
{
DBconnect.ConnectionDB();
} catch (Exception e)
{
System.out.println("oracle连接池失败");
e.printStackTrace();
}
}}请问:高手们,到底这是怎么回事?不好意思就剩10分了,以后补给大家。
我今天自己装了个oracle数据库,连接数据库出问题了。
提示如下:
java.sql.SQLException: Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=150999297)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:335)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:361)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:442)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:321)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.dudeng.DBOperator.DBconnect.ConnectionDB(DBconnect.java:26)
at com.dudeng.DBOperator.DBconnect.main(DBconnect.java:42)我的类:
package com.dudeng.DBOperator;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;public class DBconnect
{
public static Connection ConnectionDB()
{
Connection con = null;
String ORACLECON = "jdbc:oracle:thin:@127.0.0.1:1521:DUDENG";
String USER = "y";
String PWD = "z";
try
{
//加载数据库连接驱动程序
Class.forName("oracle.jdbc.driver.OracleDriver");
//返回一个连接
con = DriverManager.getConnection(ORACLECON,USER,PWD);
//支持事务
//con.setAutoCommit(false);
}
catch(Exception e)
{
e.printStackTrace();
}
return con;
}
public static void main(String args[])
{
try
{
DBconnect.ConnectionDB();
} catch (Exception e)
{
System.out.println("oracle连接池失败");
e.printStackTrace();
}
}}请问:高手们,到底这是怎么回事?不好意思就剩10分了,以后补给大家。
這里就錯了,javabean沒有主函數的還沒你出錯的應該是在你的JSP頁面的sql語句上或者在你的數據上