• Recent
    • Tags
    • Popular
    • Register
    • Login

    Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

    Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website Mango 5 Documentation Website

    Using the H2 DB

    User help
    2
    3
    1.6k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • L
      LarryE
      last edited by

      Where can I get information on setting up relationships using the h2 console? Is their another front end to use for this?

      1 Reply Last reply Reply Quote 0
      • phildunlapP
        phildunlap
        last edited by

        Hi Larry,

        What do you mean, "setting up relationships?" You can run ALTER TABLE statements either through the SQL Console or through the h2-web-console script described here: http://help.infiniteautomation.com/support/solutions/articles/14000022661-about-the-h2-database

        H2 has lots of documentation: http://www.h2database.com/html/main.html

        You can also convert to MySQL if you have a greater familiarity with it or tools based upon it.

        1 Reply Last reply Reply Quote 0
        • L
          LarryE
          last edited by

          I am trying to connect to the h2 server DB with "Razorsql" ,but it tells me ------
          ((ERROR: An error occurred while trying to make a connection to the
          database:

          JDBC URL: jdbc:h2:P:\IT Dept Installs\Mango Automation 2.7.10
          Enterprise Demo\databases\mah2

          Database may be already in use: "Locked by another process".
          Possible solutions: close all other connection(s); use the server
          mode [90020-166] ))
          Has any one used razor for the h2 DB? Any help would be great. Thanks

          1 Reply Last reply Reply Quote 0
          • First post
            Last post