Hi Jayaraj, Ar you working remotely? Current implementation does not support mixed remote transactions (APIs and SQL together, see http://orientdb.com/docs/2.2.x/Transactions.html). This will be supported in next v 3.0
Anyway, v 2.0.x is no longer supported and definitely much less stable than latest 2.2.x, I strongly suggest you to upgrade. If you need help on this, please let us know Thanks Luigi 2016-12-22 6:00 GMT+01:00 jaya raj <jackrajfurious1...@gmail.com>: > Hi , > > I am using orientdb 2.0.18, rollback is not working. > > factory = new OrientGraphFactory( > DatabaseConnectionMgr.URL,DatabaseConnectionMgr.USERNAME, > DatabaseConnectionMgr.PASSWORD).setupPool(1,10); > OrientGraph graph = factory.getTx(); > String sql = "insert into package_master set name=\""+bean.getName()+"\", > cost_price="+bean.getCostPrice()+",special_price="+bean.getSpecialPrice() > +", tax="+tax+", validity_count="+bean.getValidityCount()+", > validity_type="+bean.getValidityType()+", > validity_days="+bean.getValidityDays()+",discount=" > +bean.getDiscount()+",is_deleted=0,is_status=1,created_ > date='"+bean.getCurrentDate()+"'"; > Vertex v = graph.command(new OCommandSQL(sql)).execute(); > > graph.rollback() ; // is not working; > > > Regards > Jayaraj > > -- > > --- > You received this message because you are subscribed to the Google Groups > "OrientDB" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to orient-database+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
