Dhtmlx form Incorrect XML

Suite and Optimus Suite 5
#1

Hi,

i am using dhtmlx connector and data processor to save the data from the form to database but gives the Incorrect XML format but the xml i generated using the servlet is valid

When i typed the data in form and click the save button the error displays INCORRECT XML

please help me

my code as below

DataConn.java Servlet code

import com.dhtmlx.connector.ConnectorServlet;
import com.dhtmlx.connector.GridConnector;

import java.sql.Connection;
import java.sql.DriverManager;

public class DataConn extends ConnectorServlet {
private static final long serialVersionUID = 1L;
public GridConnector conn;
public Connection connection=null;

public DataConn() {
    super();
    
}

@Override
protected void configure() {
	try {
		Class.forName ("org.h2.Driver").newInstance ();
		connection = DriverManager.getConnection("jdbc:h2:~/test", "sa", "");
	} catch (Throwable e) {
		e.printStackTrace();
	}
	
	conn = new GridConnector(connection);
	conn.render_table("test", "ID", "ID,NAME");
	
}

}

Design.jsp

Insert title here 
<link rel="STYLESHEET" type="text/css" href="codebase/dhtmlx.css">

<script src="codebase/dhtmlx.js" type="text/javascript"></script>
<div id="box" style="width:250px; height:160px; background-color:white;"></div>

XML generated from servelet.


1
Hi


2
se


3
sudha

4
vino

5
vino

#2

a) because it is a form, instead of
conn = new GridConnector(connection);
you need to use
conn = new FormConnector(connection);

b) in client side code you need to use
myForm.load(‘DataConn?id=123’);
where 123 - id of record, which you want to load in the form

#3

hi,

i changed the code to FormConnector

conn = new FormConnector(connection);

but the error occurs Incorrect XML

om.dhtmlx.connector.FormConnector cannot be cast to com.dhtmlx.connector.CommonConnector

#4

sorry
the error is
java.lang.ClassCastException: com.dhtmlx.connector.FormConnector cannot be cast to com.dhtmlx.connector.CommonConnector

#5

This is the sample code try to init form connector in the same manner

[code]import java.sql.Connection;

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

import com.dhtmlx.connector.FormConnector;
import com.dhtmlx.connector.ThreadSafeConnectorServlet;

public class Form_01_LoadConnector extends ThreadSafeConnectorServlet {

@Override
protected void configure(HttpServletRequest req, HttpServletResponse res) {
	Connection conn= ( new DataBaseConnection()).getConnection();
	
	FormConnector form = new FormConnector(conn);
	form.servlet(req, res);
	form.render_table("packages_small","Id","Package,Version,Maintainer");
}

}
[/code]

#6

Hi,

I used the above code and it generates the XML as follows

1 Hi 2 se 3 sudha 4 vino 5 vino

when i try to save the new data through my jsp it throws the error as follows…

java.lang.ClassCastException: com.dhtmlx.connector.FormConnector cannot be cast to com.dhtmlx.connector.CommonConnector
at com.dhtmlx.connector.DataProcessor.get_status(DataProcessor.java:158)
at com.dhtmlx.connector.DataProcessor.process(DataProcessor.java:120)
at com.dhtmlx.connector.BaseConnector.render(BaseConnector.java:292)
at com.dhtmlx.connector.BaseConnector.render_table(BaseConnector.java:210)
at com.dhtmlx.connector.BaseConnector.render_table(BaseConnector.java:178)
at test.FormConn.configure(FormConn.java:41)
at com.dhtmlx.connector.ThreadSafeConnectorServlet.doGet(ThreadSafeConnectorServlet.java:18)
at com.dhtmlx.connector.ThreadSafeConnectorServlet.doPost(ThreadSafeConnectorServlet.java:25)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:679)

#7

If issue still occurs for you - please open ticket at support system, the same code works correctly locally.