PowerDesigner connecting MySQL and reverse engineering diagrams

Source: Internet
Author: User
Tags sql error powerdesigner

1, MySQL database connection (JDBC mode) The configuration of JDBC requires some basic environment and preparation, but also very simple, that is, the JDK and MySQL connection jar package, no longer elaborated here. 1.1 Create a new Pdm,dbms select MySQL

1.2 Database-connect Select a database connection

1.3 Configuring connection Information database connection here is a configuration file to get the connection information, the first word because there is no, so we need to choose Configure to configure. 1.4 Fill in the configuration information, select Add Database resources, appear as above, the relevant instructions are as follows:
    • Connection profile NAME:JDBC configuration file name, can be filled in freely
    • Directory: Configuration File Save path
    • Description: Configuration file description, can be filled according to the actual use
    • Connection Type: Connection mode, here we choose JDBC
    • DBMS Type: Database types, which provide most of the major database choices, we choose MySQL
    • User name: Username of login Database
    • JDBC Driver Class: Specifies the driver class, using the default Com.mysql.jdbc.Driver
    • JDBC connection url: Connection URL, format jdbc:mysql://serverip/hostname:port/database
    • JDBC driver jar files: specifying the path to a connected jar package

1.5 connection test and configuration save fill in the information after completion, click on the bottom left of the test Connection, the successful prompt indicates that the connection is feasible: if the test connection does not pass, and the Non SQL error:could not load class Com.mysql.jd Bc. Drive error, and the specified jar package is not problematic, it is because PowerDesigner cannot find the driver generated. The workaround is to configure the system's Classpath path, specifying the path to the jar package. After successful connection, we go all the way to save this configuration file, you can end up in the folder you specify (there is no limit, the directory can be customized, here I was built in a userconf folder under the installation file) to see this saved file: 2, Reverse engineer a table from an existing Database 2.1 menu selection, update model 2.2 from database Select Database connection profile 2.3 Select the database involved and the table you want to export 2.4 done 3, reference link:
    • PowerDesigner connecting MySQL Database
    • powerdesigner16.5 reverse engineering, export PDM from remote ORACLE11G database
    • Non SQL error:could not load class com.mysql.jdbc.Drive when connecting to database using PowerDesigner

PowerDesigner connecting MySQL and reverse engineering diagrams

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.