Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

PowerDesigner common settin

2025-04-06 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Network Security >

Share

Shulou(Shulou.com)06/01 Report--

1. Using JDBC to connect to Oracle to reverse generate database PDM

Using ODBC to connect to Oracle database can learn from this brother's blog: http://www.cnblogs.com/clivehua/articles/4593211.html

Personally, I feel that it is relatively simple to connect to Oracle by JDBC.

[Database]-> [Configure Connections]

A few points to note:

1. If you cannot initialize JVM, the number of digits of your JDK version and PowerDesigner is not the same, please adjust.

2. JDBC driver jar: select the driver Jar that connects to the database in your project, and add the location of the jar to the system variable classPath.

3. Connection profile: the name of the connection is whatever you want.

4. Description: the description of the connection, which can be left empty.

5. Fill in the UserName/JDBC driver class/connecton URl correctly and click on the test link.

Back to the top.

two。 Desynchronization of tables Name and Code in logical model

[Tool]-> [General Options]-> [Dialog]-> [Operating modes]-> [Name to Code mirroring] cancel √

Back to the top.

3. In the logical model, Name is automatically populated with comments when comments are empty.

Back to the top.

4. Generate database SQL to remove table names and field double quotation marks

[Database]-> [Edit current database]-> [Script]-> [Sql]-> whether [Format] uses case to specify identifiers

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Network Security

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report