Problem with connector and dataprocessor

Suite and Optimus Suite 5
#1

From: sudhakar940
To: Stanislav
hi,

the following code read the DB using connector and display it in grid but fails to do the update operation i don’t know where i made the mistake

please help me…

Servlet code DatabaseConn.java

public class DatabaseConn extends ConnectorServlet implements Servlet {
public GridConnector conn;
public Connection connection=null;

public DatabaseConn() {
super();
}
@Override
protected void configure() {
// TODO Auto-generated method stub
try {
Class.forName (“org.h2.Driver”).newInstance ();
connection = DriverManager.getConnection(“jdbc:h2:~/test”, “sa”, “”);
} catch (Throwable e) {
e.printStackTrace();
}

conn = new GridConnector(connection);
conn.render_table(“test”, “ID”, “ID,NAME”);
conn.enable_log(“./log.txt”,true);
}

}

HTML code grid.html

Insert title here
#2

In server side code change order of commands as

conn.enable_log("./log.txt",true);
conn.render_table(“test”, “ID”, “ID,NAME”);

it will give some meaningful record log

Also on client side the setTransactionMode command is not necessary ( must not cause any harm though )

#3

Hi Stanislav,

i have done those changes u mentioned even though there is no change the update,delete, operations are not working is there is anything wrong in my code? i think the connector is working perfect but the problem may be in the dataprocessor could u give me any suggestions on this because after working with the trial only my org promises to purchase the Enterprise license…