ask in the Discussion Forums: Financials Module https://sourceforge.net/forum/forum.php?forum_id=540292
Jose Diaz sent the following on 12/21/2007 12:47 PM: > I am having problems with transactions of big processing time. > > Failure in create operation for entity [AgingReport]: > org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on commit > (Cannot commit a transactional connection: See JDBC 2.0 Optional Package > Specification section 7.1 (p25)). Rolling back transaction. > I am generating an report but it never finish. > > Jose. > > More log here: > > SequenceUtil.java:263:INFO ] Got bank of sequenced IDs for > [EntitySyncRemove]; curSeqId=1844600, maxSeqId=1844610, bankSize=10 > 2007-12-21 14:27:59,557 (JotmBatch) [ TransactionImpl.java:765:INFO ] set > rollback only (tx=bb14:38:0:01f4aaf849f1eeb03e...a64fe3:) > 2007-12-21 14:27:59,562 (invoker-Thread-8) [ TransactionUtil.java:77 :WARN ] > ---- exception report > ---------------------------------------------------------- > [TransactionUtil.begin] active transaction marked for rollback in place, so > no transaction begun; this stack trace shows when the exception began: > Exception: java.lang.Exception > Message: Tx Stack Placeholder > ---- stack trace > --------------------------------------------------------------- > java.lang.Exception: Tx Stack Placeholder > org.ofbiz.entity.transaction.TransactionUtil.setTransactionBeginStack(TransactionUtil.java:535) > org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:111) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:285) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:216) > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123) > org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:80) > org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:226) > java.lang.Thread.run(Thread.java:534) > -------------------------------------------------------------------------------- > 2007-12-21 14:27:59,563 (invoker-Thread-8) [ TransactionUtil.java:633:WARN ] > ---- exception report > ---------------------------------------------------------- > WARNING: In getSetRollbackOnlyCause no stack placeholder was in place, here > is the current location: > Exception: java.lang.Exception > Message: Current Stack Trace > ---- stack trace > --------------------------------------------------------------- > java.lang.Exception: Current Stack Trace > org.ofbiz.entity.transaction.TransactionUtil.getSetRollbackOnlyCause(TransactionUtil.java:632) > org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:82) > org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:57) > org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:2447) > org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:2434) > org.ofbiz.entity.GenericDelegator.saveEntitySyncRemoveInfo(GenericDelegator.java:675) > org.ofbiz.entity.GenericDelegator.removeByPrimaryKey(GenericDelegator.java:715) > org.ofbiz.entity.GenericDelegator.removeAll(GenericDelegator.java:1198) > org.ofbiz.entity.GenericDelegator.removeAll(GenericDelegator.java:1170) > com.opensourcestrategies.financials.accounts.AccountsServices.postAgingReceivablePayable(AccountsServices.java:147) > com.opensourcestrategies.financials.accounts.AccountsServices.postAgingReportReceivable(AccountsServices.java:293) > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > java.lang.reflect.Method.invoke(Method.java:324) > org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:101) > org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:63) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:345) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:216) > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123) > org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:80) > org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:226) > java.lang.Thread.run(Thread.java:534) > -------------------------------------------------------------------------------- > 2007-12-21 14:27:59,564 (invoker-Thread-8) [ TransactionUtil.java:77 :WARN ] > ---- exception report > ---------------------------------------------------------- > [TransactionUtil.begin] active transaction marked for rollback in place, so > no transaction begun; this stack trace shows when the exception began: > Exception: java.lang.Exception > Message: Tx Stack Placeholder > ---- stack trace > --------------------------------------------------------------- > java.lang.Exception: Tx Stack Placeholder > org.ofbiz.entity.transaction.TransactionUtil.setTransactionBeginStack(TransactionUtil.java:535) > org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:111) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:285) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:216) > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123) > org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:80) > org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:226) > java.lang.Thread.run(Thread.java:534) > -------------------------------------------------------------------------------- > 2007-12-21 14:27:59,565 (invoker-Thread-8) [ TransactionUtil.java:633:WARN ] > ---- exception report > ---------------------------------------------------------- > WARNING: In getSetRollbackOnlyCause no stack placeholder was in place, here > is the current location: > Exception: java.lang.Exception > Message: Current Stack Trace > ---- stack trace > --------------------------------------------------------------- > java.lang.Exception: Current Stack Trace > org.ofbiz.entity.transaction.TransactionUtil.getSetRollbackOnlyCause(TransactionUtil.java:632) > org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:82) > org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:57) > org.ofbiz.entity.GenericDelegator.getNextSeqIdLong(GenericDelegator.java:2501) > org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:2450) > org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:2434) > org.ofbiz.entity.GenericDelegator.saveEntitySyncRemoveInfo(GenericDelegator.java:675) > org.ofbiz.entity.GenericDelegator.removeByPrimaryKey(GenericDelegator.java:715) > org.ofbiz.entity.GenericDelegator.removeAll(GenericDelegator.java:1198) > org.ofbiz.entity.GenericDelegator.removeAll(GenericDelegator.java:1170) > com.opensourcestrategies.financials.accounts.AccountsServices.postAgingReceivablePayable(AccountsServices.java:147) > com.opensourcestrategies.financials.accounts.AccountsServices.postAgingReportReceivable(AccountsServices.java:293) > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > java.lang.reflect.Method.invoke(Method.java:324) > org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:101) > org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:63) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:345) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:216) > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123) > org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:80) > org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:226) > java.lang.Thread.run(Thread.java:534) > -------------------------------------------------------------------------------- > 2007-12-21 14:27:59,566 (invoker-Thread-8) [ TransactionUtil.java:77 :WARN ] > ---- exception report > ---------------------------------------------------------- > [TransactionUtil.begin] active transaction marked for rollback in place, so > no transaction begun; this stack trace shows when the exception began: > Exception: java.lang.Exception > Message: Tx Stack Placeholder > ---- stack trace > --------------------------------------------------------------- > java.lang.Exception: Tx Stack Placeholder > org.ofbiz.entity.transaction.TransactionUtil.setTransactionBeginStack(TransactionUtil.java:535) > org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:111) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:285) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:216) > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123) > org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:80) > org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:226) > java.lang.Thread.run(Thread.java:534) > -------------------------------------------------------------------------------- > 2007-12-21 14:27:59,567 (invoker-Thread-8) [ TransactionUtil.java:633:WARN ] > ---- exception report > ---------------------------------------------------------- > WARNING: In getSetRollbackOnlyCause no stack placeholder was in place, here > is the current location: > Exception: java.lang.Exception > Message: Current Stack Trace > ---- stack trace > --------------------------------------------------------------- > java.lang.Exception: Current Stack Trace > org.ofbiz.entity.transaction.TransactionUtil.getSetRollbackOnlyCause(TransactionUtil.java:632) > org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:82) > org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:57) > org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:555) > org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:543) > org.ofbiz.entity.GenericValue.create(GenericValue.java:121) > org.ofbiz.entity.GenericDelegator.saveEntitySyncRemoveInfo(GenericDelegator.java:677) > org.ofbiz.entity.GenericDelegator.removeByPrimaryKey(GenericDelegator.java:715) > org.ofbiz.entity.GenericDelegator.removeAll(GenericDelegator.java:1198) > org.ofbiz.entity.GenericDelegator.removeAll(GenericDelegator.java:1170) > com.opensourcestrategies.financials.accounts.AccountsServices.postAgingReceivablePayable(AccountsServices.java:147) > com.opensourcestrategies.financials.accounts.AccountsServices.postAgingReportReceivable(AccountsServices.java:293) > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > java.lang.reflect.Method.invoke(Method.java:324) > org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:101) > org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:63) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:345) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:216) > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123) > org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:80) > org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:226) > java.lang.Thread.run(Thread.java:534) > -------------------------------------------------------------------------------- > 2007-12-21 14:27:59,569 (invoker-Thread-8) [ SQLProcessor.java:155:ERROR] > ---- exception report > ---------------------------------------------------------- > Exception: java.sql.SQLException > Message: Cannot commit a transactional connection: See JDBC 2.0 Optional > Package Specification section 7.1 (p25) > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Cannot commit a transactional connection: See JDBC 2.0 > Optional Package Specification section 7.1 (p25) > org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAClientConnection.commit(XAClientConnection.java:250) > org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:152) > org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:203) > org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:197) > org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:137) > org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75) > org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:570) > org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:543) > org.ofbiz.entity.GenericValue.create(GenericValue.java:121) > org.ofbiz.entity.GenericDelegator.saveEntitySyncRemoveInfo(GenericDelegator.java:677) > org.ofbiz.entity.GenericDelegator.removeByPrimaryKey(GenericDelegator.java:715) > org.ofbiz.entity.GenericDelegator.removeAll(GenericDelegator.java:1198) > org.ofbiz.entity.GenericDelegator.removeAll(GenericDelegator.java:1170) > com.opensourcestrategies.financials.accounts.AccountsServices.postAgingReceivablePayable(AccountsServices.java:147) > com.opensourcestrategies.financials.accounts.AccountsServices.postAgingReportReceivable(AccountsServices.java:293) > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > java.lang.reflect.Method.invoke(Method.java:324) > org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:101) > org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:63) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:345) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:216) > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123) > org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:80) > org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:226) > java.lang.Thread.run(Thread.java:534) > -------------------------------------------------------------------------------- > 2007-12-21 14:27:59,570 (invoker-Thread-8) [ SQLProcessor.java:190:WARN ] > [SQLProcessor.rollback]: SQL Exception while rolling back insert. Error > was:java.sql.SQLException: Cannot rollback a transactional connection: See > JDBC 2.0 Optional Package Specification section 7.1 (p25) > 2007-12-21 14:27:59,571 (invoker-Thread-8) [ SQLProcessor.java:191:WARN ] > ---- exception report > ---------------------------------------------------------- > Exception: java.sql.SQLException > Message: Cannot rollback a transactional connection: See JDBC 2.0 Optional > Package Specification section 7.1 (p25) > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Cannot rollback a transactional connection: See JDBC > 2.0 Optional Package Specification section 7.1 (p25) > org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAClientConnection.rollback(XAClientConnection.java:262) > org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:178) > org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:157) > org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:203) > org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:197) > org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:137) > org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75) > org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:570) > org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:543) > org.ofbiz.entity.GenericValue.create(GenericValue.java:121) > org.ofbiz.entity.GenericDelegator.saveEntitySyncRemoveInfo(GenericDelegator.java:677) > org.ofbiz.entity.GenericDelegator.removeByPrimaryKey(GenericDelegator.java:715) > org.ofbiz.entity.GenericDelegator.removeAll(GenericDelegator.java:1198) > org.ofbiz.entity.GenericDelegator.removeAll(GenericDelegator.java:1170) > com.opensourcestrategies.financials.accounts.AccountsServices.postAgingReceivablePayable(AccountsServices.java:147) > com.opensourcestrategies.financials.accounts.AccountsServices.postAgingReportReceivable(AccountsServices.java:293) > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > java.lang.reflect.Method.invoke(Method.java:324) > org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:101) > org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:63) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:345) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:216) > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123) > org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:80) > org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:226) > java.lang.Thread.run(Thread.java:534) > -------------------------------------------------------------------------------- > 2007-12-21 14:27:59,572 (invoker-Thread-8) [ SQLProcessor.java:190:WARN ] > [SQLProcessor.rollback]: SQL Exception while rolling back insert. Error > was:java.sql.SQLException: Cannot rollback a transactional connection: See > JDBC 2.0 Optional Package Specification section 7.1 (p25) > 2007-12-21 14:27:59,573 (invoker-Thread-8) [ SQLProcessor.java:191:WARN ] > ---- exception report > ---------------------------------------------------------- > Exception: java.sql.SQLException > Message: Cannot rollback a transactional connection: See JDBC 2.0 Optional > Package Specification section 7.1 (p25) > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Cannot rollback a transactional connection: See JDBC > 2.0 Optional Package Specification section 7.1 (p25) > org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAClientConnection.rollback(XAClientConnection.java:262) > org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:178) > org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:139) > org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75) > org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:570) > org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:543) > org.ofbiz.entity.GenericValue.create(GenericValue.java:121) > org.ofbiz.entity.GenericDelegator.saveEntitySyncRemoveInfo(GenericDelegator.java:677) > org.ofbiz.entity.GenericDelegator.removeByPrimaryKey(GenericDelegator.java:715) > org.ofbiz.entity.GenericDelegator.removeAll(GenericDelegator.java:1198) > org.ofbiz.entity.GenericDelegator.removeAll(GenericDelegator.java:1170) > com.opensourcestrategies.financials.accounts.AccountsServices.postAgingReceivablePayable(AccountsServices.java:147) > com.opensourcestrategies.financials.accounts.AccountsServices.postAgingReportReceivable(AccountsServices.java:293) > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > java.lang.reflect.Method.invoke(Method.java:324) > org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:101) > org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:63) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:345) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:216) > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123) > org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:80) > org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:226) > java.lang.Thread.run(Thread.java:534) > -------------------------------------------------------------------------------- > 2007-12-21 14:27:59,575 (invoker-Thread-8) [ SQLProcessor.java:155:ERROR] > ---- exception report > ---------------------------------------------------------- > Exception: java.sql.SQLException > Message: Cannot commit a transactional connection: See JDBC 2.0 Optional > Package Specification section 7.1 (p25) > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Cannot commit a transactional connection: See JDBC 2.0 > Optional Package Specification section 7.1 (p25) > org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAClientConnection.commit(XAClientConnection.java:250) > org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:152) > org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:203) > org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:142) > org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75) > org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:570) > org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:543) > org.ofbiz.entity.GenericValue.create(GenericValue.java:121) > org.ofbiz.entity.GenericDelegator.saveEntitySyncRemoveInfo(GenericDelegator.java:677) > org.ofbiz.entity.GenericDelegator.removeByPrimaryKey(GenericDelegator.java:715) > org.ofbiz.entity.GenericDelegator.removeAll(GenericDelegator.java:1198) > org.ofbiz.entity.GenericDelegator.removeAll(GenericDelegator.java:1170) > com.opensourcestrategies.financials.accounts.AccountsServices.postAgingReceivablePayable(AccountsServices.java:147) > com.opensourcestrategies.financials.accounts.AccountsServices.postAgingReportReceivable(AccountsServices.java:293) > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > java.lang.reflect.Method.invoke(Method.java:324) > org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:101) > org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:63) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:345) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:216) > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123) > org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:80) > > > > > Sincere & Best Regards, > José Amadeo Martin Díaz Díaz > Senior Software Engineering > BlueStar Energy SAC. > Av. Benavides 395, Miraflores > Lima > Office: (51) 1 447300 > www.bluestarenergy.com > The information contained in this communication and any attachments are > intended only for the use of the individual or entity to which it is > addressed. All information within or attached is privileged, confidential and > exempt from disclosure. If the reader of this message is not the intended > recipient, or an employee or agent responsible for delivering this message to > the intended recipient, you are hereby notified that any dissemination, > distribution or copying of this communication or attachments is strictly > prohibited and may be unlawful. If you have received this message in error, > please notify the original sender immediately by return email and delete this > message, along with any attachments, from your computer. Thank you. > > > ----- Original Message ----- > From: Chris Howe (JIRA) <[EMAIL PROTECTED]> > Sent: Fri, 12/21/2007 3:18pm > To: [email protected] > Subject: [jira] Commented: (OFBIZ-1256) Send mail through gmail with the > javamail api in ofbiz > > > [ > https://issues.apache.org/jira/browse/OFBIZ-1256?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12554024 > ] > > Chris Howe commented on OFBIZ-1256: > ----------------------------------- > > Looking at BJ's suggestions for the multiple email accounts, it shouldn't > affect this issue. > > A mutliple account solution would make the appropriate data available in the > context.get(""); for what ever account is sending the email. As a side note > to BJ's suggestion, the account information should be stored in the database, > not in property files. The general.properties are simply default > configurations to pass to JavaMail if nothing is provided in the context. > >> Send mail through gmail with the javamail api in ofbiz >> ------------------------------------------------------ >> >> Key: OFBIZ-1256 >> URL: https://issues.apache.org/jira/browse/OFBIZ-1256 >> Project: OFBiz >> Issue Type: New Feature >> Components: content >> Affects Versions: SVN trunk >> Environment: All >> Reporter: Fabien Carrion >> Assignee: Jacques Le Roux >> Priority: Minor >> Fix For: SVN trunk >> >> Attachments: emailssl_diff.patch, gmail.patch >> >> >> This a small patch to accept ssl connections to smtp servers. >> Index: content/src/org/ofbiz/content/email/EmailServices.java >> =================================================================== >> --- content/src/org/ofbiz/content/email/EmailServices.java (revision >> 576503) >> +++ content/src/org/ofbiz/content/email/EmailServices.java (working >> copy) >> @@ -129,6 +129,8 @@ >> >> String sendFrom = (String) context.get("sendFrom"); >> String sendType = (String) context.get("sendType"); >> + String port = (String) context.get("port"); >> + String ssl = (String) context.get("ssl"); >> String sendVia = (String) context.get("sendVia"); >> String authUser = (String) context.get("authUser"); >> String authPass = (String) context.get("authPass"); >> @@ -151,6 +153,12 @@ >> if (authUser != null && authUser.length() > 0) { >> useSmtpAuth = true; >> } >> + if (port == null || port.length() == 0) { >> + port = >> UtilProperties.getPropertyValue("general.properties", "mail.smtp.port", >> "25"); >> + } >> + if (ssl == null || ssl.length() == 0) { >> + ssl = UtilProperties.getPropertyValue("general.properties", >> "mail.smtp.ssl", "javax.net.ssl.SSLSocketFactory"); >> + } >> } else if (sendVia == null) { >> return ServiceUtil.returnError("Parameter sendVia is required >> when sendType is not mail.smtp.host"); >> } >> @@ -168,6 +176,14 @@ >> try { >> Properties props = System.getProperties(); >> props.put(sendType, sendVia); >> + if (port != null && port.length() > 0) { >> + props.put("mail.smtp.port", port); >> + props.put("mail.smtp.socketFactory.port", port); >> + } >> + if (ssl != null && ssl.length() > 0) { >> + props.put("mail.smtp.socketFactory.class", ssl); >> + props.put("mail.smtp.socketFactory.fallback", "false"); >> + } >> if (useSmtpAuth) { >> props.put("mail.smtp.auth", "true"); >> } >
