Custom JDBC Driver with separate credentials file
I'm trying to setup a connection to Infor Datalake. They have a provided JDBC Driver. The driver relies on a separate file for credentials ending in .IONAPI. The normal setup is to drop the .jar and .ionapi file into the same folder and then connect. I'm able to connect with this setup usind DBeaver, so I know it works, however, when attempting to recreate the same setup in DataGrip, I'm unable to connect with this error:
JDBC Error 100
Unable to connect. The Infor Compass JDBC Driver.ionapi file is not found. The file must be located in the folder containing the Compass JDBC driver JAR file.
However, both my JAR and .ionapi file are in the same folder and the JAR file and that folder are mapped in the Driver Files setup area. I was curious if maybe the .ionapi file needs to be somewhere else within the datagrip folder structure or if anyone has had success with a similar setup. Thanks.
请先登录再写评论。
May I know how you added the driver via Custom Jar, or Library option? I may assume you might need the second option
https://www.jetbrains.com/help/datagrip/other-databases.html#library-paths-for-user-drivers
I have the same problem here.
I've tried adding the jar file, and it doesn't find the .ionapi file.
Then I've tried adding the folder, and it doesn't pick the JDBC driver.
Also tried adding both and nothing too…
Did you managed to solve this?
Thanks in advance,
haritrigger,
Have you tried adding it according to Aleksandrs' suggestion?
In case anyone else runs into this, I was able to get it working by copying the .ionapi file into the Working directory of the connection.
Created the Driver using the .jar file.
Created a Data Source using the Driver and then copied the .ionapi file into the Working directory (which you can find using the Advanced tab).