User Close

Search

THE DEVELOPER PORTAL FOR SOA

General: upgrade ddl's for updating database

remcocats's picture

Submitted by remcocats on November 24, 2009 - 04:19

hi, I like to know if there are ddl's for upgrading 3.0.0 to 3.0.1 or 3.0.2. Or are there tools for creating delta's of two ddl's. We want to update our registry to 3.0.2 because of the content reading problems of remote registry in 3.0.0. best regards, Remco Cats

senakafdo's picture

Re: General: upgrade ddl's for updating database

Submitted by senakafdo on November 27, 2009 - 05:59.

What is the type of DBMS that you use? Thanks, Senaka.

Login or register to post comments

senakafdo's picture

Re: General: upgrade ddl's for updating database

Submitted by senakafdo on November 27, 2009 - 06:40.

Hi Remco, Please find the related discussion on our developer list, [1]. [1] http://markmail.org/thread/2ftxyt5ds4kamzm7. Thanks, Senaka.

Login or register to post comments

remcocats's picture

Senaka, I use oracle 10

Submitted by remcocats on November 27, 2009 - 06:38.

Senaka, I use oracle 10 database. best regards, Remco

Login or register to post comments

senakafdo's picture

Re: Senaka, I use oracle 10

Submitted by senakafdo on November 27, 2009 - 07:07.

Hi Remco, A simple diff on the oracle db scripts revealed that the change from 3.0.0 to 3.0.1 is simple. 217c217 < REG_VALUE VARCHAR2(500), --- > REG_VALUE VARCHAR2(1000), Therefore, to upgrade from 3.0.0 to 3.0.1, on oracle you need to run the following SQL (using a client such as SQL Plus). alter table reg_property modify reg_value varchar2(1000); commit; However, there seems to be some new constraints added in 3.0.2, and also some new columns. Please follow the discussion thread (I have mentioned the link in my previous comment), for further updates. Thanks, Senaka.

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 (456110 reads)
How to Embed an Axis2 based Web Service in your Webapp? (104742 reads)
Hello World with Apache Axis2 (102585 reads)
Web Services Security with Apache Rampart – Part 1 ( Transport Level Security ) (96169 reads)
Downloading a Binary File from a Web Service using Axis2 and SOAP with Attachments (91218 reads)
Developing Web Services Using Apache Axis2 Eclipse Plugins - Part 2 (84682 reads)
Writing Your Own services.xml for Axis2 Web Services (80090 reads)
Reference Guide to Apache Axis2 Client API Parameters (72631 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

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