该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
搞了一下午,在网上找了很多代码,但就是无法解决,目测驱动安装应该正确,
import java.sql.*;
public class text_1 {
/**
* @param args
*/
public static void main(String[] args) {
String url="jdbc:oracle:thin:@localhost:1521:orcl";//表示安装oracle时的取名
String userName="scott";
String passWord="Xwp19941017";
Connection conn=null;
Statement stmt = null;// 创建预编译语句对象,
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
System.out.println("开始尝试连接数据库!");
conn=DriverManager.getConnection(url,userName,passWord);
System.out.println("连接成功");
String sql = "create table text_table(name varchar(20))";// 预编译语句,
stmt = conn.createStatement();// 实例化预编译语句
stmt.executeUpdate(sql);
stmt.close();
conn.close ();
}
catch(Exception e)
{
System.out.println("<<
e.printStackTrace();
}
}
}
然后就报错了
开始尝试连接数据库!
<<
java.sql.SQLRecoverableException: 无法从套接字读取更多的数据
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1200)
at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:279)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:366)
at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:752)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:359)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:531)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:221)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at text_1.main(text_1.java:19)