You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by Jose Diaz <jd...@bluestarenergy.com> on 2007/12/21 21:47:55 UTC
Help me with it error
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) <ji...@apache.org>
Sent: Fri, 12/21/2007 3:18pm
To: dev@ofbiz.apache.org
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");
> }
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
Re: Help me with it error
Posted by BJ Freeman <bj...@free-man.net>.
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) <ji...@apache.org>
> Sent: Fri, 12/21/2007 3:18pm
> To: dev@ofbiz.apache.org
> 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");
>> }
>