List of usage examples for org.hibernate.sql JoinFragment FULL_JOIN
int FULL_JOIN
To view the source code for org.hibernate.sql JoinFragment FULL_JOIN.
Click Source Link
From source file:unikn.dbis.univis.navigation.tree.VTree.java
License:Open Source License
/** * TODO: document me!!!//w w w .j a v a 2s.c o m * * @param dimension * @return * @throws SQLException */ private ResultSet getResult(VDimension dimension) throws SQLException { // Get a connection to retrieve items. Connection connection = VExplorer.getConnection(); QuerySelect querySelect = new QuerySelect(HibernateUtil.getDialect()); Statement stmt = connection.createStatement(); querySelect.addSelectColumn("id", "id"); if (dimension.isDependent()) { querySelect.addSelectColumn("parent", "parent"); } querySelect.addSelectColumn("name", "name"); querySelect.getJoinFragment().addJoin(dimension.getTableName(), UniVisDialect.generateTableAlias(dimension.getTableName(), 1), new String[] { "parent" }, new String[] { "id" }, JoinFragment.FULL_JOIN); String sql = "SELECT " + dimension.getTableName() + ".id, " + (dimension.isDependent() ? dimension.getTableName() + ".parent, " : "") + dimension.getTableName() + ".name " + createWhereClause(dimension); return stmt.executeQuery(sql); }