#2 Exception when doubleclicking datasource

[Anonymous]

Getting the following stacktrace:

[ 108844] ERROR - com.intellij.ide.q - Error
during dispatching of java.awt.event.MouseEvent
[MOUSE_CLICKED,
(578,140),button=1,modifiers=Button1,clickCount=2] on
frame0
[ 108844] ERROR - com.intellij.ide.q - IntelliJ
IDEA (Ariadna) 3.0 Build #642
[ 108844] ERROR - com.intellij.ide.q - JDK:
1.4.0_01
[ 108844] ERROR - com.intellij.ide.q - VM:
Java HotSpot(TM) Client VM
[ 108844] ERROR - com.intellij.ide.q - Vendor:
Sun Microsystems Inc.
[ 108844] ERROR - com.intellij.ide.q - OS:
Windows NT
[ 108844] ERROR - com.intellij.ide.q -
java.lang.UnsatisfiedLinkError: SQLFreeConnect
at
COM.ibm.db2.jdbc.app.DB2Connection.SQLFreeConnec
t(Native Method)
at COM.ibm.db2.jdbc.app.DB2Connection.close2
(DB2Connection.java:694)
at COM.ibm.db2.jdbc.app.DB2Connection.close
(DB2Connection.java:659)
at
net.plugin.sql.gui.SQLDataPanel.buildSchemaList
(Unknown Source)
at net.plugin.sql.gui.SQLDataPanel.<init>
(Unknown Source)
at net.plugin.sql.gui.SQLFrame.<init>(Unknown
Source)
at
net.plugin.sql.gui.SQLWindowManager.createFrame
(Unknown Source)
at
net.plugin.sql.gui.MainSQLView.dataSourceSelected
(Unknown Source)
at
net.plugin.sql.gui.SQLConnectionTree.notifyDatasourceLi
steners(Unknown Source)
at
net.plugin.sql.gui.SQLConnectionTree.mouseClicked
(Unknown Source)
at java.awt.AWTEventMulticaster.mouseClicked
(AWTEventMulticaster.java:208)
at java.awt.Component.processMouseEvent
(Component.java:5024)
at java.awt.Component.processEvent
(Component.java:4818)
at java.awt.Container.processEvent
(Container.java:1525)
at java.awt.Component.dispatchEventImpl
(Component.java:3526)
at java.awt.Container.dispatchEventImpl
(Container.java:1582)
at java.awt.Component.dispatchEvent
(Component.java:3367)
at
java.awt.LightweightDispatcher.retargetMouseEvent
(Container.java:3359)
at
java.awt.LightweightDispatcher.processMouseEvent
(Container.java:3083)
at java.awt.LightweightDispatcher.dispatchEvent
(Container.java:3004)
at java.awt.Container.dispatchEventImpl
(Container.java:1568)
at java.awt.Window.dispatchEventImpl
(Window.java:1581)
at java.awt.Component.dispatchEvent
(Component.java:3367)
at java.awt.EventQueue.dispatchEvent
(EventQueue.java:445)
at com.intellij.ide.q.a(q.java:9)
at com.intellij.ide.q.dispatchEvent(q.java:23)
at
java.awt.EventDispatchThread.pumpOneEventForHierarc
hy(EventDispatchThread.java:191)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy
(EventDispatchThread.java:144)
at java.awt.EventDispatchThread.pumpEvents
(EventDispatchThread.java:138)
at java.awt.EventDispatchThread.pumpEvents
(EventDispatchThread.java:130)
at java.awt.EventDispatchThread.run
(EventDispatchThread.java:98)
SQLPlugin.writeExternal
writing dataSource = db21

[James Birchfield]

Logged In: YES
user_id=162865

The Exception id one of 'UnsatisfiedLinkError'. Although I
have not used DB2 as my database, it appears you need
to adjust your Java environment to pick up the native
libraries required by your driver. First I would recommend
using a 'thn' fdriver, one that does not require any native
code. If you are going to use native code, you must place
the directory containing the dll's or so's in the environemnt
variable 'java.library.path'.

The reason you are allowed to make the datasource
successfully is this. SQLViewer does not actually attempt
to use the datasource at creation time. It simply looks up
and makes sure it can find the driver class. Once you
create it and double click it, then it tries to use it and it
fails.