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是数据库实例名称.
