辛淼 Jin

The below result of a test today with ojdbc6.jar in oracle database.      Connection con =null;       Statement stmt=null;       Connection  con =              DriverManager.getConnection( “jdbc:oracle:thin:@127.0.0.1:1521:test”, User,PW);             stmt = con.createStatement();             ResultSet rs = stmt.executeQuery("select * from table1");           // 1 CachedRowSet is ok.           CachedRowSet rowSet;           rowSet=new CachedRowSetImpl();           rowSet.populate(rs); // It work            //2 Jd...

Create a JdbcRowSet object in various ways: 1. By using the reference implementation constructor that takes a ResultSet object 2. By using the reference implementation constructor that takes a Connection object 3. By using the reference implementation default constructor 4. By using an instance of RowSetFactory , which is created from the class RowSetProvider Testing Environment : JDBC driver: Sqljdbc4.jar Java SE Version:1.7.0_51 Result: 1.Passing ResultSet Objects // It works. 2.Passing Connection Objects // It does not work 3.Using the Default Constructor // It does not work 4.Using the RowSetFactory Interface // It does not work import com.sun.rowset.JdbcRowSetImpl; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import javax.sql.rowset. JdbcRowSet ; import javax.sql.rowset.RowSetFactory; import javax.sql.rowset.RowSetProvider;     public static void main(String[] args)...