AW: AW: [Objectbridge-developers] Q: How to setup the database?

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

Hi Ivan,

I found a way to use the ScriptTool to connect to a given Database with
username and password.

You have to edit the sql1.txt file as follows:
; First load the JDBC driver and open the demo-database.
d COM.ibm.db2.jdbc.app.DB2Driver;
o jdbc:db2:dbalias username password;

(this is a sample for DB 2).

Attached you find a modified sql1.txt that works fine with DB2. Maybe =
you
can try it with postgresql.

HTH

Thomas

> -----Urspr=FCngliche Nachricht-----
> Von: Mahler Thomas [mailto:tho...@it...]
> Gesendet: Mittwoch, 8. August 2001 11:36
> An: 'Ivan Toshkov'
> Cc: obj...@li...
> Betreff: AW: AW: [Objectbridge-developers] Q: How to setup=20
> the database?
>=20
>=20
> Hi Ivan,
>=20
> > -----Urspr=FCngliche Nachricht-----
> > Von: Ivan Toshkov [mailto:to...@cr...]
> > Gesendet: Mittwoch, 8. August 2001 10:50
> > An: Mahler Thomas
> > Cc: obj...@li...
> > Betreff: Re: AW: [Objectbridge-developers] Q: How to setup=20
> > the database?
> >=20
> >=20
> > Hi Mahler,
> >=20
> > Thanks for your help.
> >=20
> > I have some more questions, though.
> >=20
> > 1) How is the file `slq1.txt' generated?  Is there a way to=20
> > create such
> > file for other objects, as well?
>=20
> this file was written manually. it is used by the instantDB=20
> ScriptTool to
> perform database operations like creating tables and=20
> insertinmg test data.
>=20
> What "other objects" do you have in mind?
>=20
> >=20
> > 2) The setup[.bat] runs class=20
> > `org.enhydra.instantdb.ScriptTool', which
> > is obviously part of InstantDB. At least I couldn't find a=20
> way to set
> > the user and password properties and therefore couldn't use it with
> > postgresql.
>=20
> The documentation for the instantDB ScriptTool is here:
> http://www.lutris.com/products/projects/instantDB/software/doc
umentation/idb
4_0/sample-applications.html#scriptool

As far as I see, there is no option to specify  a user or password :-(
So you will have to write the DDL manually... Will not be too difficult =
for
just the two tables...=20

>=20
> I work on a web-based reservation system, using java=20
> servlets, jsps and
> xml/xslt. We have developed our own persistence layer, but it=20
> isn't too
> mature, yet. It supports only forward engineering and the=20
> developert has
> little or no control over the table structuring. I'm in a process of
> research for alternatives and I like the ObjectBridge very much.
>=20
> I will be very glad to contribute to the project.

You are welcome to contribute. OJB currently has no tools for forward- =
or
reverse engineering or graphically composing the O/R mappings. So your
know-how in this area will help a lot!

cheers,


Thomas

>=20
> Cheers,
> Ivan
>=20

_______________________________________________
Objectbridge-developers mailing list
Obj...@li...
http://lists.sourceforge.net/lists/listinfo/objectbridge-developers