portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Atul Dambalkar <adamb...@cisco.com>
Subject Re: 1.3a2 release
Date Fri, 12 Oct 2001 19:15:50 GMT
At 03:18 PM 10/12/01 -0400, you wrote:
>Keep in mind that Jetspeed is distributed as a WAR file.  If their
>resulting class and jars are DBMS specific, then we will have to
>distribute a Jetspeed-oracle.war, Jetspeed-MySql.war, ... :(

No..it shouldn't be that way. That's why we need to merge Turbine-schema 
and db-psml-schema, as David said.

-Atul


>Paul Spencer
>
>Atul Dambalkar wrote:
> >
> > At 06:26 PM 10/11/01 -0700, you wrote:
> > >Atul,
> > >
> > >Im looking at the Peer classes that I generated for Hypersonic and Oracle.
> > >Except for the timestamp, the java source seems to be exactly the same.
> > >
> > >I think what needs to be added is a webapp/torque directory:
> > >
> > >webapp/torque
> > >     |-----database
> > >     |-----lib         (we can add the necessary jars to 
> jakarta-jetspeed/lib
> > >and drop this since many are common)
> > >     |-----schema      (has your dbpsml-schema.xml)
> >
> > I also found one problem with the generated SQL from Torque for Oracle.
> > Since, the schema defines Index and Unique constraint on same set of
> > columns. What Oracle does is, it automatically creates indexes on columns
> > with unique constraint and specifying another unique constraints on the
> > same set of columns, causes it to crib that the constraint on those columns
> > exists. I tried to look into SQL specs for Index and Unique constraints,
> > but couldn't find any semantics on unique constraint should be implemented
> > in relational databases. If its a generic feature of all the relational
> > databases to automatically generate indexes on columns with unique
> > constraints, we can slightly modify the schema to get rid of specific index
> > on same set of columns.
> >
> > >     |-----src         (the generated SQL for hypersonic, the default db -
> > >which will also exist in om)
> > >     |-----templates
> > >     |
> > >     build.properties
> > >     build.xml
> > >
> > >While we are doing this, we could also drop all the scripts in
> > >src/sql/external and add the turbine-schema.xml for turbine)
> > >In fact we could combine the two xml files.
> >
> > Yes..sounds perfect.
> >
> > Thanks for handling all that, David.
> >
> > -Atul
> >
> > >What do you think?
> > >
> > >
> > > > -----Original Message-----
> > > > From: David Sean Taylor [mailto:david@bluesunrise.com]
> > > > Sent: Thursday, October 11, 2001 9:12 AM
> > > > To: jetspeed-dev@jakarta.apache.org
> > > > Subject: RE: 1.3a2 release
> > > >
> > > >
> > > > > >3. Test and commit db-psml impl. from Atul, fix bug in
> > > > > profiler for db-psml
> > > > >
> > > > > Also, depending upon the database, how can we generate Peer
> > > > > classes for
> > > > > Db-Psml in the build system..? We need to work on that
> > > > aspect as well.
> > > > >
> > > >
> > > > Interesting, thats something I didn't know about Torque.
> > > > So the peer classes are actually different per database backend?
> > > > I don't think that I like that.
> > > >
> > > >
> > > > > >4. Update Configure How-to Guide
> > > > >
> > > > > Is that Update for db-psml How-to Guide as well?
> > > > >
> > > >
> > > > Yes, I will add that to the docs todo list :-)
> > > >
> > > >
> > > >
> > > >
> > > > ---------------------------------------------------------------------
> > > > To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
> > > > For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
> > > >
> > > >
> > >
> > >
> > >
> > >---------------------------------------------------------------------
> > >To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
> > >For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org


Mime
View raw message