db-commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tra...@spaceprogram.com
Subject RE: RE: Re: [Hibernate] automatic db creation
Date Wed, 26 Mar 2003 09:04:16 GMT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2655.35">
<TITLE>RE: Re: [Hibernate] automatic db creation</TITLE>
</HEAD>
<BODY>Ok,
<br>
<br>So I went ahead and got a start on the auto build.
<br>
<br>Build happens in Configuration.buildSessionFactory, most basic data types should
work, haven't test any relationships or collections yet, but the basic ones should work if
the column exists in the metadata.
<br>
<br>This can be turned on by adding the following to hibernate.properties
<br>hibernate.autobuilddb true
<br>
<br>If someone could commit this so we can get some testing and work out the kinks,
that would be great. &nbsp;
<br>
<br>Class and patch at: <a href="http://sourceforge.net/tracker/index.php?func=detail&aid=709940&group_id=40712&atid=428710">http://sourceforge.net/tracker/index.php?func=detail&aid=709940&group_id=40712&atid=428710</a>
<br>
<br>Travis
<br>
<br>
<br>
<br>---- Original Message ----
<br>From: ROSSEL Olivier &lt;<a href="mailto:olivier.rossel@airbus.com">olivier.rossel@airbus.com</a>>
<br>Sent: 2003-03-25
<br>To: <a href="mailto:hibernate-devel@lists.sourceforge.net">hibernate-devel@lists.sourceforge.net</a>,

<br> &quot;<a href="mailto:'commons-user@db.apache.org'">'commons-user@db.apache.org'</a>"
&lt;<a href="mailto:commons-user@db.apache.org">commons-user@db.apache.org</a>>
<br>Subject: RE: Re: [Hibernate] automatic db creation
<br>
<br>

<P><FONT SIZE=2>Once again a central point for references to database libraries
would greatly </FONT>
<BR><FONT SIZE=2>improve the productivity of developpers.</FONT>
</P>

<P><FONT SIZE=2>May be at db.apache.org there could be a link called &quot;resources&quot;</FONT>
<BR><FONT SIZE=2>that would link to other interesting pieces of software.</FONT>
</P>
<BR>
<BR>

<P><FONT SIZE=2>&gt; -----Message d'origine-----</FONT>
<BR><FONT SIZE=2>&gt; De: travis@spaceprogram.com [<A HREF="mailto:travis@spaceprogram.com">mailto:travis@spaceprogram.com</A>]</FONT>
<BR><FONT SIZE=2>&gt; Date: lundi 24 mars 2003 22:51</FONT>
<BR><FONT SIZE=2>&gt; : Aaron Metzger; hibernate-devel@lists.sourceforge.net</FONT>
<BR><FONT SIZE=2>&gt; Objet: RE: Re: [Hibernate] automatic db creation</FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; Hi all,</FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; Just got back from vacation and glad to hear that this
</FONT>
<BR><FONT SIZE=2>&gt; discussion has been sparked up again.&nbsp; Aaron
has pointed out </FONT>
<BR><FONT SIZE=2>&gt; the best reason for having this feature, ie: deploying
</FONT>
<BR><FONT SIZE=2>&gt; changes to multiple clients.&nbsp; Others include,
ease of </FONT>
<BR><FONT SIZE=2>&gt; development and initial deployment.</FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; Anyways, as for being smart with updates, we did this
in OJB </FONT>
<BR><FONT SIZE=2>&gt; at apache by adding new columns if they don't exist
and we </FONT>
<BR><FONT SIZE=2>&gt; are using crossdb to do the table creation and altering.&nbsp;
</FONT>
<BR><FONT SIZE=2>&gt; www.crossdb.com&nbsp; This ensures that the same
code can modify </FONT>
<BR><FONT SIZE=2>&gt; various databases seamlessly.</FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; So in creating this feature, I would propose using crossdb
</FONT>
<BR><FONT SIZE=2>&gt; for it as it will work and make the feature quite easy
to create.</FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; Travis</FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; ---- Original Message ----</FONT>
<BR><FONT SIZE=2>&gt; From: Aaron Metzger &lt;ametzger@silkspeed.com&gt;</FONT>
<BR><FONT SIZE=2>&gt; Sent: 2003-03-18</FONT>
<BR><FONT SIZE=2>&gt; To: hibernate-devel@lists.sourceforge.net</FONT>
<BR><FONT SIZE=2>&gt; Subject: Re: [Hibernate] automatic db creation</FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; &gt; </FONT>
<BR><FONT SIZE=2>&gt; &gt; </FONT>
<BR><FONT SIZE=2>&gt; &gt; Yes - and that is that such an &quot;reliable
runtime update&quot; </FONT>
<BR><FONT SIZE=2>&gt; really has to be</FONT>
<BR><FONT SIZE=2>&gt; &gt; smart :)</FONT>
<BR><FONT SIZE=2>&gt; &gt; And I would like to hear how reliable such
a tool can be ?</FONT>
<BR><FONT SIZE=2>&gt; &gt; It seems as an almost unsolvable problem to
me :)</FONT>
<BR><FONT SIZE=2>&gt; &gt; </FONT>
<BR><FONT SIZE=2>&gt; &gt; /max</FONT>
<BR><FONT SIZE=2>&gt; &gt; </FONT>
<BR><FONT SIZE=2>&gt; &gt; </FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; Your correct that it is a tough problem given the lack
of </FONT>
<BR><FONT SIZE=2>&gt; features and </FONT>
<BR><FONT SIZE=2>&gt; standardization across the database engines with respect
to </FONT>
<BR><FONT SIZE=2>&gt; &quot;alter table&quot;.</FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; However, the 90% use case is &quot;add a new table&quot;
or &quot;add a new column&quot; </FONT>
<BR><FONT SIZE=2>&gt; which most vendors do support.&nbsp; So, a first
cut for the smart-update </FONT>
<BR><FONT SIZE=2>&gt; is that it solves the problem or is smart enough to
know that </FONT>
<BR><FONT SIZE=2>&gt; it can't </FONT>
<BR><FONT SIZE=2>&gt; solve the problem and tells you that it can't.</FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; In the role of pushing out production code to customers,
I will know </FONT>
<BR><FONT SIZE=2>&gt; if the upgrade is one that can be handled by smart-update
or not.&nbsp; If </FONT>
<BR><FONT SIZE=2>&gt; it can, I just give them new code without having to
give them a </FONT>
<BR><FONT SIZE=2>&gt; separate database update script, procedures for running
it, and the </FONT>
<BR><FONT SIZE=2>&gt; involvement of their expensive DB admin.&nbsp; I
have a solution like this </FONT>
<BR><FONT SIZE=2>&gt; in my own home-grown BMP persistence engine which has
allowed me to </FONT>
<BR><FONT SIZE=2>&gt; just send new &quot;.ear&quot; files to my customers
for years without them </FONT>
<BR><FONT SIZE=2>&gt; having to know that a database schema change occurred.&nbsp;
I'm hoping to </FONT>
<BR><FONT SIZE=2>&gt; be able to use Hibernate just as transparently.</FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; The post regarding the Eclipse Plugin is great news
for </FONT>
<BR><FONT SIZE=2>&gt; developers but </FONT>
<BR><FONT SIZE=2>&gt; doesn't help the end customer that is receiving a bundle
of software </FONT>
<BR><FONT SIZE=2>&gt; that they need to install.&nbsp; Maybe I have the
odd case here because I </FONT>
<BR><FONT SIZE=2>&gt; ship applications which end-users install and manage.&nbsp;
My developers </FONT>
<BR><FONT SIZE=2>&gt; are not the ones doing production installation.</FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; -- </FONT>
<BR><FONT SIZE=2>&gt; Aaron Metzger</FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; -------------------------------------------------------</FONT>
<BR><FONT SIZE=2>&gt; This SF.net email is sponsored by: Does your code think
in ink? </FONT>
<BR><FONT SIZE=2>&gt; You could win a Tablet PC. Get a free Tablet PC hat
just for playing. </FONT>
<BR><FONT SIZE=2>&gt; What are you waiting for?</FONT>
<BR><FONT SIZE=2>&gt; <A HREF="http://ads.sourceforge.net/cgi-bin/redirect.pl?micr5043en"
TARGET="_blank">http://ads.sourceforge.net/cgi-bin/redirect.pl?micr5043en</A></FONT>
<BR><FONT SIZE=2>&gt; _______________________________________________</FONT>
<BR><FONT SIZE=2>&gt; hibernate-devel mailing list</FONT>
<BR><FONT SIZE=2>&gt; hibernate-devel@lists.sourceforge.net</FONT>
<BR><FONT SIZE=2>&gt; <A HREF="https://lists.sourceforge.net/lists/listinfo/hibernate-devel"
TARGET="_blank">https://lists.sourceforge.net/lists/listinfo/hibernate-devel</A></FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; -------------------------------------------------------</FONT>
<BR><FONT SIZE=2>&gt; This sf.net email is sponsored by:ThinkGeek</FONT>
<BR><FONT SIZE=2>&gt; Welcome to geek heaven.</FONT>
<BR><FONT SIZE=2>&gt; <A HREF="http://thinkgeek.com/sf" TARGET="_blank">http://thinkgeek.com/sf</A></FONT>
<BR><FONT SIZE=2>&gt; _______________________________________________</FONT>
<BR><FONT SIZE=2>&gt; hibernate-devel mailing list</FONT>
<BR><FONT SIZE=2>&gt; hibernate-devel@lists.sourceforge.net</FONT>
<BR><FONT SIZE=2>&gt; <A HREF="https://lists.sourceforge.net/lists/listinfo/hibernate-devel"
TARGET="_blank">https://lists.sourceforge.net/lists/listinfo/hibernate-devel</A></FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; This mail has originated outside your organization,</FONT>
<BR><FONT SIZE=2>&gt; either from an external partner or the Global Internet.
</FONT>
<BR><FONT SIZE=2>&gt; Keep this in mind if you answer this message.</FONT>
<BR><FONT SIZE=2>&gt; </FONT>
</P>

</BODY>
</HTML>

Mime
View raw message