Connecting to a remote MS SQL database using Java Connector

Suite and Optimus Suite 5
#1

Hello!

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.

Thanks!

#2

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

docs.dhtmlx.com/doku.php?id=dhtm … nd_logging

#3

Hai,

In server side i got this error

SEVERE: Servlet.service() for servlet jsp threw exception
java.lang.NullPointerException
at com.dhtmlx.connector.BaseConnector.parse_request(BaseConnector.java:351)
at com.dhtmlx.connector.GridConnector.parse_request(GridConnector.java:56)
at com.dhtmlx.connector.BaseConnector.render(BaseConnector.java:287)
at com.dhtmlx.connector.BaseConnector.render_table(BaseConnector.java:210)
at com.dhtmlx.connector.BaseConnector.render_table(BaseConnector.java:178)
at org.apache.jsp.MyJsp_jsp._jspService(MyJsp_jsp.java:60)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
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:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)

#4

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 ?

#5

Thanks

#6

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

nedd some help

#7

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

I need some help