| 
| Query -> Available Items; DB2 JDBC [message #337457] | Wed, 23 January 2008 15:50 |  | 
| Eclipse User  |  |  |  |  | Originally posted by: kenneth.thornbrough.fnis.com 
 The only item being displayed in the "Available Items" list on the Query
 window is the single DB2 JDBC data source entry I have defined.  The
 schemas and table names for the DB2 connection are not being listed.  When
 I test the connection it works fine and I have developed several dataset
 definitions by manually writing the SQL which are working fine also.
 
 I have releases 2.1.3 and 2.2.1.1 loaded and have the same problem with
 both.  While the preference options are slightly different between the
 releases, I am using the defaults which have prefetch selected, 20
 schema's, and 100 tables.  For this particular DB2 connection, I should
 get probably 15 schema's with around 75 tables each max.
 
 I have searched the bug repository and didn't get any hits similar to this
 or they were older than these releases and were listed as closed/fixed.
 
 Any thoughts before I log a bug?
 Thanks.
 |  |  |  | 
Powered by 
FUDForum. Page generated in 0.03859 seconds