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 Error occured while trying to connect to the database Error connecting to database: (using class com.ibm.db2.jcc.DB2Driver) The DDM parameter is not supported. Unsupported DDM parameter code point: 0x111a

Pentaho BI Platform Tracking | Rutger Deterd Oude Weme | 8 years ago
  1. 0

    In PDI 3.0.4 build 53 this works: <connection> <name>source</name> <server>127.0.0.16</server> <type>DB2</type> <access>Native</access> <database>NLGEMHDB</database> <port>446</port> <username>user</username> <password>xxxxxxxx</password> <servername/> <data_tablespace/> <index_tablespace/> <attributes> <attribute><code>EXTRA_OPTION_MYSQL.defaultFetchSize</code><attribute>500</attribute></attribute> <attribute><code>EXTRA_OPTION_MYSQL.useCursorFetch</code><attribute>true</attribute></attribute> <attribute><code>IS_CLUSTERED</code><attribute>N</attribute></attribute> <attribute><code>MAXIMUM_POOL_SIZE</code><attribute>10</attribute></attribute> <attribute><code>PORT_NUMBER</code><attribute>446</attribute></attribute> <attribute><code>STREAM_RESULTS</code><attribute>Y</attribute></attribute> <attribute><code>USE_POOLING</code><attribute>N</attribute></attribute> </attributes> </connection> in PDI 3.1.0-RC1 build 811 this connection doesn't work. I get the following message: 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 Error occured while trying to connect to the database Error connecting to database: (using class com.ibm.db2.jcc.DB2Driver) The DDM parameter is not supported. Unsupported DDM parameter code point: 0x111a 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 Error occured while trying to connect to the database Error connecting to database: (using class com.ibm.db2.jcc.DB2Driver) The DDM parameter is not supported. Unsupported DDM parameter code point: 0x111a at org.pentaho.di.core.database.DatabaseMetaInformation.getData(DatabaseMetaInformation.java:320) at org.pentaho.di.ui.core.database.dialog.GetDatabaseInfoProgressDialog$1.run(GetDatabaseInfoProgressDialog.java:64) ... 1 more Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Error connecting to database: (using class com.ibm.db2.jcc.DB2Driver) The DDM parameter is not supported. Unsupported DDM parameter code point: 0x111a at org.pentaho.di.core.database.Database.normalConnect(Database.java:318) at org.pentaho.di.core.database.Database.connect(Database.java:267) at org.pentaho.di.core.database.Database.connect(Database.java:229) at org.pentaho.di.core.database.Database.connect(Database.java:219) at org.pentaho.di.core.database.DatabaseMetaInformation.getData(DatabaseMetaInformation.java:168) ... 2 more Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Error connecting to database: (using class com.ibm.db2.jcc.DB2Driver) The DDM parameter is not supported. Unsupported DDM parameter code point: 0x111a at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:435) at org.pentaho.di.core.database.Database.normalConnect(Database.java:302) ... 6 more Caused by: com.ibm.db2.jcc.b.DisconnectException: The DDM parameter is not supported. Unsupported DDM parameter code point: 0x111a at com.ibm.db2.jcc.a.bb.C(bb.java:4549) at com.ibm.db2.jcc.a.bb.Y(bb.java:1928) at com.ibm.db2.jcc.a.bb.z(bb.java:599) at com.ibm.db2.jcc.a.bb.n(bb.java:497) at com.ibm.db2.jcc.a.bb.a(bb.java:306) at com.ibm.db2.jcc.a.bb.a(bb.java:111) at com.ibm.db2.jcc.a.b.e(b.java:1233) at com.ibm.db2.jcc.a.b.b(b.java:1147) at com.ibm.db2.jcc.a.b.q(b.java:931) at com.ibm.db2.jcc.a.b.a(b.java:702) at com.ibm.db2.jcc.a.b.<init>(b.java:305) at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:162) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:416) ... 7 more But, this is only the case when I 'test' or 'explore' this connection in the database connection dialogbox. I can use the connection in my transformation

    Pentaho BI Platform Tracking | 8 years ago | Rutger Deterd Oude Weme
    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 Error occured while trying to connect to the database Error connecting to database: (using class com.ibm.db2.jcc.DB2Driver) The DDM parameter is not supported. Unsupported DDM parameter code point: 0x111a
  2. 0

    In PDI 3.0.4 build 53 this works: <connection> <name>source</name> <server>127.0.0.16</server> <type>DB2</type> <access>Native</access> <database>NLGEMHDB</database> <port>446</port> <username>user</username> <password>xxxxxxxx</password> <servername/> <data_tablespace/> <index_tablespace/> <attributes> <attribute><code>EXTRA_OPTION_MYSQL.defaultFetchSize</code><attribute>500</attribute></attribute> <attribute><code>EXTRA_OPTION_MYSQL.useCursorFetch</code><attribute>true</attribute></attribute> <attribute><code>IS_CLUSTERED</code><attribute>N</attribute></attribute> <attribute><code>MAXIMUM_POOL_SIZE</code><attribute>10</attribute></attribute> <attribute><code>PORT_NUMBER</code><attribute>446</attribute></attribute> <attribute><code>STREAM_RESULTS</code><attribute>Y</attribute></attribute> <attribute><code>USE_POOLING</code><attribute>N</attribute></attribute> </attributes> </connection> in PDI 3.1.0-RC1 build 811 this connection doesn't work. I get the following message: 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 Error occured while trying to connect to the database Error connecting to database: (using class com.ibm.db2.jcc.DB2Driver) The DDM parameter is not supported. Unsupported DDM parameter code point: 0x111a 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 Error occured while trying to connect to the database Error connecting to database: (using class com.ibm.db2.jcc.DB2Driver) The DDM parameter is not supported. Unsupported DDM parameter code point: 0x111a at org.pentaho.di.core.database.DatabaseMetaInformation.getData(DatabaseMetaInformation.java:320) at org.pentaho.di.ui.core.database.dialog.GetDatabaseInfoProgressDialog$1.run(GetDatabaseInfoProgressDialog.java:64) ... 1 more Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Error connecting to database: (using class com.ibm.db2.jcc.DB2Driver) The DDM parameter is not supported. Unsupported DDM parameter code point: 0x111a at org.pentaho.di.core.database.Database.normalConnect(Database.java:318) at org.pentaho.di.core.database.Database.connect(Database.java:267) at org.pentaho.di.core.database.Database.connect(Database.java:229) at org.pentaho.di.core.database.Database.connect(Database.java:219) at org.pentaho.di.core.database.DatabaseMetaInformation.getData(DatabaseMetaInformation.java:168) ... 2 more Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Error connecting to database: (using class com.ibm.db2.jcc.DB2Driver) The DDM parameter is not supported. Unsupported DDM parameter code point: 0x111a at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:435) at org.pentaho.di.core.database.Database.normalConnect(Database.java:302) ... 6 more Caused by: com.ibm.db2.jcc.b.DisconnectException: The DDM parameter is not supported. Unsupported DDM parameter code point: 0x111a at com.ibm.db2.jcc.a.bb.C(bb.java:4549) at com.ibm.db2.jcc.a.bb.Y(bb.java:1928) at com.ibm.db2.jcc.a.bb.z(bb.java:599) at com.ibm.db2.jcc.a.bb.n(bb.java:497) at com.ibm.db2.jcc.a.bb.a(bb.java:306) at com.ibm.db2.jcc.a.bb.a(bb.java:111) at com.ibm.db2.jcc.a.b.e(b.java:1233) at com.ibm.db2.jcc.a.b.b(b.java:1147) at com.ibm.db2.jcc.a.b.q(b.java:931) at com.ibm.db2.jcc.a.b.a(b.java:702) at com.ibm.db2.jcc.a.b.<init>(b.java:305) at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:162) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:416) ... 7 more But, this is only the case when I 'test' or 'explore' this connection in the database connection dialogbox. I can use the connection in my transformation

    Pentaho BI Platform Tracking | 8 years ago | Rutger Deterd Oude Weme
    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 Error occured while trying to connect to the database Error connecting to database: (using class com.ibm.db2.jcc.DB2Driver) The DDM parameter is not supported. Unsupported DDM parameter code point: 0x111a
  3. 0

    [JAVA/SQL] Problema connessione con DB2 sia con jdbc che con squirrelSQL!!! help [Archivio] - Hardware Upgrade Forum

    hwupgrade.it | 6 months ago
    com.ibm.db2.jcc.b.DisconnectException: A communication error has been detected. Communication protocol being used: Reply.fill(). Communication API being used: InputStream.read(). Location where the error was detected: insufficient data. Communication function detecting the error: *. Protocol specific error codes(s) TCP/IP SOCKETS
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    HELP! Error trying to connect to DB2.

    narkive.com | 6 months ago
    com.ibm.db2.jcc.b.DisconnectException: A communication error has been detected. Communication protocol being used: Reply.fill(). Communication API being used: InputStream.read(). Location where the error was detected: Connection reset. Communication function detecting the error: *. Protocol specific error codes(s) TCP/IP SOCKETS
  6. 0

    Db2 8.1 on AIX 5 and JDBC connection problem

    theserverside.com | 6 months ago
    com.ibm.db2.jcc.b.DisconnectException: A communication error has been detected. Communication protocol being used: Reply.fill(). Communication API being used: I nputStream.read(). Location where the error was detected: insufficient data. Com munication function detecting the error: *. Protocol specific error codes(s) TCP /IP SOCKETS

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. com.ibm.db2.jcc.b.DisconnectException

      The DDM parameter is not supported. Unsupported DDM parameter code point: 0x111a

      at com.ibm.db2.jcc.a.bb.C()
    2. IBM DB2
      b.<init>
      1. com.ibm.db2.jcc.a.bb.C(bb.java:4549)
      2. com.ibm.db2.jcc.a.bb.Y(bb.java:1928)
      3. com.ibm.db2.jcc.a.bb.z(bb.java:599)
      4. com.ibm.db2.jcc.a.bb.n(bb.java:497)
      5. com.ibm.db2.jcc.a.bb.a(bb.java:306)
      6. com.ibm.db2.jcc.a.bb.a(bb.java:111)
      7. com.ibm.db2.jcc.a.b.e(b.java:1233)
      8. com.ibm.db2.jcc.a.b.b(b.java:1147)
      9. com.ibm.db2.jcc.a.b.q(b.java:931)
      10. com.ibm.db2.jcc.a.b.a(b.java:702)
      11. com.ibm.db2.jcc.a.b.<init>(b.java:305)
      11 frames
    3. com.ibm.db2
      DB2Driver.connect
      1. com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:162)
      1 frame
    4. Java RT
      DriverManager.getConnection
      1. java.sql.DriverManager.getConnection(Unknown Source)
      2. java.sql.DriverManager.getConnection(Unknown Source)
      2 frames
    5. org.pentaho.di
      GetDatabaseInfoProgressDialog$1.run
      1. org.pentaho.di.core.database.Database.connectUsingClass(Database.java:416)
      2. org.pentaho.di.core.database.Database.normalConnect(Database.java:302)
      3. org.pentaho.di.core.database.Database.connect(Database.java:267)
      4. org.pentaho.di.core.database.Database.connect(Database.java:229)
      5. org.pentaho.di.core.database.Database.connect(Database.java:219)
      6. org.pentaho.di.core.database.DatabaseMetaInformation.getData(DatabaseMetaInformation.java:168)
      7. org.pentaho.di.ui.core.database.dialog.GetDatabaseInfoProgressDialog$1.run(GetDatabaseInfoProgressDialog.java:64)
      7 frames
    6. JFace
      ModalContext$ModalContextThread.run
      1. org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)
      1 frame