How do I create a tree with dhtmlxConnector?

Suite and Optimus Suite 5
#1

Hi,
I am trying to create a dhtmllxtree that uses a connector in the server side. I did not find a complete example in the documentation for how to do this - as exists for the table. Is there more documentation somewhere that I missed?
Anyway, I improvised based on the information that I did find. My client and server code are below. The HTML showed no output. Any ideas?

dhtmlx tree

The server code (in Java):

import com.dhtmlx.connector.*;
import com.dhtmlxApp.ConnectionManager;
import com.dhtmlxApp.test.GridTest;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class TreeConnectorServlet extends ConnectorServlet {
@Override
protected void configure() {
//obtain DB connection
Connection conn=null;
try {
conn = ConnectionManager.getConnection();
//Initialize connector
TreeConnector c = new TreeConnector(conn, DBType.MySQL);
//configure used table and fields
c.render_table(“TREE_TEST”, “id”, “prop01,prop02,prop03”, “”, “parent_id”);
} catch (Throwable e) {
e.printStackTrace();
}
}
}

#2

You code is mostly correct

<div id="treeBox" style="width:200;height:200" will work better as <div id="treeBox" style="width:200px;height:200px"

and the next line is not necessary in js code of tree initialization
treeGridConn.render_table(“tableA”,“id”,“name,price”,"",“parent_id”);

As for samples, grab full package
dhtmlx.com/x/download/regula … r_java.zip
it contains samples.war inside
samples.war\WEB-INF\src\Tree_01_BasicConnector.java

#3

I tried with the changes but it still does not work. I put a breakpoint in the servlet and the breakpoint IS reached and run passes successfully. However, the html remains blank. Maybe the SQL results are not right? This is the result of the SQL “select * from tree_test”:
id;prop01;prop02;prop03;parent_id

0;‘root’;‘prop2’;‘prop3’;
1;‘child-1.1’;‘prop2’;‘prop3’;0
2;‘child-1.2’;‘prop2’;‘prop3’;0
3;‘child-1.3’;‘prop2’;‘prop3’;0
4;‘child-1.2.1’;‘prop2’;‘prop3’;2
5;‘child-1.2.2’;‘prop2’;‘prop3’;2

#4

Never mind - I succeeded. I removed the lines after the div:
setImagePath=“dhtmlxTree/codebase/imgs/”
class=“dhtmlxTree”

and used
window.dhx_globalImgPath=“dhtmlxTree/codebase/imgs”;
instead of
tree.setImagePath(“dhtmlxTree/codebase/imgs”);

and I finally see a tree:)