I fix my mistake, new one become to:
<delegator name="test" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main">
<group-map group-name="org.apache.ofbiz" datasource-name="localoracle"/>
</delegator>
but still error.
________________________________
From: Donhu Vy <[email protected]>
Sent: Wednesday, June 28, 2017 10:01:27 AM
To: [email protected]
Subject: Re: How to config OFBiz works with Oracle database 11g express?
Thank Rishi Solanki,
I uninstall Oracle 11g, then install 12cR2.
I use Oracle 12cR2 at local (Windows 10 pro x64). I added ojdbc7.jar to
\apache-ofbiz-16.11.02\lib folder.
I create use: ofbiz, password: 123456, SID: orcl.
This is my entityengine.xml
https://gist.github.com/donhuvy/2f21708851eb768259a9fd0873862ccd
This is CMD console:
https://gist.githubusercontent.com/donhuvy/46a78306d81c111cec0690080f3ca8e9/raw/086a4a16c0e5bd3cf9c8a027f8fc31042e53cbad/cmd.log
How to fix it?
________________________________
From: Rishi Solanki <[email protected]>
Sent: Wednesday, June 21, 2017 3:28:54 PM
To: ofbizuser
Subject: Re: How to config OFBiz works with Oracle database 11g express?
You can use localoracle and ignore the other one. Note that it will have
the jdbc driver mentioned as jdbc-driver="oracle.jdbc.driver.OracleDriver"
also you need to put the oracle jar (compatible ojdbc jar) file in the lib
folder same as you put for the mysql.
Finally add <group-map group-name="org.ofbiz"
datasource-name="localoracle"/> with ofbiz entity group. You can create
update and delete in oracle db from OFBiz for all the entities available in
org.ofbiz.
HTH!
Rishi Solanki
Manager, Enterprise Software Development
HotWax Systems Pvt. Ltd.
Direct: +91-9893287847
http://www.hotwaxsystems.com
On Wed, Jun 21, 2017 at 9:29 AM, Donhu Vy <[email protected]> wrote:
> I face a hard task. I have been already connect OFBiz with MySQL database
> success. I try to connect OFBiz with Oracle datatabase 11g express.
>
>
> I config in file \framework\entity\config\entityengine.xml
>
>
> With MySQL, I have 3 datasources: localmysql, localmysqlolap,
> localmysqltenant.
>
> But with Oracle, I see 2 datasources: localoracle, localoracledd.
>
>
> I don't know what is the purpose of localoracledd data source? How to
> adapt, when MySQL has 3 datasources while Oracle has 2 datasources, it is a
> mismatch point, and I don't know how to resolve problem.
>
>
> If you have exiting config for Oracle database, can you give it to me?
>
>
> Best regards,
>
>
> Vy
>
>
