Re: Deletion of Party Data
Hello, You can't delete a party without using SQL processor, there are too many links with other entity, and afaik OFBiz do not offer a tool for that. OFBiz offer to desactivate the party in partymgr/control/editperson?partyId=YourPartyId , by changing his statuts. In most case it's sufficient, to keep the history of the party Gil Le 02/12/2014 07:47, vivek.mi a écrit : Hello all, I want to delete a party along with all associated data with it. How can it be achieved in OFBiz, as of now i can not see if we can delete a party in OFBiz. Thanks in advance, Vivek - Vivek Mishra -- View this message in context: http://ofbiz.135035.n4.nabble.com/Deletion-of-Party-Data-tp4659287.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Deletion of Party Data
Hello all, I want to delete a party along with all associated data with it. How can it be achieved in OFBiz, as of now i can not see if we can delete a party in OFBiz. Thanks in advance, Vivek - Vivek Mishra -- View this message in context: http://ofbiz.135035.n4.nabble.com/Deletion-of-Party-Data-tp4659287.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Tomcat Unresponsive
Hi folks, As always, thanks for your input Jacopo: That's interesting, I was wondering the same thing, and seems to make some sense based on the dump. It should also have been noted that the network which I am operating on is a bit volatile, so whether the DB server (PostgreSQL in my case) may be closing the connections, or perhaps some other external interference (e.g. connection drop), is probably quite possible. In some of my non-OFBiz apps, I set a hard connection age so that the pool is reacquiring connections often, even if the connections have not been idle for an extended period of time. I've studied the javadocs in regards to DBCP 1.4 and the commons GenericObjectPool which is used in the DBCP connection factory, but have not seen any similar option (in 1.4) for setting a connection age such that a connection will be reacquired when that time expires, however this seems to be available via the maxConnLifetimeMillis setting in the new versions. In my 12.04.02 copy of DBCPConnectionFactory the only options being set on the pool (which are pulled from entityengine.xml) are: - timeBetweenEvictionRunsMillis - maxActive - maxIdle - minIdle - maxWait I suppose I could manually set the "testOnBorrow" flag to support or rule out whether this may be the issue (not sure how much of a performance hit having this on would be, if it turns out to alleviate the problem), but based on your knowledge of the framework and DBCP configurations, do you have any other suggestions on what configurations could be set to further confirm that a connection "gone bad" may be the cause? I've attached the pertinent threaddump content below Mike Z: I'm running JDK 6 update 45 (64-bit). Upon launch of OFBiz, the only setting being set is setting maximum JVM memory (i.e. pos.memory.max.param=-Xmx4096M). Partial Threaddump: "ajp-bio-0.0.0.0-8009-exec-38" daemon prio=10 tid=0x5c11f000 nid=0x561a waiting for monitor entry [0x2b0ab9959000] java.lang.Thread.State: BLOCKED (on object monitor) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:781) - waiting to lock <0x000700f02318> (a org.apache.commons.pool.impl.GenericObjectPool) at org.apache.commons.dbcp.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:117) at org.apache.commons.dbcp.managed.ManagedConnection.(ManagedConnection.java:55) at org.apache.commons.dbcp.managed.ManagedDataSource.getConnection(ManagedDataSource.java:77) at org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:66) at org.ofbiz.entity.jdbc.ConnectionFactory.getManagedConnection(ConnectionFactory.java:135) at org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:83) at org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:97) at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:85) at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:250) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:356) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:340) at org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:532) at org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:503) at org.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:85) at org.ofbiz.entity.GenericDelegator.findOne(GenericDelegator.java:1572) at org.ofbiz.entity.GenericDelegator.findOne(GenericDelegator.java:1538) at org.ofbiz.webapp.stats.VisitHandler.getVisitor(VisitHandler.java:245) - locked <0x0007b1206a68> (a org.apache.catalina.session.StandardSessionFacade) at org.ofbiz.webapp.control.LoginWorker.setWebContextObjects(LoginWorker.java:509) at org.ofbiz.webapp.control.LoginWorker.doBasicLogout(LoginWorker.java:639) at org.ofbiz.webapp.control.LoginWorker.logout(LoginWorker.java:585) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:93) at org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:79) at org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:660) at org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:406) at org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:224) at javax.servlet.http.HttpServlet.service(HttpServlet.java:621) at javax.servlet.http.HttpServlet.service(HttpS
Re: Need help in customization
okie. Thanks for the info Jacques! Regards, Aashish Repal 09623381664 On Sun, Nov 30, 2014 at 2:20 PM, Jacques Le Roux < jacques.le.r...@les7arts.com> wrote: > Yes, even if you change the key/s size/s of the field/s of a primary key. > Though with Derby (not Postgres at least) changing the primary key sizes > of 2 primary keys which are related by a relation is not recommended > because currently there is still an issue with relation when you change > these sizes. > > Jacques > > Le 29/11/2014 16:45, Ashish Repal a écrit : > > Ya..I have gone through that link. >> my doubt is, if i extend any component say catalog, and modify its >> entitydef with my requirements will it change the original table >> structure? >> >> Aashish >> >> On Saturday, November 29, 2014, Jacques Le Roux < >> jacques.le.r...@les7arts.com> wrote: >> >> Better to follow this way https://cwiki.apache.org/ >>> confluence/display/OFBIZ/Addressing+Custom+Requirements+In+OFBiz >>> >>> Jacques >>> >>> Le 29/11/2014 13:47, Ashish Repal a écrit : >>> >>> Hi, I am planning to develop ERP application for manufacturing industryusing ofbiz. For this I need to modify existing components, Catalog,facility,order,party etc. May be I think, I need to extend these components or is there any other way? I also have to add, remove entity fields from OFBIZ tables so can I do it in my custom component's entitydef? If yes, after build, this will overwrite existing table? please guide. Regards, Aashish Repal
