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
first question is: is there an oracle DML provided to fill up the
database with some initial datas?
Anyway with these settings I obtain the error
SQL error 933 on /: ORA-00933: SQL command not properly ended
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)
Someone has succesfully installed the repo on oracle? Have I missed
some step?
I followed the steps described here[2].
Thanks for your help
Ciao,
--
Gian Carlo Pace
Sourcesense - making sense of Open Source (http://www.sourcesense.com)
Mobile : +39 3400638601
[1] http://www.hippocms.org/download/attachments/5392/
oracle_schema_slide.sql?version=2
[2] http://www.hippocms.org/display/CMS/Hippo+Repository+with+Oracle
+database
********************************************
Hippocms-dev: Hippo CMS development public mailinglist
