Monday, November 14, 2011

java.lang.UnsatisfiedLinkError: no db2jdbc in java.library.path

If you get below mentioned error


Exception in thread "main" java.sql.SQLException: java.lang.UnsatisfiedLinkError: no db2jdbc in java.library.path
        at COM.ibm.db2.jdbc.app.DB2Driver.(Unknown Source)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at java.lang.Class.newInstance0(Class.java:355)
        at java.lang.Class.newInstance(Class.java:308)


Possible reason could be you forgot to add db2java.jar file in classpath. Please cross check if the jar file db2java.jar is added in class path.

Also make sure that driver name is in proper case, as Driver name case sensitive. i.e. COM.ibm.db2.jdbc.app.DB2Driver (Note that COM is in upper case)

To download Jar file : Click here