Insertion Excep

[eswar reddy]

when I am trying to insert with the following query

OrientGraphNoTx graph = factory.getNoTx();

  try {

String query = "INSERT INTO SuperMarket (Item,Code,Quantity) VALUES('banana',12.33,50)";

graph.command(new OCommandSQL(query).execute());

graph.commit();

} catch (Exception e) {

graph.rollback();

System.out.println(e);

} finally {

graph.shutdown();

}

I am getting exception but the query is executed(data inserted)

why its committed rather than rollback()

but actual query is  graph.command(new OCommandSQL(query)).execute();

please help me any one (I am connecting at remote db)

[alessand...@gmail.com]

Hi,

you must replace

graph.command(new OCommandSQL(query).execute());

with 

graph.command(new OCommandSQL(query)).execute();

You can't do a rollback with a non-transactional graph.

Best regards,

Alessandro

[eswar reddy]

thanks for your suggestions but if I use transactional graph it didn't rollback.

when I use wrong query ( graph.command(new OCommandSQL(query).execute());

but the data is inserted into table

[alessand...@gmail.com]

Hi,

I tried your code with transactional graph and was not made the rollback.

Can you open an issue on github?

Best regards,

Alessandro