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.

0
5 comments
Avatar
Permanently deleted user

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.

0
Avatar
Permanently deleted user

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

0
Avatar
Permanently deleted user

btw, i have used the sql plugin to connect to a db2 database using db2connect, so it will work

0
Avatar
Permanently deleted user

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:

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.

0
Avatar
Permanently deleted user

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

0

Please sign in to leave a comment.