Connecting to a remote MS SQL database using Java Connector


We would appreciate if any one could guide us in connecting to a remote MSSQL database using the Java Connector.

We are using the DHTMLx Grid component in a JSP Page . We already tried the following steps:

1> included the connector.jar file
2> implemented the following code:

GridConnector c = new GridConnector(conn);
c.render_table(“item_mast”, “id”, “code,name”);

We are able to connect to the database but the the above step(2) to populate the grid with the records in the “item_mast” table is not working.

If we can get an example, it would be great.


Try to enable server side logging and check the error details. … nd_logging


In server side i got this error

SEVERE: Servlet.service() for servlet jsp threw exception
at com.dhtmlx.connector.BaseConnector.parse_request(
at com.dhtmlx.connector.GridConnector.parse_request(
at com.dhtmlx.connector.BaseConnector.render(
at com.dhtmlx.connector.BaseConnector.render_table(
at com.dhtmlx.connector.BaseConnector.render_table(
at org.apache.jsp.MyJsp_jsp._jspService(
at org.apache.jasper.runtime.HttpJspBase.service(
at javax.servlet.http.HttpServlet.service(
at org.apache.jasper.servlet.JspServletWrapper.service(
at org.apache.jasper.servlet.JspServlet.serviceJspFile(
at org.apache.jasper.servlet.JspServlet.service(
at javax.servlet.http.HttpServlet.service(
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
at org.apache.catalina.core.StandardWrapperValve.invoke(
at org.apache.catalina.core.StandardContextValve.invoke(
at org.apache.catalina.core.StandardHostValve.invoke(
at org.apache.catalina.valves.ErrorReportValve.invoke(
at org.apache.catalina.core.StandardEngineValve.invoke(
at org.apache.catalina.connector.CoyoteAdapter.service(
at org.apache.coyote.http11.Http11Processor.process(
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(

What do you mean by “implemented the following code:”
Are you creating new class on base of ConnectorServlet and override “configure” method, or just use the GridConnector class in wild ?


dis you solve the problem of [Connecting to a remote MS SQL database using Java Connector ?

nedd some help

did you solve the problem of Connecting to a remote MS SQL database using Java Connector ?

I need some help