?
Solved

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

Posted on 2003-02-27
9
Medium Priority
?
181 Views
Last Modified: 2013-11-24
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?
0
Comment
Question by:swift99
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
9 Comments
 
LVL 6

Author Comment

by:swift99
ID: 8036461
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
 
LVL 3

Expert Comment

by:NetWize
ID: 8040101
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
 
LVL 6

Author Comment

by:swift99
ID: 8041697
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
Command Line Tips and Tricks

The command line is a powerful tool at the disposal of every Linux user. Although Linux distros come with beautiful user interfaces, it's worthwhile to learn the command line because it allows you to do a number of things that you otherwise cannot do from the GUI.  

 
LVL 3

Expert Comment

by:NetWize
ID: 8041723
good luck then.
0
 
LVL 6

Author Comment

by:swift99
ID: 8042089
Thanks ... we'll need it!   :o)
0
 

Expert Comment

by:CleanupPing
ID: 9059030
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
 
LVL 6

Accepted Solution

by:
swift99 earned 0 total points
ID: 9069552
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
 
LVL 35

Expert Comment

by:TimYates
ID: 9671553
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

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Java contains several comparison operators (e.g., <, <=, >, >=, ==, !=) that allow you to compare primitive values. However, these operators cannot be used to compare the contents of objects. Interface Comparable is used to allow objects of a cl…
Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses
Course of the Month14 days, 9 hours left to enroll

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question