Thread: [Squirrel-sql-users] New Release of Mogwai ERDesigner Plugin
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Sertic M. B. <Mir...@be...> - 2008-02-05 12:10:19
|
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 |
From: David D. Jr. <dav...@gm...> - 2008-02-20 18:07:51
|
On Tue, Feb 5, 2008 at 6:09 AM, Sertic Mirko, Bedag <Mir...@be...> wrote: > 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 I've installed the new version, and it now works with Oracle databases (at least to the extent that I tested). I've got a lot of object in a schema. Is there any way to filter these, so that only a few show up in the reverse engineer? Thanks, Dave |
From: Sertic M. B. <Mir...@be...> - 2008-02-21 16:33:28
|
Hi Thank you for your feedback! At the moment, the whole schema, all objects that belong to it, are reverse engineered and added to the model. What kind of filter do you need? Would a kind of regular expression be ok, or do you need to be more specific? Regards Mirko -----Ursprüngliche Nachricht----- Von: squ...@li... [mailto:squ...@li...] Im Auftrag von David Durham, Jr. Gesendet: Mittwoch, 20. Februar 2008 19:08 An: squ...@li... Betreff: Re: [Squirrel-sql-users] New Release of Mogwai ERDesigner Plugin On Tue, Feb 5, 2008 at 6:09 AM, Sertic Mirko, Bedag <Mir...@be...> wrote: > 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 I've installed the new version, and it now works with Oracle databases (at least to the extent that I tested). I've got a lot of object in a schema. Is there any way to filter these, so that only a few show up in the reverse engineer? Thanks, Dave ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
From: David D. Jr. <dav...@gm...> - 2008-02-21 17:49:40
|
On Thu, Feb 21, 2008 at 10:32 AM, Sertic Mirko, Bedag <Mir...@be...> wrote: > Hi > > Thank you for your feedback! > > At the moment, the whole schema, all objects that belong to it, are > reverse engineered and added to the model. What kind of filter do you need? > Would a kind of regular expression be ok, or do you need to be more specific? I don't think it needs to be much, and I don't know how other tools accomplish this. I could see something where you're selecting (and possibly searching for) tables that you check off as wanting to be included in the reverse engineering. Thanks, Dave |
From: Sertic M. B. <Mir...@be...> - 2008-02-22 15:53:57
|
Hi I will take a look at this feature. Perhaps I can provide a beta with this functionality at the beginning of next week... Regards Mirko -----Ursprüngliche Nachricht----- Von: squ...@li... [mailto:squ...@li...] Im Auftrag von David Durham, Jr. Gesendet: Donnerstag, 21. Februar 2008 18:50 An: Sertic Mirko, Bedag Cc: squ...@li... Betreff: Re: [Squirrel-sql-users] New Release of Mogwai ERDesigner Plugin On Thu, Feb 21, 2008 at 10:32 AM, Sertic Mirko, Bedag <Mir...@be...> wrote: > Hi > > Thank you for your feedback! > > At the moment, the whole schema, all objects that belong to it, are > reverse engineered and added to the model. What kind of filter do you need? > Would a kind of regular expression be ok, or do you need to be more specific? I don't think it needs to be much, and I don't know how other tools accomplish this. I could see something where you're selecting (and possibly searching for) tables that you check off as wanting to be included in the reverse engineering. Thanks, Dave ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
From: Sertic M. B. <Mir...@be...> - 2008-02-22 16:19:59
|
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...@ec...] 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: squ...@li... [mailto:squ...@li...] On Behalf Of Sertic Mirko, Bedag Sent: dinsdag 5 februari 2008 13:10 To: squ...@li... 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 <http://mogwai.sourceforge.net> or http://sourceforge.net/projects/mogwai <http://sourceforge.net/projects/mogwai> Regards Mirko Disclaimer: http://www.kuleuven.be/cwis/email_disclaimer.htm for more information. |
From: Sertic M. B. <Mir...@be...> - 2008-02-25 08:05:02
|
Hi I released the 1.2.2 version of ERDesigner. It fixes some bugs regarding the reverse engineering and the oracle datatype system. Also, I changed the default locale to English. I tested the reverse engineering with function based indexes. Now, if such an index occours, it is ignored, as the editor does not support such indexes at all. Can you please give it a try? Regards Mirko Von: squ...@li... [mailto:squ...@li...] Im Auftrag von Sertic Mirko, Bedag Gesendet: Freitag, 22. Februar 2008 18:17 An: squ...@li... Betreff: Re: [Squirrel-sql-users] New Release of Mogwai ERDesignerPlugin:problems with fields like SYS_NC00010$ in Oracle databases 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...@ec...] 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: squ...@li... [mailto:squ...@li...] On Behalf Of Sertic Mirko, Bedag Sent: vrijdag 22 februari 2008 17:20 To: squ...@li... 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...@ec...] 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: squ...@li... [mailto:squ...@li...] On Behalf Of Sertic Mirko, Bedag Sent: dinsdag 5 februari 2008 13:10 To: squ...@li... 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 <http://mogwai.sourceforge.net> or http://sourceforge.net/projects/mogwai <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. |
From: Sertic M. B. <Mir...@be...> - 2008-02-22 17:17:40
|
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...@ec...] 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: squ...@li... [mailto:squ...@li...] On Behalf Of Sertic Mirko, Bedag Sent: vrijdag 22 februari 2008 17:20 To: squ...@li... 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...@ec...] 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: squ...@li... [mailto:squ...@li...] On Behalf Of Sertic Mirko, Bedag Sent: dinsdag 5 februari 2008 13:10 To: squ...@li... 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 <http://mogwai.sourceforge.net> or http://sourceforge.net/projects/mogwai <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. |