[rules-users] How to change database configuration from derby to oracle?

[Michael Anstis]

HI Deepak,

You never did answer my question:

Can you create new rules when configured to use Oracle? If so your
configuration, I'd assume, to be correct. AFAIK the repository folder is
only relevant if you're using JCR's file-system storage - if configured to
use a database I doubt it has much relevance. So you'll need to export the
repository XML first (your comment above implied you know how) from Derby,
re-configure for Oracle and import.

With kind regards,

Mike

2011/7/6 Deepak Cherukuri <deepak.cherukuri at valuemomentum.biz>

> Dear All,****
>
> Firstly, before deploying the Drools guvnor in weblogic11g , I set the
> repository configuration in components.xml.below is the path i mentioned for
> repositoryConfiguration****
>
> <component name="repositoryConfiguration">
> <property name="homeDirectory">E:/GuvnorRepo/</property>****
>
> Deployed the Drools guvnor in weblogic11g , and in E drive GuvnorRepo
> folder has created with 3 sub folders workspaces,repository,version and
> repository.xml.
> Now i updated the repository.xml for changing the database from derby to
> oracle.
> Below are the changes
> <PersistenceManager
> class="org.apache.jackrabbit.core.persistence.bundle.OraclePersistenceManager">
>
> <param name="driver" value="oracle.jdbc.driver.OracleDriver"/>
> <param name="url" value="jdbc:oracle:thin:@rsa10gserver:1525:ifpub34"/>
> <param name="user" value="drools_repository"/>
> <param name="password" value="drools_repository"/>
> <param name="schema" value="oracle"/>
> <param name="schemaObjectPrefix" value="version_"/>
> <param name="tableSpace" value=""/>
> <param name="errorHandling" value=""/>
> </PersistenceManager>****
>
> Now i restarted the weblogic11g and it successfully deployed and entered
> into the login page and but i could not see any rules in the left navigation
> page.****
>
> Is there any other procedure rather than what I have done?****
>
> Whether I should import/export new repository.xml ?****
>
> Please help me regarding this.****
>
> ** **
>
> ** **
>
> *Thanks & Regards*
>
> * *
>
> *Deepak Cherukuri* | Software Engineer****
>
> Value Momentum Software Services Pvt Ltd(SEZUnit),****
>
> HitechCity2, Gachibowli(V)****
>
> Hyderabad 500 081****
>
> deepak.cherukuri at valuemomentum.biz ****
>
>  Cell: +91 95537 - 95999****
>
> http://www.valuemomentum.com****
>
> [image: cid:image003.jpg at 01CA595B.191D0A30]****
>
> ** **
>
> _______________________________________________
> rules-users mailing list
> rules-users at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20110706/6601e5b5/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 2669 bytes
Desc: not available
Url : http://lists.jboss.org/pipermail/rules-users/attachments/20110706/6601e5b5/attachment.jpe