hibernate连接oracle10g时相关异常处理

1.jdbc驱动问题

e:\oracle\product\10.2.0\db_1\jdbc\lib这个目录下有很多jar文件,hibernate连接oracle10g时,只需要ojdbc14.jar这个jar就可以了.其它的占时不太清楚.

 

 

2.Oracle10g中"listener does not currently know of SID given in connect descriptor"

 这个是你的listener.ora文件配置错误,正确的配置如下:

 

# listener.ora Network Configuration File: e:\oracle\product\10.2.0\db_1\network\admin\listener.ora 
# Generated by Oracle configuration tools. 
SID_LIST_LISTENER = 
(SID_LIST = 
    (SID_DESC = 
      (SID_NAME = PLSExtProc) 
      (ORACLE_HOME = e:\oracle\product\10.2.0\db_1) 
      (PROGRAM = extproc) 
    ) 
    (SID_DESC = 
      (GLOBAL_DBNAME = link) 
      (ORACLE_HOME = e:\oracle\product\10.2.0\db_1) 
      (SID_NAME = link) 
    ) 
) 
LISTENER = 
(DESCRIPTION_LIST = 
    (DESCRIPTION = 
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) 
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) 
    ) 
) 

 link是数据库实例名称.