[gundapu]

Hello all,

I have a problem connecting to UDB database. I am gettting the follwing message.

“Error while trying to connect to database: The version of the IBM Universal JDBC Driver in use is not licensed for connectivity to DB2 for Unix/Windows databases.To connect to this database server, please obtain a licensed copy of the IBM DB2 Universal Deriver for JDBC and SQLJ. An appropriate license file db2jcc_license_*.jar for this target platform must be installed to the application classpath.Connectivity to DB2 for Unix/Windows databases is enabled by any of the follwing licese files: {db2jcc_license_cisuz.jar,db2jcc_license_cu.jar}”

I have included the three jar files
(db2jcc.jar, db2jcc_license_cisuz.jar,db2jcc_license_cu.jar) in the system classpath. And also included in the (Windows>Preferences>MyEclipse>Database>Drivers). Still I was not able to get thru. I am still getting the same error message. I did not get any enough help from MyEclipseIde support team. They suggested me to include those jar files in (Windows>Preferences>MyEclipse>Database>Drivers). So I did , but that did not help. Now if any of you have experienced this kind of issues while connecting to UDB, please help me get thru this situation.

Thanks,
Srinivas

[rzn7z7]

Today I created a new driver under Windows>Preferences>MyEclipse>Database Explorer>Drivers and successfully connected to UDB v8.1 thru DB Explorer, so I know it can be done. Yes, you must include all 3 jar files; for the driver class name I used com.ibm.db2.jcc.DB2Driver and my connection uses a URL of jdbc:db2://<host>:<port #>/<dbname>

Attempts to connect w/ the IBM DB2 App Driver that’s provided w/ MyEclipse didn’t work, nor did a second driver I created using COM.ibm.db2.jdbc.net.DB2Driver as the driver class name

Config info: Windows XP, Eclipse 3.0.1, MyEclipse 3.8.4 connecting to UDB 8.1

You’re getting a licensing error? Can you write a simple java client to connect to UDB? If it complains, too, your issue isn’t due to MyEclipse

gm

[gundapu]

I included all the three jars in the .classpath file for the project. And I used the same driver as com.ibm.db2.jcc.DB2Driver. It worked from the java client. But this is not working from DB Explorer. That is the issue. I am getting connection from java client. but not from DB Explorer. Can you please tell what you included in Windows>Preferences>MyEclipse>Database Explorer>Drivers. I would appreciate if you can paste or tell me what exactly you included above mentioned Drivers locations. I need to get that connection from DB Explorer.

Thanks,
Srinivas

[rzn7z7]

I did not include the jars in the projects’ classpath; instead, when adding the new driver under Windows>Preferences>MyEclipse>Database Explorer>Drivers I added them on the Extra Class Path tab; they’re not in the lone jar file (startup.jar) listed on the Java Class Path tab

That’s all it took….plus some jiggerin’ w/ the URL

gm

[quickhelper_319487]

I’m not using MyEclipse. Just the Database Explorer in Eclipse 3.1. To connect to db2 I had to supply both driver files in the Class location: field. I did it by clicking browse and selecting both files in the dialogue box. After clicking OK the Class location: had the following in it:

C:\eclipse31wtp\db2\db2jcc.jar;C:\eclipse31wtp\db2\db2jcc_license_cu.jar

Everythings working great now. You just have to include both jar’s paths separated by a semicolon.

[Brian Fernandes]

Gundapu,

I apologize for not replying to this post, we missed it becuase it was probably replied to already.
Could you post screenshots of your Driver setup and connection profile? In particular, what driver class are you specifying and what connection URL do you use? (Feel free to blank out the IP)

Please answer all questions asked here: Posting Guidelines

Best,
Brian.

[Author]

Posts