Re: OFBiz no start

2017-06-09 Thread Taher Alkhateeb
Try https://localhost:8443/ecommerce

On Jun 10, 2017 5:29 AM, "geodude"  wrote:

Has anybody find a solution to this issue?
Downlaoded ofbiz and jdk 1.8
run
./gradlew cleanAll loadDefault
finishes successfully

./gradlew ofbiz
stays stuck at 91% when I try to access the
http://127.0.0.1:8080/ecommerce/control/main and nothing

tried running
./gradlew cleanAll loadDefault "ofbiz --start"
stays stuck at 96%

if anybody has a solution or any pointers, would be greatly appreciated.

Thank you.



--
View this message in context: http://ofbiz.135035.n4.nabble.
com/OFBiz-no-start-tp4700872p4706429.html
Sent from the OFBiz - User mailing list archive at Nabble.com.


Re: OFBiz no start

2017-06-09 Thread geodude
Has anybody find a solution to this issue?
Downlaoded ofbiz and jdk 1.8
run 
./gradlew cleanAll loadDefault
finishes successfully

./gradlew ofbiz
stays stuck at 91% when I try to access the
http://127.0.0.1:8080/ecommerce/control/main and nothing

tried running
./gradlew cleanAll loadDefault "ofbiz --start"
stays stuck at 96%

if anybody has a solution or any pointers, would be greatly appreciated.

Thank you.



--
View this message in context: 
http://ofbiz.135035.n4.nabble.com/OFBiz-no-start-tp4700872p4706429.html
Sent from the OFBiz - User mailing list archive at Nabble.com.


GL Defaults

2017-06-09 Thread Craig Parker
I'm tooling around the demo site and don't see what I'm looking for. 
I've called them "GL Defaults" for years, but maybe they're called 
something different in OFBiz...


When some action occurs (AR payments on account, bank deposits, company 
vehicle repair bills) is there an application that lets you set which GL 
account gets credited/debited by default?


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

2017-06-09 Thread Daniel Coric
Hi Michael,

there is literally no difference between my local copy and the repository 
release source code - if we don't count 'ofbizDemo'-component unversioned 
directories and files. I checked out 'release16.11' and started with the 
tutorial... copy-pasted the code... changed only from 'import org.ofbiz...' to 
'import org.apache.ofbiz...' in 'OfbizDemoServices.java' and 
'OfbizDemoServices.groovy'... groovy works - java don't... 

Regards,
Daniel


Re: Mapping Derby Sample Data Foreign Keys

2017-06-09 Thread stimits
Hi,
 
I agree that a lot is needed for WebPOS, but it is a starting point if I can 
get to the data and put real world data in. I only go through these routes 
because it seems no other method exists to do this reliably.
 
So far as just loading data from sample into PostegreSQL goes, I still need to 
do the same mapping of foreign keys and columns to foreign tables which are 
allowed to be null. Derby is just the place I started because I don't know the 
inner details of either Derby or PostgreSQL, but saw examples of using system 
tables for Derby. I'm confident with SQL, but have never delved into the 
metadata within a SQL server.
 
Basically I cannot trust editing data in SQL directly unless I know I am 
editing from top-most table downward into dependent tables in an order which 
guarantees I won't leave any original data which needed to be altered. The web 
tools do not seem to provide everything I need so far as understanding required 
order of edit (not just order of load...loading data in the correct order is 
insufficient for these purposes). Though I might investigate doing the same 
thing under PostgreSQL...the tools for PostgreSQL may offer a way to export 
what I need.
 
Understand that right now I just want to get WebPOS running with real data from 
a real retail store. If I can do that, then I can adjust WebPOS (which I agree 
is terribly nonintuitive). Getting a chart of accounts which matches or is 
compatible with the current POS is the first goal...I can't do that from within 
the existing interfaces (due to WebPOS requirements).
 
Thanks!
 
- Original Message -From: Mike To: user 
Sent: Fri, 09 Jun 2017 15:56:07 - (UTC)Subject: Re: 
Mapping Derby Sample Data Foreign Keys

Hey stimits. Are you finding that the demo webpos for 16.x works for you?The 
reason I ask is that I would assume a properly functioning POS wouldneed a lot 
of supporting stuff, like a chart of accounts, payment accounts,etc. I tried it 
(demo), and it is not very intuitive as is.

If you REALLY want to capture all the SQL that postgresql sees, you cansimply 
set "log_statement = mod', and it will log all of the SQL, but goingthis route 
is not recommended. Instead, you can create a very simplehot-deploy component 
that can load all of the stuff you need after seed,and seed-initial. Here is a 
sample:

root@server:/opt/ofbiz/hot-deploy# find 
my_data/my_data/my_data/ofbiz-component.xmlmy_data/datamy_data/data/16240_shop_StandardCostingData.xmlmy_data/data/16120_shop_RelatedData.xmlmy_data/data/16020_shop_CatalogData.xml---etc...

Consists of ONE "ofbiz-component.xml" file, a directory called "data", andthe 
.xml files you want to load, preferably named to create order. That'sit.

The "data" directory has the xml files to load. I keep them named by 
aconsistent 5 digit number where if you list it's contents, they are alwaysin 
the exact same loading sequence. The key item is theofbiz-component.xml file, 
which lists the items to load, which is basicallythe same order as the files... 
Example:

http://www.w3.org/2001/XMLSchema-instance; 
xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/ofbiz-component.xsd;>
  ... ETC... More 
files

Notice the line: ofbiz-component name="my_data" and "reader-name"... Thatname 
(my_data) is the name used to load (and re-load as necessary) all ofthe xml 
files in the "data" directory. For instance:

./ant load-readers "-Ddata-readers=seed,seed-initial" (this is run 
ONCE)...then/ant load-readers "-Ddata-readers=my_data" (look for ERRORS, 
fix .xml asrequired)./ant load-readers "-Ddata-readers=my_data" (RERUN untill 
all loadingerrors are gone)

Hope this helps.

On Thu, Jun 8, 2017 at 2:37 PM, Michael Brohl wrote:

> 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 

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

2017-06-09 Thread Michael Brohl
Coric,

I guess there is a typo somewhere so that the class cannot be found. No chance 
to diagnose without all information/ the full code. If you can make a patch of 
your setting against the release version we might find the error.

Regards,
Michael



> Am 09.06.2017 um 22:22 schrieb cori...@gmail.com:
> 
> Hi Jacques,
> 
> yes, this solved the problem with the 'GenericDelegator ERRORs'.
> 
> Unfortunately, the problem with the 'Cannot find service 
> [createOfbizDemoByJavaService] location class 
> (com.companyname.ofbizdemo.services.OfbizDemoServices)' is still there.
> 
> I think, someone of you, experienced OFBiz-guys, should really check out 
> this tutorial 
> 
>  
> with the fresh 'svn co release16.11'... for the sake of all newcomers. :)
> 
> The newest 'error.log' - follows.
> 
> Regards,
> Daniel
> 
> 
> 2017-06-09 20:52:34,397 |http-nio-8443-exec-8 |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)
>  
> ~[geronimo-transaction-3.1.1.jar:3.1.1]
> at 
> org.apache.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:249)
>  
> [ofbiz.jar:?]
> at 
> org.apache.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:235)
>  
> [ofbiz.jar:?]
> at 
> org.apache.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:119)
>  
> [ofbiz.jar:?]
> at 
> org.apache.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:80)
>  
> [ofbiz.jar:?]
> at 
> org.apache.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:732)
>  
> [ofbiz.jar:?]
> at 
> org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:453)
> [ofbiz.jar:?]
> at 
> org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:210) 
> [ofbiz.jar:?]
> at 
> org.apache.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:85) 
> [ofbiz.jar:?]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) 
> [javax.servlet-api-3.1.0.jar:3.1.0]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) 
> [javax.servlet-api-3.1.0.jar:3.1.0]
> at 
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
>  
> [tomcat-catalina-8.0.42.jar:8.0.42]
> at 
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
>  
> [tomcat-catalina-8.0.42.jar:8.0.42]
> at 
> org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) 
> [tomcat-embed-websocket-8.0.39.jar:8.0.39]
> at 
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
>  
> [tomcat-catalina-8.0.42.jar:8.0.42]
> at 
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
>  
> [tomcat-catalina-8.0.42.jar:8.0.42]
> at 
> org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:209)
>  
> [ofbiz.jar:?]
> at 
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
>  
> [tomcat-catalina-8.0.42.jar:8.0.42]
> at 
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
>  
> [tomcat-catalina-8.0.42.jar:8.0.42]
> at 
> org.apache.ofbiz.webapp.control.ControlFilter.doFilter(ControlFilter.java:156)
>  
> [ofbiz.jar:?]
> at 
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
>  
> [tomcat-catalina-8.0.42.jar:8.0.42]
> at 
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
>  
> [tomcat-catalina-8.0.42.jar:8.0.42]
> at 
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
>  
> [tomcat-catalina-8.0.42.jar:8.0.42]
> at 
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94)
>  
> [tomcat-catalina-8.0.42.jar:8.0.42]
> at 
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
>  
> [tomcat-catalina-8.0.42.jar:8.0.42]
> at 
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141) 
> [tomcat-catalina-8.0.42.jar:8.0.42]
> at 
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) 
> [tomcat-catalina-8.0.42.jar:8.0.42]
> at 
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
>  
> [tomcat-catalina-8.0.42.jar:8.0.42]
> at 
> 

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

2017-06-09 Thread Jacques Le Roux

Hi Michael,

It doesn't.

Actually I did not look into all details of the stack trace, I thought it was only one issue. So I focused on the 1st issue (top in stack) because I 
was working on similar issues in trunk after having fixed r1797222 and r1797097


So at r1798179 I only fixed bugs introduced with r1787949. And I need to 
continue on trunk...

But it's completely unrelated with the 2nd issue which is 8 minutes later. 
Maybe a typo somewhere, though just looked, I did not spot any obvious

Jacques


Le 09/06/2017 à 12:15, Michael Brohl a écrit :

Hi Jacques,

please help me: how does the patch relate to the problem that the service class 
cannot be found?

Thanks,

Michael Brohl
ecomify GmbH
www.ecomify.de

Am 09.06.17 um 11:42 schrieb Jacques Le Roux:

Hi Daniel,

I fixed the issue, with another similar, in the R16.11 branch with revision: 
1798179

Sorry for that, you need to update your copy yourself. For that there are 2 
means either you

 * svn checkout the R16.11 branch and make an svn export to get rid of .svn
 * Apply a patch from r1798179 on your current copy

HTH

Jacques


Le 08/06/2017 à 21:25, Daniel Coric a écrit :

Thank you, Jacques.

I'm looking forward to it. :)

Regards,
Daniel











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

2017-06-09 Thread coric75

Hi Jacques,

yes, this solved the problem with the 'GenericDelegator ERRORs'.

Unfortunately, the problem with the 'Cannot find service 
[createOfbizDemoByJavaService] location class 
(com.companyname.ofbizdemo.services.OfbizDemoServices)' is still there.


I think, someone of you, experienced OFBiz-guys, should really check out 
this tutorial 
 
with the fresh 'svn co release16.11'... for the sake of all newcomers. :)


The newest 'error.log' - follows.

Regards,
Daniel


2017-06-09 20:52:34,397 |http-nio-8443-exec-8 |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) 
~[geronimo-transaction-3.1.1.jar:3.1.1]
at 
org.apache.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:249) 
[ofbiz.jar:?]
at 
org.apache.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:235) 
[ofbiz.jar:?]
at 
org.apache.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:119) 
[ofbiz.jar:?]
at 
org.apache.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:80) 
[ofbiz.jar:?]
at 
org.apache.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:732) 
[ofbiz.jar:?]
at 
org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:453) 
[ofbiz.jar:?]
at 
org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:210) 
[ofbiz.jar:?]
at 
org.apache.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:85) 
[ofbiz.jar:?]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) 
[javax.servlet-api-3.1.0.jar:3.1.0]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) 
[javax.servlet-api-3.1.0.jar:3.1.0]
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292) 
[tomcat-catalina-8.0.42.jar:8.0.42]
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) 
[tomcat-catalina-8.0.42.jar:8.0.42]
at 
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) 
[tomcat-embed-websocket-8.0.39.jar:8.0.39]
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) 
[tomcat-catalina-8.0.42.jar:8.0.42]
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) 
[tomcat-catalina-8.0.42.jar:8.0.42]
at 
org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:209) 
[ofbiz.jar:?]
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) 
[tomcat-catalina-8.0.42.jar:8.0.42]
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) 
[tomcat-catalina-8.0.42.jar:8.0.42]
at 
org.apache.ofbiz.webapp.control.ControlFilter.doFilter(ControlFilter.java:156) 
[ofbiz.jar:?]
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) 
[tomcat-catalina-8.0.42.jar:8.0.42]
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) 
[tomcat-catalina-8.0.42.jar:8.0.42]
at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212) 
[tomcat-catalina-8.0.42.jar:8.0.42]
at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94) 
[tomcat-catalina-8.0.42.jar:8.0.42]
at 
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504) 
[tomcat-catalina-8.0.42.jar:8.0.42]
at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141) 
[tomcat-catalina-8.0.42.jar:8.0.42]
at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) 
[tomcat-catalina-8.0.42.jar:8.0.42]
at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) 
[tomcat-catalina-8.0.42.jar:8.0.42]
at 
org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620) 
[tomcat-catalina-8.0.42.jar:8.0.42]
at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:502) 
[tomcat-catalina-8.0.42.jar:8.0.42]
at 
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1104) 
[tomcat-coyote-8.0.42.jar:8.0.42]
at 
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684) 
[tomcat-coyote-8.0.42.jar:8.0.42]
at 
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1519) 
[tomcat-coyote-8.0.42.jar:8.0.42]
at 

Any OFBiz Spanish Users or Service Providers ?

2017-06-09 Thread Sharan Foga
Hi All

Last week at the Open Source Expo in Madrid I got a few queries about OFBiz as 
I'd brought a few stickers to give away at the event. I spoke to a few people 
about it but was limited by my lack of Spanish! 

Someone has now followed up by asking about for more information about OFBiz so 
I'm looking for any OFBiz users or service providers based in Spain (or perhaps 
even simply Spanish speaking ones wherever you are!) that I can put them in 
contact with.

Thanks
Sharan



OFBiz Blog - May 2017 Update

2017-06-09 Thread Sharan Foga
Hi Everyone

Our regular monthly blog update is now available at the link below:

https://blogs.apache.org/ofbiz/entry/apache-ofbiz-news-may-2017

As always thanks very much to Michael and  Jacques for their help putting it 
together and reviewing it. 

Thanks 
Sharan


Re: Mapping Derby Sample Data Foreign Keys

2017-06-09 Thread Mike
Hey stimits.  Are you finding that the demo webpos for 16.x works for you?
The reason I ask is that I would assume a properly functioning POS would
need a lot of supporting stuff, like a chart of accounts, payment accounts,
etc.  I tried it (demo), and it is not very intuitive as is.

If you REALLY want to capture all the SQL that postgresql sees, you can
simply set "log_statement = mod', and it will log all of the SQL, but going
this route is not recommended.  Instead, you can create a very simple
hot-deploy component that can load all of the stuff you need after seed,
and seed-initial.  Here is a sample:

root@server:/opt/ofbiz/hot-deploy# find my_data/
my_data/
my_data/ofbiz-component.xml
my_data/data
my_data/data/16240_shop_StandardCostingData.xml
my_data/data/16120_shop_RelatedData.xml
my_data/data/16020_shop_CatalogData.xml
---etc...

Consists of ONE "ofbiz-component.xml" file, a directory called "data", and
the .xml files you want to load, preferably named to create order.  That's
it.

The "data" directory has the xml files to load.  I keep them named by a
consistent 5 digit number where if you list it's contents, they are always
in the exact same loading sequence.  The key item is the
ofbiz-component.xml file, which lists the items to load, which is basically
the same order as the files... Example:


http://www.w3.org/2001/XMLSchema-instance;
xsi:noNamespaceSchemaLocation="
http://ofbiz.apache.org/dtds/ofbiz-component.xsd;>





 ... ETC... More files


Notice the line: ofbiz-component name="my_data" and "reader-name"... That
name (my_data) is the name used to load (and re-load as necessary) all of
the xml files in the "data" directory.  For instance:

./ant load-readers "-Ddata-readers=seed,seed-initial" (this is run ONCE)
...then...
./ant load-readers "-Ddata-readers=my_data" (look for ERRORS, fix .xml as
required)
./ant load-readers "-Ddata-readers=my_data" (RERUN untill all loading
errors are gone)

Hope this helps.

On Thu, Jun 8, 2017 at 2:37 PM, Michael Brohl 
wrote:

> 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 

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

2017-06-09 Thread Michael Brohl

Hi Jacques,

please help me: how does the patch relate to the problem that the 
service class cannot be found?


Thanks,

Michael Brohl
ecomify GmbH
www.ecomify.de

Am 09.06.17 um 11:42 schrieb Jacques Le Roux:

Hi Daniel,

I fixed the issue, with another similar, in the R16.11 branch with 
revision: 1798179


Sorry for that, you need to update your copy yourself. For that there 
are 2 means either you


 * svn checkout the R16.11 branch and make an svn export to get rid of 
.svn

 * Apply a patch from r1798179 on your current copy

HTH

Jacques


Le 08/06/2017 à 21:25, Daniel Coric a écrit :

Thank you, Jacques.

I'm looking forward to it. :)

Regards,
Daniel









smime.p7s
Description: S/MIME Cryptographic Signature


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

2017-06-09 Thread Jacques Le Roux

Hi Daniel,

I fixed the issue, with another similar, in the R16.11 branch with revision: 
1798179

Sorry for that, you need to update your copy yourself. For that there are 2 
means either you

 * svn checkout the R16.11 branch and make an svn export to get rid of .svn
 * Apply a patch from r1798179 on your current copy

HTH

Jacques


Le 08/06/2017 à 21:25, Daniel Coric a écrit :

Thank you, Jacques.

I'm looking forward to it. :)

Regards,
Daniel