[求助]连接出错,不明白请教.
<P>程序如下:<BR>package mypackage;<BR>import java.sql.*;<BR>import java.sql.SQLException.*;<BR>import oracle.jdbc.driver.*;</P><P>public class AccessingClass <BR>{<BR> Connection conn;<BR> public void initialize() throws SQLException <BR> {<BR> /*//加载方法(1)<BR> Class.forName("oracle.jdbc.driver.OracleDirver");<BR> //加载方法(2)<BR> DriverManager.registerDriver(new oracle.jdbc.driver.OracleDirver());*/<BR> //加载方法(3)<BR> OracleDriver driver = new OracleDriver();<BR> conn = DriverManager.getConnection<BR> ("jdbc:oracle:thin:@simon:1521:oracledb1","sysman","orcl");<BR> conn.setAutoCommit(false);<BR> System.out.println("连接成功!"); //在initialize()方法中:<BR> }</P>
<P> public AccessingClass()<BR> {<BR> }<BR> public static void main(String args[] ) throws SQLException<BR> {<BR> AccessingClass accessingClass = new AccessingClass( );<BR> System.out.println("The arguments are : " + args[0]<BR> + ", " + args[1] + ", " + args[2]);<BR> accessingClass.initialize();<BR> }<BR>}<BR><BR>出错提示:<BR>Exception in thread main<BR>java.sql.SQLException: Listener refused the connection with the following error:<BR>ORA-12505, TNS:listener does not currently know of SID given in connect descriptor<BR>The Connection descriptor used by the client was:<BR>simon:1521:oracledb1<BR> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)</P>
<P> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:279)</P>
<P> at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:327)</P>
<P> at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:365)</P>
<P> at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:150)</P>
<P> at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:31)</P>
<P> at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:563)</P>
<P> at java.sql.DriverManager.getConnection(DriverManager.java:512)</P>
<P> at java.sql.DriverManager.getConnection(DriverManager.java:171)</P>
<P> at mypackage.AccessingClass.initialize(AccessingClass.java:16)</P>
<P> at mypackage.AccessingClass.main(AccessingClass.java:31)</P>
<P>Process exited with exit code 1.<BR></P>
页:
[1]