OfBiz NewBie User

[eric]

Hi, please help me along. I use admin/ofbiz to play around. But each time I
created website/catalog/category/product, I cannot delete it.

How to delete those I created to test?

 

How to delete demo data because I want to build my own
catalog->category->product?

 

Is there a superuser for this purpose?

 

Another issue is when I decided to use Oracle DB for OfBiz, do I need 3
instances for olap, tenant and ordinary datastructure?

 

 

Best Regards

Eric Halim

 



---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com

[Rong Nguyen]

Hi Eric,
 -  You can not delete them. If you really want to delete, try with sql(you can search the previous topic). With current implement of OFBiz, you just disable them by changing ThruDate or don't assign product(category or catalog) to any category(catalog, store).
 -  In Oracle DB, you just create 3 users(3 default schemas will be created), don't need 3 Oracle instances.

[eric]

Dear Rong Nguyen,

Thanks. What are those 3 users in Oracle? Currently, I just using 1 schema.

Best Regards
Eric Halim

-----Original Message-----
From: Rong Nguyen [mailto:[hidden email]]
Sent: Monday, April 07, 2014 4:14 PM
To: [hidden email]
Subject: Re: OfBiz NewBie User

Hi Eric,
 -  You can not delete them. If you really want to delete, try with sql(you
can search the previous topic). With current implement of OFBiz, you just
disable them by changing ThruDate or don't assign product(category or
catalog).
 -  In Oracle DB, you just create 3 users(3 default schemas will be
created), don't need 3 Oracle instances.



-----
Rong Nguyen

Olbius JSC
Deliver highest business value
http://www.olbius.com/
--
View this message in context:
http://ofbiz.135035.n4.nabble.com/OfBiz-NewBie-User-tp4650234p4650236.html
Sent from the OFBiz - User mailing list archive at Nabble.com.


---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com

[Rong Nguyen]

hi Eric,
I mean 3 users(3 schemas will be created in Oracle), it will separate role between Tenant, olap and ordinary.
You can use only one, ok!

[eric]

Oh yes, but how to configure it using 3 users? Should we create 3 setups on
entityengine.xml?
Can you share the details?

Best Regards
Eric Halim


-----Original Message-----
From: Rong Nguyen [mailto:[hidden email]]
Sent: Monday, April 07, 2014 4:33 PM
To: [hidden email]
Subject: RE: OfBiz NewBie User

hi Eric,
I mean 3 users(3 schemas will be created in Oracle), it will separate role
between Tenant, olap and ordinary.
You can use only one, ok!



-----
Rong Nguyen

Olbius JSC
Deliver highest business value
http://www.olbius.com/
--
View this message in context:
http://ofbiz.135035.n4.nabble.com/OfBiz-NewBie-User-tp4650234p4650238.html
Sent from the OFBiz - User mailing list archive at Nabble.com.


---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com

[Rong Nguyen]

Take a look at entityengine.xml, it have predefined with some databases(include Oracle):
 <delegator name="default" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main" distributed-cache-clear-enabled="false">
        <group-map group-name="org.ofbiz" datasource-name="localderby"/>
        <group-map group-name="org.ofbiz.olap" datasource-name="localderbyolap"/>
        <group-map group-name="org.ofbiz.tenant" datasource-name="localderbytenant"/>
    </delegator>

You can define your Oracle's schema and replace your target Oracle's schema in datasource-name attribute.

[eric]

Yes sure, the delegator part I got it. But for the 3 schemas for
localoracle, localoracleolap and localoracletenant how would you set these?
How would these 3 differ in each other?

I only got this currently

<datasource name="localoracle"
            helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
            schema-name="OFBIZ"
            field-type-name="oracle"
            check-on-start="true"
            add-missing-on-start="true"
            alias-view-columns="false"
            join-style="ansi"
            use-order-by-nulls="true">
        <read-data reader-name="tenant"/>
        <read-data reader-name="seed"/>
        <read-data reader-name="seed-initial"/>
        <read-data reader-name="demo"/>
        <read-data reader-name="ext"/>
        <inline-jdbc
                jdbc-driver="oracle.jdbc.driver.OracleDriver"
                jdbc-uri="jdbc:oracle:thin:@127.0.0.1:1521:ORCL"
                jdbc-username="ofbiz"
                jdbc-password="ofbiz"
                pool-minsize="2"
                pool-maxsize="250"
                time-between-eviction-runs-millis="600000"/>
    </datasource>

What are those values would be differ for olap and tenant?

Thanks in advance.

Best Regards
Eric Halim


-----Original Message-----
From: Rong Nguyen [mailto:[hidden email]]
Sent: Monday, April 07, 2014 4:46 PM
To: [hidden email]
Subject: RE: OfBiz NewBie User

Take a look at entityengine.xml, it have predefined with some
databases(include Oracle):
 <delegator name="default" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
distributed-cache-clear-enabled="false">
        <group-map group-name="org.ofbiz" datasource-name="localderby"/>
        <group-map group-name="org.ofbiz.olap"
datasource-name="localderbyolap"/>
        <group-map group-name="org.ofbiz.tenant"
datasource-name="localderbytenant"/>
    </delegator>

You can define your Oracle's schema and replace your target Oracle's schema
in datasource-name attribute.



-----
Rong Nguyen

Olbius JSC
Deliver highest business value
http://www.olbius.com/
--
View this message in context:
http://ofbiz.135035.n4.nabble.com/OfBiz-NewBie-User-tp4650234p4650240.html
Sent from the OFBiz - User mailing list archive at Nabble.com.


---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com

[Rong Nguyen]

You have ORCL instance,
Now, you define 3 datasources:
  + <datasource name="origin_oracle" with user_origin
  + <datasource name="olap_oracle" with user_olap
  + <datasource name="tenant_oracle" with user_tenant
and then map them in delegator section:
        <group-map group-name="org.ofbiz" datasource-name="origin_oracle"/>
        <group-map group-name="org.ofbiz.olap" datasource-name="olap_oracle"/>
        <group-map group-name="org.ofbiz.tenant" datasource-name="tenant_oracle"/>

[eric]

Thanks. What about jdbc uri? The sample given on localderby, they have
differences on jdbc uri.
Is it fine to give same jdbc uri for Oracle in this case for all 3 schemas?

Best Regards
Eric Halim


-----Original Message-----
From: Rong Nguyen [mailto:[hidden email]]
Sent: Monday, April 07, 2014 5:02 PM
To: [hidden email]
Subject: RE: OfBiz NewBie User

You have ORCL instance,
Now, you define 3 datasources:
  + <datasource name=&quot;origin_oracle&quot; with user_origin
  + &lt;datasource name=&quot;olap_oracle&quot; with user_olap
  + &lt;datasource name=&quot;tenant_oracle&quot; with user_tenant and then
map them in delegator section:
        &lt;group-map group-name=&quot;org.ofbiz&quot;
datasource-name=&quot;origin_oracle&quot;/>
        <group-map group-name="org.ofbiz.olap"
datasource-name="olap_oracle"/>
        <group-map group-name="org.ofbiz.tenant"
datasource-name="tenant_oracle"/>






-----
Rong Nguyen

Olbius JSC
Deliver highest business value
http://www.olbius.com/
--
View this message in context:
http://ofbiz.135035.n4.nabble.com/OfBiz-NewBie-User-tp4650234p4650242.html
Sent from the OFBiz - User mailing list archive at Nabble.com.


---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com

[Rong Nguyen]

hi Eric,
In Oracle:
 - URI to connect to instance.
 - User will define schema.

[eric]

Thanks for your explanation.

Best Regards
Eric Halim

On Apr 7, 2014 5:25 PM, Rong Nguyen <[hidden email]> wrote:

>
> hi Eric,
> In Oracle:
> - URI to connect to instance.
> - User will define schema.
>
>
>
>
> -----
> Rong Nguyen
>
> Olbius JSC
> Deliver highest business value
> http://www.olbius.com/ 
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/OfBiz-NewBie-User-tp4650234p4650244.html 
> Sent from the OFBiz - User mailing list archive at Nabble.com.

[eric]

Hi Rong Nguyen,

What are plus and minus having separate schema for olap, tenant and standard compared to whole into 1 schema?

Thanks.

Best Regards
Eric Halim

On Apr 7, 2014 5:25 PM, Rong Nguyen <[hidden email]> wrote:

>
> hi Eric,
> In Oracle:
> - URI to connect to instance.
> - User will define schema.
>
>
>
>
> -----
> Rong Nguyen
>
> Olbius JSC
> Deliver highest business value
> http://www.olbius.com/ 
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/OfBiz-NewBie-User-tp4650234p4650244.html 
> Sent from the OFBiz - User mailing list archive at Nabble.com.

[Rong Nguyen]

Hi Eric,
 1. Multi-tenancy is the ability to run separate data instances (tenants) from a single copy of OFBiz
 2. OLAP: online analytic processing(see more details at BI component)

See also:
http://ofbiz.135035.n4.nabble.com/What-is-OLAP-database-td4639171.html
https://cwiki.apache.org/confluence/display/OFBIZ/Multitenancy+support

[eric]

Thank You for the links Rong Nguyen.

But what I want to know is that any concern/impact if we choose only use 1
schema for all instead separating those schema respectively?

Do OLAP and Multi Tenant feature are automatically enabled when first
installing OfBiz?
I mean when we only specify 1 schema for all 3 delegators, would OLAP and
Multi Tenant also available?
Or we must separate those 3 schemas to make OLAP and Multi Tenant works?

Sorry if I asked too many questions.

Best Regards
Eric Halim


-----Original Message-----
From: Rong Nguyen [mailto:[hidden email]]
Sent: Tuesday, April 08, 2014 7:50 AM
To: [hidden email]
Subject: RE: OfBiz NewBie User

Hi Eric,
 1. Multi-tenancy is the ability to run separate data instances (tenants)
from a single copy of OFBiz  2. OLAP: online analytic processing(see more
details at BI component)

*See also:*
http://ofbiz.135035.n4.nabble.com/What-is-OLAP-database-td4639171.html
https://cwiki.apache.org/confluence/display/OFBIZ/Multitenancy+support



-----
Rong Nguyen

Olbius JSC
Deliver highest business value
http://www.olbius.com/
--
View this message in context:
http://ofbiz.135035.n4.nabble.com/OfBiz-NewBie-User-tp4650234p4650257.html
Sent from the OFBiz - User mailing list archive at Nabble.com.


---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com

[Rong Nguyen]

I don't have enough experiment in this area, sorry :-)

[eric]

It's ok. You have been very helpful. Hope somebody else could answer me.

Best Regards
Eric Halim


-----Original Message-----
From: Rong Nguyen [mailto:[hidden email]]
Sent: Tuesday, April 08, 2014 9:38 AM
To: [hidden email]
Subject: RE: OfBiz NewBie User

I don't have enough experiment in this area, sorry :-)



-----
Rong Nguyen

Olbius JSC
Deliver highest business value
http://www.olbius.com/
--
View this message in context:
http://ofbiz.135035.n4.nabble.com/OfBiz-NewBie-User-tp4650234p4650261.html
Sent from the OFBiz - User mailing list archive at Nabble.com.


---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com

[Jacques Le Roux]

Le 08/04/2014 03:55, Eric Halim a écrit :
> Thank You for the links Rong Nguyen.
>
> But what I want to know is that any concern/impact if we choose only use 1
> schema for all instead separating those schema respectively?
>
> Do OLAP and Multi Tenant feature are automatically enabled when first
> installing OfBiz?

It depends on what you mean by "automatically enabled"
For BI as a demo you need to get to he BI component and populate the DB (else for instance reports generated by BIRT will not work)

For multi tenant, refer to https://cwiki.apache.org/confluence/display/OFBIZ/Multitenancy+support (OK I see  now Rong gave you this one already)

> I mean when we only specify 1 schema for all 3 delegators, would OLAP and
> Multi Tenant also available?
> Or we must separate those 3 schemas to make OLAP and Multi Tenant works?

There are good reasons to separate schemas.
For multi tenant it must be to guarantee confidentiality (you even need to create new DB for each new tenant)
For BI it's a matter of performance look for "oltp and olap on same server" on the net

Jacques

>
> Sorry if I asked too many questions.
>
> Best Regards
> Eric Halim
>
>
> -----Original Message-----
> From: Rong Nguyen [mailto:[hidden email]]
> Sent: Tuesday, April 08, 2014 7:50 AM
> To: [hidden email]
> Subject: RE: OfBiz NewBie User
>
> Hi Eric,
>   1. Multi-tenancy is the ability to run separate data instances (tenants)
> from a single copy of OFBiz  2. OLAP: online analytic processing(see more
> details at BI component)
>
> *See also:*
> http://ofbiz.135035.n4.nabble.com/What-is-OLAP-database-td4639171.html
> https://cwiki.apache.org/confluence/display/OFBIZ/Multitenancy+support
>
>
>
> -----
> Rong Nguyen
>
> Olbius JSC
> Deliver highest business value
> http://www.olbius.com/
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/OfBiz-NewBie-User-tp4650234p4650257.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>
> ---
> This email is free from viruses and malware because avast! Antivirus protection is active.
> http://www.avast.com
>
>

--

[Jaya Melon]

hi Eric,

if you want to have multi-tenant, try ant load-demo-multitenant and then
ant start.
then look to your DB to see the differences.

best regards,
Johnson Chandra



On Sat, Apr 12, 2014 at 7:04 PM, Jacques Le Roux <
[hidden email]> wrote:

>
> Le 08/04/2014 03:55, Eric Halim a écrit :
>
>  Thank You for the links Rong Nguyen.
>>
>> But what I want to know is that any concern/impact if we choose only use 1
>> schema for all instead separating those schema respectively?
>>
>> Do OLAP and Multi Tenant feature are automatically enabled when first
>> installing OfBiz?
>>
>
> It depends on what you mean by "automatically enabled"
> For BI as a demo you need to get to he BI component and populate the DB
> (else for instance reports generated by BIRT will not work)
>
> For multi tenant, refer to https://cwiki.apache.org/
> confluence/display/OFBIZ/Multitenancy+support (OK I see  now Rong gave
> you this one already)
>
>
>  I mean when we only specify 1 schema for all 3 delegators, would OLAP and
>> Multi Tenant also available?
>> Or we must separate those 3 schemas to make OLAP and Multi Tenant works?
>>
>
> There are good reasons to separate schemas.
> For multi tenant it must be to guarantee confidentiality (you even need to
> create new DB for each new tenant)
> For BI it's a matter of performance look for "oltp and olap on same
> server" on the net
>
> Jacques
>
>
>
>> Sorry if I asked too many questions.
>>
>> Best Regards
>> Eric Halim
>>
>>
>> -----Original Message-----
>> From: Rong Nguyen [mailto:[hidden email]]
>> Sent: Tuesday, April 08, 2014 7:50 AM
>> To: [hidden email]
>> Subject: RE: OfBiz NewBie User
>>
>> Hi Eric,
>>   1. Multi-tenancy is the ability to run separate data instances (tenants)
>> from a single copy of OFBiz  2. OLAP: online analytic processing(see more
>> details at BI component)
>>
>> *See also:*
>> http://ofbiz.135035.n4.nabble.com/What-is-OLAP-database-td4639171.html
>> https://cwiki.apache.org/confluence/display/OFBIZ/Multitenancy+support
>>
>>
>>
>> -----
>> Rong Nguyen
>>
>> Olbius JSC
>> Deliver highest business value
>> http://www.olbius.com/
>> --
>> View this message in context:
>> http://ofbiz.135035.n4.nabble.com/OfBiz-NewBie-User-
>> tp4650234p4650257.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>>
>> ---
>> This email is free from viruses and malware because avast! Antivirus
>> protection is active.
>> http://www.avast.com
>>
>>
>>
> --
>

[eric]

Thank you

Best Regards
Eric Halim

-----Original Message-----
From: MelonJaya [mailto:[hidden email]]
Sent: Tuesday, April 22, 2014 2:39 PM
To: user
Subject: Re: OfBiz NewBie User

hi Eric,

if you want to have multi-tenant, try ant load-demo-multitenant and then ant start.
then look to your DB to see the differences.

best regards,
Johnson Chandra



On Sat, Apr 12, 2014 at 7:04 PM, Jacques Le Roux < [hidden email]> wrote:

>
> Le 08/04/2014 03:55, Eric Halim a écrit :
>
>  Thank You for the links Rong Nguyen.
>>
>> But what I want to know is that any concern/impact if we choose only
>> use 1 schema for all instead separating those schema respectively?
>>
>> Do OLAP and Multi Tenant feature are automatically enabled when first
>> installing OfBiz?
>>
>
> It depends on what you mean by "automatically enabled"
> For BI as a demo you need to get to he BI component and populate the
> DB (else for instance reports generated by BIRT will not work)
>
> For multi tenant, refer to https://cwiki.apache.org/
> confluence/display/OFBIZ/Multitenancy+support (OK I see  now Rong gave
> you this one already)
>
>
>  I mean when we only specify 1 schema for all 3 delegators, would OLAP
> and
>> Multi Tenant also available?
>> Or we must separate those 3 schemas to make OLAP and Multi Tenant works?
>>
>
> There are good reasons to separate schemas.
> For multi tenant it must be to guarantee confidentiality (you even
> need to create new DB for each new tenant) For BI it's a matter of
> performance look for "oltp and olap on same server" on the net
>
> Jacques
>
>
>
>> Sorry if I asked too many questions.
>>
>> Best Regards
>> Eric Halim
>>
>>
>> -----Original Message-----
>> From: Rong Nguyen [mailto:[hidden email]]
>> Sent: Tuesday, April 08, 2014 7:50 AM
>> To: [hidden email]
>> Subject: RE: OfBiz NewBie User
>>
>> Hi Eric,
>>   1. Multi-tenancy is the ability to run separate data instances
>> (tenants) from a single copy of OFBiz  2. OLAP: online analytic
>> processing(see more details at BI component)
>>
>> *See also:*
>> http://ofbiz.135035.n4.nabble.com/What-is-OLAP-database-td4639171.htm
>> l
>> https://cwiki.apache.org/confluence/display/OFBIZ/Multitenancy+suppor
>> t
>>
>>
>>
>> -----
>> Rong Nguyen
>>
>> Olbius JSC
>> Deliver highest business value
>> http://www.olbius.com/
>> --
>> View this message in context:
>> http://ofbiz.135035.n4.nabble.com/OfBiz-NewBie-User-
>> tp4650234p4650257.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>>
>> ---
>> This email is free from viruses and malware because avast! Antivirus
>> protection is active.
>> http://www.avast.com
>>
>>
>>
> --
>

---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com


--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

[Vijay Krishnamurthy]

Hello All Users/Developers,

Can any one suggest me does this application suits for my Transport
business?
I have few vehicles and I gives the renting and leased...
I need to track the vehicles, Staff and Drivers, invoices...

Please help me out this... Thanking You All..

Regards,
Vijay
On 4/22/2014 1:09 PM, MelonJaya wrote:

> hi Eric,
>
> if you want to have multi-tenant, try ant load-demo-multitenant and then
> ant start.
> then look to your DB to see the differences.
>
> best regards,
> Johnson Chandra
>
>
>
> On Sat, Apr 12, 2014 at 7:04 PM, Jacques Le Roux <
> [hidden email]> wrote:
>
>> Le 08/04/2014 03:55, Eric Halim a écrit :
>>
>>   Thank You for the links Rong Nguyen.
>>> But what I want to know is that any concern/impact if we choose only use 1
>>> schema for all instead separating those schema respectively?
>>>
>>> Do OLAP and Multi Tenant feature are automatically enabled when first
>>> installing OfBiz?
>>>
>> It depends on what you mean by "automatically enabled"
>> For BI as a demo you need to get to he BI component and populate the DB
>> (else for instance reports generated by BIRT will not work)
>>
>> For multi tenant, refer to https://cwiki.apache.org/
>> confluence/display/OFBIZ/Multitenancy+support (OK I see  now Rong gave
>> you this one already)
>>
>>
>>   I mean when we only specify 1 schema for all 3 delegators, would OLAP and
>>> Multi Tenant also available?
>>> Or we must separate those 3 schemas to make OLAP and Multi Tenant works?
>>>
>> There are good reasons to separate schemas.
>> For multi tenant it must be to guarantee confidentiality (you even need to
>> create new DB for each new tenant)
>> For BI it's a matter of performance look for "oltp and olap on same
>> server" on the net
>>
>> Jacques
>>
>>
>>
>>> Sorry if I asked too many questions.
>>>
>>> Best Regards
>>> Eric Halim
>>>
>>>
>>> -----Original Message-----
>>> From: Rong Nguyen [mailto:[hidden email]]
>>> Sent: Tuesday, April 08, 2014 7:50 AM
>>> To: [hidden email]
>>> Subject: RE: OfBiz NewBie User
>>>
>>> Hi Eric,
>>>    1. Multi-tenancy is the ability to run separate data instances (tenants)
>>> from a single copy of OFBiz  2. OLAP: online analytic processing(see more
>>> details at BI component)
>>>
>>> *See also:*
>>> http://ofbiz.135035.n4.nabble.com/What-is-OLAP-database-td4639171.html
>>> https://cwiki.apache.org/confluence/display/OFBIZ/Multitenancy+support
>>>
>>>
>>>
>>> -----
>>> Rong Nguyen
>>>
>>> Olbius JSC
>>> Deliver highest business value
>>> http://www.olbius.com/
>>> --
>>> View this message in context:
>>> http://ofbiz.135035.n4.nabble.com/OfBiz-NewBie-User-
>>> tp4650234p4650257.html
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>
>>>
>>> ---
>>> This email is free from viruses and malware because avast! Antivirus
>>> protection is active.
>>> http://www.avast.com
>>>
>>>
>>>
>> --
>>