FYI: The problem was that a small bug in JdbcRecordReader where a while loop for some reason is not checking if the resultSet is still open.
Once I corrected it on my version I have no issues accessing the tables in DB2. I will check if there’s a jira, if not open one and provide the fix for consideration. Regards, Magnus > 30 mar 2016 kl. 13:30 skrev Magnus Pierre <mpie...@maprtech.com>: > > > Hello, > > I am trying to use the JDBC plugin with DB2 and have some issues: > I am connected to a particular database using the DB in the JDBC url. > Thing look good: > I can see metadata and I can interrogate tables: > > jdbc:drill:zk=local> show schemas; > +-----------------------+ > | SCHEMA_NAME | > +-----------------------+ > | INFORMATION_SCHEMA | > | cp.default | > | dfs.default | > | dfs.root | > | dfs.tmp | > | gs_db.GOSALES | > | gs_db.GOSALESDW | > | gs_db.GOSALESHR | > | gs_db.GOSALESMR | > | gs_db.GOSALESRT | > | gs_db.MPIERRE | > | gs_db.NULLID | > | gs_db.SQLJ | > | gs_db.SYSCAT | > | gs_db.SYSFUN | > | gs_db.SYSIBM | > | gs_db.SYSIBMADM | > | gs_db.SYSIBMINTERNAL | > | gs_db.SYSIBMTS | > | gs_db.SYSPROC | > | gs_db.SYSPUBLIC | > | gs_db.SYSSTAT | > | gs_db.SYSTOOLS | > | gs_db | > | sys | > +-----------------------+ > 25 rows selected (0,226 seconds) > 0: jdbc:drill:zk=local> show tables in gs_db.GOSALES; > +----------------+-----------------------+ > | TABLE_SCHEMA | TABLE_NAME | > +----------------+-----------------------+ > | gs_db.GOSALES | BRANCH | > | gs_db.GOSALES | CONVERSION_RATE | > | gs_db.GOSALES | COUNTRY | > | gs_db.GOSALES | CURRENCY_LOOKUP | > | gs_db.GOSALES | EURO_CONVERSION | > | gs_db.GOSALES | INVENTORY_LEVELS | > | gs_db.GOSALES | ORDER_DETAILS | > | gs_db.GOSALES | ORDER_HEADER | > | gs_db.GOSALES | ORDER_METHOD | > | gs_db.GOSALES | PRODUCT | > | gs_db.GOSALES | PRODUCT_BRAND | > | gs_db.GOSALES | PRODUCT_COLOR_LOOKUP | > | gs_db.GOSALES | PRODUCT_FORECAST | > | gs_db.GOSALES | PRODUCT_LINE | > | gs_db.GOSALES | PRODUCT_NAME_LOOKUP | > | gs_db.GOSALES | PRODUCT_SIZE_LOOKUP | > | gs_db.GOSALES | PRODUCT_TYPE | > | gs_db.GOSALES | RETURNED_ITEM | > | gs_db.GOSALES | RETURN_REASON | > | gs_db.GOSALES | SALES_REGION | > | gs_db.GOSALES | SALES_TARGET | > | gs_db.GOSALES | TIME_DIMENSION | > | gs_db.GOSALES | TIME_QUARTER_LOOKUP | > | gs_db.GOSALES | XGOREV | > +----------------+-----------------------+ > 24 rows selected (0,232 seconds) > 0: jdbc:drill:zk=local> describe gs_db.GOSALES.BRANCH; > +------------------------+--------------------+--------------+ > | COLUMN_NAME | DATA_TYPE | IS_NULLABLE | > +------------------------+--------------------+--------------+ > | BRANCH_CODE | INTEGER | NO | > | ADDRESS1 | CHARACTER VARYING | NO | > | ADDRESS1_MB | CHARACTER VARYING | YES | > | ADDRESS2 | CHARACTER VARYING | YES | > | ADDRESS2_MB | CHARACTER VARYING | YES | > | CITY | CHARACTER VARYING | NO | > | CITY_MB | CHARACTER VARYING | NO | > | PROV_STATE | CHARACTER VARYING | YES | > | PROV_STATE_MB | CHARACTER VARYING | YES | > | POSTAL_ZONE | CHARACTER VARYING | NO | > | COUNTRY_CODE | INTEGER | NO | > | ORGANIZATION_CODE | CHARACTER VARYING | NO | > | WAREHOUSE_BRANCH_CODE | INTEGER | NO | > +------------------------+--------------------+--------------+ > 13 rows selected (0,216 seconds) > > > However, when accessing a table I get: > --------------------------------------- > 0: jdbc:drill:zk=local> select * from gs_db.GOSALES.BRANCH; > Error: DATA_READ ERROR: Failure while attempting to read from database. > > sql SELECT * > FROM "GOSALES"."BRANCH" > plugin gs_db > Fragment 0:0 > > [Error Id: bbd65e6c-6a85-460b-8d70-80c1333ed23b on mpie-mbp.lan:31010] > (state=,code=0) > 0: jdbc:drill:zk=local> select * from gs_db.GOSALES.COUNTRY; > Error: DATA_READ ERROR: Failure while attempting to read from database. > > sql SELECT * > FROM "GOSALES"."COUNTRY" > plugin gs_db > Fragment 0:0 > > [Error Id: 871474a1-ddf8-474b-b1c5-3231980bda62 on mpie-mbp.lan:31010] > (state=,code=0) > > > ——————————————————— > > Anyone seen this? > > (I am using an own build so I could try the official drop) > > Regards, > Magnus >
