Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Teams

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

Does anyone know if there is a DataSet class in Java like there is in .Net? I am familiar with EJB3 and the "java way" of doing data. However, I really still miss the seamless integration between database queries, xml and objects provided by the DataSet class. Has anyone found a Java implementation of DataSet (including DataTable, DataRow, etc)?

Edit: Also if anyone has tutorials for the java flavor of DataSet, please share a link.

The WebRowSetImpl provides the standard reference implementation, which may be extended if required.

The standard WebRowSet XML Schema definition is available at the following URI:

   http://java.sun.com/xml/ns/jdbc/webrowset.xsd
  
It describes the standard XML document
  format required when describing a
  RowSet object in XML and must be used
  be all standard implementations of the
  WebRowSet interface to ensure
  interoperability. In addition, the
  WebRowSet schema uses specific SQL/XML
  Schema annotations, thus ensuring
  greater cross platform
  inter-operability. This is an effort
  currently under way at the ISO
  organization. The SQL/XML definition
  is available at the following URI:
   http://standards.iso.org/iso/9075/2002/12/sqlxml
you may want to look into this open-source library: 
https://www.developerfusion.com/project/20506/casperdatasets/
Its easy to use (a lot like using the sql resultset), and its all in-memory.  it also supports complex queries and indexes on your data.  
                Interesting doc link. It seems that a Java sql.DataSet is roughly equivalent to a .NET DataTable
– bkwdesign
                Feb 26, 2019 at 18:00
                ResultSet is much more like .NETs DataReader, which are very different things compared to DataSets/DataTables
– nos
                Jul 28, 2009 at 17:34
I know what you mean by the "dataset way" maybe you can find something similar, however are you sure you want to go that way? Java has many options but if you want something more cooked, why don't explore hibernate, it's the very popular in the industry and will give you more power that the one you are asking for.
You might be looking for LINQ implementation in Java. IMHO better than the DataSet/DataTable route.
http://code.google.com/p/jaque/
http://quaere.codehaus.org/
Disclaimer: I haven't used either of these.
I'm an author of ExDataSet. If you need a way to send DataSet from java/android application to .NET the web service, you should take a look on this library. It is 100% fully compatible in xml representation with .NET DataSet objects and supports sending tables, rows, relations, foreign and unique keys, nested tables etc.
        
Thanks for contributing an answer to Stack Overflow!
Please be sure to answer the question. Provide details and share your research!
But avoid …
Asking for help, clarification, or responding to other answers.
Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.