Re: [Hibernate] dynamic schema update

[Christoph Sturm]

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" <[EMAIL PROTECTED]>
To: "Christoph Sturm" <[EMAIL PROTECTED]>
Cc: "hibernate list" <[EMAIL PROTECTED]>
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" <[EMAIL PROTECTED]>
To: "Gavin King" <[EMAIL PROTECTED]>
Cc: "hibernate list" <[EMAIL PROTECTED]>
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
[EMAIL PROTECTED]
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
[EMAIL PROTECTED]
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
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hibernate-devel