Is there a reason why you tried to use org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager
instead of org.apache.jackrabbit.core.state.db.OraclePersistenceManager as PersistenceManager? You know, this has nothing to do with Magnolia, it is a jackrabbit issue. If this does not work, you should address this to the jackrabbit list. If it works, you are welcome to add a wiki page with your findings to http://wiki.magnolia.info ;-) Ralf -----Ursprüngliche Nachricht----- Von: [email protected] [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 4. August 2006 17:39 An: [email protected] Betreff: [magnolia-user] Magnolia 3.0 & Oracle: ORA-00902 Hi I'm trying to use Oracle RDBMS with Magnolia 3.0 RC2. The only thing I did was to configure the file system/persistence manager, in a new file I created (jackrabbit-oracle-search.xml): <FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem"> <param name="path" value="${wsp.home}/default" /> </FileSystem> <PersistenceManager class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager"> <param name="driver" value="oracle.jdbc.OracleDriver"/> <param name="url" value="jdbc:oracle:thin:@myserver:1521:mydb"/> <param name="user" value="myuser"/> <param name="password" value="password"/> <param name="schemaObjectPrefix" value="${wsp.name}_"/> <param name="externalBLOBs" value="false"/> </PersistenceManager> But, when magnolia is booting, it's trying to create its schema, tables, and stuff, and then it breaks and throw this exception: javax.jcr.RepositoryException: Cannot instantiate persistence manager org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager: ORA-00902: invalid datatype : ORA-00902: invalid datatype Is there anything else I need to do to make it work? Thanx, JS. ---------------------------------------------------------------- for list details see http://www.magnolia.info/en/magnolia/developer.html ----------------------------------------------------------------
