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?
LVL 6
swift99Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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?
0
NetWizeCommented:
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?
0
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.

0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

NetWizeCommented:
good luck then.
0
swift99Author Commented:
Thanks ... we'll need it!   :o)
0
CleanupPingCommented:
swift99:
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 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0
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.


0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
TimYatesCommented:
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.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

TimYates
EE Cleanup Volunteer
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Java EE

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.