Hi
When I execute the example 05_save with dhtmlxConnector for Java and Oracle table like this:
ID_NODE VALUE PARENT_ID
1 3109534 0
2 Ecatepec1 1
3 Neza 1
4 Coacalco 1
5 CC 1 3
6 CC 2 3
The tree is loaded sucessfully but when i try to delete a node the accion dont delete the record in the Oracle data base, for example if i try to delete the element with id_node 5, the next sql appers in the log:
====================================
Log started, Thu Nov 25 13:09:18 CST 2010
DB query
DELETE FROM BSKVTD_RET_TF_DAT_NODO WHERE ID_NODE=‘5’ AND ( PARENT_ID=‘0’ )
The record is not delete because the PARENT_ID for ID_NODE 5 is 3 not 0, the same ocurrs with the update:
UPDATE BSKVTD_RET_TF_DAT_NODO SET VALOR=‘11111111111’ WHERE ID_NODE=‘5’ AND (PARENT_ID=‘0’)
How I can specify to the conector that not include “AND ( PARENT_ID=‘0’ )” in the delete or update stament?
Thanks
My class is:
public class Tree_05_SaveConnector extends ConnectorServlet {
/* (non-Javadoc)
* @see com.dhtmlx.connector.ConnectorServlet#configure()
*/
@Override
protected void configure() {
Connection conn= ( new DataBaseConnection()).getConnection();
TreeConnector c = new TreeConnector(conn, DBType.Oracle);
c.render_table("BSKVTD_RET_TF_DAT_NODO", "ID_NODE", "VALUE","","PARENT_ID");
c.enable_log("C:\\Users\\aalzaga\\temp.log", true);
}
}