what is the difference between resultset and rowset?

what is the difference between resultset and rowset?

what is the difference between resultset and rowset? define the resultset? define the rowset? define resultsetmetadate? i want to dispaly tables of a database how do i do it? can you explain connection factory class? what is databasemetadata? define meta data? all java dirver?

View Answers

May 9, 2012 at 1:11 PM

Difference between ResutSet and Rowset:

1)The ResultSet does not contain all the data from your query. Since it has a connection to the database, when you run the next() method if the ResultSet needs more data it can go to the database and get it.While the RowSet can't do that since it isn't connected to the database so it must load and hold all the data from your query as soon as you run the execute() method.

2)ResultSet is connected and not serializable but RowSet is disconnected and serializable.

ResultSet: ResultSet is a java object that is used for database connectivity to hold the data returned by a select query. When we run a select query, it returns us the data with each row representing one logical group of data with a number of columns. JDBC ResultSet Example

RowSet: A RowSet object contains a set of rows from a result set or some other source of tabular data, like a file or spreadsheet. Because a RowSet object follows the JavaBeans model for properties and event notification, it is a JavaBeans component that can be combined with other components in an application. As is true with other Beans, application programmers will probably use a development tool to create a RowSet object and set its properties. JDBC RowSet Example

ResultSetMetaData: ResultSetMetaData is a class which provides information about a result set that is returned by an executeQuery() method. JDBC details interrogation can be done by using ResultSetMetaData. It includes the information about the names of the columns, number of columns, data type they contain etc. ResultSetMetaData Example

Java Display Tables of Database

ConnectionFactory Class:A ConnectionFactory object encapsulates a set of connection configuration parameters that has been defined by an administrator. A client uses it to create a connection with a JMS provider.

DatabaseMetadata:DatabaseMetaData provides comprehensive information about the database. This interface is implemented by the driver vendors to allow the user to obtain information about the tables of a relational database as a part of JDBC application. User can use this interface to deal with various underlying DBMSs.

Metadata: Metadata is data about data.It is the information that describes about structure and properties of our data. When we define a table we specify each columns name, type of data it holds and restrictions imposed (Constraints) and who owns it. This Information in JDBC Context is called MetaData.

JDBC Drivers









Related Tutorials/Questions & Answers:
What is the difference between the >> and >>> operators?
what is the difference between extends and implements
Advertisements
what is the difference between extends and implements
What is the difference between PHP4 and PHP5?
What is difference between a PROCEDURE & FUNCTION ?
What is the difference between $message and $$message?
what is the difference between pop and oop
what is the Difference between weblogic and jboss?
What is the difference between hibernate and spring
What is the difference between a constructor and a method?
What is difference between the java and javascript?
What is the difference between a JDK and a JVM?
What is difference between Path and Classpath?
What is difference between TRUNCATE & DELETE
What is the difference between JPA and Hibernate?
What is difference between the java and javascript?
What is the difference between ereg_replace() and eregi_replace()?
What is the difference between the functions unlink and unset?
What are the difference between abstract class and interface?
What’s the difference between include and require?
what is the difference between distributed application and web application?
What’s the difference between load() and get()?
What is difference between singleton and prototype bean?
What is the difference between JSF, Servlet and JSP?
what is difference between objectan primitive? - Java Beginners
what is the difference between productList==null and productList.size()==0
What is the difference between the Boolean & operator and the && operator?
What are difference between Bean Factory and Application Context ?
what is the difference between the eclipse and myeclipse - IDE Questions
What is the difference between component and tag in JSF?
What is the difference between IN and BETWEEN, that are used inside a WHERE clause?
What is the difference between GET and POST method?
What is the difference between UNION and UNION ALL in SQL?
What is difference between UNIX Hosting and Window Hosting?
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
What is the difference between a data analyst and a data scientist?
What is difference between data analyst and data scientist?
what is the difference between frontcontroller and actionservlet? - Struts
What is the difference between an if statement and a switch statement?
What is the difference between Big Data and Hadoop?
What is the difference between Big Data and Hadoop?
What is the difference between static and dynamic SQL?
What is the difference between a break statement and a continue statement?
What is the difference between EJB 3.0 and JPA - Framework
What is difference between JDK,JRE and JVM?
What is difference between Core Java and Advanced Java?
What is difference between Core Java and Advanced Java?
What is the difference between mysql_fetch_object and mysql_fetch_array?
what is the difference between jdk 1.4 and 1.5 and 1.6
What?s the difference between md5(), crc32() and sha1() crypto on PHP?

Ads