Recent changes to 1534: DB2/Object Tree Issue

#1534 DB2/Object Tree Issue

2025-08-20T18:51:15.631000Z

Your welcome, Paul.

Concerning how I got around the problem:
There are three rather common table types namely TABLE, VIEW and SYSTEM TABLE. If the database itself doesn't provide any table types I now proceed as if the database provided these types.

Concerning the 5.0.0 release:
I'll wait at least till Java 25 is released. If no bugs or feature request occur which I think should make it into the release it shouldn't be long after the Java release.

#1534 DB2/Object Tree Issue

2025-08-19T18:46:13.949000Z

Hey Gerd, I did end up working with the one that actually installs DB2 software on our mainframe system, David. Turns out they had tried to get around this issue over 4 years ago with no success. At the time, I don't think they was able to get any support from Squirrel support although I don't know how they tried to reach out. So thank you again for responding to me when I started this ticket.

David actually compared our working DB2 installations (DB2 & WDB2) to the not working version TDB2. He couldn't find any differences in setup/config or anything. The ONLY thing that is a big difference is the size of the schema list and tables in TDB2 vs DB2 or WDB2. Our test system has much more than production or the warehouse (as we call them). Maybe that's why it returns no results? It blows it out of the water somehow?

Which, btw, we were curious, how did you work around this problem in the code fix you made in the snapshot you gave me and what you plan to add to version 5.0.0?
At this point, our solution looks like it is going to have to be wait for what you all call a stable version of 5.x with this fix and then promote that as the version for all of our developers to load and use.

#1534 DB2/Object Tree Issue

2025-08-18T18:46:42.556000Z

Thanks Gerd! I did load the latest snapshot and confirmed that it is working as the prior iterations have been. Also, I reached out to our DBA sharing the test java app and asked if he can explain why the test database has the issue but other DB2 dbs do not, just like Squirrel exhibited.
If the DBAs come back with a response, I will let you know.
But, thank you for finding a workaround that populates the object tree regardless of this config issue/bug. Assuming we never get the test database modified to work on any version of Squirrel, I plan to let it be known the 5.0.0. upcoming release is going to have a fix for this in it that we can target to have available for all users to load on their systems. Thanks again for all your help on this!

#1534 DB2/Object Tree Issue

2025-08-15T20:37:13.050000Z

After our tests this result is what I expected.
The reason why SQuirreL did not show tables for the database with the issues, was that no results were returned by the test program.

If you'd be interested you could contact DB admins and ask them why no results are returned by the test program.

I just released a new snapshot with the changes I made for you. It is available here
https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20250815_2152/
or here
https://github.com/squirrel-sql-client/squirrel-sql-snapshot-releases/releases/tag/snapshot-20250815_2152

The changes will be included in the upcoming 5.0.0 release.

Gerd

#1534 DB2/Object Tree Issue

2025-08-15T20:26:59.889000Z

Thanks for the information, Paul. I just committed the changes you tried out.

Your information bear no surprises considering the tests we did.

#1534 DB2/Object Tree Issue

2025-08-14T15:40:45.238000Z

Hey again Gerd,
I got someone to run the java pointed to the database with the issues we have been working on and they said that no results were returned.

Just to be sure they were doing it right, they did point it against one of our DB2 databases that does work, that we can "DB2" and they got the following results:
tableTypeName = ALIAS
tableTypeName = AUXILIARY TABLE
tableTypeName = GLOBAL TEMPORARY TABLE
tableTypeName = MATERIALIZED QUERY TABLE
tableTypeName = SYNONYM
tableTypeName = SYSTEM TABLE
tableTypeName = TABLE
tableTypeName = VIEW

Hope this helps and just let me know when you have something else to test and I'll run it and give you more results.
Thanks!
Paul

#1534 DB2/Object Tree Issue

2025-08-13T21:07:45.266000Z

Hey Gerd,
I just recalled I never actually came back and did your last test you requested as I thought I had, so sorry about that! So, per your last request
1) I uploaded the newest copy of the app you gave me and it worked just like it did before. I can provide a log file again if you want it.
2) I clicked on several tables and on the "Info" tab, under property name "Type", the "Value" is "TABLE" for every one that I clicked.
3) I'm not a java developer and I just asked some folks this afternoon around my team and on some other teams for help. So, I know what we need to populate in the variables you left in your snippet, but I need someone with a java IDE to include the db2 driver in their classpath and compile it for me. I will provide another update as soon as I can get this completed. but I wanted to at least give you an update and let you know I am working on your last request.
Thanks!
Paul

#1534 DB2/Object Tree Issue

2025-08-05T20:13:05.084000Z

Good to hear, Paul, that already the first guess was a hit. May I ask for the following three things:

I just uploaded another version to the same place as before with a proper implementation of the changes and less logging. Could you try if it still works?
Click on any of the now loaded tables in the Object tree then check the tab named "Info" on the right an let me know if it displays a Property name "type". If so please tell me its "Value".
In case you or one of your colleagues knows some Java please adjust the attached small Java program to your databases data. Then compile and run it and let me know its output.

Thanks Gerd

#1534 DB2/Object Tree Issue

2025-08-04T16:08:00.762000Z

Hey Gerd!
I have good news! I have clicked the object trees on every test, but this time, as you anticipated, I DO see the tables AND if I click on a table, I see the column details and other details on the tabs on the right! I didn't notice any unexpected behavior with my small amount of testing. But, this is great progress! What do you think the next step should be? Do you have more changes for me to test? Eventually, I will want to recommend a stable version with the fix to this issue to our IT support to include for user downloads. So I will look to your advice on which one to specify.
Thanks so much for your continued efforts in resolving this issue!
Paul

#1534 DB2/Object Tree Issue

2025-08-02T20:52:38.103000Z

No problem, Paul, I'm just uploading another version.

It might be that something unexpected happens when table types are loaded from your database. If you should at least see the Object tree's top node please click it and then look at the "Table Types" tab on the right. My guess for now is that it is empty.

FYI: I added one functional change in this version which might even make tables appear. It could also cause some unexpected behavior.