Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

udb 7 jdbc issue

 
k matt
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
OS WIN2K, eclipse 3.1.0 id

connection.createStatement() is giving the following error. I am getting a valid connection.

java.lang.UnsatisfiedLinkError: SQLFreeConnect
at COM.ibm.db2.jdbc.app.DB2Connection.SQLFreeConnect(Native Method)
at COM.ibm.db2.jdbc.app.DB2Connection.close2(DB2Connection.java:702)
at COM.ibm.db2.jdbc.app.DB2Connection.close(DB2Connection.java:667)
at etl.MyDbConnection.main(MyDbConnection.java:56)
Exception in thread "main"

Thanks
Matt
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64683
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"matt",

There aren't many rules that you need to worry about here on the Ranch, but one that we take very seriously regards the use of proper names. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.

In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.

Thanks!
bear
Forum Bartender
 
Makarand Parab
Ranch Hand
Posts: 121
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi matt
Please check this url for your solution
http://eai.ittoolbox.com/groups/groups.asp?v=seebeyond-l&i=371794

Let me know if it is of any help

Regards
Makarand Parab
 
k matt
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Which *.so file are they talking about in LD_LIBRARY_PATH, I can connect to the database by running the same app from command line, but cannot run the app from Eclipse IDE. I looked for *.so file and there are more than 200 files in the system.

Matt
 
Makarand Parab
Ranch Hand
Posts: 121
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Matt
i have no idea what does file mean, i was looking at solution for your problem on google and then i gave you the feedback. U need to drop a mail to IBM support in order to figure out the given problem.

Regards
Makarand Parab
 
k matt
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Mak,
The interesting thing is the same code works from command line, but does not run from Eclipse. I know it is complaining about loading the native library. System.loadLibrary("SQLFreeConnect") will give the same error.

Thanks,
k matt
 
Makarand Parab
Ranch Hand
Posts: 121
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
Did u put those files/ or path in the runtime classpath of the Eclipse. Try that and see
 
k matt
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes I did, the same problem.

Matt
 
Makarand Parab
Ranch Hand
Posts: 121
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Matt
When you run through command line it runs in java runtime env while when u run through eclipse it runs in IBM runtime env. Ru missing something over there. Just a guess.

Regards
Makarand Parab
 
k matt
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Mak,
I tried to set run time libraries for Eclipse, but with no success. I am not sure whether I did it the right way

Matt
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34178
340
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
As this turned into an Eclipse issue, I'll move the thread to our IDEs forum for you.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic