ora-03115:不支持的网络数据类型 oracle,java.sql.SQLException: ORA-03115: 不支持的网络数据类型或表示法...

java.sql.SQLException: ORA-03115: 不支持的网络数据类型或表示法

at

oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)

at

oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)

at

oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)

at

oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)

at

oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)

at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)

at

oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)

at

oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)

at

oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)

at

oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)

at

oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1469)

at

oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:389)

at com.jdbc.JDBCPackaging.select(JDBCPackaging.java:25)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native

Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown

Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown

Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at

org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:45)

at

org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)

at

org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:42)

at

org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)

at

org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:263)

at

org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:68)

at

org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:47)

at

org.junit.runners.ParentRunner$3.run(ParentRunner.java:231)

at

org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:60)

at

org.junit.runners.ParentRunner.runChildren(ParentRunner.java:229)

at

org.junit.runners.ParentRunner.access$000(ParentRunner.java:50)

at

org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:222)

at

org.junit.runners.ParentRunner.run(ParentRunner.java:300)

at

org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)

at

org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)

at

org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)

at

org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)

at

org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)

at

org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)

代码:

package com.jdbc;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import org.junit.Test;

public class JDBCPackaging

{

private String url =

"jdbc:oracle:thin:@//localhost:1521/orcl";

private String user = "scott";

private String password = "tigger";

int empno = 7499;

@Test

public void select(){

try {

Class.forName("oracle.jdbc.driver.OracleDriver");

Connection conn =

DriverManager.getConnection(url, user,

password);

String sql = "select empno,ename from emp

where empno=?";

PreparedStatement ps =

conn.prepareStatement(sql);

ps.setInt(1, empno);

ResultSet rs =

ps.executeQuery(sql);

while(rs.next()){

System.out.println("["+rs.getString("empno")+"]"+"["+rs.getString("ename")+"]");

}

} catch (Exception e) { e.printStackTrace(); } } }

问题解决:

问题是出现在

ResultSet

rs = ps.executeQuery(sql);  把sql删掉就可以了