Open Source Project: DBDesigner

 

DBDesigner 4 is a visual database design system that integrates database design, modeling, creation and maintenance into a single, seamless environment.

It combines professional features and a clear and simple user interface to offer the most efficient way to handle your databases.

DBDesigner 4 compares to products like Oracle’s Designer©, IBM’s Rational Rose©, Computer Associates’s ERwin© and theKompany’s DataArchitect© but is an Open Source Project available for Microsoft Windows© 2k/XP and Linux KDE/Gnome. It is release on the GPL.

DBDesigner 4 is developed and optimized for the open source MySQL-Database to support MySQL users with a powerful and free available design tool.

All MySQL specific features have been built in to offer the most convenient way to design and keep control of your MySQL-Databases.

配置 Apache + ColdFusion MX 7 + MySQL + Eclipse 开发环境(Windows)

VIA: www.stephencollins.org

The ACME Guide – Apache, ColdFusion MX 7, MySQL and Eclipse

PDF:  (6.1Mb)

FlashPaper (3.0Mb)

CFMX连接MySQL4.1错误的解决方法

今天把mysql升级到4.1后,程序连接数据库出错,于是打开admin校验数据源,果然不能连接,出错信息如下:
Connection verification failed for data source: mysql_bad java.sql.SQLException: Communication failure during handshake.Is there a server running on localhost:3306?
The root cause was that: java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306?

记得以前看过一篇blog,提到了解决办法,于是”赶紧的”

先到mysql.com下个最新的JDBC驱动,然后将下回来的压缩包里的”mysql-connector-java-3.1.6-bin.jar”
放到$CFMX_HOME/runtime/servers/lib/ (for CFMX Server Configuration )或者$JRUN_HOME/servers/lib/(for CFMX on JRun Configuration),比如我机器的是:C:\blackstone\runtime\lib

然后重起CFMX.

重新定义数据源,在”Driver”下拉框这项选择”other”,接下来的配置如下图:

提交后数据源添加成功.

之所以升级到mysql4.1后数据源出错,是因为cfmx的jdbc驱动还是旧的.

相信MM在不久后会更新内置的JDBC驱动,不过在blackstone beta2里的是旧的.