Not at all.

 

I will fix the language issue. At the moment, the default language is German if the locale cannot

be determined. I will change the default language to English in the next release.

 

I will check the reverse engineering issue this weekend and give you feedback as soon as possible.

 

Regards

 

Mirko

 

Von: Magerman, Tom [mailto:Tom.Magerman@econ.kuleuven.be]
Gesendet: Freitag, 22. Februar 2008 18:05
An: Sertic Mirko, Bedag
Betreff: RE: [Squirrel-sql-users] New Release of Mogwai ERDesigner Plugin:problems with fields like SYS_NC00010$ in Oracle databases

 

Thank you for your very quick response.

 

My locale (Windows Regional Settings) is "Dutch (Belgium)". Although there is some relation between Dutch and German language, automatically mapping this locale to the German version of the plug-in is not a very logical choice. Especially German computer languege is rather hard to understand for Dutch speaking people. I'm quite confident that almost al Dutch speaking people would prefer English over German.

 

The problem with the system generated column names in Oracle might be a very though one. It might have to do with field names that have been renamed or deleted, but it also might have to do with automatically generated indexes or field contraints. Filtering out these system column names might be a quick solution, but maybe some more severe underlying problem is causing the error (e.g., by filtering out you might miss all not null constraints defined at the moment of table creation, because Oracle will create an automatically named constraint like 'SYS_C00000$' for every field indicated as not null in a table creation query).

 

I checked it out on some tables, and I think I have found where it goes wrong: function based indexes.

We use function based indexes on almost all of our tables. E.g., we have a lot of databases where dates are stored in an numerical field as YYYYMMDD. For our indexing purposes, we are only interested in the year, so we create function based indexes to index only the first 4 characters of the field. Now it seems that Oracle creates a 'system' field for all these function based indexes. I do not know how this finaly generates an error in the Squirrel plugin, but untill now I see that the field names mentioned in the error messages of the plugin are field names automatically created by Oracle when creating functin based indexes (like SYS_NC00010$). I hope this gives you enough information to solve the issue.

 

Regards,

 

Tom Magerman


 


From: squirrel-sql-users-bounces@lists.sourceforge.net [mailto:squirrel-sql-users-bounces@lists.sourceforge.net] On Behalf Of Sertic Mirko, Bedag
Sent: vrijdag 22 februari 2008 17:20
To: squirrel-sql-users@lists.sourceforge.net
Subject: Re: [Squirrel-sql-users] New Release of Mogwai ERDesigner Plugin:problems with fields like SYS_NC00010$ in Oracle databases

Hi

 

Thank you for trying ERDesigner!

 

ERDesigner supports German and English locales. Which Locale are you using? It defaults to the system locale, so if you

are running on a Windows box, and its default is German, the German locale is used.

 

About the column reverse engineering problem. I am not sure if this is related to the oracle recycle bin. I know that tables

are renamed to a strange name if they are dropped and moved to the recycle bin. Is anybody out there who can confirm that the

same thing happens to table columns? Recycle bin tables are filtered during reverse engineering, so I think I have to add

the same filter to columns..

 

Regards

Mirko

 

Von: Magerman, Tom [mailto:Tom.Magerman@econ.kuleuven.be]
Gesendet: Freitag, 22. Februar 2008 17:09
An: Sertic Mirko, Bedag
Betreff: [Squirrel-sql-users] New Release of Mogwai ERDesigner Plugin: problems with fields like SYS_NC00010$ in Oracle databases

 

Dear Mirko,

 

I love Squirrel a lot and I am very interested in this ERDesigner pluging.

 

First of all, is it normal that the plugin is in German? No Englisch available?

 

In practice, I always run into problems when reverse engineering our Oracle database. For every schema I want to reverse engineer, I get an error because some tables contain fields like 'SYS_NC00010$' (de.erdesignerng.exception.ReverseEngineeringException: Cannot find attribute SYS_NC00010$ in table APPLN) and the process stops.

 

I presume this has to do with deleted or renamed fields in Oracle tables. In practice, this means I was not able to create a schema for any of my Oracle schema's. Any idea what is going on and how it can be solved?

 

Kind regards,

 

Tom Magerman

 

 


From: squirrel-sql-users-bounces@lists.sourceforge.net [mailto:squirrel-sql-users-bounces@lists.sourceforge.net] On Behalf Of Sertic Mirko, Bedag
Sent: dinsdag 5 februari 2008 13:10
To: squirrel-sql-users@lists.sourceforge.net
Subject: [Squirrel-sql-users] New Release of Mogwai ERDesigner Plugin

Hi @all!

I’ve made a new release of the Mogwai ERDesigner plugin for Squirrel.

The new version 1.1 includes the following changes and features:

-       Reverse engineering of MySQL, MSSQL, Postgres and Oracle databases

-       Designing tables and relations in a visual way ( adding , modifying and deleting )

-       Export database diagram as SVG, PNG , BMP and GIF

-       Generate changelog for model modifications

-       Many bug fixes

The new release can be downloaded at http://mogwai.sourceforge.net or

http://sourceforge.net/projects/mogwai

Regards

Mirko



Disclaimer: http://www.kuleuven.be/cwis/email_disclaimer.htm for more information.



Disclaimer: http://www.kuleuven.be/cwis/email_disclaimer.htm for more information.