[news.eclipse.technology.dali] Re: Generate Entities from Tables not wor

[Bill.Blalock@xxxxxxxx (Bill Blalock)]

Neil:

> Main tab -> Program to Run: |X| Run a product: org.eclipse.platform.ide

> Arguments tab -> VM Arguments:  -Xmx1024M -XX:MaxPermSize=128m

That worked! I had
  org.eclipse.sdk.ide
as the product to run.  Thanks!

I have it all loaded up and am able to run it in debug.

Now I need sugestions as to which plug-ins projects I should import as 
binary projects and classes I should watch in the debug view.  I'd 
appreciate any other advice or suggestions.

So far this is what I have learned:

For DB2 i5/OS the catalog must be specified in Preferences > Java 
Persistence.  The default catalog for the JTOpen driver is *SYSBASE.  The 
correct catalog is in the drop down box but it has to be selected.

If the catalog is specified in Preferences > Java Persistence  
- JPA Tools > Generate Entities from Tables 
-   will default to the default schema and list the tables
-   will list all the schemas (in the Schema drop down) but none will show 
tables (except default)

The default schema can't be overriden in Preferences > Java Persistence.  
If you try to do so only the default schema is listed in the schema drop 
down, none of the other schemas are listed.

The default schema is the schema which corresponds to the user who makes 
the connection.  

For example if I signon as BLALOCK and the BLALOCK library (think schema) 
is the default schema and the Build Entities will shows the tables in 
BLALOCK.  The other schemas come up in the drop down but none of them list 
tables.  The default schema can't be changed from BLALOCK.

If I connect as "e012676" there will be no default schema because there is 
no library names E012676.

The default schema is controlled by using the "libraries" property of the 
IBM JTOpen driver.

Specifying the "libraries" property in either the URL or the additional 
properties (by choosing an "other driver" in the driver selection of DB2 
for i5/OS) has no effect.  I am very familiar with the use of this 
property from other projects.

If no libraries property is specified the user becomes the default schema. 
This behavior is documented at:

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/rzahh/jdbcproperties.htm

That being said JPA Tools > Generate Entities will generate entities for 
tables in BLALOCK when the connection uses BLALOCK as the user.  That is 
progress.

What classes should I watch in the debugger to find the cause of this 
behavior?

Where whould I look to see what meta data is being passed to Dali? 

Thanks
Bill Blalock