GridGain Community Edition

Expand all | Collapse all

What is the difference between JDBC interface access to Ignite and access to other relational databases such as MySQL?

  • 1.  What is the difference between JDBC interface access to Ignite and access to other relational databases such as MySQL?

    Posted 29 days ago

    Hi ,

     

    I would like to consult the following questions,thanks.

     

    Java applications use the MyBatis framework as the premise. What is the difference between accessing Ignite through the JDBC interface and accessing other relational databases such as MySQL? In addition, what are the restrictions on use? thanks.

     

    BR,



    ------------------------------
    Qiaoqiao Sun
    office staff
    ASUS Technology
    ------------------------------


  • 2.  RE: What is the difference between JDBC interface access to Ignite and access to other relational databases such as MySQL?

    Posted 29 days ago
    Hello!

    Every database has its own SQL dialect and may implement a different set of JDBC features. There may be different connection settings - in cast of GridGain it is collocated, distributedJoins, lazy mode, etc.

    So I don't know how to answer your question in general. There should not be significant difference.

    Regards,

    ------------------------------
    Ilya Kasnacheev
    Community Support Specialist
    GridGain
    ------------------------------



  • 3.  RE: What is the difference between JDBC interface access to Ignite and access to other relational databases such as MySQL?

    Posted 28 days ago

    Hello! thanks for your reply!

     

    I also want to consult you that if there are any defects or special attention to use when integrating ignite queries with persistence frameworks such as mybatis?

     

    Regards,



    ------------------------------
    Qiaoqiao Sun
    office staff
    ASUS Technology
    ------------------------------



  • 4.  RE: What is the difference between JDBC interface access to Ignite and access to other relational databases such as MySQL?

    Posted 28 days ago
    Hello!

    We don't have any specific recommendations regarding this use case. I don't expect there will be any issues, but if you see any, please write here.

    Regards,

    ------------------------------
    Ilya Kasnacheev
    Community Support Specialist
    GridGain
    ------------------------------