In this case, we must use the Java 1.7 JVM that we installed earlier as opposed to any system JVM.Ĩ1 82 The LD_LIBRARY_PATH variable includes the location of the libJdbcOdbc.so library (the native component of the JDBC-ODBC bridge) and various libraries that it depends on.Ĩ3 84 The LD_PRELOAD variable makes sure that the ODBC library is loaded, as libJdbcOdbc.so requires it, but isn't actually linked against it, for some reason.Ĩ5 86 Give the script execute permissions as follows.Ĩ9 sudo chmod 755 /usr/local/bin/datagrip.shĩ3 94 Append the following to /etc/odbcinst.iniĩ9 Setup=/usr/local/firstworks/lib/libsqlrodbc.soġ00 Driver=/usr/local/firstworks/lib/libsqlrodbc.soġ01 Setup64=/usr/local/firstworks/lib/libsqlrodbc.soġ02 Driver64=/usr/local/firstworks/lib/libsqlrodbc.soġ05 106 Append the following to /etc/odbc/iniġ16 117 118 = Run !DataGrip for the First Time =ġ19 120 The first time you run !DataGrip it prompts you for various initial configuration options.ġ21 122 Run the datagrip.sh script you created earlier as follows.ġ27 128 * On the Complete Installation dialog:ġ29 * Leave Do not import settings selectedġ31 * On the !DataGrip Privacy Policy Agreement dialog:ġ33 * On the !DataGrip License Activation dialog:ġ36 * On the License Agreement for !DataGrip. ĥ8 * Wait a few seconds for the download to start.Ħ6 67 Create the script /usr/local/bin/datagrip.sh with the following contents:ħ3 export LD_LIBRARY_PATH=/opt/jdk1.7.0_80/jre/lib/amd64ħ4 export LD_PRELOAD=/usr/lib/x86_64-linux-gnu/libodbc.soħ9 80 The JAVA_HOME variable indicates which JVM to use. Ĥ0 * Click the radio box next to //Accept License Agreement//.Ĥ1 * Scroll down to the section labelled //Java SE Development Kit 7u80// and download the following tar.gz file from beneath that section:Ĥ3 44 Install the contents of the tar.gz file as follows:ĥ5 56 * Navigate to. ģ6 * Mouse-over the //Sign In// link at the top right of the page.ģ7 * If you don't already have an account, click //Create an account// and follow the instructions.ģ8 * If you have an account, click the //Sign In// box and enter your Username and Password.ģ9 * Navigate to. )ģ2 33 On the !DataGrip/SQL Relay client system, download Java JDK 1.7 as follows.ģ4 35 * Navigate to. )Ģ1 22 * Any operating system that supports SQL Relay server, accessible as:Ģ7 28 ( See the how-to for information on configuring a system like this. So, the JDBC-ODBC bridge provided by Java 1.7 can be used to access SQL Relay.ĩ 10 The how-to assumes that two systems have been set up and configured as follows:ġ3 14 * Ubuntu 16.04 Desktop operating systemġ5 * //apt upgrade// was run post-installġ6 * A user with sudo privileges has desktop access to the systemġ7 18 ( See the how-to for information on configuring a system like this. SQL Relay doesn't provide a proper JDBC driver, but does provide an ODBC driver. As a special service "Fossies" has tried to format the requested text file into HTML format (style: standard) with prefixed line numbers.Īlternatively you can here view or download the uninterpreted source code file.ġ = Ubuntu 16.04 - !JetBrains !DataGrip + SQL Relay =Ĥ 5 * Installing !JetBrains !DataGrip on an Ubuntu 16.04 systemĦ * Using !DataGrip to access a database via an SQL Relay server, installed on another systemħ 8 !DataGrip can access any data source for which a JDBC driver exists.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |