Description Areq Novak 2014-03-25 04:57:26 EDT

Hi,

I have a problem with update and delete (select works ok)

This code works ok:

String query = "select * from eve_art where cdo_id = '"
+ id + "'";
StandaloneCDOAccess standaloneCDOAccess = new StandaloneCDOAccess();
CDOSession cdoSession = standaloneCDOAccess.openSession();
CDOTransaction transaction = cdoSession.openTransaction();
CDOQuery cqo = transaction.createQuery("sql", query);
EObject object = cqo.getResultValue(clazz);


but this code works wrong (a lack of change in db):

String query = "delete from eve_art where cdo_id = '"
+ uid + "'";
StandaloneCDOAccess standaloneCDOAccess = new StandaloneCDOAccess();
CDOSession cdoSession = standaloneCDOAccess.openSession();
CDOTransaction transaction = cdoSession.openTransaction();
CDOQuery cqo = transaction.createQuery("sql", query);
cqo.setParameter("queryStatement", false);
System.out.println("!! " + cqo.getResult().get(0));

syso returned 1, record still exist in db


init and openSession from StandaloneCDOAccess :

private void init()
{
OMPlatform.INSTANCE.setDebugging(false);
OMPlatform.INSTANCE.addLogHandler(PrintLogHandler.CONSOLE);
OMPlatform.INSTANCE.addTraceHandler(PrintTraceHandler.CONSOLE);

IManagedContainer container = ContainerUtil.createContainer();
Net4jUtil.prepareContainer(container);
TCPUtil.prepareContainer(container);
CDONet4jUtil.prepareContainer(container);
container.activate();

IConnector connector = TCPUtil.getConnector(container, StandaloneCDOServer.DEFAULT_SERVER_ADDRESS);

configuration = CDONet4jUtil.createNet4jSessionConfiguration();
configuration.setConnector(connector);
configuration.setRepositoryName("opencoss");
}


public CDOSession openSession()
{
CDOSession session = configuration.openNet4jSession();

for (EPackage ePackage : getEPackages()) {
session.getPackageRegistry().putEPackage(ePackage);
}

return session;
}

thanks
Mike