Skip to Main Content
Forums

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

20.02 Layout Font Colors not loaded when loading Model

denzerAug 14 2020 — edited Aug 18 2020

Hello, we work with very colorful models in Oracle Designer for 25 years now.

Beeing time to move forward we are trying out the SQL Developer Data Modeler.

I can live with the ER-Diagrams not beeing importet, though it hurts a bit with a 150 Entity-Diagram.

What I can not live with is:

When I format an entity in the logical model and change the background and therefore the font colors, save

and close the model, the font colors are all back to default when I reopen it. Rendering it to completely

non-readable with a dark background.

I took a look into the xml files and the font color information seems to be present, so its "only" the loading

process that dismisses those values.

Is this problem already known ? Will there come an update?

Oh, btw, using classification types could be a way out of this problem, if only there weren't so many different

kinds of entities/tables.

Best regards,

Volker Denzer
This post has been answered by Philip Stoyanov-Oracle on Aug 17 2020
Jump to Answer

Comments

mNem

Works for me on 18.3... and https://livesql.oracle.com.

SQL> select banner_full from v$version
  2  /

BANNER_FULL
--------------------------------------------------------------------------------
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0

SQL> ed
Wrote file afiedt.buf

  1  WITH testdata(xmlfile) AS
  2  (
  3  SELECT xmltype(
  4  '<pubDat>
  5        <bNumber>string</bNumber>
  6        <fld>string</fld>
  7        <dbInstance>string</dbInstance>
  8  </pubDat>')
  9  FROM dual)
10  SELECT
11  XMLQUERY(
12      'copy $tmp := .
13       modify replace value of node $tmp/pubDat/bNumber with "test"
14       return $tmp
15      '
16  PASSING xmlfile RETURNING CONTENT
17  ) newxml
18* FROM testdata
SQL> /

NEWXML
--------------------------------------------------------------------------------
<pubDat>
  <bNumber>test</bNumber>
  <fld>string</fld>
  <dbInstance>string</dbInstance>
</pubDat>

1 person found this helpful
_jum

Both queries work fine for me too with Oracle Database 12c Standard Edition Release 12.1.0.2.0.

1 person found this helpful
CarstenDD

Hello mNem,

thanks for your test and telling me where you did it. After trying different things I found out that my problem has to do with the usage of SQL-Detective as SQL-tool.

Regards Carsten

CarstenDD

Hello _jum,

thanks for your test and telling me where you did it. After trying different things I found out that my problem has to do with the usage of SQL-Detective as SQL-tool.

Regards Carsten

CarstenDD
Answer

Hello all,

the reason for the error is the usage of SQL-Detective which seems to send some strange data to the Oracle-DB. After using SQL-Developer everythings works fine. Thanks for the tester to give me the idea to change my SQL-Tool.

Regards Carsten

Marked as Answer by CarstenDD · Sep 27 2020
1 - 5

Post Details

Added on Aug 14 2020
5 comments
199 views