Gian Carlo Pace wrote: > Hi hippoers, > I got an issue in deploying a hippo repository on Oracle. I installed > the Oracle Express Edition on an Ubuntu box and I modified the > config/slide/definition.xml setting up and oracle database connection > > ... > > <nodestore classname="org.apache.slide.store.impl.rdbms.JDBCStore"> > <parameter > name="adapter">org.apache.slide.store.impl.rdbms.OracleRDBMSAdapter</parameter> > > <parameter > name="driver">oracle.jdbc.driver.OracleDriver</parameter> > <parameter > name="url">jdbc:oracle:thin:@192.168.221.240:1521:XE</parameter> > <parameter name="user">slide</parameter> > <parameter name="password">slide</parameter> > <parameter name="dbcpPooling">true</parameter> > <parameter name="maxPooledConnections">20</parameter> > <parameter name="compress">false</parameter> > </nodestore> > ... > > Finally I set up the database with the schema provided here [1]. The You can always find the latest version of the schema in svn [3]. (I don't think anything has change as of lately)
> first question is: is there an oracle DML provided to fill up the > database with some initial datas? No, we don't have such a thing. You will have to start with a "clean" repository and run the initialization tool [4]. > > Anyway with these settings I obtain the error > > SQL error 933 on /: ORA-00933: SQL command not properly ended This is a very generic oracle error. Which version of the repository and oracle driver are you using? You could try to use the trunk with the oracle 10g driver. > > And also > > 2008-01-04 06:35:56.167 ERROR fortress.system.command > Could not prepare ComponentHandler for: > nl.hippo.slide.repository.impl.SlideRepositoryImpl > org.apache.slide.structure.ObjectNotFoundException: No object found at > /actions/read > at > org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.retrieveObject(StandardRDBMSAdapter.java:313) This could be a result of the error above. > Someone has succesfully installed the repo on oracle? Have I missed some > step? Yes, we have many production installations running on oracle, although not on the Express Edition. > I followed the steps described here[2]. > Thanks for your help You're welcome ;) Regards, Bart [3] http://svn.hippocms.org/viewvc/hippo-repository/trunk/server/src/config/slide/OracleSchema.sql [4] http://wiki.hippo.nl/display/CMS/Initializing+the+Hippo+Repository -- Hippo Oosteinde 11 1017WT Amsterdam The Netherlands Tel +31 (0)20 5224466 ------------------------------------------------------------- [EMAIL PROTECTED] / http://www.hippo.nl -------------------------------------------------------------- ******************************************** Hippocms-dev: Hippo CMS development public mailinglist
