Users - Breakpoints in Code Dealing with Transactions

[Vinay Agarwal]

Hello,

 

Do I have to change some setting (e.g. timeout) for database (postgresql 8.1) or ofbiz to step through java code dealing with transactions? Whenever I try doing that, I get strange errors like the following:

Did not complete the order, the following occurred:ERROR : Could not create order (write error :SQL Exception occurred on commit (Cannot commit a transactional connection: See JDBC 2.0 Optional Package Specification section 7.1 (p25))).

Everything works OK if I don’t put breakpoints (using NetBeans 5.0).

 

Thanks in advance,

Vinay Agarwal

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

[Lei Gao-2]

I guess it is due to transaction time out, or some time out. You just set all related time out long enough for you stepping throuogh the whole target debugging module.

Lei

On 4/12/06, Vinay Agarwal <[hidden email]> wrote:

Hello,

 

Do I have to change some setting (e.g. timeout) for database (postgresql 8.1) or ofbiz to step through java code dealing with transactions? Whenever I try doing that, I get strange errors like the following:

Did not complete the order, the following occurred:ERROR : Could not create order (write error :SQL Exception occurred on commit (Cannot commit a transactional connection: See JDBC 2.0 Optional Package Specification section 7.1 (p25))).

Everything works OK if I don't put breakpoints (using NetBeans 5.0).

 

Thanks in advance,

Vinay Agarwal

_______________________________________________
Users mailing list
[hidden email]
<a onclick="return top.js.OpenExtLink(window,event,this)" href="http://lists.ofbiz.org/mailman/listinfo/users" target="_blank"> http://lists.ofbiz.org/mailman/listinfo/users

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

[Vinay Agarwal]

It has something to do with Postgres settings. I switched to derby for debugging and I can step through the code without any strange errors.

Vinay Agarwal

 

-----Original Message-----
From: [hidden email] [mailto:[hidden email]] On Behalf Of Lei Gao
Sent: Wednesday, April 12, 2006 3:08 PM
To: OFBiz Users / Usage Discussion
Subject: Re: [OFBiz] Users - Breakpoints in Code Dealing with Transactions

 

I guess it is due to transaction time out, or some time out. You just set all related time out long enough for you stepping throuogh the whole target debugging module.

Lei

On 4/12/06, Vinay Agarwal <[hidden email]> wrote:

Hello,

 

Do I have to change some setting (e.g. timeout) for database (postgresql 8.1) or ofbiz to step through java code dealing with transactions? Whenever I try doing that, I get strange errors like the following:

Did not complete the order, the following occurred:ERROR : Could not create order (write error :SQL Exception occurred on commit (Cannot commit a transactional connection: See JDBC 2.0 Optional Package Specification section 7.1 (p25))).

Everything works OK if I don't put breakpoints (using NetBeans 5.0).

 

Thanks in advance,

Vinay Agarwal

_______________________________________________
Users mailing list
[hidden email]
<a href="http://lists.ofbiz.org/mailman/listinfo/users" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://lists.ofbiz.org/mailman/listinfo/users

 

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

[rohit]

Hi,

I am getting the same error

"The Following Errors Occurred:

    * Did not complete the order, the following occurred:ERROR : Could not create order (write error :SQL Exception occurred on commit (Cannot commit a transactional connection: See JDBC 2.0 Optional Package Specification section 7.1 (p25)))."

And i am to using postgres 8.1. I guess this has to something with the recent code change, because the code from 14 April SVN was working just fine.

Any ideas how to get over this.

Rohit


 

Vinay Agarwal wrote

It has something to do with Postgres settings. I switched to derby for
debugging and I can step through the code without any strange errors.

Vinay Agarwal

 

-----Original Message-----
From: [e-mail] [mailto:[e-mail]]
On Behalf Of Lei Gao
Sent: Wednesday, April 12, 2006 3:08 PM
To: OFBiz Users / Usage Discussion
Subject: Re: [OFBiz] Users - Breakpoints in Code Dealing with Transactions

 

I guess it is due to transaction time out, or some time out. You just set
all related time out long enough for you stepping throuogh the whole target
debugging module.

Lei

On 4/12/06, Vinay Agarwal <[e-mail]> wrote:

Hello,

 

Do I have to change some setting (e.g. timeout) for database (postgresql
8.1) or ofbiz to step through java code dealing with transactions? Whenever
I try doing that, I get strange errors like the following:

Did not complete the order, the following occurred:ERROR : Could not create
order (write error :SQL Exception occurred on commit (Cannot commit a
transactional connection: See JDBC 2.0 Optional Package Specification
section 7.1 (p25))).

Everything works OK if I don't put breakpoints (using NetBeans 5.0).

 

Thanks in advance,

Vinay Agarwal



_______________________________________________
Users mailing list
[e-mail]
http://lists.ofbiz.org/mailman/listinfo/users

 


 
_______________________________________________
Users mailing list
[e-mail]
http://lists.ofbiz.org/mailman/listinfo/users