Hi, Phil, On Saturday 03 December 2005 09:39, Randall R Schulz wrote:
...
Using the 3.1.12 from Packman did indeed solve the hanging problem and I now have a nice HTML-ified display of my schema.
Thanks, Phil, for putting me onto this. I and my co-workers can certainly make use of this tool.
So, I'm finding this useful already, as I'm just in the midst of my first Hibernate project and it helps me visualize the resulting database schema. Anyway, I noticed this diagnostic when I run schemaSpy: -==--==--==--==--==--==--==--==--==--==--==--==--==--==--==--==- Warning: Invalid version of dot detected (2.2). SchemaSpy requires dot version 2.2.1 or versions greater than 2.4. Generated pages will not contain a graphical view of table relationships. -==--==--==--==--==--==--==--==--==--==--==--==--==--==--==--==- So I went hunting for a newer version of the graphviz package (the home / source of the "dot" program). I could not find a SuSE-specific package, but it turns out the version from the Graphviz site (<http://www.graphviz.org/> / <http://www.graphviz.org/Download_linux.php>) that is compiled for FC4 installs and seems to work. There may be problems not disclosed by schemaSpy's use of dot, but since it's not something I use otherwise, it was worth the minor risk of installing it. The results are moderately cool. Go to a page for a table and select the "Implied relationships" check-box. I think there's either a problem with the DDL generated by the Hibernate tool or a problem with schemaSpy (or, most likely, with my Hibernate mapping file), 'cause the foreign key constraints in the resulting schema are supposed to be explicit. Randall Schulz