From graffito-dev-return-168-apmail-incubator-graffito-dev-archive=www.apache.org@incubator.apache.org Thu Apr 07 20:48:26 2005 Return-Path: Delivered-To: apmail-incubator-graffito-dev-archive@www.apache.org Received: (qmail 15402 invoked from network); 7 Apr 2005 20:48:26 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 7 Apr 2005 20:48:26 -0000 Received: (qmail 92614 invoked by uid 500); 7 Apr 2005 20:48:26 -0000 Mailing-List: contact graffito-dev-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: graffito-dev@incubator.apache.org Delivered-To: mailing list graffito-dev@incubator.apache.org Received: (qmail 92600 invoked by uid 99); 7 Apr 2005 20:48:26 -0000 X-ASF-Spam-Status: No, hits=-10.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from minotaur.apache.org (HELO [127.0.0.1]) (209.237.227.194) by apache.org (qpsmtpd/0.28) with ESMTP; Thu, 07 Apr 2005 13:48:24 -0700 Message-ID: <42559C96.90104@sword-technologies.com> Date: Thu, 07 Apr 2005 22:48:22 +0200 From: Christophe Lombart User-Agent: Mozilla Thunderbird 0.9 (Windows/20041103) X-Accept-Language: en-us, en MIME-Version: 1.0 To: graffito-dev@incubator.apache.org Subject: Re: Getting Graffito to work with Jetspeed-2-M2 and Oracle9i References: <4253EDBD.5000208@douma.nu> In-Reply-To: <4253EDBD.5000208@douma.nu> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Ate Douma wrote: > Hello Team, > > I thought I'd like to see how Graffito was progressing and started > building it this morning > while trying to get it to work with Oracle9i (my primary db) and the > new Jetspeed-2.0-M2. > > Well, that took some time... > I'd like to help out with the project and can provide numerous > fixes/patches but my time > for today is already running out (I've hacked my way through getting > it to work, my changes > need cleanup before they can be committed). > > But, I'd like to mention a few of the issues I encountered: > > - Mapping java.sql.Date/java.util.Date to SQL TIMESTAMP fails on > Oracle (ClassCastException) > CmsObject.creationDate and CmsObject.lastModified are mapped as > TIMESTAMP but in the java > implementation they are defined as java.util.Date. > And in several locations these are furthermore filled with > java.sql.Date instances. > As I expect you would like to store the full time part I modified > the CmsObject interface > to use java.sql.Timestamp for these fields instead (and adjusted all > usages accordingly) Code has been updated > - Blob usage on Oracle > OJB 1.0.1 doesn't handle Blob fields on Oracle. I've upgraded to OJB > 1.0.2 (1.0.3 doesn't > work with the version of Spring used for Graffito). project has been updated to use OJB 1.0.2 et Spring 1.1.5. David, can you add OJB 1.0.2 in your maven repo. it is not present in the ASF maven repo. > - Mapping of CmsObject.owner and CmsObject.language are defined > required in the schema but > not always filled in in the testcases. As I didn't think it should > be required I made them > optional (wondering how you can get past this on mysql though) Can you give more info ? which unit test ? I tested with TestContentModelService. If I drop setter methods for owner & language, this unit test failed. FYI, I want to make a proposal to change a little bit the Graffito object model to gives more flexibility and build custom model depending on the application needs. > - project/build.properties are not complete. I was missing the > following properties in the > sample-build.properties (but they are included in > site/build.properties.txt): > org.apache.portals.graffito.database.ojb.plateform (note the > typing error for platform) > org.apache.portals.graffito.database.ojb.datasource > Typing error fixed. Drop duplicated file : sample-build.properties. trunk/site/xdoc/build.properties.txt is the correct one (used to build the Graffito site) . Graffito site will be updated. Let me know if you still have some issues. Thanks, Christophe