[Steve Gutter]

I added that jar, but got the same results.
Here’s the log entry:
Message: Error while trying to login to database
Exception Stack Trace:
java.sql.SQLException: Unable to create connection. Check your URL.
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:102)
at com.genuitec.eclipse.sqlexplorer.actions.LoginProgress$Login.run(LoginProgress.java:43)
at java.lang.Thread.run(Unknown Source)

[Haris Peco]

jdbc:db2//u957dbc9.atlas.com:52012/ALPHADB1

try this

jdbc:db2://u957dbc9.atlas.com:52012/ALPHADB1

‘:’ between db2 and // is necessary, too

best

[Steve Gutter]

Yes, that jar is in the list also.
BTW: I do appreciate you hanging on trying to resolve this issue.

Here’s the error log entry:
java.sql.SQLException: Unable to create connection. Check your URL.
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:102)
at com.genuitec.eclipse.sqlexplorer.actions.LoginProgress$Login.run(LoginProgress.java:43)
at java.lang.Thread.run(Unknown Source)

[Steve Gutter]

Sorry about the last post: I didn’t notice you’d already replied.
The jars I have in the Driver definition are:
db2jcc_license_cu.jar
db2jcc.jar
db2jcc_javax.jar
The driver class name I’m using is:
com.ibm.db2.jcc.DB2Driver

I changed the URL to the format you specified,
and the error I’m getting is in the log at the end of this post.

When I did a Google for db2jcc_license_cisuz.jar,
which is listed in the error log,
it says I need db2jcc_license_cisuz.jar for z/OS DB2:
db2jcc_license_cu.jar is only for Unix, Linux, Windows, and Cloudscape.
My DB2 is on z/OS.
Here’s the URL for that:
http://www-1.ibm.com/support/docview.wss?uid=swg21191319

Where do I download this jar from?

com.ibm.db2.jcc.b.SqlException: The version of the IBM Universal JDBC driver in use is not licensed for connectivity to QDB2 databases. To connect to this DB2 server, please obtain a licensed copy of the IBM DB2 Universal Driver for JDBC and SQLJ. An appropriate license file db2jcc_license_*.jar for this target platform must be installed to the application classpath. Connectivity to QDB2 databases is enabled by any of the following license files: { db2jcc_license_cisuz.jar }
at com.ibm.db2.jcc.b.o.eb(o.java:3323)
at com.ibm.db2.jcc.b.o.a(o.java:3259)
at com.ibm.db2.jcc.c.b.a(b.java:578)
at com.ibm.db2.jcc.c.b.<init>(b.java:294)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:165)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:99)
at com.genuitec.eclipse.sqlexplorer.actions.LoginProgress$Login.run(LoginProgress.java:43)
at java.lang.Thread.run(Unknown Source)

[Haris Peco]

etienneg,

I want help you, but I think that you have to search licence from IBM – see this http://www-128.ibm.com/developerworks/db2/library/techarticle/0307zikopoulos/0307zikopoulos.html
or ask on ibm forum
http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=292&cat=19

It’s possible taht you have driver in your distribution, already (see first links)

best

[Steve Gutter]

I’ll try it via my IBM rep.
Which leads me back to my original question:
it worked fine with COM.ibm.db2.jdbc.app.DB2Driver from db2java.jar
in MyEclipse 3.8.
While this may not be the preferred driver to use,
if there was no change from ME 3.8 to 4.1,
then why doesn’t that work anymore in MyEclipse 4.1?

[Steve Gutter]

That solved it!
Since I’m trying to use z/OS DB2, I needed db2jcc_license_cisuz.jar.
The other file (db2jcc_license_cu.jar) is for Linux DB2.
Thanks for all your help.

[Haris Peco]

etienneg,

Great.I have tried your problem with type 2 driver.Do you interest for this driver now ?

Best

[Steve Gutter]

I’d just like to get it working with what worked in ME 3.8:
COM.ibm.db2.jdbc.app.DB2Driver from db2java.jar,
using a URL of jdbc:db2:someAlias

[Haris Peco]

eteinneg,

I work on this case.There are problems, but I have to explore more.Please, be patient.I hope that it will be resolved in 4.1.1

Best

[Haris Peco]

etienneg,

What is your OS.We can resolve problem for db2 type 2 on windows, but Linux is problem because there is bug in IBM driver (probably)

Thanks

[Steve Gutter]

The operating system is z/OS (the new name for IBM’s MVS).
No big rush: I have a work around for now, but it would be nice if type 2 worked as in ME 3.8.

[Steve Gutter]

The operating system is z/OS (the new name for IBM’s MVS).
No big rush: I have a work around for now, but it would be nice if type 2 worked as in ME 3.8.

[Haris Peco]

etienneg

it is fixed . I can verify Windows and Linux, only
If it worked before, then i hope that it will work in 4.1.1 , too

Best

[Steve Gutter]

OK. I’ll use the way I’ve got it for now, then try it the old way (type 2 driver) in 4.1.1.
Thanks for sticking with the problem! MUCH appreciated!

[Author]

Posts