From: Yaron Z. <ya...@id...> - 2002-10-23 10:08:24
|
Hi, Is this feature going to get into 1.1.6 ? Thanks, Yaron. -----Original Message----- From: Christoph Sturm [mailto:ch...@sc...] Sent: Thursday, October 17, 2002 9:57 PM To: Gavin King Cc: hibernate list Subject: Re: [Hibernate] dynamic schema update I will look at it when I have the time. I think they dont have alter table support too. If they have a nice structure we could add the stuff we need and submit it back. There are so many java persistency frameworks, and it would be nice if they would share some code that is common to them all, and sql generation is for sure. greetz chris Gavin King wrote: >Hmmmm the only trouble with this is that they support *way* fewer platforms >than us. > >Also, can you tell if there is support for subqueries in the API? > >----- Original Message ----- >From: "Gavin King" <ga...@ap...> >To: "Christoph Sturm" <ch...@sc...> >Cc: "hibernate list" <hib...@li...> >Sent: Friday, October 18, 2002 5:34 AM >Subject: Re: [Hibernate] dynamic schema update > > > > >>Yeah, funny, I looked at this project about a year ago in the early stages >>of Hibernate but it didnt seem far enough advanced to actually use. >> >> >Looking > > >>pretty good now. >> >>----- Original Message ----- >>From: "Christoph Sturm" <ch...@sc...> >>To: "Gavin King" <ga...@ap...> >>Cc: "hibernate list" <hib...@li...> >>Sent: Friday, October 18, 2002 5:30 AM >>Subject: Re: [Hibernate] dynamic schema update >> >> >> >> >>>Gavin King wrote: >>> >>> >>> >>>>>I have now added a Schemaupdater to hibernate. At the moment it only >>>>>adds missing colums to the schema, and creates tables if they are >>>>>missing. I have testet it with sql server. All the rest of hibernate >>>>>seems to still work, so I could commit it to cvs if you have no >>>>> >>>>> >>>>> >>>>> >>>>objections. >>>> >>>>Cool!! Go Ahead and check it in. Sounds like something that will really >>>>be used by a lot of users.... >>>> >>>> >>>> >>>> >>>> >>>> >>>>>Something we should really do in the near future is create classes for >>>>>all the sql statements. I think we should think of our database >>>>> >>>>> >dialects > > >>>>>as SQL-Statementfactory-factories, then we could deal with different >>>>> >>>>> >sql > > >>>>>dialects much easier. >>>>> >>>>> >>>>> >>>>> >>>>Yes, you are absolutely right (and I have mentioned this before). The >>>> >>>> >>main >> >> >>>>remaining piece of bad-design is the lack of a proper OO model of SQL. >>>>If you want to have a go at writing an elegant heirarchy of classes for >>>>this, >>>>it would be _highly_ appreciated. >>>> >>>> >>>> >>>> >>>i wonder if >>>http://sourceforge.net/projects/crossdb/ would be an option. Just saw >>>that the ojb guys use this. >>> >>>regards >>> chris >>> >>> >> >>------------------------------------------------------- >>This sf.net email is sponsored by: viaVerio will pay you up to >>$1,000 for every account that you consolidate with us. >>http://ad.doubleclick.net/clk;4749864;7604308;v? >>http://www.viaverio.com/consolidator/osdn.cfm >>_______________________________________________ >>hibernate-devel mailing list >>hib...@li... >>https://lists.sourceforge.net/lists/listinfo/hibernate-devel >> >> > > > >------------------------------------------------------- >This sf.net email is sponsored by: viaVerio will pay you up to >$1,000 for every account that you consolidate with us. >http://ad.doubleclick.net/clk;4749864;7604308;v? >http://www.viaverio.com/consolidator/osdn.cfm >_______________________________________________ >hibernate-devel mailing list >hib...@li... >https://lists.sourceforge.net/lists/listinfo/hibernate-devel > > > > ------------------------------------------------------- This sf.net email is sponsored by: viaVerio will pay you up to $1,000 for every account that you consolidate with us. http://ad.doubleclick.net/clk;4749864;7604308;v? http://www.viaverio.com/consolidator/osdn.cfm _______________________________________________ hibernate-devel mailing list hib...@li... https://lists.sourceforge.net/lists/listinfo/hibernate-devel |
From: Christoph S. <ch...@mc...> - 2002-10-23 10:38:07
|
I have it on my harddisk at home, and its actually finished and just needs some more tests. I dont know when 1.1.6 will be released, but I think i will commit it soon, at least before the weekend. regards chris ----- Original Message ----- From: "Yaron Zakai" <ya...@id...> To: "'Christoph Sturm'" <ch...@sc...>; "Gavin King" <ga...@ap...> Cc: "hibernate list" <hib...@li...> Sent: Wednesday, October 23, 2002 12:08 PM Subject: RE: [Hibernate] dynamic schema update > Hi, > > Is this feature going to get into 1.1.6 ? > > Thanks, Yaron. > > -----Original Message----- > From: Christoph Sturm [mailto:ch...@sc...] > Sent: Thursday, October 17, 2002 9:57 PM > To: Gavin King > Cc: hibernate list > Subject: Re: [Hibernate] dynamic schema update > > > I will look at it when I have the time. I think they dont have alter > table support too. If they have a nice structure we could add the stuff > we need and submit it back. There are so many java persistency > frameworks, and it would be nice if they would share some code that is > common to them all, and sql generation is for sure. > > greetz > chris > > > Gavin King wrote: > > >Hmmmm the only trouble with this is that they support *way* fewer platforms > >than us. > > > >Also, can you tell if there is support for subqueries in the API? > > > >----- Original Message ----- > >From: "Gavin King" <ga...@ap...> > >To: "Christoph Sturm" <ch...@sc...> > >Cc: "hibernate list" <hib...@li...> > >Sent: Friday, October 18, 2002 5:34 AM > >Subject: Re: [Hibernate] dynamic schema update > > > > > > > > > >>Yeah, funny, I looked at this project about a year ago in the early stages > >>of Hibernate but it didnt seem far enough advanced to actually use. > >> > >> > >Looking > > > > > >>pretty good now. > >> > >>----- Original Message ----- > >>From: "Christoph Sturm" <ch...@sc...> > >>To: "Gavin King" <ga...@ap...> > >>Cc: "hibernate list" <hib...@li...> > >>Sent: Friday, October 18, 2002 5:30 AM > >>Subject: Re: [Hibernate] dynamic schema update > >> > >> > >> > >> > >>>Gavin King wrote: > >>> > >>> > >>> > >>>>>I have now added a Schemaupdater to hibernate. At the moment it only > >>>>>adds missing colums to the schema, and creates tables if they are > >>>>>missing. I have testet it with sql server. All the rest of hibernate > >>>>>seems to still work, so I could commit it to cvs if you have no > >>>>> > >>>>> > >>>>> > >>>>> > >>>>objections. > >>>> > >>>>Cool!! Go Ahead and check it in. Sounds like something that will really > >>>>be used by a lot of users.... > >>>> > >>>> > >>>> > >>>> > >>>> > >>>> > >>>>>Something we should really do in the near future is create classes for > >>>>>all the sql statements. I think we should think of our database > >>>>> > >>>>> > >dialects > > > > > >>>>>as SQL-Statementfactory-factories, then we could deal with different > >>>>> > >>>>> > >sql > > > > > >>>>>dialects much easier. > >>>>> > >>>>> > >>>>> > >>>>> > >>>>Yes, you are absolutely right (and I have mentioned this before). The > >>>> > >>>> > >>main > >> > >> > >>>>remaining piece of bad-design is the lack of a proper OO model of SQL. > >>>>If you want to have a go at writing an elegant heirarchy of classes for > >>>>this, > >>>>it would be _highly_ appreciated. > >>>> > >>>> > >>>> > >>>> > >>>i wonder if > >>>http://sourceforge.net/projects/crossdb/ would be an option. Just saw > >>>that the ojb guys use this. > >>> > >>>regards > >>> chris > >>> > >>> > >> > >>------------------------------------------------------- > >>This sf.net email is sponsored by: viaVerio will pay you up to > >>$1,000 for every account that you consolidate with us. > >>http://ad.doubleclick.net/clk;4749864;7604308;v? > >>http://www.viaverio.com/consolidator/osdn.cfm > >>_______________________________________________ > >>hibernate-devel mailing list > >>hib...@li... > >>https://lists.sourceforge.net/lists/listinfo/hibernate-devel > >> > >> > > > > > > > >------------------------------------------------------- > >This sf.net email is sponsored by: viaVerio will pay you up to > >$1,000 for every account that you consolidate with us. > >http://ad.doubleclick.net/clk;4749864;7604308;v? > >http://www.viaverio.com/consolidator/osdn.cfm > >_______________________________________________ > >hibernate-devel mailing list > >hib...@li... > >https://lists.sourceforge.net/lists/listinfo/hibernate-devel > > > > > > > > > > > > > > ------------------------------------------------------- > This sf.net email is sponsored by: viaVerio will pay you up to > $1,000 for every account that you consolidate with us. > http://ad.doubleclick.net/clk;4749864;7604308;v? > http://www.viaverio.com/consolidator/osdn.cfm > _______________________________________________ > hibernate-devel mailing list > hib...@li... > https://lists.sourceforge.net/lists/listinfo/hibernate-devel > > > ------------------------------------------------------- > This sf.net emial is sponsored by: Influence the future > of Java(TM) technology. Join the Java Community > Process(SM) (JCP(SM)) program now. > http://ads.sourceforge.net/cgi-bin/redirect.pl?sunm0002en > _______________________________________________ > hibernate-devel mailing list > hib...@li... > https://lists.sourceforge.net/lists/listinfo/hibernate-devel > |
From: Gavin K. <ga...@ap...> - 2002-10-23 10:43:27
|
Christoph, how does it work, by the way? Is it a seperate tool or an option to SchemaExport or what? just curious.... ----- Original Message ----- From: "Christoph Sturm" <ch...@mc...> To: "Yaron Zakai" <ya...@id...>; "'Christoph Sturm'" <ch...@sc...>; "Gavin King" <ga...@ap...> Cc: "hibernate list" <hib...@li...> Sent: Wednesday, October 23, 2002 8:38 PM Subject: Re: [Hibernate] dynamic schema update > I have it on my harddisk at home, and its actually finished and just needs > some more tests. I dont know when 1.1.6 will be released, but I think i will > commit it soon, at least before the weekend. > > regards > chris > > > > ----- Original Message ----- > From: "Yaron Zakai" <ya...@id...> > To: "'Christoph Sturm'" <ch...@sc...>; "Gavin King" > <ga...@ap...> > Cc: "hibernate list" <hib...@li...> > Sent: Wednesday, October 23, 2002 12:08 PM > Subject: RE: [Hibernate] dynamic schema update > > > > Hi, > > > > Is this feature going to get into 1.1.6 ? > > > > Thanks, Yaron. > > > > -----Original Message----- > > From: Christoph Sturm [mailto:ch...@sc...] > > Sent: Thursday, October 17, 2002 9:57 PM > > To: Gavin King > > Cc: hibernate list > > Subject: Re: [Hibernate] dynamic schema update > > > > > > I will look at it when I have the time. I think they dont have alter > > table support too. If they have a nice structure we could add the stuff > > we need and submit it back. There are so many java persistency > > frameworks, and it would be nice if they would share some code that is > > common to them all, and sql generation is for sure. > > > > greetz > > chris > > > > > > Gavin King wrote: > > > > >Hmmmm the only trouble with this is that they support *way* fewer > platforms > > >than us. > > > > > >Also, can you tell if there is support for subqueries in the API? > > > > > >----- Original Message ----- > > >From: "Gavin King" <ga...@ap...> > > >To: "Christoph Sturm" <ch...@sc...> > > >Cc: "hibernate list" <hib...@li...> > > >Sent: Friday, October 18, 2002 5:34 AM > > >Subject: Re: [Hibernate] dynamic schema update > > > > > > > > > > > > > > >>Yeah, funny, I looked at this project about a year ago in the early > stages > > >>of Hibernate but it didnt seem far enough advanced to actually use. > > >> > > >> > > >Looking > > > > > > > > >>pretty good now. > > >> > > >>----- Original Message ----- > > >>From: "Christoph Sturm" <ch...@sc...> > > >>To: "Gavin King" <ga...@ap...> > > >>Cc: "hibernate list" <hib...@li...> > > >>Sent: Friday, October 18, 2002 5:30 AM > > >>Subject: Re: [Hibernate] dynamic schema update > > >> > > >> > > >> > > >> > > >>>Gavin King wrote: > > >>> > > >>> > > >>> > > >>>>>I have now added a Schemaupdater to hibernate. At the moment it only > > >>>>>adds missing colums to the schema, and creates tables if they are > > >>>>>missing. I have testet it with sql server. All the rest of hibernate > > >>>>>seems to still work, so I could commit it to cvs if you have no > > >>>>> > > >>>>> > > >>>>> > > >>>>> > > >>>>objections. > > >>>> > > >>>>Cool!! Go Ahead and check it in. Sounds like something that will > really > > >>>>be used by a lot of users.... > > >>>> > > >>>> > > >>>> > > >>>> > > >>>> > > >>>> > > >>>>>Something we should really do in the near future is create classes > for > > >>>>>all the sql statements. I think we should think of our database > > >>>>> > > >>>>> > > >dialects > > > > > > > > >>>>>as SQL-Statementfactory-factories, then we could deal with different > > >>>>> > > >>>>> > > >sql > > > > > > > > >>>>>dialects much easier. > > >>>>> > > >>>>> > > >>>>> > > >>>>> > > >>>>Yes, you are absolutely right (and I have mentioned this before). The > > >>>> > > >>>> > > >>main > > >> > > >> > > >>>>remaining piece of bad-design is the lack of a proper OO model of SQL. > > >>>>If you want to have a go at writing an elegant heirarchy of classes > for > > >>>>this, > > >>>>it would be _highly_ appreciated. > > >>>> > > >>>> > > >>>> > > >>>> > > >>>i wonder if > > >>>http://sourceforge.net/projects/crossdb/ would be an option. Just saw > > >>>that the ojb guys use this. > > >>> > > >>>regards > > >>> chris > > >>> > > >>> > > >> > > >>------------------------------------------------------- > > >>This sf.net email is sponsored by: viaVerio will pay you up to > > >>$1,000 for every account that you consolidate with us. > > >>http://ad.doubleclick.net/clk;4749864;7604308;v? > > >>http://www.viaverio.com/consolidator/osdn.cfm > > >>_______________________________________________ > > >>hibernate-devel mailing list > > >>hib...@li... > > >>https://lists.sourceforge.net/lists/listinfo/hibernate-devel > > >> > > >> > > > > > > > > > > > >------------------------------------------------------- > > >This sf.net email is sponsored by: viaVerio will pay you up to > > >$1,000 for every account that you consolidate with us. > > >http://ad.doubleclick.net/clk;4749864;7604308;v? > > >http://www.viaverio.com/consolidator/osdn.cfm > > >_______________________________________________ > > >hibernate-devel mailing list > > >hib...@li... > > >https://lists.sourceforge.net/lists/listinfo/hibernate-devel > > > > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------- > > This sf.net email is sponsored by: viaVerio will pay you up to > > $1,000 for every account that you consolidate with us. > > http://ad.doubleclick.net/clk;4749864;7604308;v? > > http://www.viaverio.com/consolidator/osdn.cfm > > _______________________________________________ > > hibernate-devel mailing list > > hib...@li... > > https://lists.sourceforge.net/lists/listinfo/hibernate-devel > > > > > > ------------------------------------------------------- > > This sf.net emial is sponsored by: Influence the future > > of Java(TM) technology. Join the Java Community > > Process(SM) (JCP(SM)) program now. > > http://ads.sourceforge.net/cgi-bin/redirect.pl?sunm0002en > > _______________________________________________ > > hibernate-devel mailing list > > hib...@li... > > https://lists.sourceforge.net/lists/listinfo/hibernate-devel > > |
From: Christoph S. <ch...@mc...> - 2002-10-23 10:59:52
|
I have implemented it as a method in a static class that i call at the start of my webapp. I think i will commit it this way, and then add it to SchemaExport. -chris ----- Original Message ----- From: "Gavin King" <ga...@ap...> To: "Christoph Sturm" <ch...@mc...> Cc: "hibernate list" <hib...@li...> Sent: Wednesday, October 23, 2002 12:42 PM Subject: Re: [Hibernate] dynamic schema update > Christoph, how does it work, by the way? > > Is it a seperate tool or an option to SchemaExport or what? > > just curious.... > > ----- Original Message ----- > From: "Christoph Sturm" <ch...@mc...> > To: "Yaron Zakai" <ya...@id...>; "'Christoph Sturm'" > <ch...@sc...>; "Gavin King" <ga...@ap...> > Cc: "hibernate list" <hib...@li...> > Sent: Wednesday, October 23, 2002 8:38 PM > Subject: Re: [Hibernate] dynamic schema update > > > > I have it on my harddisk at home, and its actually finished and just needs > > some more tests. I dont know when 1.1.6 will be released, but I think i > will > > commit it soon, at least before the weekend. > > > > regards > > chris > > > > > > > > ----- Original Message ----- > > From: "Yaron Zakai" <ya...@id...> > > To: "'Christoph Sturm'" <ch...@sc...>; "Gavin King" > > <ga...@ap...> > > Cc: "hibernate list" <hib...@li...> > > Sent: Wednesday, October 23, 2002 12:08 PM > > Subject: RE: [Hibernate] dynamic schema update > > > > > > > Hi, > > > > > > Is this feature going to get into 1.1.6 ? > > > > > > Thanks, Yaron. > > > > > > -----Original Message----- > > > From: Christoph Sturm [mailto:ch...@sc...] > > > Sent: Thursday, October 17, 2002 9:57 PM > > > To: Gavin King > > > Cc: hibernate list > > > Subject: Re: [Hibernate] dynamic schema update > > > > > > > > > I will look at it when I have the time. I think they dont have alter > > > table support too. If they have a nice structure we could add the stuff > > > we need and submit it back. There are so many java persistency > > > frameworks, and it would be nice if they would share some code that is > > > common to them all, and sql generation is for sure. > > > > > > greetz > > > chris > > > > > > > > > Gavin King wrote: > > > > > > >Hmmmm the only trouble with this is that they support *way* fewer > > platforms > > > >than us. > > > > > > > >Also, can you tell if there is support for subqueries in the API? > > > > > > > >----- Original Message ----- > > > >From: "Gavin King" <ga...@ap...> > > > >To: "Christoph Sturm" <ch...@sc...> > > > >Cc: "hibernate list" <hib...@li...> > > > >Sent: Friday, October 18, 2002 5:34 AM > > > >Subject: Re: [Hibernate] dynamic schema update > > > > > > > > > > > > > > > > > > > >>Yeah, funny, I looked at this project about a year ago in the early > > stages > > > >>of Hibernate but it didnt seem far enough advanced to actually use. > > > >> > > > >> > > > >Looking > > > > > > > > > > > >>pretty good now. > > > >> > > > >>----- Original Message ----- > > > >>From: "Christoph Sturm" <ch...@sc...> > > > >>To: "Gavin King" <ga...@ap...> > > > >>Cc: "hibernate list" <hib...@li...> > > > >>Sent: Friday, October 18, 2002 5:30 AM > > > >>Subject: Re: [Hibernate] dynamic schema update > > > >> > > > >> > > > >> > > > >> > > > >>>Gavin King wrote: > > > >>> > > > >>> > > > >>> > > > >>>>>I have now added a Schemaupdater to hibernate. At the moment it > only > > > >>>>>adds missing colums to the schema, and creates tables if they are > > > >>>>>missing. I have testet it with sql server. All the rest of > hibernate > > > >>>>>seems to still work, so I could commit it to cvs if you have no > > > >>>>> > > > >>>>> > > > >>>>> > > > >>>>> > > > >>>>objections. > > > >>>> > > > >>>>Cool!! Go Ahead and check it in. Sounds like something that will > > really > > > >>>>be used by a lot of users.... > > > >>>> > > > >>>> > > > >>>> > > > >>>> > > > >>>> > > > >>>> > > > >>>>>Something we should really do in the near future is create classes > > for > > > >>>>>all the sql statements. I think we should think of our database > > > >>>>> > > > >>>>> > > > >dialects > > > > > > > > > > > >>>>>as SQL-Statementfactory-factories, then we could deal with > different > > > >>>>> > > > >>>>> > > > >sql > > > > > > > > > > > >>>>>dialects much easier. > > > >>>>> > > > >>>>> > > > >>>>> > > > >>>>> > > > >>>>Yes, you are absolutely right (and I have mentioned this before). > The > > > >>>> > > > >>>> > > > >>main > > > >> > > > >> > > > >>>>remaining piece of bad-design is the lack of a proper OO model of > SQL. > > > >>>>If you want to have a go at writing an elegant heirarchy of classes > > for > > > >>>>this, > > > >>>>it would be _highly_ appreciated. > > > >>>> > > > >>>> > > > >>>> > > > >>>> > > > >>>i wonder if > > > >>>http://sourceforge.net/projects/crossdb/ would be an option. Just saw > > > >>>that the ojb guys use this. > > > >>> > > > >>>regards > > > >>> chris > > > >>> > > > >>> > > > >> > > > >>------------------------------------------------------- > > > >>This sf.net email is sponsored by: viaVerio will pay you up to > > > >>$1,000 for every account that you consolidate with us. > > > >>http://ad.doubleclick.net/clk;4749864;7604308;v? > > > >>http://www.viaverio.com/consolidator/osdn.cfm > > > >>_______________________________________________ > > > >>hibernate-devel mailing list > > > >>hib...@li... > > > >>https://lists.sourceforge.net/lists/listinfo/hibernate-devel > > > >> > > > >> > > > > > > > > > > > > > > > >------------------------------------------------------- > > > >This sf.net email is sponsored by: viaVerio will pay you up to > > > >$1,000 for every account that you consolidate with us. > > > >http://ad.doubleclick.net/clk;4749864;7604308;v? > > > >http://www.viaverio.com/consolidator/osdn.cfm > > > >_______________________________________________ > > > >hibernate-devel mailing list > > > >hib...@li... > > > >https://lists.sourceforge.net/lists/listinfo/hibernate-devel > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------- > > > This sf.net email is sponsored by: viaVerio will pay you up to > > > $1,000 for every account that you consolidate with us. > > > http://ad.doubleclick.net/clk;4749864;7604308;v? > > > http://www.viaverio.com/consolidator/osdn.cfm > > > _______________________________________________ > > > hibernate-devel mailing list > > > hib...@li... > > > https://lists.sourceforge.net/lists/listinfo/hibernate-devel > > > > > > > > > ------------------------------------------------------- > > > This sf.net emial is sponsored by: Influence the future > > > of Java(TM) technology. Join the Java Community > > > Process(SM) (JCP(SM)) program now. > > > http://ads.sourceforge.net/cgi-bin/redirect.pl?sunm0002en > > > _______________________________________________ > > > hibernate-devel mailing list > > > hib...@li... > > > https://lists.sourceforge.net/lists/listinfo/hibernate-devel > > > > |