Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 198
  • Last Modified:

JBuilder gurus: Configuration problem with DB2 on MVS and Jbuilder 8

I am having a problem configuring the JBuilder IDE EJB Designer tool to recognize the tables in a DB2 database hosted on MVS.  We have had no problems getting the DatabasePilot tool to work correctly, and we are using exactly the same configuration.

The symptoms are as follows:
1. Connection is established correctly
2. Download of table names proceeds in same time as DatabasePilot
3. Of 3200 +/- tables, only one is displayed.  It is a temp table with a creator = my user ID.
4. No exceptions are displayed, and there are no issues noted when we run in verbose mode.

Database pilot tool shows all 3200 +/- tables correctly with identical configuration.

Any ideas?  What are we missing?
1 Solution
swift99Author Commented:
We have tried this with many user ID's, and the IDE only recognizes those tables created by the user running the IDE.  

We figured out a workaround, but it's a real pain and seems to destabilize the IDE (maybe exposing a bug?).

Any one have some real solutions?
Hm. the EJB Designer might check if the user connecting has appropriate rights to perform whatever operation the EJB Designer might want to on the tables.
Have you tried this with super-user privileges on DB2?
swift99Author Commented:
That was our first thought.  We all have the necessary priveleges on the development database.

If we did not have the necessary priveleges then our workaround would not work.

It looks like the Borland engineers tried to filter the tables down and just went one step too far, filtering by owner in their query.  When you have a couple of hundred developers you can't depend on the "owner" for anything but the initial creation.

Also, they never figured on a database schema as large as ours.  Their designer tool has problems when there are that many tables.  We don't have a commitment yet, but we are talking to Borland about some minor changes around the EJB Entity Bean designer to support our scale of system.

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

good luck then.
swift99Author Commented:
Thanks ... we'll need it!   :o)
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
Post your closing recommendations!  No comment means you don't care.
swift99Author Commented:
We resolved our problem here,  so I guess I'll want this PAQ'ed.

The problem is that IBM's paths start with COM.*.*(upper case), and everything else in the world is com.*.* (lowercase).   The mix of case insensitive OS and case sensitive Java was confusing things.  We got this working by manipulating the paths.

Thanks, and sorry for leaving this hanging so long.

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

Question PAQed and Points refunded

Please leave any comments here within the next seven days.


EE Cleanup Volunteer

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now