public final static String DRIVER = "oracle.jdbc.driver.OracleDriver";
public final static String URL = "jdbc:oracle:thin:@127.0.0.1:1521:ORCL";
标识确实是ORCL
java.sql.SQLException: Io 异常: Size Data Unit (SDU) mismatch
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:254)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:386)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:413)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:164)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:752)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at dao.BaseDao.getConn(BaseDao.java:21)
at dao.test.selectUser(test.java:15)
at dao.test.main(test.java:40)
java.lang.NullPointerException
at dao.test.selectUser(test.java:16)
at dao.test.main(test.java:40)不时程序代码问题,应该是连接的问题以下是sqlnet.log的信息
Fatal NI connect error 12537, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.1)(Port=1521))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\Data\oracle\product\10.2.0\db_1\perl\5.8.3\bin\MSWin32-x86-multi-thread\perl.exe)(HOST=PC-201105052021)(USER=SYSTEM)))) VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
Time: 05-5月 -2011 22:22:44
Tracing not turned on.
Tns error struct:
ns main err code: 12537
TNS-12537: TNS: 连接关闭
ns secondary err code: 12560
nt main err code: 507
TNS-00507: 连接已关闭
nt secondary err code: 0
nt OS err code: 0
监听日志:05-5月 -2011 22:22:43 * 12502
TNS-12502: TNS: 监听程序没有从客户机收到 CONNECT_DATA
05-5月 -2011 22:22:43 * 12502
TNS-12502: TNS: 监听程序没有从客户机收到 CONNECT_DATA
05-5月 -2011 22:22:43 * 12502
TNS-12502: TNS: 监听程序没有从客户机收到 CONNECT_DATA
05-5月 -2011 22:22:43 * 12502
TNS-12502: TNS: 监听程序没有从客户机收到 CONNECT_DATA
05-5月 -2011 22:22:43 * 12502
TNS-12502: TNS: 监听程序没有从客户机收到 CONNECT_DATA
05-5月 -2011 22:22:43 * 12502
TNS-12502: TNS: 监听程序没有从客户机收到 CONNECT_DATA
05-5月 -2011 22:22:44 * 12502
TNS-12502: TNS: 监听程序没有从客户机收到 CONNECT_DATA
05-5月 -2011 22:23:06 * 12502
TNS-12502: TNS: 监听程序没有从客户机收到 CONNECT_DATA
05-5月 -2011 22:23:06 * 12502
TNS-12502: TNS: 监听程序没有从客户机收到 CONNECT_DATA
05-5月 -2011 22:23:13 * 12502我是个oracle初学者,第一次连接就报错了,真让我无语,就象我之前用java连接sqlserver的时候报IO错误一样无法解决,连接mysql能行.
各位大大指点一下吧.万分感谢
public final static String URL = "jdbc:oracle:thin:@127.0.0.1:1521:ORCL";
标识确实是ORCL
java.sql.SQLException: Io 异常: Size Data Unit (SDU) mismatch
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:254)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:386)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:413)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:164)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:752)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at dao.BaseDao.getConn(BaseDao.java:21)
at dao.test.selectUser(test.java:15)
at dao.test.main(test.java:40)
java.lang.NullPointerException
at dao.test.selectUser(test.java:16)
at dao.test.main(test.java:40)不时程序代码问题,应该是连接的问题以下是sqlnet.log的信息
Fatal NI connect error 12537, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.1)(Port=1521))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\Data\oracle\product\10.2.0\db_1\perl\5.8.3\bin\MSWin32-x86-multi-thread\perl.exe)(HOST=PC-201105052021)(USER=SYSTEM)))) VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
Time: 05-5月 -2011 22:22:44
Tracing not turned on.
Tns error struct:
ns main err code: 12537
TNS-12537: TNS: 连接关闭
ns secondary err code: 12560
nt main err code: 507
TNS-00507: 连接已关闭
nt secondary err code: 0
nt OS err code: 0
监听日志:05-5月 -2011 22:22:43 * 12502
TNS-12502: TNS: 监听程序没有从客户机收到 CONNECT_DATA
05-5月 -2011 22:22:43 * 12502
TNS-12502: TNS: 监听程序没有从客户机收到 CONNECT_DATA
05-5月 -2011 22:22:43 * 12502
TNS-12502: TNS: 监听程序没有从客户机收到 CONNECT_DATA
05-5月 -2011 22:22:43 * 12502
TNS-12502: TNS: 监听程序没有从客户机收到 CONNECT_DATA
05-5月 -2011 22:22:43 * 12502
TNS-12502: TNS: 监听程序没有从客户机收到 CONNECT_DATA
05-5月 -2011 22:22:43 * 12502
TNS-12502: TNS: 监听程序没有从客户机收到 CONNECT_DATA
05-5月 -2011 22:22:44 * 12502
TNS-12502: TNS: 监听程序没有从客户机收到 CONNECT_DATA
05-5月 -2011 22:23:06 * 12502
TNS-12502: TNS: 监听程序没有从客户机收到 CONNECT_DATA
05-5月 -2011 22:23:06 * 12502
TNS-12502: TNS: 监听程序没有从客户机收到 CONNECT_DATA
05-5月 -2011 22:23:13 * 12502我是个oracle初学者,第一次连接就报错了,真让我无语,就象我之前用java连接sqlserver的时候报IO错误一样无法解决,连接mysql能行.
各位大大指点一下吧.万分感谢
能。估计是电脑问题吧。我帮别人都连起了,自己的电脑却完成不了 哎。