Menu
▾
▴
hibernate-devel
|
From: Christoph S. <ch...@sc...> - 2002-10-17 18:23:12
|
Hi All! 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. 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. regards chris |
|
From: Christoph S. <ch...@sc...> - 2002-11-04 01:07:05
|
Hi All! I finally managed to commit the dynamic schema update. To use it just instantiate a SchemaUpdater Object, and call doUpdate. I tried it with MS SQL Server, later I will try it with firebird and oracle, I just wanted to commit it, because I have it sitting on my drive for such a long time. regards chris |
|
From: Gavin K. <ga...@ap...> - 2002-10-17 18:34:18
|
> 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. Thanks Gavin |
|
From: Christoph S. <ch...@sc...> - 2002-10-17 19:31:01
|
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 |
|
From: Gavin K. <ga...@ap...> - 2002-10-17 19:35:17
|
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 |
|
From: Gavin K. <ga...@ap...> - 2002-10-17 19:43:13
|
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 |
|
From: Christoph S. <ch...@sc...> - 2002-10-17 19:58:06
|
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 > > > > |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X