power designer 连接mysql提示“connection test failed”
本机环境:
win10 64位
jdk8 64位
问题:
测试连接时,总是提示
根据网上搜索:
根源在于:PowerDesigner based on 32 bit JVM kernel
参考:
http://hunt1574.blog.51cto.com/1390776/1016582
http://prog3.com/sbdm/blog/czmchen/article/details/32155753
下面是连接的内容,怕丢了,这边贴过来:
Using PowerDesigner to generate the table structure in reverse, need MySQL connection, configured to connect directly, test report: connection test failed"!
OS:WIN7 flagship version 64 JDK: 64 PowerDesigner:15.1.0.2850 Problem causes: PowerDesigner based on 32 bit JVM kernel Detailed processing ideas // 这里:安装32位jdk,配置32jdk的环境变量,配置jdk的powedesign环境变量 Install JDK 32bit Configure JDK 32bit environment variable Configure JDK powerdesign environment variable PowerDesigner Tools Options - > General - > Variables:C:\Program Files JAR (x86) \Java\bin\jar.exe
JAVA Files C:\Program (x86) \Java\bin\java.exe
JAVAC Files C:\Program (x86) \Java\bin\javac.exe
JAVADOC Files C:\Program (x86) \Java\bin\javadoc.exe
Restart powerdersign, connect successfully! ----------------------------2018-08-14更新------------------------------- 在该博文里发现,其实是有64位的powerdesigner的。参考: 当然了,对我来说,搞这些还是很麻烦。我一般选择直接生成sql脚本,再导入到数据库。 或者从sql脚本来逆向生成pdm等。