You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jdo-dev@db.apache.org by Craig Russell <Cr...@Sun.COM> on 2005/04/27 18:00:04 UTC
New Apache db project loosely coupled to Apache JDO
Hi Brian, Geir,
I'd like to start a sub-project that JDO needs but don't want to
develop it in Apache JDO, because it goes beyond JDO. It is a memory
model of relational database schema that can be used for O/R mapping
GUI applications for JDO and EJB3, as well as the runtime mapping.
Anyway, we could start building it in Apache JDO just because we have
the infrastructure in place, but would really like *not* to have any
JDO in the package name.
We would want to call it "org.apache.db.model" and put interfaces there
that could be reused by other projects.
I'd also like to have an alias for talking about the model in the
Apache DB group.
Any of this make sense?
Thanks,
Craig
Craig Russell
Architect, Sun Java Enterprise System http://java.sun.com/products/jdo
408 276-5638 mailto:Craig.Russell@sun.com
P.S. A good JDO? O, Gasp!
Re: New Apache db project loosely coupled to Apache JDO
Posted by Thomas Dudziak <to...@first.fhg.de>.
Craig Russell wrote:
> Hi Thomas,
>
> Just today I looked for something like the ddlutils at the apache db
> web site and came up dry. Thanks for the info.
You are right, the page is not yet linked to.
> We will be looking at this with keen interest, so let us know (via the
> alias of course) what it happening!
Actually the code is pretty stable already, there are only minor changes
(mostly missing unit tests and documentation) and enhancements (options
mostly, e.g. ascii or unicode database etc.). So please feel free to
play around with it.
I can also keep the jdo-dev list updated in case of major changes.
regards,
Tom
Re: New Apache db project loosely coupled to Apache JDO
Posted by Craig Russell <Cr...@Sun.COM>.
Hi Gianny,
What we want from the DBUtils is only the model of the database schema.
We want to be able to use the model to create mappings of persistent
instances to the database schema. We want to do this without having a
live connection to the database, but get all of the information
normally obtained via JDBC metadata calls.
I understand that Tranql includes a java representation of some of the
elements of a schema, but I consider that an implementation of a model.
I have looked at other database mapping implementations and all of them
that I looked at combine the java model with the database model. I'm
looking for a clean separation of: interfaces from implementation; and
mapping from database.
I'm looking for a component library that for example could generate DDL
from the model for any kind of database; represent the schema from an
existing database; migrate schema from one database to another;
generate a java object model from database schema; generate database
schema from a java object model; create a mapping between an object
model and a database schema, possibly suggesting changes to one side or
the other.
For the Apache JDO project, I envision using the database model mostly
for the mapping exercise, and then at runtime, telling Tranql what the
mapping is in order for it to handle the jdbc and caching issues.
Hope that helps,
Craig
On Apr 28, 2005, at 6:26 AM, Gianny Damour wrote:
> Hi Craig,
>
> Sorry to revive this rather old thread. Indeed, DBUtils seems to be
> very nice.
>
> I would like to know how you would like to use this tool in the
> context of Apache JDO: do you want to leverage it to have an in memory
> representation of a database? Do you want to use it to also handle
> database interactions?
>
> Please let me know what such a tool should do and I will tell you if
> TranQL can do it for you and submit some code to actually do it.
>
> Thanks,
> Gianny
>
> On 28/04/2005 4:25 AM, Craig Russell wrote:
>
>> Hi Thomas,
>>
>> Just today I looked for something like the ddlutils at the apache db
>> web site and came up dry. Thanks for the info.
>>
>> We will be looking at this with keen interest, so let us know (via
>> the alias of course) what it happening!
>>
>> Thanks,
>>
>> Craig
>
> <snip>
>
>
Craig Russell
Architect, Sun Java Enterprise System http://java.sun.com/products/jdo
408 276-5638 mailto:Craig.Russell@sun.com
P.S. A good JDO? O, Gasp!
Re: New Apache db project loosely coupled to Apache JDO
Posted by Gianny Damour <gi...@optusnet.com.au>.
Hi Craig,
Sorry to revive this rather old thread. Indeed, DBUtils seems to be very
nice.
I would like to know how you would like to use this tool in the context
of Apache JDO: do you want to leverage it to have an in memory
representation of a database? Do you want to use it to also handle
database interactions?
Please let me know what such a tool should do and I will tell you if
TranQL can do it for you and submit some code to actually do it.
Thanks,
Gianny
On 28/04/2005 4:25 AM, Craig Russell wrote:
> Hi Thomas,
>
> Just today I looked for something like the ddlutils at the apache db
> web site and came up dry. Thanks for the info.
>
> We will be looking at this with keen interest, so let us know (via the
> alias of course) what it happening!
>
> Thanks,
>
> Craig
<snip>
Re: New Apache db project loosely coupled to Apache JDO
Posted by Craig Russell <Cr...@Sun.COM>.
Hi Thomas,
Just today I looked for something like the ddlutils at the apache db
web site and came up dry. Thanks for the info.
We will be looking at this with keen interest, so let us know (via the
alias of course) what it happening!
Thanks,
Craig
On Apr 27, 2005, at 11:05 AM, Thomas Dudziak wrote:
> Brian McCallister wrote:
>
>> On Apr 27, 2005, at 12:54 PM, Michael Bouschen wrote:
>>
>>> Hi Brian,
>>>
>>> do you have a link to get more details about the DdlUtils stuff?
>>
>>
>> http://db.apache.org/ddlutils/
>
>
> DdlUtils and its site are freshly migrated, I need to update and
> enhance it in the next days. Feel free to register at the mailing
> lists:
>
> ddlutils-dev-subscribe@db.apache.org
> <ma...@db.apache.org>
> ddlutils-user-subscribe@db.apache.org
> <ma...@db.apache.org>
>
> FYI, one of the main purposes of the migration of commons-sql to
> db.apache.org is that Torque and OJB (and others) can create/maintain
> a common codebase for DDL-related stuff, e.g. working with a database
> schema in code, creating/altering/deleting/dumping this database
> schema etc.
>
> Tom
>
>
Craig Russell
Architect, Sun Java Enterprise System http://java.sun.com/products/jdo
408 276-5638 mailto:Craig.Russell@sun.com
P.S. A good JDO? O, Gasp!
Re: New Apache db project loosely coupled to Apache JDO
Posted by Thomas Dudziak <to...@first.fhg.de>.
Brian McCallister wrote:
> On Apr 27, 2005, at 12:54 PM, Michael Bouschen wrote:
>
>> Hi Brian,
>>
>> do you have a link to get more details about the DdlUtils stuff?
>
>
> http://db.apache.org/ddlutils/
DdlUtils and its site are freshly migrated, I need to update and enhance
it in the next days. Feel free to register at the mailing lists:
ddlutils-dev-subscribe@db.apache.org
<ma...@db.apache.org>
ddlutils-user-subscribe@db.apache.org
<ma...@db.apache.org>
FYI, one of the main purposes of the migration of commons-sql to
db.apache.org is that Torque and OJB (and others) can create/maintain a
common codebase for DDL-related stuff, e.g. working with a database
schema in code, creating/altering/deleting/dumping this database schema etc.
Tom
Re: New Apache db project loosely coupled to Apache JDO
Posted by Brian McCallister <br...@chariotsolutions.com>.
On Apr 27, 2005, at 12:54 PM, Michael Bouschen wrote:
> Hi Brian,
>
> do you have a link to get more details about the DdlUtils stuff?
http://db.apache.org/ddlutils/
-Brian
Re: New Apache db project loosely coupled to Apache JDO
Posted by Michael Bouschen <mb...@spree.de>.
Hi Brian,
do you have a link to get more details about the DdlUtils stuff?
Regards Michael
> Makes sense, and might overlap a lot with the DdlUtils stuff. I cc:ed
> Tom Dudziak who knows a lot about that project.
>
> -Brian
>
> On Apr 27, 2005, at 12:00 PM, Craig Russell wrote:
>
>> Hi Brian, Geir,
>>
>> I'd like to start a sub-project that JDO needs but don't want to
>> develop it in Apache JDO, because it goes beyond JDO. It is a memory
>> model of relational database schema that can be used for O/R mapping
>> GUI applications for JDO and EJB3, as well as the runtime mapping.
>>
>> Anyway, we could start building it in Apache JDO just because we have
>> the infrastructure in place, but would really like *not* to have any
>> JDO in the package name.
>>
>> We would want to call it "org.apache.db.model" and put interfaces
>> there that could be reused by other projects.
>>
>> I'd also like to have an alias for talking about the model in the
>> Apache DB group.
>>
>> Any of this make sense?
>>
>> Thanks,
>>
>> Craig
>>
>> Craig Russell
>> Architect, Sun Java Enterprise System http://java.sun.com/products/jdo
>> 408 276-5638 mailto:Craig.Russell@sun.com
>> P.S. A good JDO? O, Gasp!
>
--
Michael Bouschen Tech@Spree Engineering GmbH
mailto:mbo.tech@spree.de http://www.tech.spree.de/
Tel.:++49/30/235 520-33 Buelowstr. 66
Fax.:++49/30/2175 2012 D-10783 Berlin
Re: New Apache db project loosely coupled to Apache JDO
Posted by Brian McCallister <br...@apache.org>.
Makes sense, and might overlap a lot with the DdlUtils stuff. I cc:ed
Tom Dudziak who knows a lot about that project.
-Brian
On Apr 27, 2005, at 12:00 PM, Craig Russell wrote:
> Hi Brian, Geir,
>
> I'd like to start a sub-project that JDO needs but don't want to
> develop it in Apache JDO, because it goes beyond JDO. It is a memory
> model of relational database schema that can be used for O/R mapping
> GUI applications for JDO and EJB3, as well as the runtime mapping.
>
> Anyway, we could start building it in Apache JDO just because we have
> the infrastructure in place, but would really like *not* to have any
> JDO in the package name.
>
> We would want to call it "org.apache.db.model" and put interfaces
> there that could be reused by other projects.
>
> I'd also like to have an alias for talking about the model in the
> Apache DB group.
>
> Any of this make sense?
>
> Thanks,
>
> Craig
>
> Craig Russell
> Architect, Sun Java Enterprise System http://java.sun.com/products/jdo
> 408 276-5638 mailto:Craig.Russell@sun.com
> P.S. A good JDO? O, Gasp!