Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Nested set from SQL to Java  RSS feed

Knolf Moervenson
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi there!
In a Java application I am using an SQL table in Nested Set structure for saving a XML tree. The nested set structure is said to be able to rebuild the tree structure very quickly (just one select), which is exactly what I need.
Now, I am trying to get the tree structure out of the database table and put the result in a Java tree. In the web there are excellent examples for that quick select statement, but sorry, the result is not a tree but as a matter of select statements in general the result is ofcourse always a list. Has anyone experiences with getting a Nested Set Tree from an SQL table back in a Java tree? Do I have to rebuild the tree structure in Java on my own or is it possible to get a tree structure directly out of the MySQL datatable using a certain statement (so that the result set is not a list but a tree)?

  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!