NonStop SQL is a commercial relational database management system that is designed for fault tolerance and scalability for the HP NonStop. The latest version of the product is SQL MX 3.2.1 which was released in February 2013. This post describes how to setup IntelliJ or respective DataGrip to work with SQL MX.
- Create NonStop SQL MX driver setup
- Configure Connection
Create NonStop SQL MX driver
First we need to create a driver within IntelliJ since the HP NonStop is rather exotic in the common Java development. To do this, we need the JDBC driver for SQL MX from HP itself. In the below screenshot you see the default settings.
After you have successfully create the driver definition for the HP NonStop SQL MX, you can setup the data source. Take into consideration, that data on HP NonStop is highly critical and therefore avoid accidental changes, use a read only connection. The scope for the data source is also important. You can assign the scope to the project or the IDE, i.e. the data source is available in any project. Below you can see the default settings. Replace the user and password with your user.
If you query some tables and the alias is set, column names are displayed in the output. If the alias for a column isn’t set, DataGrip/IntelliJ displays anonymous. As workaround you can execute the invoke statement (which shows the table definition).