DHTMLX Java Connector

Discontinued products DHTMLX Touch
#1

Are there any docs are something on how to use this with the Touch Grid?

#2

Latest official version still has not support for touch grid, but you can use the attached jar and code like

[code]import java.sql.Connection;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.dhtmlx.connector.JSONCommonConnector;
import com.dhtmlx.connector.ThreadSafeConnectorServlet;

public class JSONSimpleDataSource extends ThreadSafeConnectorServlet {

@Override
protected void configure(HttpServletRequest req, HttpServletResponse res) {
	Connection conn = ( new DataBaseConnection()).getConnection();
	
	JSONCommonConnector data = new JSONCommonConnector(conn);
	data.servlet(req, res);
	data.render_table("touch_users", "id", "name,age,group_name,city,phone,sex,driver_license");
}

}
[/code]

on client side you need just use the path to the above servlet in “url” property of touch grid.
dhtmlxconnector.zip (173 KB)

#3

Common logic of connector (actions, parameters, options) - all the same as for normal java connectors

docs.dhtmlx.com/doku.php?id=dhtm … orjava:toc

#4

What should the datatype be? JSON throws an error and XML removes the error but it will not load the data. Thanks

#5

You need to use “json” as second parameter ( or just don’t use it at all - json is default data type )

#6

If issue still occurs - try to load the data-url directly in the browser and check its response.

#7
<?xml version='1.0' encoding='utf-8' ?>[{"id":"181827","DATE_ENT":"2011-01-10","EQUIPID":"001","EMPCODE":"BENNET","LRATE":"89.00","HOURS":"2.25","PAYTYPE":"1A"}]

is my response

Uncaught SyntaxError: Unexpected token <
dhx.DataDriver.json.toObject touchui_debug.js:3060
dhx.DataLoader.dhx.proto._onLoad touchui_debug.js:3475

this is what i get when it is set to json

#8

data=data.substring(data.indexOf("["))

that added to the json datadriver fixes it for me