Re: Mapping Derby Sample Data Foreign Keys

[Michael Brohl]

Why don't you just configure OFBiz to use your Postgres database and load the 
demo data the same way you did with the embedded Derby database?

Your approach seems to be overly complicated to me (or I am missing something).



> Am 08.06.2017 um 23:08 schrieb stim...@comcast.net:
> 
> Hi,
> 
> I do have that book which explains concepts, but currently I am trying to 
> make the existing system's WebPOS work...versus extending, customizing, or 
> adding to the existing system. The book has no concept of how the OfBiz 
> interface itself is arranged. I need a working WebPOS, which means I need to 
> be able to enter data for POS terminals and stores, but there is no web 
> interface for this. Thus the route of trying to edit sample data and transfer 
> it over to my PostgreSQL database instead of Derby.
> 
> The OfBizDatamodelBook charts are indeed something like what I want, but I 
> need it in a form where I can use tools to automate tasks based on query of 
> an existing Derby database and copy to PostgreSQL. Someone made a very nice 
> chart of account relationships, but the PDF is for human-readable form and 
> may not reflect changes and other details of the actual database (for example 
> the chart does not know about automatic sequences for generating various 
> keys...a database query may be able to take this into account and simple copy 
> of data from one database to another results in an error).
> 
> In terms of using the web tools with copy and paste to load data I have tried 
> this unsuccessfully. The time it takes to make attempts is extreme and error 
> messages do not necessarily point out what needs to be loaded for a given 
> failure to be fixed. Here are some points about the web tool copy and paste 
> method:
> 
> 1. Many XML documents have a root tag of "". This requires 
> editing the XML files and removing the "" (you can't paste 
> "" within ""). This isn't too bad of an 
> issue, but it slows things down (especially if it is a large file and you are 
> skipping open/close tags via scrolling around in an editor). Sometimes java 
> errors are so long that the pop-up showing them is not capable of displaying 
> on a large monitor (though log files do not have this limitation).
> 
> 2. Some tables (many) have a foreign key and produce an error if the foreign 
> table does not already have an entry. There are also cases where a column in 
> a foreign table is copied during insert, but the value is allowed to be 
> null...I worry that no error would be generated if the foreign key is there 
> but the data for the null column has not yet been populated. Those columns 
> pulling data from another table where null is allowed may change whether the 
> data is valid but will never produce an error (copy by value). I see a SQL 
> query as a programmatic way to be certain columns which can be null will 
> always be loaded from a parent table which has had the maximum opportunity to 
> be populated before using that parent.
> 
> 3. In some cases I am going to be copying from Derby to PostgreSQL. 
> SQuirrel-sqL has a tool for this, but the tool does not deal well with keys 
> which have been generated using different methods between the different 
> databases. This is a particular case of the above mentioned need to be able 
> to see generated values.
> 
> I have tried for a long time, with many hours per day, to come up with a 
> simpler solution for getting WebPOS working (including mouse copy and paste, 
> then command line XML file loads). Then I tried for quite some time to be 
> able to get the Derby demo data into PostgreSQL using simpler tools and 
> methods...once again without success. I am positive that if I have detailed 
> access to both the demo database under Derby and to the database under 
> PostgreSQL that I can guarantee certain qualities during copy. Once I can do 
> that I can investigate editing the data for replacing some demo data with a 
> real world store. I do not yet know how to create the missing interface for 
> populating WebPOS, so I am limited to this route...once I can do this and 
> understand it I can work on modifying or customizing OfBiz to include an 
> interface for avoiding all of the WebPOS issues.
> 
> I just wish that part of the unit testing before OfBiz releases included 
> checking if demo data can be loaded by an end user without direct database 
> manipulation (this would of course be a monumentally difficult task to see if 
> every bit of demo data could be hand entered...someone would have to actually 
> enter it). The written instructions of how the unit test would be performed 
> would serve as an incredibly valuable way of understanding how to set up a 
> new business. Right now I'm basically reverse engineering this when all I 
> really wanted to do was set up the existing features and get it running 
> (modification could come later).
> 
> So I'm back to finding ways to map table relationships in Derby...it looks 
> like a simple SQL 

Re: Mapping Derby Sample Data Foreign Keys

[stimits]

Hi,
 
I do have that book which explains concepts, but currently I am trying to make 
the existing system's WebPOS work...versus extending, customizing, or adding to 
the existing system. The book has no concept of how the OfBiz interface itself 
is arranged. I need a working WebPOS, which means I need to be able to enter 
data for POS terminals and stores, but there is no web interface for this. Thus 
the route of trying to edit sample data and transfer it over to my PostgreSQL 
database instead of Derby.
 
The OfBizDatamodelBook charts are indeed something like what I want, but I need 
it in a form where I can use tools to automate tasks based on query of an 
existing Derby database and copy to PostgreSQL. Someone made a very nice chart 
of account relationships, but the PDF is for human-readable form and may not 
reflect changes and other details of the actual database (for example the chart 
does not know about automatic sequences for generating various keys...a 
database query may be able to take this into account and simple copy of data 
from one database to another results in an error).
 
In terms of using the web tools with copy and paste to load data I have tried 
this unsuccessfully. The time it takes to make attempts is extreme and error 
messages do not necessarily point out what needs to be loaded for a given 
failure to be fixed. Here are some points about the web tool copy and paste 
method:
 
1. Many XML documents have a root tag of "". This requires 
editing the XML files and removing the "" (you can't paste 
"" within ""). This isn't too bad of an 
issue, but it slows things down (especially if it is a large file and you are 
skipping open/close tags via scrolling around in an editor). Sometimes java 
errors are so long that the pop-up showing them is not capable of displaying on 
a large monitor (though log files do not have this limitation).
 
2. Some tables (many) have a foreign key and produce an error if the foreign 
table does not already have an entry. There are also cases where a column in a 
foreign table is copied during insert, but the value is allowed to be null...I 
worry that no error would be generated if the foreign key is there but the data 
for the null column has not yet been populated. Those columns pulling data from 
another table where null is allowed may change whether the data is valid but 
will never produce an error (copy by value). I see a SQL query as a 
programmatic way to be certain columns which can be null will always be loaded 
from a parent table which has had the maximum opportunity to be populated 
before using that parent.
 
3. In some cases I am going to be copying from Derby to PostgreSQL. 
SQuirrel-sqL has a tool for this, but the tool does not deal well with keys 
which have been generated using different methods between the different 
databases. This is a particular case of the above mentioned need to be able to 
see generated values.
 
I have tried for a long time, with many hours per day, to come up with a 
simpler solution for getting WebPOS working (including mouse copy and paste, 
then command line XML file loads). Then I tried for quite some time to be able 
to get the Derby demo data into PostgreSQL using simpler tools and 
methods...once again without success. I am positive that if I have detailed 
access to both the demo database under Derby and to the database under 
PostgreSQL that I can guarantee certain qualities during copy. Once I can do 
that I can investigate editing the data for replacing some demo data with a 
real world store. I do not yet know how to create the missing interface for 
populating WebPOS, so I am limited to this route...once I can do this and 
understand it I can work on modifying or customizing OfBiz to include an 
interface for avoiding all of the WebPOS issues.
 
I just wish that part of the unit testing before OfBiz releases included 
checking if demo data can be loaded by an end user without direct database 
manipulation (this would of course be a monumentally difficult task to see if 
every bit of demo data could be hand entered...someone would have to actually 
enter it). The written instructions of how the unit test would be performed 
would serve as an incredibly valuable way of understanding how to set up a new 
business. Right now I'm basically reverse engineering this when all I really 
wanted to do was set up the existing features and get it running (modification 
could come later).
 
So I'm back to finding ways to map table relationships in Derby...it looks like 
a simple SQL query won't be possible, I'm going to have to use the JDBC 
interface.
 
Thanks!
 
- Original Message -From: Paul Foxworthy To: 
user@ofbiz.apache.orgSent: Thu, 08 Jun 2017 07:31:52 - (UTC)Subject: Re: 
Mapping Derby Sample Data Foreign Keys

Hi stimits,

I agree with Taher about the most productive way to solve your problem.

For an overall understanding of the data model, 

Re: Online Demo

[Michael Brohl]

You're welcome, Craig.

Have fun,

Michael


Am 08.06.17 um 21:52 schrieb Craig Parker:
Whoah -- there's even a chat room. Nice! Thanks Michael. Chromebook it 
is!



On 06/08/2017 03:43 PM, Michael Brohl wrote:
Sure, see ofbiz.apache.org on the right side for ecommerce and 
backend demos.


Michael

Am 08.06.17 um 21:38 schrieb Craig Parker:
Maybe I'm numbing it... Is there an online demo? Even if it resets 
every night. Not sure if I'm taking my chrome book, or my laptop 
this weekend. THey're both running Linux, but the laptop has a 
running instance of OFBiz on it, it's just a lot bigger.












smime.p7s
Description: S/MIME Cryptographic Signature

Re: Online Demo

[Craig Parker]

Whoah -- there's even a chat room. Nice! Thanks Michael. Chromebook it is!


On 06/08/2017 03:43 PM, Michael Brohl wrote:
Sure, see ofbiz.apache.org on the right side for ecommerce and backend 
demos.


Michael

Am 08.06.17 um 21:38 schrieb Craig Parker:
Maybe I'm numbing it... Is there an online demo? Even if it resets 
every night. Not sure if I'm taking my chrome book, or my laptop this 
weekend. THey're both running Linux, but the laptop has a running 
instance of OFBiz on it, it's just a lot bigger.

Re: Online Demo

[Michael Brohl]

Sure, see ofbiz.apache.org on the right side for ecommerce and backend 
demos.


Michael

Am 08.06.17 um 21:38 schrieb Craig Parker:
Maybe I'm numbing it... Is there an online demo? Even if it resets 
every night. Not sure if I'm taking my chrome book, or my laptop this 
weekend. THey're both running Linux, but the laptop has a running 
instance of OFBiz on it, it's just a lot bigger.







smime.p7s
Description: S/MIME Cryptographic Signature

Online Demo

[Craig Parker]

Maybe I'm numbing it... Is there an online demo? Even if it resets every 
night. Not sure if I'm taking my chrome book, or my laptop this weekend. 
THey're both running Linux, but the laptop has a running instance of 
OFBiz on it, it's just a lot bigger.

Re: Service dispatcher threw an exception: Cannot find service location class

[Daniel Coric]

Thank you, Jacques.

I'm looking forward to it. :)

Regards,
Daniel

Re: Service dispatcher threw an exception: Cannot find service location class

[Jacques Le Roux]

Thanks Daniel for report,

This is my bad, I found similar cases I'll soon fix all in trunk and backport

Jacques


Le 08/06/2017 à 20:24, Daniel Coric a écrit :

Hi Michael,

no, I'm not using trunk. It's about 'stable release 16.11.02' (as stated - and 
advised to download - on official OFBiz web page).

I read about changes in trunk and they are known to me, thanks anyway.

MFG

Re: Service dispatcher threw an exception: Cannot find service location class

[Daniel Coric]

Hi Michael,

no, I'm not using trunk. It's about 'stable release 16.11.02' (as stated - and 
advised to download - on official OFBiz web page).

I read about changes in trunk and they are known to me, thanks anyway.

MFG

Re: Service dispatcher threw an exception: Cannot find service location class

[Michael Brohl]

Hi Daniel,

are you working with trunk? If yes, please update your sandbox.

We have renamed specialpurpose to plugins, it seems you are not 
completely up to date. So your class has to reside in


../plugins/ofbizDemo/src/com/companyname/ofbizdemo/services/OfbizDemoServices.java

Regards,

Michael Brohl
ecomify GmbH
www.ecomify.de


Am 08.06.17 um 19:26 schrieb Daniel Coric:

Hi Michael,
thank you for your prompt reply.

I used './gradlew createPlugin -PpluginId=ofbizDemo' to create plugin and 
didn't change directory structure.

The class is located under: 
'../specialpurpose/ofbizDemo/src/com/companyname/ofbizdemo/services/OfbizDemoServices.java'

This is service definition:

Create an Ofbiz Demo record using a service in 
Java





At disposal for any additional infos, of course.






smime.p7s
Description: S/MIME Cryptographic Signature

Re: Service dispatcher threw an exception: Cannot find service location class

[Daniel Coric]

Hi Michael, 
thank you for your prompt reply.

I used './gradlew createPlugin -PpluginId=ofbizDemo' to create plugin and 
didn't change directory structure.

The class is located under: 
'../specialpurpose/ofbizDemo/src/com/companyname/ofbizdemo/services/OfbizDemoServices.java'

This is service definition:

Create an Ofbiz Demo record using a service in 
Java





At disposal for any additional infos, of course.

Re: Service dispatcher threw an exception: Cannot find service location class

[Michael Brohl]

Hi Daniel,

are you sure that the custom class 
com.companyname.ofbizdemo.services.OfbizDemoServices is available for OFBiz?


Where is it located?

Can you please give us some more information (like the service 
definition or the layout of your project (folders/packages).


I'm sure we can work this out then.

Regards,

Michael Brohl
ecomify GmbH
www.ecomify.de


Am 08.06.17 um 18:46 schrieb Daniel Coric:

Hello everyone,

I'm trying to make myself familiar with the OFBiz following the tutorial 'OFBiz 
Tutorial - A Beginners Development Guide for 16.11' and everything goes fine 
until I try to test 'java-service' through the 'Run Service'.

This is what I get: 'The Following Errors Occurred: Service dispatcher threw an 
exception: Cannot find service [createOfbizDemoByJavaService] location class 
(com.companyname.ofbizdemo.services.OfbizDemoServices).'

The 'groovy-service' works fine.

Previously I worked through 'OFBiz Tutorial - A Beginners Development Guide' 
intended to be used with the branch 14.12 and 15.12 of Apache OFBiz using 
'release15.12' without any problems or errors.

Any help is appreciated. Thank you.


Here is 'error.log':

2017-06-08 14:39:28,098 |OFBiz-JobQueue-0 |GenericDelegator |E| ERROR: Cannot 
do a find that returns an EntityListIterator with no transaction in place. Wrap 
this call in a transaction.
java.lang.Exception: Stack Trace
at org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1533) 
[ofbiz.jar:?]
at org.apache.ofbiz.entity.util.EntityQuery.queryIterator(EntityQuery.java:396) 
[ofbiz.jar:?]
at 
org.apache.ofbiz.order.order.OrderServices.runSubscriptionAutoReorders(OrderServices.java:5571)
 [ofbiz.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_131]
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 
~[?:1.8.0_131]
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 ~[?:1.8.0_131]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_131]
at 
org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100)
 [ofbiz.jar:?]
at 
org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57)
 [ofbiz.jar:?]
at 
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:395) 
[ofbiz.jar:?]
at 
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:227) 
[ofbiz.jar:?]
at 
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
 [ofbiz.jar:?]
at 
org.apache.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69) 
[ofbiz.jar:?]
at org.apache.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87) 
[ofbiz.jar:?]
at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) 
[?:1.8.0_131]
at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) 
[?:1.8.0_131]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_131]

2017-06-08 14:39:28,225 |OFBiz-JobQueue-1 |GenericDelegator |E| ERROR: Cannot 
do a find that returns an EntityListIterator with no transaction in place. Wrap 
this call in a transaction.
java.lang.Exception: Stack Trace
at org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1533) 
[ofbiz.jar:?]
at org.apache.ofbiz.entity.util.EntityQuery.queryIterator(EntityQuery.java:396) 
[ofbiz.jar:?]
at 
org.apache.ofbiz.order.shoppinglist.ShoppingListServices.createListReorders(ShoppingListServices.java:132)
 [ofbiz.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_131]
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 
~[?:1.8.0_131]
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 ~[?:1.8.0_131]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_131]
at 
org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100)
 [ofbiz.jar:?]
at 
org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57)
 [ofbiz.jar:?]
at 
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:395) 
[ofbiz.jar:?]
at 
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:227) 
[ofbiz.jar:?]
at 
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
 [ofbiz.jar:?]
at 
org.apache.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69) 
[ofbiz.jar:?]
at org.apache.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87) 
[ofbiz.jar:?]
at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) 
[?:1.8.0_131]
at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) 
[?:1.8.0_131]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_131]

2017-06-08 14:47:24,661 |http-nio-8443-exec-2 |TransactionUtil |E| Rollback 
Only was set when trying to commit 

Service dispatcher threw an exception: Cannot find service location class

[Daniel Coric]

Hello everyone, 

I'm trying to make myself familiar with the OFBiz following the tutorial 'OFBiz 
Tutorial - A Beginners Development Guide for 16.11' and everything goes fine 
until I try to test 'java-service' through the 'Run Service'.

This is what I get: 'The Following Errors Occurred: Service dispatcher threw an 
exception: Cannot find service [createOfbizDemoByJavaService] location class 
(com.companyname.ofbizdemo.services.OfbizDemoServices).'

The 'groovy-service' works fine.

Previously I worked through 'OFBiz Tutorial - A Beginners Development Guide' 
intended to be used with the branch 14.12 and 15.12 of Apache OFBiz using 
'release15.12' without any problems or errors.

Any help is appreciated. Thank you.


Here is 'error.log':

2017-06-08 14:39:28,098 |OFBiz-JobQueue-0 |GenericDelegator |E| ERROR: Cannot 
do a find that returns an EntityListIterator with no transaction in place. Wrap 
this call in a transaction.
java.lang.Exception: Stack Trace
at org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1533) 
[ofbiz.jar:?]
at org.apache.ofbiz.entity.util.EntityQuery.queryIterator(EntityQuery.java:396) 
[ofbiz.jar:?]
at 
org.apache.ofbiz.order.order.OrderServices.runSubscriptionAutoReorders(OrderServices.java:5571)
 [ofbiz.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_131]
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 
~[?:1.8.0_131]
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 ~[?:1.8.0_131]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_131]
at 
org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100)
 [ofbiz.jar:?]
at 
org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57)
 [ofbiz.jar:?]
at 
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:395) 
[ofbiz.jar:?]
at 
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:227) 
[ofbiz.jar:?]
at 
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
 [ofbiz.jar:?]
at 
org.apache.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69) 
[ofbiz.jar:?]
at org.apache.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87) 
[ofbiz.jar:?]
at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) 
[?:1.8.0_131]
at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) 
[?:1.8.0_131]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_131]

2017-06-08 14:39:28,225 |OFBiz-JobQueue-1 |GenericDelegator |E| ERROR: Cannot 
do a find that returns an EntityListIterator with no transaction in place. Wrap 
this call in a transaction.
java.lang.Exception: Stack Trace
at org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1533) 
[ofbiz.jar:?]
at org.apache.ofbiz.entity.util.EntityQuery.queryIterator(EntityQuery.java:396) 
[ofbiz.jar:?]
at 
org.apache.ofbiz.order.shoppinglist.ShoppingListServices.createListReorders(ShoppingListServices.java:132)
 [ofbiz.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_131]
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 
~[?:1.8.0_131]
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 ~[?:1.8.0_131]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_131]
at 
org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100)
 [ofbiz.jar:?]
at 
org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57)
 [ofbiz.jar:?]
at 
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:395) 
[ofbiz.jar:?]
at 
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:227) 
[ofbiz.jar:?]
at 
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
 [ofbiz.jar:?]
at 
org.apache.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69) 
[ofbiz.jar:?]
at org.apache.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87) 
[ofbiz.jar:?]
at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) 
[?:1.8.0_131]
at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) 
[?:1.8.0_131]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_131]

2017-06-08 14:47:24,661 |http-nio-8443-exec-2 |TransactionUtil |E| Rollback 
Only was set when trying to commit transaction here; throwing rollbackOnly 
cause exception 
javax.transaction.RollbackException: Unable to commit: transaction marked for 
rollback
at 
org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:272)
 ~[geronimo-transaction-3.1.1.jar:3.1.1]
at 
org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:252)
 

Re: ApacheCon Keynote on Digital Psychometrics

[Jacques Le Roux]

Finally could not resist, according to Magic sauce and Tweeter My "Jungian Personality 
Type" is "Introverted iNtuitive Thinking Perceiving"

Seems to be cool, at least to me https://en.wikipedia.org/wiki/INTP but in 
professional life might need help of ESTJ and ISTJ they say

Anyway this is fun, but I don't take it too seriously (maybe because I'd be an 
INTP :D)

Jacques


Le 08/06/2017 à 10:56, Taher Alkhateeb a écrit :

Very cool. I definitely fit into the geeky introverted category :)

On Thu, Jun 8, 2017 at 10:02 AM, Sharan Foga  wrote:


Hi Everyone

If you haven't seen the ApacheCon Miami keynote on Digital Psychometrics
from Sandra Matz then I'd strongly recommend it. I found it very
entertaining and surprising especially if you use Twitter or Facebook.

https://youtu.be/hFqGg8a6JHo?list=PLbzoR-pLrL6pLDCyPxByWQwYTL-JrF5Rp

Thanks
Sharan

Re: ApacheCon Keynote on Digital Psychometrics

[Taher Alkhateeb]

Very cool. I definitely fit into the geeky introverted category :)

On Thu, Jun 8, 2017 at 10:02 AM, Sharan Foga  wrote:

> Hi Everyone
>
> If you haven't seen the ApacheCon Miami keynote on Digital Psychometrics
> from Sandra Matz then I'd strongly recommend it. I found it very
> entertaining and surprising especially if you use Twitter or Facebook.
>
> https://youtu.be/hFqGg8a6JHo?list=PLbzoR-pLrL6pLDCyPxByWQwYTL-JrF5Rp
>
> Thanks
> Sharan
>
>

Re: Query Regarding OFBiz Features

[Abhishek Sharma]

Thanks Shi for replying. So can i get the version of OFBiz which have this
feature or is it still in progress?

Regards
Abhishek

On 08-Jun-2017 1:10 PM, "Shi Jinghai"  wrote:

> Hi Abhishek,
>
> The features you required is not OOTB in OFBiz. OFBiz can be extended to
> achieve them. We're running such a platform developed on OFBiz.
>
> Kind Regards,
>
> Shi Jinghai
>
> -邮件原件-
> 发件人: Abhishek Sharma [mailto:sharma.abhishek2...@gmail.com]
> 发送时间: 2017年6月6日 23:12
> 收件人: user@ofbiz.apache.org
> 主题: Query Regarding OFBiz Features
>
> Hi Team,
>
> I have few queries regarding features in OFBiz. It will be great if anyone
> can help me out in resolving these queries -
>
> 1) Do OFBiz support market place like option i.e. anyone can create their
> store and sell their product on a single OFBiz instance.
>
> 2) Can we add product directly in store?
>
> Your support is highly appreciated.
>
> Regards
> Abhishek Sharma
>

Re: Query Regarding OFBiz Features

[Shi Jinghai]

Hi Abhishek,

The features you required is not OOTB in OFBiz. OFBiz can be extended to 
achieve them. We're running such a platform developed on OFBiz.

Kind Regards,

Shi Jinghai

-邮件原件-
发件人: Abhishek Sharma [mailto:sharma.abhishek2...@gmail.com] 
发送时间: 2017年6月6日 23:12
收件人: user@ofbiz.apache.org
主题: Query Regarding OFBiz Features

Hi Team,

I have few queries regarding features in OFBiz. It will be great if anyone can 
help me out in resolving these queries -

1) Do OFBiz support market place like option i.e. anyone can create their store 
and sell their product on a single OFBiz instance.

2) Can we add product directly in store?

Your support is highly appreciated.

Regards
Abhishek Sharma

Re: Mapping Derby Sample Data Foreign Keys

[Paul Foxworthy]

Hi stimits,

I agree with Taher about the most productive way to solve your problem.

For an overall understanding of the data model, see
https://cwiki.apache.org/confluence/display/OFBIZ/Data+Model . There's a
mention there of the Data Model Resource Book by Len Silverston, which
inspired much of OFBiz's data model, and links to diagrams. The diagrams
are a few years old but still substantially correct and relevant.

Cheers

Paul Foxworthy

On 8 June 2017 at 06:43, Taher Alkhateeb  wrote:

> Hi,
>
> I might be wrong, but I think you're trying to do this the hard way. The
> problem is really simple in that you have some missing data that is not
> loading correctly. To fix this issue I would suggest the following steps:
>
> 1- Copy the XML data file contents
> 2- Paste it into the XML data import window (i.e.
> https://localhost:8443/webtools/control/EntityImport)
> 3- Click Import Text
> 4- Observe error message (it will tell you which foreign key is violated
> and how)
> 5- fix the data accordingly
> 6- Repeat 1 to 5 as needed
>
> That would be much faster and easier than going down to the SQL level to
> try to investigate. I recommend that you use the entity engine to your
> advantage instead of bypassing it completely.
>
> HTH
>
> On Wed, Jun 7, 2017 at 1:42 AM,  wrote:
>
> > Hi,
> >
> > There are 861 tables in the ofbiz Derby database under ofbiz-16.11.02 for
> > demo data. I'm trying to learn to load this data manually using SQL
> > queries, and thus making a dependency list of tables with foreign key
> > requirements (or even references to other tables which are allowed to be
> > null). Basically, no table referencing another table's data can be loaded
> > without first loading that parent table. With 861 tables and some tables
> > having more than one foreign key I wanted to automate this with a SQL
> query
> > (I'm using SQuirrel-sqL to explore now). As such I'm looking at system
> > tables describing constraints and keys.
> >
> > Through system tables I can find a list of tables and the ID of
> > constraints which are foreign keys. However, I seem to be losing the
> battle
> > to find the name of the foreign table and foreign column name to which
> the
> > constraint points (only the table with the originating constraint is easy
> > to find and automate a listing for). I see this may be possible to find
> > through JDBC; SQuirrel-sqL itself shows imported and exported keys with
> no
> > apparent means to export the information. Can anyone tell me if it is
> > possible to use an ordinary SQL query to find all foreign keys of a table
> > and print the list of the child table and the parent foreign
> table.column?
> > If I can do this I can get around the missing WebPOS setup functionality
> > and edit/load SQL directly (I'm using PostegreSQL so I can't edit a Derby
> > database directly...it needs to be copied over to PostgresSQL first in
> the
> > proper order).
> >
> > If you think I need to write a JDBC app instead to map table load order
> > dependencies, please let me know. I don't believe there is any other way
> to
> > use the WebPOS without doing it this way. I hate to think I may have to
> go
> > through all of those tables and hand write a spreadsheet with the
> > dependencies.
> >
> > Thanks!
>



-- 
Coherent Software Australia Pty Ltd
PO Box 2773
Cheltenham Vic 3192
Australia

Phone: +61 3 9585 6788
Web: http://www.coherentsoftware.com.au/
Email: i...@coherentsoftware.com.au

ApacheCon Keynote on Digital Psychometrics

[Sharan Foga]

Hi Everyone

If you haven't seen the ApacheCon Miami keynote on Digital Psychometrics 
from Sandra Matz then I'd strongly recommend it. I found it very 
entertaining and surprising especially if you use Twitter or Facebook.


https://youtu.be/hFqGg8a6JHo?list=PLbzoR-pLrL6pLDCyPxByWQwYTL-JrF5Rp

Thanks
Sharan