AW: AW: [Objectbridge-developers] generating mapping files and da taba ses

[Mahler T. <tho...@it...>]

hi all,

> -----Urspr=FCngliche Nachricht-----
> Von: Ivan Toshkov [mailto:to...@cr...]
> Gesendet: Donnerstag, 23. August 2001 15:23
> An: Mahler Thomas
> Cc: 'Lasse Lindg=E5rd'; obj...@li...
> Betreff: Re: AW: [Objectbridge-developers] generating mapping=20
> files and
> databa ses
>=20
>=20
> On Thu, 2001-08-23 at 13:08, Mahler Thomas wrote:
> > 2. This has already been done by Ivan Toshkov. Just extract=20
> the attached zip
> > file into the ojb src directory.
> > Now you can use java ojb.broker.metadata repository.xml to=20
> generate the DDL
> > !!!
> Unfortunately, there isn't quite enough data in the=20
> repository.xml file
> to generate the correct SQL statements.  So far, I don't know when to
> generate 'NOT NULL' and the size of VARCHAR objects.
>=20
> So, perhaps we should add this data to the XML?
>=20

Yes I have been thinking in this direction too.


> (While on the subject, the repository.xml looks somewhat strange,
> because of the lack of naming convention. E.g. elements like
> FieldDescriptor, field.name and jdbc_type.
>=20
> I would personally like to see some of the fields, as attributes. For
> example, PrimaryKey could be an attribute to FieldDescriptor. This =
can
> be used to set a meeningfull default value in the DTD.)
>=20

Sure, the DTD is somewhat "homegrown". Any enhancements are =
appreciated!

> The second issue is with different syntax for the different=20
> DBMSes. IMO,
> the best way to do that is to support some kind of pluggable SQL
> generators, and I'll try to spend some time on this during the =
weekend
> (no promises, though :)).
>=20

There have already some request in this direction. SO I guess it's good =
to
have a look at this subject.

<thomas/>

>=20
> Cheers,
> Ivan
>=20