Everything runs OK, no errors, but in the graphical relationship page is not generated. I can see the dot files in graphs/summary directory, but no relationship page is generated.
Please advice
Win XP
SchemaSpy 2.1.2
MySql 5.0.18-nt
Thank you in advance.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
With MySQL you have to use InnoDB as the table type...the default doesn't enforce foreign key relationships. Note that SchemaSpy is just reporting what it's finding.
John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2006-05-01
what was your command line for this? I cannot get schema spy running with 5.1.9 and the beta java connector.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I tried the beta driver this weekend and it apparently has lots of threading issues. I didn't try it, but you should be able to specify -dbThreads=1 to make the collection of db metadata single threaded.
John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
In release 3.0.0 SchemaSpy always generates a relationships page, even if no relationships were detected. It should display some (hopefully) meaningful messages when it detects no relationships. Note, however, that it doesn't give DB-specific messages (like when you're not using InnoDB tables with MySQL).
John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Everything runs OK, no errors, but in the graphical relationship page is not generated. I can see the dot files in graphs/summary directory, but no relationship page is generated.
Please advice
Win XP
SchemaSpy 2.1.2
MySql 5.0.18-nt
Thank you in advance.
With MySQL you have to use InnoDB as the table type...the default doesn't enforce foreign key relationships. Note that SchemaSpy is just reporting what it's finding.
John
what was your command line for this? I cannot get schema spy running with 5.1.9 and the beta java connector.
I tried the beta driver this weekend and it apparently has lots of threading issues. I didn't try it, but you should be able to specify -dbThreads=1 to make the collection of db metadata single threaded.
John
In release 3.0.0 SchemaSpy always generates a relationships page, even if no relationships were detected. It should display some (hopefully) meaningful messages when it detects no relationships. Note, however, that it doesn't give DB-specific messages (like when you're not using InnoDB tables with MySQL).
John