Powered by Ajaxy
Digg StumbleUpon LinkedIn YouTube Flickr Facebook Twitter RSS Reset

Java: operate in a disconnected environment using ‘CachedRowSet’

Java: operate in a disconnected environment using  'CachedRowSet'
{filelink=7051}

import java.sql.*;
import javax.sql.rowset.CachedRowSet;
import com.sun.rowset.CachedRowSetImpl; 
public class CachedRS
 {
  public static void main(String[] args) throws Exception
  	{
        // set CachedRowSet properties
       CachedRowSet rowSet = new CachedRowSetImpl();
        // Connect to Microsoft SQL Server
        rowSet.setUrl( "jdbc:sqlserver://localhost; databasaname=cours" );
        rowSet.setUsername( "user" );                            // Set username
        rowSet.setPassword( "passdemo" );                        // Set password
        rowSet.setType(ResultSet.TYPE_SCROLL_INSENSITIVE);
        rowSet.setConcurrency(ResultSet.CONCUR_UPDATABLE);
        rowSet.setCommand("SELECT * FROM Test");
        rowSet.execute();
  }
}

Users who found this page were searching for:

  • get disconnected with cachedrowset
  • jdbc cachedrowset example
  • operate in a disconnected environment cached java mesexemples.com
  • cachedresultset java is disconnected
  • javax.mail.store disconnect
  • java disconnected resultset 2013
  • disconnected environment java
  • microsoft "sql server" jdbc driver cachedrowset
  • disconnected+environment+in+jdbc
  • Cache row set program

No comments yet.

Leave a Comment