Hello
Annex I get the error when I try to fill a grid.
HTTP Status 404 - /sgn/Clientes.do
type Status report
message /sgn/Clientes.do
description The requested resource (/sgn/Clientes.do) is not available.
Apache Tomcat/7.0.25
The work environment is as follows:
Netbeans 7.1.2
Apache Tomcat 7.0.22.0
Grails 2.0.3
Dhtmlx 3.0
Java Source Packages/sgn/Clientes.java:
package sgn;
import java.sql.Connection;
import java.sql.DriverManager;
import com.dhtmlx.connector.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class Clientes extends ThreadSafeConnectorServlet{
@Override
protected void configure(HttpServletRequest req, HttpServletResponse res) {
Connection conn=null;
try {
Class.forName (“com.mysql.jdbc.Driver”).newInstance ();
conn = DriverManager.getConnection(“jdbc:mysql://localhost/sgn”, “root”, “yansar”);
} catch (Throwable e) {
e.printStackTrace();
System.out.println("Error al hacer la coneecion "+e.getMessage().toString());
}
GridConnector c = new GridConnector(conn,DBType.MySQL);
c.servlet(req, res);
c.render_table("clientes", "codigo", "codigo,nombre,contacto,telefono");
}
}
Views and Loyouts/grupos/Index.gsp:
<%@ page contentType=“text/html;charset=UTF-8” %>
<g:javascript library='jquery' plugin='jquery' />
<link rel="stylesheet" type="text/css" href="${resource(dir: 'codebase', file: 'dhtmlxgrid.css')}"/>
<link rel="stylesheet" type="text/css" href="${resource(dir: 'codebase/skins', file: 'dhtmlxgrid_dhx_skyblue.css')}"/>
<g:javascript src="codebase/dhtmlxcommon.js" />
<g:javascript src="codebase/dhtmlxtree.js" />
<g:javascript src="codebase/dhtmlxgrid.js" />
<g:javascript src="codebase/dhtmlxgridcell.js" />
<g:javascript src="codebase/connector.js" />
<g:javascript src="codebase/dhtmlxdataprocessor.js" />
<g:javascript>
mygrid = new dhtmlXGridObject(‘gridbox’);
mygrid.setImagePath(“codebase/imgs/”);//path to images required by grid
mygrid.setHeader(“Codigo, Nombre,Contacto,Telefono”);//set column names
mygrid.setInitWidths(“50,100,300,150”);//set column width in px
mygrid.setColAlign(“right,left,right,right”);//set column values align
mygrid.setColTypes(“ed,ed,ed,ed”);//set column types
mygrid.setColSorting(“int,str,str,int”);//set sorting
mygrid.init();//initialize grid
mygrid.setSkin(“dhx_skyblue”);//set grid skin
mygrid.loadXML(“Clientes.do”);//load data
myDP = new dataProcessor(“Clientes.do”);
myDP.init(myGrid);
</g:javascript>
SGN
Grupos de Clientes.
Controllers/GruposControllers.groovy
package sgn
class GruposController {
def index() { }
}
Appears the grid, but without the data.
Thank you very much for your reply.