SQL Query Plugin
Hello. I'm attempting to use the SQL Query plugin with Idea 4.5.1. to connect to a remote DB2 database. I place my jdbc 2.0 driver (db2java.zip) in the plugin/lib directory as well as well as add the directory to the "alternative driver". However, it's not in the driver list. I also select "other driver" and place in my username & URL (should their be an entry for "class" as well?). But I still can't connect. Any help would be appreciated. Thanks.
Please sign in to leave a comment.
BTW, I get the following error after entering my password:
java.lang.UnsatisfiedLinkError: no db2jdbc in java.library.path
I only have this problem on the remote (Win XP) machine. I can connect just fine locally(Win 2K). When using other SQL clients such as DBVisualizer, I have no problems. Thanks.
You may need runtime.zip also. I have had some problems in the past with applications not liking the .zip extension. I usually take db2java.zip and runtime.zip and rename them to .jar
btw, i have used the sql plugin to connect to a db2 database using db2connect, so it will work
Because of the UnsatisfiedLinkError i think there is some DLL missing
required by the JDBC driver. Only jar files are loaded from the
plugin\ks-sql\lib or alternate location.
If you use 'Other Driver' where sould be 4 entries in the properties
table: Class, URL, User, Auto Commit.
Bye, Stefan.
no_mail@jetbrains.com wrote:
i work with db2 and the plugin works ok, just cant changed
data inside the results :(
btw i used the other driver option to work with db2