hibernate连接不上oracle

cq_chencheng 2012-02-17 04:53:55

请各位高手帮我看哈，我到底是哪里出了错。在此我先谢谢各位了
运行代码出现下面的错误
Exception in thread "main" org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1354)
at UserText.main(UserText.java:20)
Caused by: java.sql.SQLException: Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=168821248)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:404)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
... 5 more

一下是我hibernate.cfg.xml
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>

<session-factory>


<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="connection.url">dbc:oracle:thin:@192.168.0.56:1521:oa</property>
<property name="connection.username">*</property>
<property name="connection.password">*</property>


<property name="connection.pool_size">1</property>


<property name="dialect">org.hibernate.dialect.OracleDialect</property>


<property name="current_session_context_class">thread</property>


<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>

<property name="show_sql">true</property>

<property name="hbm2ddl.auto">update</property>
</session-factory>

</hibernate-configuration>

安装的为oracle10g，然后在myeclipse中加入的jdbc驱动为：ojdbc14

...全文

152 9 打赏收藏转发到动态举报

写回复

用AI写文章

9 条回复

切换为时间正序

请发表友善的回复…

发表回复

caicai123 2012-02-24

打赏
举报

[Quote=引用 7 楼 a597926661 的回复:]
引用 6 楼 julan518 的回复:
我个人觉得是链接url有问题 <property name="connection.url">dbc:oracle:thin:@192.168.0.56:1521:oa</property>

下边是我测试的一个链接 jdbc:oracle:thin:@125.67.67.71:1521:auxwlyd

<property name="con……
[/Quote]我也觉得是这里有问题

fruitboy2005 2012-02-24

打赏
举报

会不会是数据库权限问题。以normal 身份可以登录吗？

a597926661 2012-02-24

打赏
举报

[Quote=引用 6 楼 julan518 的回复:]
我个人觉得是链接url有问题 <property name="connection.url">dbc:oracle:thin:@192.168.0.56:1521:oa</property>

下边是我测试的一个链接 jdbc:oracle:thin:@125.67.67.71:1521:auxwlyd
[/Quote]
<property name="connection.url">dbc:oracle:thin:@192.168.0.56:1521:oa</property>
同楼上楼主是不是这不对啊

黑猫警长-- 2012-02-24

打赏
举报

我个人觉得是链接url有问题 <property name="connection.url">dbc:oracle:thin:@192.168.0.56:1521:oa</property>

下边是我测试的一个链接 jdbc:oracle:thin:@125.67.67.71:1521:auxwlyd

莫欺少年穷 2012-02-23

打赏
举报

Caused by: java.sql.SQLException: Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=168821248)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))

连接被拒绝，是不是TCP没启动？？

五哥 2012-02-23

打赏
举报

url对了么？

username对么？

password对么？

package com.cai.jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Properties ;

public class ConnectionUtil {
/**
* 2
*通过方法参数方式传递连接参数
* @return 数据库连接
*/
public static Connection getConnection(String driver, String url, String user, String password){

Connection conn = null ;

try{
Class.forName(driver) ;
conn = DriverManager.getConnection(url, user, password) ;

return conn ;

}catch(Exception e){
e.printStackTrace();
}

return null ;
}

public static void main(String [] args){
Connection conn = getConnection("oracle.jdbc.driver.OracleDriver", "dbc:oracle:thin:@192.168.0.56:1521:oa", "", "") ;

System.out.println(conn) ;

}
}

自己写个测试类，测试一下你的连接参数是否正确先

中草药代码 2012-02-23

打赏
举报

解决方式为：修改%oracle_home%\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora文件,加上下面红色的字体部分:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\tools\oracle\product\10.1.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = C:\tools\oracle\product\10.1.0\db_1)
(SID_NAME = orcl)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
)

重新启动数据库服务，看能否正常连接，如果还不行，在Enterprise manager console软件中配置数据库的连接信息(如果之前没有配置过)，然后用system以sysdba身份登录，在例程->配置->一般信息中将例程状态改为“启动”，然后点下面的应用。这时会出来一个对话框提示正在启动，等他提示完成以后就好了。

fafa 2012-02-17