Dynamic Loading with Java Connectors Servlet

edited May 2017 in Technical questions

Hello,

I may have not well understood how dynamic loading work, and facing strange behaviors.

I have a Java Servlet getting an Oracle Datasource from my smx server, and using JSONCommonConnector to render the data.
Everything shows well on my client-side UI datatable.

Then I add the dynamic_loading to my servlet, and my browser then sends requests on scroll, like myDataUrl?start=200&count=50&continue=true, which is good.

The problem is when I reach this url myDataUrl?start=200&count=50&continue=true, it does not load the correct data, but always the initial one, at pos=0.

What have I missed?

Also, using JSONCommonConnector (or any other connector) cannot render ORACLE Timestamp fields, throwing :

com.dhtmlx.connector.ConnectorOperationException: Conversion to String failed

How comes?

[Here are my codes]

Java Servlet


public class JournalState extends ThreadSafeConnectorServlet {

   private static DataSource dataSource;

   public JournalState(final DataSource dataSourceServ ){
      dataSource = dataSourceServ;
   }

   @Override
   protected void configure(HttpServletRequest req, HttpServletResponse res) {
      
      //obtain DB connection
      Connection conn = null;
      try{
         conn = dataSource.getConnection();
      }catch(Throwable e){
         e.printStackTrace();
      }
      
      //Initialize connector
      JSONCommonConnector c = new JSONCommonConnector(conn, DBType.Oracle);
      c.servlet(req, res);

      //configure used table and fields
      c.dynamic_loading(200);
      c.render_table("MYTABLE", "ID", "NAME,LOCATION,QUANTITY");
   }

}

Webix JS


 webix.ui({
  view : "datatable",
  id : "journal:datatable",
  autoConfig : true,
  navigation : true,
  select : true,
  resizeColumn : true,
  url : myDataUrl,
});

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!