User Close

Search

THE DEVELOPER PORTAL FOR SOA

Prepare statement in MS SQL 2005 probably not correct

eggwise's picture

Submitted by eggwise on January 29, 2009 - 07:35

Hi, We use stored procedures in our data services to insert and update records in a MS SQL 2005 database. Initially it didn't work. No updates ore inserts were made. Then we noticed the statements were rolledback at the end of the prepared statements. Now we add:


if @@trancount > 0 commit tran

at the end of our sp's and all works as to be expected. We suggest the statements from the stored procedures (and plain SQL) aren't prepared correctly. Thanks, Jan-Bart

sumedha's picture

Hi,By default auto commit

Submitted by sumedha on February 6, 2009 - 01:04.

Hi, By default auto commit property is set to false. You can make it to true by adding following property into <config> section of your data service. <property name="org.wso2.ws.dataservice.autocommit">true</property> /sumedha

Login or register to post comments

rvverner7.gmail.com's picture

Thanks for your useful info,

Submitted by rvverner7.gmail.com on January 4, 2010 - 18:42.

Thanks for your useful info, I think it's a good topic Russell blog

Login or register to post comments

library project main code

Featured

In your cloud environment, if a user is consuming too much of your resources, either you have to control the user's behavior or scale up your resources to cater the situation and charge the user for consuming resources. If you decide to control the user, then, throttling is the answer for you...

WSO2 StratosLive is the public Platform as a Service (PaaS) from WSO2. With its lean, complete and 100% open source model, StratosLive holds key attributes to become competitively prominent in the enterprise cloud space...

Messaging is used with distributed computing to achieve asynchronous communication. An Event is a change of state in a software system. Eventing is referred to as propagating messages which contain those event information through publish and subscribe...

Patterns are essential ingredients for architects when building solutions since patterns make solutions more stable as well as clean. It is important to pick the correct pattern based on the problem or the use-case that is implemented by a solution...

WSO2 Carbon Studio immensely simplifies SOA development by providing a complete Eclipse IDE for service/application development, deployment and execution. This article explains Carbon Studio and its benefits...

Popular Content

Developing Web Services Using Apache Axis2 Eclipse Plugins - Part 1 (456073 reads)
How to Embed an Axis2 based Web Service in your Webapp? (104725 reads)
Hello World with Apache Axis2 (102572 reads)
Web Services Security with Apache Rampart – Part 1 ( Transport Level Security ) (96143 reads)
Downloading a Binary File from a Web Service using Axis2 and SOAP with Attachments (91215 reads)
Developing Web Services Using Apache Axis2 Eclipse Plugins - Part 2 (84676 reads)
Writing Your Own services.xml for Axis2 Web Services (80079 reads)
Reference Guide to Apache Axis2 Client API Parameters (72621 reads)

Learn Cloud

Learn

Cloud

The WSO2 Application Server is a reliable application server that can host your enterprise web applications. The WSO2 Application Server as a Service is offered in StratosLive, the WSO2 Platform as a Service. This article explains how a simple web application can be developed and deployed from Carbon Studio to the WSO2 Application Server...

Latest Webinar

Different groups within an organization need to monitor different Key Performance Indicators (KPIs) - An operations team will be interested in the response times of business services and loads of each service,..

Thursday, February 9th 2012, 09.00 AM (PST)

Thursday, February 9th 2012, 10.00 AM (GMT)

Tags

WS-Policy WS-ReliableMessaging WS-Security WS-PolicyAttachment transports WS-* WS-Eventing WS-Policy WS-Trust Web services