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.
Using the H2 DB
-
Where can I get information on setting up relationships using the h2 console? Is their another front end to use for this?
-
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.
-
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\mah2Database 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