Newbie - Problem Generating Entities from Existing Empty DB.

[rmbittmann]

Hi Again,

I am using: Eclipse 3.5.1, JBoss Tools 3.1.0.CR1, TestNG 5.11.0.28, jdk1.6.0_17, JBoss AS 5.1.0GA-jdk6, Seam 2.2.0.GA, JBoss 4.2.2GA & MySQL 5.1.37.

I added a schema to my MySQL DB with some tables. There are no values in the tables.

I created a Seam Web Project, with a with a Database connection to the schema, tested it and the connection works fine.

I tested the project with the home page and again everything is fine.

Going to the Database perspective I can browse the schema and its tables and fields, so far so good.

Now I am trying to generate an entity:

I right click on the project name -> New -> Generates Seam Entities with the default Seam Project and Hibernate Console Configuration and the Reverse engineer from database checked.

Click Next to the select table page. Press the Refresh button and get the configured Schema from above with a + on the left indicating it can be expanded so I can select the table I choose for entity generation.

Trying to expand it (clicking on the small + on the left) nothing happens! There are no tables available in the Schema.

I will appreciate your help in telling me what I am doing wrong or where to look for a solution.

Thanks,

Rani.

[maxandersen]

What is your default_schema and default_catalog set to ?

[rmbittmann]

Hi Max,

First thanks for finding the time to help. I really appreciate your commitment and helping me and as I see many others in multiple occasions!

Since I not proficient with JBoss Tools yet, and to be sure I answer your question correctly, where may I find these parameters now that the project is created?

Thanks,

Rani.

[rmbittmann]

Hi,

Ok I made my digging and found the default_schema in the <project>/src/main/META-INF/persistence.xml file. Couldn't find a default_catalog and I believe I did not configure one for the MySQL DB. The value for the default_schema is correct and refers to the schema I try to access.

Another peculiar thing is that when I try to create a new Hibernate->reveng.xml file I am reaching the same Configure table filters dialog, but this time it finds the schema and its tables.

Again I will appreciate your help,

Rani.

[maxandersen]

what value is the default_schema ?

Have you tried the latest nightly build to see if the issue is there too ?

[rmbittmann]

Hi,

Thanks again.

The value of the default_schema is the schema name, mom1.

I tried to update Eclipse with the latest nightly JBoss Tools release but it failed, hanging with the message: Could not complete request, generating details.

I made another experiment and added manualy a default_catalog giving it the value *.

As in the previous cases it did not expand the schema, but it did generate entities for all the tables, which is not what I wanted but gives me something to work on.

Thanks,

Rani.

[rmbittmann]

Hi,

I think I found my mistake. When creating the Seam Web Project, in the Seam Facet page, I entered my schema name in the Database Schema Name field.

I created a new project and left this field empty, now Seam Generate Enteties works for me!

Rani.

[maxandersen]

hmm...then the schema name is not mom1 ..maybe its MOM1 ?

[rmbittmann]

Hi,

The schema name is mom1. Furthermore when I defined the schema default name, I got a duplication in the FROM part of the SQL query, i.e. an SQL statement ending with mom1.mom1.... Not entering a schema name at all, or removing the default schema part from the persistence.xml file (even after returning it) made the project work (for the time being).

I am probably doing something wrong, I did not write any code, so it might be the versions of the components or some of the wizard's definitions. Playing with it further I might find it and if so I will post it here.

Thanks,

Rani.