Dave, Thanks for the help and now I've got a working copy. You were correct that the 'creator' field was missing from the 'website' table, but I didn't notice any errors when the Roller tables were created. I think this is because they were created using the Oracle version of the scripts that came with the Roller 4 download on http://roller.apache.org/downloads.html. I checked the scripts and the 'creator' field is not included in the 'create table website' script.
There are no Oracle version scripts with the current download from the roller/tag/roller_4.0 - final Roller 4.0 release in the repositry at http://cwiki.apache.org/confluence/display/ROLLER/Roller+Source+Code John. -----Original Message----- From: Dave [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2008 8:50 PM To: [email protected] Subject: Re: Weblogger initialization failed On Fri, Mar 7, 2008 at 10:40 AM, John Langan <[EMAIL PROTECTED]> wrote: > Version: Roller 4.0 > Application Server: Glassfish V2 (Sun Java System Application Server 9.1_01 > (build b09d-fcs)) > Database: Oracle 10g > Java: Java 6 update 4 > OS: Windows XP > > I downloaded the Roller source this morning into a sub-directory named roller > svn co https://svn.apache.org/repos/asf/roller/trunk roller First of all, unless you're getting ready to help work on Roller 4.1 (which would be great) you should probably stick to the official Apache Roller 4.0 release. > org.apache.roller.weblogger.business.WebloggerImpl.initialize(WebloggerImpl. > java:341) > --- ROOT CAUSE --- > <0.9.7-incubating nonfatal general error> > org.apache.openjpa.persistence.PersistenceException: ORA-00904: > "T1"."CREATOR": invalid identifier > {prepstmnt 3814511 SELECT t0.id, t0.autoenabled, t0.conditioncode, ... > t4.pagemodels, t4.showalllangs, t4.timeZone, t4.weblogdayid, t1.creator, ... > t1.weblogdayid FROM pingtarget t0, website t1, weblogcategory t2, > Any help on overcoming this problem would be appreciated. Based on that, it appears that the 'creator' field is missing from the 'website' table. Did you notice any errors when the Roller tables were created? - Dave
