Antecedent: As the project in the process of research and development, database fields need to be constantly added and modified, resulting in the original design of the database prototype can not be used, and later thought to use Powerdesinger to reverse the database table structure.
Environment: Win7 64-bit system with 64-bit JDK and 32-bit JDK installed on the machine. The system environment variable is configured with the address of the 64-bit JDK. Eclipse is using a 64-bit JDK.
Symptom: PowerDesigner Connection failed error through JDBC data source direct connection to MySQL database.
Resolution: Still error after replacing the latest version of MySQL JDBC driver. To eliminate the JDBC driver problem, guess is the JDK problem, modify the system environment variable to 32-bit Jdk,powerdesigner connection database is normal.
Conclusion: powerdesigner12.5 does not support 64-bit JDK and does not know if a later version is supported.
Other issues: After modifying the system environment variable to a 32-bit JDK, eclipse cannot be opened and the JNI library cannot be loaded.
Workaround: Modify the Eclipse configuration file and specify the JDK version location directly by opening the Eclipse.ini file, and before the-vmargs parameter, add
-vm
D:\Java\jdk1.6.0_43\bin\javaw.exe (64-bit JDK installation path)
Once saved, eclipse will open normally.
Turn powerdesigner12.5 to connect MySQL database issues under 64-bit JDK