problem connecting to DB2 on z/OS

[msaint]

I get the following message when i try to connect to DB2 on z/OS

Unable to retrieve database information because of an error encoding not supported

thanks in advance

mahmut

[MattCasters]

It's probably a sign to downgrade your DB2 JDBC driver. It's best to make it match the version of your DB2 database.
When in doubt, see what IBM has to say about it.

All the best,

Matt

[msaint]

thanks for your reply.

i do connect with the same drivers from within my java applications without any problem.

[MattCasters]

So, what is the error message that you get?

[msaint]

actually test connection is ok. but when i try to explore the database i get error.

here is the trace

java.lang.reflect.InvocationTargetException: Problem encountered getting information from the database: org.pentaho.di.core.exception.KettleDatabaseException:
Unable to retrieve database information because of an error
encoding not supported!!

at org.pentaho.di.ui.core.database.dialog.GetDatabaseInfoProgressDialog$1.run(GetDatabaseInfoProgressDialog.java:67)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)
Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
Unable to retrieve database information because of an error
encoding not supported!!

at org.pentaho.di.core.database.DatabaseMetaInformation.getData(DatabaseMetaInformation.java:281)
at org.pentaho.di.ui.core.database.dialog.GetDatabaseInfoProgressDialog$1.run(GetDatabaseInfoProgressDialog.java:63)
... 1 more
Caused by: com.ibm.db2.jcc.b.DisconnectException: encoding not supported!!
at com.ibm.db2.jcc.a.ab.a(ab.java:748)
at com.ibm.db2.jcc.a.db.Yc(db.java:3127)
at com.ibm.db2.jcc.a.db.b(db.java:3056)
at com.ibm.db2.jcc.a.db.a(db.java:2682)
at com.ibm.db2.jcc.a.db.b(db.java:2609)
at com.ibm.db2.jcc.a.db.a(db.java:2476)
at com.ibm.db2.jcc.a.db.m(db.java:447)
at com.ibm.db2.jcc.a.db.l(db.java:345)
at com.ibm.db2.jcc.a.db.e(db.java:102)
at com.ibm.db2.jcc.a.r.e(r.java:72)
at com.ibm.db2.jcc.a.sb.i(sb.java:194)
at com.ibm.db2.jcc.b.zc.q(zc.java:1319)
at com.ibm.db2.jcc.b.ad.d(ad.java:2281)
at com.ibm.db2.jcc.b.bd.U(bd.java:188)
at com.ibm.db2.jcc.b.s.a(s.java:7833)
at com.ibm.db2.jcc.b.s.Wd(s.java:6428)
at com.ibm.db2.jcc.b.s.getSchemas(s.java:6355)
at org.pentaho.di.core.database.DatabaseMetaInformation.getData(DatabaseMetaInformation.java:216)
... 2 more

[MattCasters]

http://bugs.sun.com/bugdatabase/view...bug_id=6207885

[msaint]

sorry for delay; i didn't have time.

As the workaround say i reinstalled the jre with the other locales. this time problem turned out to be:

"Unable to retrieve database information because of an error
Invalid operation: result set closed"

i've searched for this and http://jira.pentaho.org/browse/PDI-612 bug seems similar. this bug said to be fixed. i've tried 3.1.0 M1 but nothing changed for me.

it's a bit late but i use
windows 2000
IBM DB2 V7.1 for ZOS
Suın JDK 1.5.0.14

thanks again

mahmut

full stacktrace:

java.lang.reflect.InvocationTargetException: Problem encountered getting information from the database: org.pentaho.di.core.exception.KettleDatabaseException:
Unable to retrieve database information because of an error
Invalid operation: result set closed

at org.pentaho.di.ui.core.database.dialog.GetDatabaseInfoProgressDialog$1.run(GetDatabaseInfoProgressDialog.java:68)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)
Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
Unable to retrieve database information because of an error
Invalid operation: result set closed

at org.pentaho.di.core.database.DatabaseMetaInformation.getData(DatabaseMetaInformation.java:281)
at org.pentaho.di.ui.core.database.dialog.GetDatabaseInfoProgressDialog$1.run(GetDatabaseInfoProgressDialog.java:64)
... 1 more
Caused by: com.ibm.db2.jcc.a.SqlException: Invalid operation: result set closed
at com.ibm.db2.jcc.a.lf.lb(lf.java:3503)
at com.ibm.db2.jcc.a.lf.c(lf.java:299)
at com.ibm.db2.jcc.a.lf.next(lf.java:285)
at org.pentaho.di.core.database.DatabaseMetaInformation.getData(DatabaseMetaInformation.java:217)
... 2 more