OFBiz › OFBiz - User

How to config OFBiz works with Oracle database 11g express?

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

5 messages Options

Donhu Vy

How to config OFBiz works with Oracle database 11g express?

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

Rishi Solanki

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 <[hidden email]> 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
>
>

Donhu Vy

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 <[hidden email]>
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 <[hidden email]> wrote:

Donhu Vy

Re: How to config OFBiz works with Oracle database 11g express?

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 <[hidden email]>
Sent: Wednesday, June 28, 2017 10:01:27 AM
To: [hidden email]
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 <[hidden email]>
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 <[hidden email]> wrote:

Rishi Solanki

Re: How to config OFBiz works with Oracle database 11g express?

Please check which data base schema you are using and try to update entry
for that at entityengine.xml where you have added the data source entry for
oracle. In general everything looks correct and should work.

Also I see you have shared the datasource-name="localoracle" in email but
in your shared entity engine file you are using oralce as its value which
seems to be corrected.

From logs it seems that system is unable to find delegator name while
loading the entities. This is all from my side, in case still fail to
connect then do following;

1) Try to direct connect with oracle db schema you are using and check if
few entities are get created or not.
2) Read/Share the specific console logs when system creates the entities.

HTH!

Rishi Solanki
Sr Manager, Enterprise Software Development
HotWax Systems Pvt. Ltd.
Direct: +91-9893287847
http://www.hotwaxsystems.com

On Wed, Jun 28, 2017 at 8:36 AM, Donhu Vy <[hidden email]> wrote:

> 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 <[hidden email]>
> Sent: Wednesday, June 28, 2017 10:01:27 AM
> To: [hidden email]
> 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/086a4a16c0e5bd3cf9c8a027f8fc31
> 042e53cbad/cmd.log
>
> How to fix it?
>
> ________________________________
> From: Rishi Solanki <[hidden email]>
> 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 <[hidden email]> 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
> >
> >
>