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

[Bill.Blalock@xxxxxxxx (Bill Blalock)]

I seem to be having a similar problem with DB2 for iSeries.  The symptoms 
match what Karl Stenerud described.

DB2 (any flavor) is no longer listed in "Connect Profile Types" list so I 
used "Generic JDBC" and specified the JTOpen as400.jar file.

In the Data Source Explorer I can drill down through the system to the 
schema I want.  Everything works there.

Generate Entity from Table won't work because the schema's aren't listed.  
If I could I'd override with the specific schema that I want but that 
won't work either.

I looked over bug ID 259534.  The problem could be is that i5 schemas 
reported are the i5 "library names."  An i5 "library name" allows the 
characters @, #, $ as well as underscore.  These non-standard characters 
are shown in in the "data soure explorer" list of schemas.

I'd appreciate any suggestion to work around this.  

So far I haven't come up with a any properties to specify to JDBC to limit 
the schema which generate entities see.  The "default schema filter" works 
fine for the data source explorer but doesn't help the problem with 
"generate entities".

Thanks all

Neil Hauge wrote:

> Karl,

> Are you using PostgreSQL?  If so, I think you may have run into bug 259534 
> - https://bugs.eclipse.org/bugs/show_bug.cgi?id=259534.

> We have a fix for this coming out soon in 2.1 maintenance.  There isn't a 
> good workaround for this issue, so rolling back to Dali 2.0.3 and waiting 
> for 2.1.1 might be your best option.

> Neil



> Karl Stenerud wrote:

> > I've just installed Dali 2.1 in eclipse 3.4.1 and I can't get the 
> > "Generate entities from tables" function to work.

> > I have a database defined (I can see it in the Data Source Explorer, and I 
> > can browse through the catalogs, schemas, tables etc) but when I try to 
> > run the entity generator tool, it brings up a database connection dialog.

> > When I select my connection, it won't let me select a schema (it tells me 
> > I must have an active connection to select a schema, but the connection 
> > button is greyed out).
> > If I go back to the data source explorer and disconnect from the database, 
> > the "connect" button will be selectable, but when I connect, I still can't 
> > select a schema.

> > Dali is obviously able to see the schema because I can browse to it from 
> > the data source explorer, so why can't the entity generator tool see it?