Hi Stan

I was able to setup ignite with Oracle as persistent layer. 
However I still have one concern, the existing Oracle DMLs are not working
with ignite

For e.g

In Oracle below is the insert statement I use

    insert into map_dummy (ENTITY_ID, MAPPING_ID_LIST, RELATIONSHIP,
UPDATEDDATETIME, UPDATEDBY, SEQUENCE_NO, TUPLE_COUNT) values
    ('8','maplist8','rel2',sysdate,'upd2','2','2')

In ignite, I had to prefix with schema

INSERT INTO *"MapDummyCache".*MAP_DUMMY (ENTITY_ID, MAPPING_ID_LIST,
RELATIONSHIP, UPDATEDDATETIME, UPDATEDBY, SEQUENCE_NO, TUPLE_COUNT) values
    ('6','maplist6','rel5',sysdate,'upd5','5','5');

Because of this, I had to change my existing Oracle DMLs to make it work
with Ignite. 
I believe I tried to change the schema to PUBLIC by explicitly setting the
schema while creating the cache, but still no luck,

Any suggestions for this,

Thanks
Naveen



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Reply via email to