dhtmlxCombo Servlet throws an IllegalStateException

Hi,

I’m trying to use dhtmlxConnector with dhtmlxCombo. To implement it, i’m using the java version of dhtmlxConnector, and i make a servlet(Proj_List.java) with this information:

ComboConnector c = new ComboConnector(conn,DBType.Oracle);
c.render_sql(“SELECT proj_short_name ID FROM project”,“proj_short_name(ID)”,“ID”);

And then, in the HTML, i created the control:

Finally, in the web.xml i wrote the next servlet mapping:

ProjList
Proj_List


ProjList
/ProjList.do

The problem is that when launch the web, it throws the following error:

GRAVE: Servlet.service() para servlet Generation lanzó excepción
java.lang.IllegalStateException
at org.apache.catalina.connector.ResponseFacade.reset(ResponseFacade.java:337)
at com.dhtmlx.connector.BaseConnector.output_as_xml(BaseConnector.java:424)
at com.dhtmlx.connector.BaseConnector.output_as_xml(BaseConnector.java:461)
at com.dhtmlx.connector.BaseConnector.render(BaseConnector.java:308)
at com.dhtmlx.connector.BaseConnector.render_sql(BaseConnector.java:262)
at com.dhtmlx.connector.BaseConnector.render_sql(BaseConnector.java:230)
at Act_Generation.configure(Act_Generation.java:34)
at com.dhtmlx.connector.ConnectorServlet.doGet(ConnectorServlet.java:28)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:562)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:395)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:250)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:188)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)

What can cause the error? Thanks,
Eduardo.

It may be related to the non-thread-safe nature of connectors.
You can update jar file with the attached one and change your code as

public class BasicConnector extends ThreadSafeConnectorServlet{ //new base class

c.servlet(req, res); //extra command
c.render_sql(“SELECT proj_short_name ID FROM project”,“proj_short_name(ID)”,“ID”);

With such init, connector will be thread-safe, which can resolve the above issue.
dhtmlxconnector.zip (163 KB)

Thanks Stanislav!

It works great.

Un saludo,
Eduardo.