druid-users Mailing List for Druid, The Database Manager
Brought to you by:
acarboni
You can subscribe to this list here.
2003 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(5) |
Dec
(5) |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2004 |
Jan
(5) |
Feb
(5) |
Mar
(2) |
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
(2) |
Sep
(3) |
Oct
|
Nov
|
Dec
|
2005 |
Jan
|
Feb
(2) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(1) |
Dec
|
2006 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
|
Dec
|
2008 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(3) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2009 |
Jan
(1) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2014 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2016 |
Jan
(1) |
Feb
|
Mar
|
Apr
(1) |
May
|
Jun
(1) |
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
|
Dec
|
2017 |
Jan
|
Feb
|
Mar
(1) |
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
From: Руслан Б. <fs...@li...> - 2008-06-19 07:58:06
|
-----Original Message----- From: Carlos ChАvez <cc...@ag...> To: malpropio <mal...@ho...> Date: Wed, 18 Jun 2008 14:16:06 -0600 Subject: Re: [Druid-users] Sequence > malpropio wrote: > > I'm using the last version of Druid to create the schema , E/R of a postgres > > DB. > > My problem is I cant assign a sequence to any field, does anyone know how > > this can be done ? > > thank you > > > I usually did that using the "Default" field, i assign to this field the > value: nextval('secuence-name') > In the "Fields" tab. > > Cheers. > Carlos ChАvez. > > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > _______________________________________________ > Druid-users mailing list > Dru...@li... > https://lists.sourceforge.net/lists/listinfo/druid-users > Also there is a possibility to use "serial" datatype. But using this datatype will only create a sequence and set a default=nextval... Thanks, Ruslan. |
From: Carlos C. <cc...@ag...> - 2008-06-18 22:27:21
|
malpropio wrote: > I'm using the last version of Druid to create the schema , E/R of a postgres > DB. > My problem is I cant assign a sequence to any field, does anyone know how > this can be done ? > thank you > I usually did that using the "Default" field, i assign to this field the value: nextval('secuence-name') In the "Fields" tab. Cheers. Carlos Chávez. |
From: malpropio <mal...@ho...> - 2008-06-18 19:31:36
|
I'm using the last version of Druid to create the schema , E/R of a postgres DB. My problem is I cant assign a sequence to any field, does anyone know how this can be done ? thank you -- View this message in context: http://www.nabble.com/Sequence-tp17990048p17990048.html Sent from the druid-users mailing list archive at Nabble.com. |
From: Ben F. <be...@au...> - 2006-08-01 21:44:40
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 [Not sure if this would be better suited to the druid-devel list, but I won't cross-post just yet] Hey folks, I'm having a problem w/ the Druid (v3.8) MySQL module's "Table type" option. I found the problem while investigating warnings I saw while creating my MySQL tables using the Druid generated script. You can find this option by clicking on a (MySQL) table, selecting the "Option" tab along the top tab list, then selecting the "Modules" tab along the lower tab list. At the bottom of the frame is a box titled "General" w/ a combo box title "Table type". The possible options are "InnoDB" and "MyISAM". This option controls the generation of the MySQL "TYPE=storage_engine" directive at the close of the table create statement I am using MySQL server v5.0.22. It appears that in v5.0.22 or before the "TYPE=storage_engine" directive was deprecated in favor of the new "ENGINE=storage_engine" directive. I get the following warnings from my Druid-generated table create statements: Warning (Code 1287): 'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' instead Is there a way to configure the Druid MySQL module to use "ENGINE" in place of "TYPE"? If not, could this be made configurable in a future release of the MySQL module? Even better (but more involved) would be to create a MySQL module setting at the database-level for the MySQL version. Then based on the version specified, the MySQL syntax generated by the module could be tweaked. I know the iptables output module of Firewall Builder <http://www.sourceforge.net/projects/fwbuilder/> does something like this by using an simple iptables version setting ["1.2.9 or later", "1.2.6 to 1.2.8", "1.2.5 or earlier"] to determine the supported iptables syntax for generation. Regards, Ben - -- Ben Feinstein, CISSP CTO & Vice President Audiun, Inc. 227 Peachtree Circle NE Suite B Atlanta, GA 30309 404-474-1199 (Voice) 404-474-7689 (FAX) be...@au... CONFIDENTIALITY NOTICE: This e-mail transmission and the attachments accompanying it may contain confidential information. The information is intended only for the use of the intended recipient. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on the contents of this information is strictly prohibited. Any unauthorized interception of this transmission is illegal under the law. If you have received this transmission in error, please promptly notify the sender by reply e-mail and destroy all copies of the transmission. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.4 (GNU/Linux) iD8DBQFEz8tCPy7Lg/DIKQgRAn5LAKDC1ZLBXhKKg6o0sdd5V/wwnMMdLgCfWf/T VeUk3sTu0IGhC3qvf3GqqVo= =dPOy -----END PGP SIGNATURE----- |
From: Roland G. <ro...@gi...> - 2005-11-03 21:36:19
|
I'm connecting to postgresql from druid and it's work fine. However... Once I've made changes to the database structure (like for example creating a trigger), how do I write those changes to the database. The changes never appear in the database? Thanks Roland Giesler |
From: Andrea C. <aca...@us...> - 2005-02-09 15:18:33
|
> Hi folks, I am currently evaluating Druid. I have a must-have feature and > a pretty-close-to-must-have feature that I'm wondering if Druid supports. > > PostgreSQL, like other databases supports a "namespace" for tables called > schemas. I see Druid's folder concept but it appears to be merely for > organization only. I can't seem to find a way to model a schema. Is this > possible? Schemas are not yet supported by druid. I have planned this feature for the 4.0 release. One way to overcome this (a hack if you prefer) if to embed the schema into the table's name (it is not the best solution, I know, but it should work). > Andrea, a post of yours in the dev list archives stated that you feel > Druid does everything you need it to do. I see the sqlDiff feature is not > completed. How do you manage changes to a database already created? I'd > love for Druid to modify the database directly and produce a script I can > apply to other database instances. I coded the sql diff one day I needed to see changes between 2 databases. The sql diff works in the sense that you can see what is changed and you can generate a diff report to send to another person to inform they about changes. When I tried to produce a sql script to automatically upgrade the first db to the second I found several difficulties regarding the sql dialects that each dbms has. The architecture is ready. The MigrationScript.java class gets called and should only be filled with a sql dialect (for example oracle). Maybe the class could ask the user which dbms dialect to use. > I am willing to contribute to this project if the scope of these features > is not overwhelming. > > Thanks. > > Daryl Stultz As I said, the sql diff is easy to code. Regarding schemas, they are easy too. Here there is a time problem. The 4.0 release will not be ready soon. Starting from june I will have much more time to code it but it will require time. In the meanwhile, most urgent features/fixes will be done into the V3_X branch. So, I think to make a 3.6 release in june with some enhancements. There are some developers that are working on them. If you want to participate I can give you cvs access. I can also give support if you want to add schemas. Cheers, Andrea |
From: Daryl S. <da...@6d...> - 2005-02-09 13:49:56
|
Hi folks, I am currently evaluating Druid. I have a must-have feature and a pretty-close-to-must-have feature that I'm wondering if Druid supports. PostgreSQL, like other databases supports a "namespace" for tables called schemas. I see Druid's folder concept but it appears to be merely for organization only. I can't seem to find a way to model a schema. Is this possible? Andrea, a post of yours in the dev list archives stated that you feel Druid does everything you need it to do. I see the sqlDiff feature is not completed. How do you manage changes to a database already created? I'd love for Druid to modify the database directly and produce a script I can apply to other database instances. I am willing to contribute to this project if the scope of these features is not overwhelming. Thanks. Daryl Stultz _____________________________________ 6 Degrees Software and Consulting, Inc. http://www.6degrees.com mailto:da...@6d... |
From: Andrea C. <aca...@us...> - 2004-09-08 21:40:17
|
> So if i remove reverse-db.jar from the modules and perform exactly the same > operation it should work right ? It is unnecessary to remove the reverse-db.jar from the modules. This module is only activated when you do a right-click on a db node and select "Import..(or what so ever, I don't remember). To use druid's native importer do this: - select a db node - select the "jdbc" tab and create a jdbc connection - from the "structure" subtab (of the "jdbc" tab) select the db node and do a right-click. - select "Import objects" from the popup (that's all) Cheers, Andrea > -----Original Message----- > From: Andrea Carboni [mailto:aca...@us...] > Sent: Wednesday, September 08, 2004 8:34 PM > To: dru...@li... > Subject: Re: [Druid-users] NoSuchMethodError > > > > Could somebody help me in solving a Durid issue. > > I am trying to generate the .jdo (to be used by OJB) file for an already > > existing schema using Druid, > > When I run the reverse engineering tool I get the following error : > > > > java.lang.NoSuchMethodError: > > druid.data.TableNode.getFieldFromId(I)Ldruid/data/FieldNode; > > at mod.treeview.reverse.ReverseDB.postprocessEntity(Unknown > Source) > > at mod.treeview.reverse.ReverseDB.postprocessDataMap(Unknown > Source) > > at mod.treeview.reverse.ReverseDB.startReverse(Unknown Source) > > at mod.treeview.reverse.ReverseDBModule.nodeSelected(Unknown > Source) > > at > > > druid.core.modules.ModuleManager.dispatchTreeNodeEvent(ModuleManager.java:28 > > 9) > > at druid.panels.ProjectView.actionPerformed(ProjectView.java:348) > > at > > javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1764) > > ......................................................... > > it appears in the druid version 3.5 as well as 3.4. > > > > I am stuck because my DB schema has too many tables and I thing manually > > writing the JDO file will be difficult and error prone. > > > > Thanks in advance. > > Regards > > Tarun > > You should use this module if (and only if) the druid's internal importer > fails > (which now rarely happen). > > Cheers, > Andrea |
From: Andrea C. <aca...@us...> - 2004-09-08 15:03:29
|
> Could somebody help me in solving a Durid issue. > I am trying to generate the .jdo (to be used by OJB) file for an already > existing schema using Druid, > When I run the reverse engineering tool I get the following error : > > java.lang.NoSuchMethodError: > druid.data.TableNode.getFieldFromId(I)Ldruid/data/FieldNode; > at mod.treeview.reverse.ReverseDB.postprocessEntity(Unknown Source) > at mod.treeview.reverse.ReverseDB.postprocessDataMap(Unknown Source) > at mod.treeview.reverse.ReverseDB.startReverse(Unknown Source) > at mod.treeview.reverse.ReverseDBModule.nodeSelected(Unknown Source) > at > druid.core.modules.ModuleManager.dispatchTreeNodeEvent(ModuleManager.java:28 > 9) > at druid.panels.ProjectView.actionPerformed(ProjectView.java:348) > at > javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1764) > ......................................................... > it appears in the druid version 3.5 as well as 3.4. > > I am stuck because my DB schema has too many tables and I thing manually > writing the JDO file will be difficult and error prone. > > Thanks in advance. > Regards > Tarun You should use this module if (and only if) the druid's internal importer fails (which now rarely happen). Cheers, Andrea |
From: <Gup...@gx...> - 2004-09-08 09:08:28
|
Hi, Could somebody help me in solving a Durid issue. I am trying to generate the .jdo (to be used by OJB) file for an already existing schema using Druid, When I run the reverse engineering tool I get the following error : java.lang.NoSuchMethodError: druid.data.TableNode.getFieldFromId(I)Ldruid/data/FieldNode; at mod.treeview.reverse.ReverseDB.postprocessEntity(Unknown Source) at mod.treeview.reverse.ReverseDB.postprocessDataMap(Unknown Source) at mod.treeview.reverse.ReverseDB.startReverse(Unknown Source) at mod.treeview.reverse.ReverseDBModule.nodeSelected(Unknown Source) at druid.core.modules.ModuleManager.dispatchTreeNodeEvent(ModuleManager.java:28 9) at druid.panels.ProjectView.actionPerformed(ProjectView.java:348) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1764) ......................................................... it appears in the druid version 3.5 as well as 3.4. I am stuck because my DB schema has too many tables and I thing manually writing the JDO file will be difficult and error prone. Thanks in advance. Regards Tarun |
From: Andrea C. <aca...@us...> - 2004-08-11 19:58:29
|
Alle 17:11, luned=EC 09 agosto 2004, ru...@ro... ha scritto: >=20 > Dear list, >=20 > I have been using Druid for a couple of weeks now, I am trying to generat= e Hibernate mappings from Druid, I have ticked the "Generate table relation= ships" option in the module; however, no relationship between related objec= ts is generated. >=20 > Any help would be greatly appreciated. >=20 > Russell Geraghty This is a bug. I will post a fixed jar ASAP. Thanks, Andrea |
From: <ru...@ro...> - 2004-08-09 15:11:10
|
Dear list, I have been using Druid for a couple of weeks now, I am trying to generate Hibernate mappings from Druid, I have ticked the "Generate table relationships" option in the module; however, no relationship between related objects is generated. Any help would be greatly appreciated. Russell Geraghty |
From: <ben...@id...> - 2004-05-25 10:39:36
|
Dear Open Source developer I am doing a research project on "Fun and Software Development" in which I kindly invite you to participate. You will find the online survey under http://fasd.ethz.ch/qsf/. The questionnaire consists of 53 questions and you will need about 15 minutes to complete it. With the FASD project (Fun and Software Development) we want to define the motivational significance of fun when software developers decide to engage in Open Source projects. What is special about our research project is that a similar survey is planned with software developers in commercial firms. This procedure allows the immediate comparison between the involved individuals and the conditions of production of these two development models. Thus we hope to obtain substantial new insights to the phenomenon of Open Source Development. With many thanks for your participation, Benno Luthiger PS: The results of the survey will be published under http://www.isu.unizh.ch/fuehrung/blprojects/FASD/. We have set up the mailing list fa...@we... for this study. Please see http://fasd.ethz.ch/qsf/mailinglist_en.html for registration to this mailing list. _______________________________________________________________________ Benno Luthiger Swiss Federal Institute of Technology Zurich 8092 Zurich Mail: benno.luthiger(at)id.ethz.ch _______________________________________________________________________ |
From: Andrea C. <aca...@us...> - 2004-03-17 14:05:23
|
On 17:10, martedì 16 marzo 2004, Claudio D'Angelo wrote: > Hi, > I'm using > DRUID version 3.2 > Oracle 9 > JVM 1.4.2_03b02 on Windows 2000 > > When I create a table with TIMESTAMP column in Oracle Druid can't visualize > the timestamp data writing "<???>". > the table structure via JDBC is: > Field : [COLUMN_NAME] > DataType : OTHER(11,7) > DbmsType : TIMESTAMP(7) > > Can anyone help me? Simply, the oracle's TIMESTAMP type is not supported by druid because it is not recognized as a standard sql type. To be more exact, oracle maps its DATE type to the sql type TIMESTAMP (as you can see in the jdbc->db->datatypes tab) and maps its TIMESTAMP to the OTHER type. Because the OTHER type is not defined (it can be binary, an array, a complex type and so on) druid is not able to show it. A suggestion can be to use the DATE type instead, which is accurate enough for normal use (it has year-month-day-hour-min-secs-decimals). Cheers, Andrea |
From: Claudio D'A. <cla...@ob...> - 2004-03-16 16:11:06
|
Hi, I'm using DRUID version 3.2 Oracle 9 JVM 1.4.2_03b02 on Windows 2000 When I create a table with TIMESTAMP column in Oracle Druid can't visualize the timestamp data writing "<???>". the table structure via JDBC is: Field : [COLUMN_NAME] DataType : OTHER(11,7) DbmsType : TIMESTAMP(7) Can anyone help me? Thanks Grazie e buon lavoro ---------- Claudio D'Angelo Software Consultant ObjectWay S.p.A. Via G.A. Boltraffio 7 20159 Milano (MI) http://www.objectway.it |
From: Jonathan C. <Jon...@ka...> - 2004-02-25 21:59:31
|
I found the velocity generation module documentation. It looks very cool a= nd I've played with it a bit. However, I don't see a way to add Java objec= ts to the Velocity context. I really need that. Is this something I just = overlooked? BTW, it would be very powerful if, instead of the generation.xml file, I co= uld specify a generation.groovy script file (http://groovy.codehaus.org). = Groovy is a powerful new Java-like scripting language that would be an exce= llent fit. (Groovy scripts can also mimic XML by creating SAX events and D= OM documents). =20 Using groovy would allow the developer to add objects (like helper objects)= to the Velocity context with no additional work from you in changing the X= ML reader. (That is, it would be no extra work if you put the Velocity con= text into the groovy script context. This would open up almost unlimited p= ossibilities for code generation). Thanks in advance for your help, (And thanks for a way-cool tool :-) Jonathan ***************************************************************************= ****** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. Katun Corporation -- Celebrating 25 Years of Service www.katun.com ***************************************************************************= ****** |
From: Jonathan C. <Jon...@ka...> - 2004-02-19 19:51:39
|
Thanks! I somehow missed that whole area of the app. Too cool. :-) Jonathan >>> Andrea Carboni <aca...@us...> 02/18/04 02:57PM >>> On 15:33, mercoled=EC 18 febbraio 2004, Jonathan Carlson wrote: > It's not clear to me whether or not reverse engineering from an existing > database works. Is reverse engineering a new feature in CVS, but not in > v3.4? > > Thanks! > > Jonathan Carlson Reverse engineering works since release 2.7. You have to: - add the jar driver to druid using dialog - create an empty db - specify a jdbc url - connect to a jdbc db - right click on the jdbc database root node and select import objects Cheers, Andrea ***************************************************************************= ****** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. Katun Corporation -- Celebrating 25 Years of Service www.katun.com ***************************************************************************= ****** |
From: Andrea C. <aca...@us...> - 2004-02-18 23:10:18
|
On 15:33, mercoledì 18 febbraio 2004, Jonathan Carlson wrote: > It's not clear to me whether or not reverse engineering from an existing > database works. Is reverse engineering a new feature in CVS, but not in > v3.4? > > Thanks! > > Jonathan Carlson Reverse engineering works since release 2.7. You have to: - add the jar driver to druid using dialog - create an empty db - specify a jdbc url - connect to a jdbc db - right click on the jdbc database root node and select import objects Cheers, Andrea |
From: Jonathan C. <Jon...@ka...> - 2004-02-18 14:38:37
|
It's not clear to me whether or not reverse engineering from an existing da= tabase works. Is reverse engineering a new feature in CVS, but not in v3.4? Thanks! Jonathan Carlson ***************************************************************************= ****** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. Katun Corporation -- Celebrating 25 Years of Service www.katun.com ***************************************************************************= ****** |
From: Jonathan C. <Jon...@ka...> - 2004-02-18 00:04:47
|
I'm new to this tool. It looks like you've done a lot of good work here. = I'm hoping to use it to define my database and generate DAOs and DTOs with = the Velocity tool. It appears that I cannot connect to DB2 8.1 because the license is in a sep= arate jar file. (You can only specify one jar file in the JDBC config area= ). I tried adding the license jar to the system classpath, but that didn't= seem to help either. Then I tried adding both jars to the system classpat= h and that didn't help either. Has anyone else tried this tool with DB2? =20 Thanks! Jonathan ***************************************************************************= ****** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. Katun Corporation -- Celebrating 25 Years of Service www.katun.com ***************************************************************************= ****** |
From: John B. M. <jb...@mi...> - 2004-01-22 06:06:11
|
From: Andrea C. <aca...@us...> - 2004-01-19 20:48:05
|
On 12:00, lunedì 19 gennaio 2004, ROSSEL Olivier (CIMPA) wrote: > I try to export as CSV the content of a SQLServer database. > I use Jtds driver and Druid 3.4. > > With SqlServer 7, I had no problems. > With SqlServer 2000, I get an error that is: > "SQL Server does not support TRANSACTION_SERIALIZABLE" > > I think the problem comes either from my driver or my database > configuration. > > Any help is welcome. The problem is on the jdbc driver. Druid asks for the best transaction level. The driver responds. Druid tries to use the given level. The driver fails. To avoid this, you can comment a line and try to rebuild druid yourself. The file is : build/src/druid/core/jdbc/JdbcConnection.java Comment line 77: tryTransactionIsolation(); must be changed into: // tryTransactionIsolation(); Go inside the build directory and issue ant to rebuild all. Run druid and enjoy !!! Cheers, Andrea |
From: Andrea C. <aca...@us...> - 2004-01-19 20:48:02
|
On 16:12, lunedì 19 gennaio 2004, ROSSEL Olivier (CIMPA) wrote: > I am retrieving a data structure from a Sql Server database. > I want to repricate this database in hsqlDb. > > I think the correct way to do it is with 'rebuild in jdbc db'. > But this menu item has an arrow, meaning that it just displays > a list of .... > Well, that's the question, because that list is empty. > > I tried both Druid 3.2 and 3.4. and still get that problem. > > Any help is welcome. You are right. That menu displays the list of sql generators currently added to your project. When you want to rebuild a database via jdbc, you have to specify which sql generator to use because the resulting sql is different from a DBMS to another. So, select the DB node and on the panel on the right, select the generation tab and, inside it, the modules tab. Now add the sql generator for your dbms (usually a standard sql module should work). Cheers, Andrea |
From: Andrea C. <aca...@us...> - 2003-12-05 22:24:01
|
On 11:08, venerdì 5 dicembre 2003, Claudio D'Angelo wrote: > Hi > how can I use Druid to insert/modify/view tables that contain column > CLOB/BLOB? > > Thank's Viewing a BLOB/CLOB is easy: in the table's data tab select a record and the lens icon (record editor) to view the record in detail. For BLOBS/CLOBS and binary fields you can view both ascii and hexadecimal data. For now, the insert/update is not possible. Cheers, Andrea |
From: Claudio D'A. <cla...@ob...> - 2003-12-05 10:08:42
|
Hi how can I use Druid to insert/modify/view tables that contain column CLOB/BLOB? Thank's |