SQL Power Software Forum

You seem to have a good idea of how the Architect works. Any changes you make in the playpen are never applied to the source database unless you forward engineer. Also, you can forward engineer the playpen to any database, it doesn't have to be the one that the one the original tables came from. The connection to the database can be used for other things as well such as profiling and comparing two databases.

As for the relationships not being retained, I'm not sure what the problem is. What version of MySQL are you using? I hope that information helps us shed light on what the problem may be.

Your suggestion is a great one. As of now you can only print out the playpen but we can surely see the use of exporting it to a PDF. Again, thanks for the suggestion. We'll try to implement it in the next release.

Thanks for your input, and hopefully we can figure out this problem with relationships for you.

- Ryan

Hello,

You did all but one thing that had to be done to connect to MySQL. Since the current version of the Architect doesn't support MySQL the driver doesn't show up in the dropdown list in our GUI so you have to specify it manually.

To do this, open up your pl.ini file. If you do not know where it is saved just check out the user preferences. In the pl.ini file find the section that has the connection you created. For the JDBC Driver Class line, change it to read "JDBC Driver Class=com.mysql.jdbc.Driver". Save the file and reopen the Architect. You should be able to connect to the database now.

You may be happy to learn that in the upcoming release of the Architect MySQL will be fully supported. We plan to have the release out very soon, so be sure to check back!

- Ryan

Currently there is no way in our UI to do this, but it is planned to be added. A current workaround would be to manually edit your pl.ini file. You can find out where your pl.ini file is stored by going to the user preferences. Each entry in the pl.ini file looks similar to the following:

With the fields filled in, of course. Just remove the entries you do not want anymore and save the pl.ini file. It would be best to close the Power*Architect before editing this file..

Looks like a pretty nasty bug. We will be sure to fix it in the upcoming release. Thanks a lot for the report!

This is a topic created to maintain a list of links to the download pages of various JDBC drivers. Feel free to post about updates or additional links that may be needed.

Oracle
Download Page

SQL Server
Download Page

PostgreSQL
Download Page

HSQL
Download Page