Question

eclipse 连接oracle不上，plsql可以登陆。

importjava.sql.*;publicclassplsql{/** *@paramargs*/publicstaticvoidmain(String[]args){//TODOAuto-generatedmethodstub//1、加载驱动程序try{Class.forName("oracle.jdbc.driver.OracleDriver");Connectionconn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL","scott","tiger");CallableStatementcs=conn.prepareCall("{calls_pro3(?,?)}");cs.setString(1,"SMITH");cs.setInt(2,200);cs.execute();//关闭操作cs.close();//关闭连接conn.close();}catch(Exceptione){e.printStackTrace();}} }报错java.sql.SQLException:Listenerrefusedtheconnectionwiththefollowingerror:ORA-12505,TNS:listenerdoesnotcurrentlyknowofSIDgiveninconnectdescriptoratoracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412)atoracle.jdbc.driver.PhysicalConnection.

Answer 1

就不能带个空格么。。
报错ORA-12505,自己搜一下咯，好像要修改oracle目录下的listener.ora文件

Answer 2

jdbc thin连接不上,就用JDBC OCI连接

Answer 3

你把oracle的jar包导入了没

Answer 4

("jdbc:oracle:thin:@localhost:1521:ORCL" 换成("jdbc:oracle:thin:@localhost:1521:orcl" 试试