This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.
Hi All, We are using MySQL running in Windows. This is an out of the box deployment except for the inclusion of the following statement in the my.ini file: lower_case_table_names=2 This allows MySQL to recognize the difference between TABLE and table. Other than that, MySQL is untouched. We are using hibernate and the "New Hibernate Mapping Files and POJOs from Database" option to generate the beans and the hbm.xml files. The problem is that even though every table in the schema has a primary key of type int, not null, unsigned, auto increment, when the window that lists the available tables pops up, about 2/3 of the tables in the schema are grayed out and have in parenthesis "(no primary key)" as text next to the table name. As I mentioned, all of the tables are setup the same way, each having a primary key but for some reason, netbeans hibernate tool does not recognize this fact and will not generate beans or hbm files for most of the tables.
Created attachment 81834 [details] screen shot showing the problem
Created attachment 81835 [details] file handled correctly
Created attachment 81836 [details] File handled incorrectly
I have uploaded some screen shots that show the issue and two tables that are virtually identical yet are seen differently by the hibernate utility.
Re-assigning to web/hibernate. If I'm wrong, assign back to db.
It's good to have sample sql script to create tables from the issue to evaluate the issue.
Can't resolve without sample script/schema