From graffito-dev-return-167-apmail-incubator-graffito-dev-archive=www.apache.org@incubator.apache.org Wed Apr 06 15:03:06 2005 Return-Path: Delivered-To: apmail-incubator-graffito-dev-archive@www.apache.org Received: (qmail 7468 invoked from network); 6 Apr 2005 15:03:06 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 6 Apr 2005 15:03:06 -0000 Received: (qmail 51279 invoked by uid 500); 6 Apr 2005 15:03:06 -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 51265 invoked by uid 99); 6 Apr 2005 15:03:06 -0000 X-ASF-Spam-Status: No, hits=0.1 required=10.0 tests=FORGED_RCVD_HELO X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from 212-233-9-146.IP-Pool.SDSL.tiscali.be (HELO bxl-exchange.bxl.cronos-technologies.com) (212.233.9.146) by apache.org (qpsmtpd/0.28) with ESMTP; Wed, 06 Apr 2005 08:03:04 -0700 Content-Class: urn:content-classes:message Subject: RE: Getting Graffito to work with Jetspeed-2-M2 and Oracle9i MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----_=_NextPart_001_01C53AB9.B86AF818" Date: Wed, 6 Apr 2005 17:02:58 +0200 X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 Message-ID: <1F7418B606BBE4478D5C5CA8D81D7CB902C162@bxl-exchange.bxl.cronos-technologies.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: <1F7418B606BBE4478D5C5CA8D81D7CB902C162@bxl-exchange.bxl.cronos-technologies.com> Thread-Topic: Getting Graffito to work with Jetspeed-2-M2 and Oracle9i thread-index: AcU6sl7JQ2q3cY9fTQ2ltAFHOtWxjQABlyP/ From: "LOMBART Christophe" To: X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N ------_=_NextPart_001_01C53AB9.B86AF818 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hi Ate,=20 I'm very happy to see you here. Welcome on board. I promise to see your issues ASAP (tommorow or maybe this evening). All = patches are welcome.=20 Concerning your question on the file system, you have to write a new = implementation for a ContentStore and create a new Server classes (based = on the server interface). We are starting some work on a JCR support. = So, in a such case, it should be possible to store on a fs.=20 Let me know if you need more info. Christophe=20 -----Original Message----- From: Ate Douma [mailto:ate@douma.nu] Sent: Wed 4/6/2005 4:10 PM To: graffito-dev@incubator.apache.org Cc:=09 Subject: Getting Graffito to work with Jetspeed-2-M2 and Oracle9i 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) - 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). - 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) - 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 I'll can try to provide patches for these if you want but it will have = to wait a bit because my client just informed me I'll have to fix a problem for one of their = developer teams. Don't know yet if that'll be resolved today or in a week time ;-) Anyway, I finally got Graffito up and running in Jetspeed-2.0-M2 and its = looks great! Congrats on that. My client might be interested in having it integrated in their J2 portal = so I might be working with/on Graffito much more soon. One thing I'm wondering about and I don't have the time anymore to look = into for now so maybe you can help me out here: will it be easy to store the Content separately in the filesystem = instead of the database? I know that might introduce problems with locking etc. but that aside, = will it be possible? Regards, Ate ------_=_NextPart_001_01C53AB9.B86AF818--